SAP ABAP Table BUPA_DATA_ALL (Structure with BUT000 Data, ADDR1 + ADDR2 + comm. data), sap-tables.org - The Best Online document for SAP ABAP Tables

SAP ABAP Table `BUPA_DATA_ALL` {Structure with BUT000 Data, ADDR1 + ADDR2 + comm. data}

Home

                title {label: "SAP ABAP table BUPA_DATA_ALL {Structure with BUT000 Data, ADDR1 + ADDR2 + comm. data}", size: "20"}

# Entities

[BUPA_DATA_ALL] {bgcolor: "tomato"}
+CLIENT {label: "CLNT (3)"}
+BPKIND {label: "CHAR (4)"}
+BU_GROUP {label: "CHAR (4)"}
+SOURCE {label: "CHAR (4)"}
TITLE {label: "CHAR (4)"}
+AUGRP {label: "CHAR (4)"}
+BU_LOGSYS {label: "CHAR (10)"}
+LEGAL_ENTY {label: "CHAR (2)"}
+IND_SECTOR {label: "CHAR (10)"}
+LEGAL_ORG {label: "CHAR (2)"}
+TITLE_ACA1 {label: "CHAR (4)"}
+TITLE_ACA2 {label: "CHAR (4)"}
+TITLE_ROYL {label: "CHAR (4)"}
+PREFIX1 {label: "CHAR (4)"}
+PREFIX2 {label: "CHAR (4)"}
+NAMEFORMAT {label: "CHAR (2)"}
+NAMCOUNTRY {label: "CHAR (3)"}
+LANGU_CORR {label: "LANG (1)"}
+MARST {label: "CHAR (1)"}
+JOBGR {label: "CHAR (4)"}
+NATIO {label: "CHAR (3)"}
+CNDSC {label: "CHAR (3)"}
+XUBNAME {label: "CHAR (12)"}
+BU_LANGU {label: "LANG (1)"}
+PARTGRPTYP {label: "CHAR (4)"}
+CITY_CODE {label: "CHAR (12)"}
+CITYP_CODE {label: "CHAR (8)"}
+CITYH_CODE {label: "CHAR (12)"}
+REGIOGROUP {label: "CHAR (8)"}
+DONT_USE_P {label: "CHAR (4)"}
+CITY_CODE2 {label: "CHAR (12)"}
+PO_BOX_REG {label: "CHAR (3)"}
+PO_BOX_CTY {label: "CHAR (3)"}
+TRANSPZONE {label: "CHAR (10)"}
+DONT_USE_S {label: "CHAR (4)"}
+STREETCODE {label: "CHAR (12)"}
+STREETABBR {label: "CHAR (2)"}
COUNTRY {label: "CHAR (3)"}
+LANGU {label: "LANG (1)"}
+REGION {label: "CHAR (3)"}
+ADDRORIGIN {label: "CHAR (4)"}
+TIME_ZONE {label: "CHAR (6)"}
+LANGU_CREA {label: "LANG (1)"}
+DELI_SERV_TYPE {label: "CHAR (4)"}
+COUNTY_CODE {label: "CHAR (8)"}
+TOWNSHIP_CODE {label: "CHAR (8)"}
+TEL_COUNTRY {label: "CHAR (3)"}
+FAX_COUNTRY {label: "CHAR (3)"}

[ADDRC_DELI_SERV] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*DELI_SERV_TYPE {label: "CHAR (4)"}

[ADRCITY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*CITY_CODE {label: "CHAR (12)"}

[ADRCITYPRT] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+CITY_CODE {label: "CHAR (12)"}
*CITYP_CODE {label: "CHAR (8)"}

[ADRCOUNTY] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*COUNTY_CODE {label: "CHAR (8)"}

[ADRREGGRP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*REGIOGROUP {label: "CHAR (8)"}

[ADRSTREET] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRT_CODE {label: "CHAR (12)"}

[ADRSTRTYPE] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*STRTYPEAB {label: "CHAR (2)"}

[ADRTOWNSHIP] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+COUNTRY {label: "CHAR (3)"}
*+REGION {label: "CHAR (3)"}
*+COUNTY_CODE {label: "CHAR (8)"}
*TOWNSHIP_CODE {label: "CHAR (8)"}

[T000] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}

[T002] {bgcolor: "#d0e0d0"}
*SPRAS {label: "LANG (1)"}

[T005] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*LAND1 {label: "CHAR (3)"}

[T005N] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*NAMEFORMAT {label: "CHAR (2)"}

[T005S] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*BLAND {label: "CHAR (3)"}

[TB001] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*BU_GROUP {label: "CHAR (4)"}

[TB004] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*BPKIND {label: "CHAR (4)"}

[TB005] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*SOURCE {label: "CHAR (4)"}

[TB019] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*LEGAL_ENTY {label: "CHAR (2)"}

[TB023] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*IND_SECTOR {label: "CHAR (10)"}

[TB025] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PARTGRPTYP {label: "CHAR (4)"}

[TB027] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*MARST {label: "CHAR (1)"}

[TB028] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*JOBGR {label: "CHAR (4)"}

[TB032] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*LEGAL_ORG {label: "CHAR (2)"}

[TB037] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*+AUOBJ {label: "CHAR (10)"}
*AUGRP {label: "CHAR (4)"}

[TBDLS] {bgcolor: "#d0e0d0"}
*LOGSYS {label: "CHAR (10)"}

[TSAD12] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*UNDELIVER {label: "CHAR (4)"}

[TSAD2] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE_KEY {label: "CHAR (4)"}

[TSAD4] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*PREFIX_KEY {label: "CHAR (4)"}

[TSAD5] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TITLE_KEY {label: "CHAR (4)"}

[TSAD6] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*ORIGIN {label: "CHAR (4)"}

[TTZZ] {bgcolor: "#d0e0d0"}
*+CLIENT {label: "CLNT (3)"}
*TZONE {label: "CHAR (6)"}

[TZONE] {bgcolor: "#d0e0d0"}
*+MANDT {label: "CLNT (3)"}
*+LAND1 {label: "CHAR (3)"}
*ZONE1 {label: "CHAR (10)"}

[USR02] {bgcolor: "#d0e0d0"}
*MANDT {label: "CLNT (3)"}
*BNAME {label: "CHAR (12)"}

# Relationships

BUPA_DATA_ALL ?--* TSAD6 {label: "BUPA_DATA_ALL-ADDRORIGIN = TSAD6-ORIGIN"}
BUPA_DATA_ALL 1--* TB037 {label: "BUPA_DATA_ALL-AUGRP = TB037-AUGRP"}
BUPA_DATA_ALL 1--* TB004 {label: "BUPA_DATA_ALL-BPKIND = TB004-BPKIND"}
BUPA_DATA_ALL 1--* TB001 {label: "BUPA_DATA_ALL-BU_GROUP = TB001-BU_GROUP"}
BUPA_DATA_ALL ?--* T002 {label: "BUPA_DATA_ALL-BU_LANGU = T002-SPRAS"}
BUPA_DATA_ALL 1--* TBDLS {label: "BUPA_DATA_ALL-BU_LOGSYS = TBDLS-LOGSYS"}
BUPA_DATA_ALL ?--* ADRCITY {label: "BUPA_DATA_ALL-CITYH_CODE = ADRCITY-CITY_CODE"}
BUPA_DATA_ALL ?--* ADRCITYPRT {label: "BUPA_DATA_ALL-CITYP_CODE = ADRCITYPRT-CITYP_CODE"}
BUPA_DATA_ALL ?--* ADRCITY {label: "BUPA_DATA_ALL-CITY_CODE = ADRCITY-CITY_CODE"}
BUPA_DATA_ALL ?--* ADRCITY {label: "BUPA_DATA_ALL-CITY_CODE2 = ADRCITY-CITY_CODE"}
BUPA_DATA_ALL 1--* T000 {label: "BUPA_DATA_ALL-CLIENT = T000-MANDT"}
BUPA_DATA_ALL 1--* T005 {label: "BUPA_DATA_ALL-CNDSC = T005-LAND1"}
BUPA_DATA_ALL ?--* ADRCOUNTY {label: "BUPA_DATA_ALL-COUNTY_CODE = ADRCOUNTY-COUNTY_CODE"}
BUPA_DATA_ALL 1--* ADDRC_DELI_SERV {label: "BUPA_DATA_ALL-DELI_SERV_TYPE = ADDRC_DELI_SERV-DELI_SERV_TYPE"}
BUPA_DATA_ALL ?--* TSAD12 {label: "BUPA_DATA_ALL-DONT_USE_P = TSAD12-UNDELIVER"}
BUPA_DATA_ALL ?--* TSAD12 {label: "BUPA_DATA_ALL-DONT_USE_S = TSAD12-UNDELIVER"}
BUPA_DATA_ALL ?--* T005 {label: "BUPA_DATA_ALL-FAX_COUNTRY = T005-LAND1"}
BUPA_DATA_ALL *--* TB023 {label: "BUPA_DATA_ALL-IND_SECTOR = TB023-IND_SECTOR"}
BUPA_DATA_ALL 1--* TB028 {label: "BUPA_DATA_ALL-JOBGR = TB028-JOBGR"}
BUPA_DATA_ALL ?--* T002 {label: "BUPA_DATA_ALL-LANGU = T002-SPRAS"}
BUPA_DATA_ALL ?--* T002 {label: "BUPA_DATA_ALL-LANGU_CORR = T002-SPRAS"}
BUPA_DATA_ALL ?--* T002 {label: "BUPA_DATA_ALL-LANGU_CREA = T002-SPRAS"}
BUPA_DATA_ALL 1--* TB019 {label: "BUPA_DATA_ALL-LEGAL_ENTY = TB019-LEGAL_ENTY"}
BUPA_DATA_ALL 1--* TB032 {label: "BUPA_DATA_ALL-LEGAL_ORG = TB032-LEGAL_ORG"}
BUPA_DATA_ALL 1--* TB027 {label: "BUPA_DATA_ALL-MARST = TB027-MARST"}
BUPA_DATA_ALL ?--* T005 {label: "BUPA_DATA_ALL-NAMCOUNTRY = T005-LAND1"}
BUPA_DATA_ALL ?--* T005N {label: "BUPA_DATA_ALL-NAMEFORMAT = T005N-NAMEFORMAT"}
BUPA_DATA_ALL 1--* T005 {label: "BUPA_DATA_ALL-NATIO = T005-LAND1"}
BUPA_DATA_ALL 1--* TB025 {label: "BUPA_DATA_ALL-PARTGRPTYP = TB025-PARTGRPTYP"}
BUPA_DATA_ALL ?--* T005 {label: "BUPA_DATA_ALL-PO_BOX_CTY = T005-LAND1"}
BUPA_DATA_ALL ?--* T005S {label: "BUPA_DATA_ALL-PO_BOX_REG = T005S-BLAND"}
BUPA_DATA_ALL 1--* TSAD4 {label: "BUPA_DATA_ALL-PREFIX1 = TSAD4-PREFIX_KEY"}
BUPA_DATA_ALL 1--* TSAD4 {label: "BUPA_DATA_ALL-PREFIX2 = TSAD4-PREFIX_KEY"}
BUPA_DATA_ALL ?--* ADRREGGRP {label: "BUPA_DATA_ALL-REGIOGROUP = ADRREGGRP-REGIOGROUP"}
BUPA_DATA_ALL ?--* T005S {label: "BUPA_DATA_ALL-REGION = T005S-BLAND"}
BUPA_DATA_ALL 1--* TB005 {label: "BUPA_DATA_ALL-SOURCE = TB005-SOURCE"}
BUPA_DATA_ALL ?--* ADRSTRTYPE {label: "BUPA_DATA_ALL-STREETABBR = ADRSTRTYPE-STRTYPEAB"}
BUPA_DATA_ALL ?--* ADRSTREET {label: "BUPA_DATA_ALL-STREETCODE = ADRSTREET-STRT_CODE"}
BUPA_DATA_ALL ?--* T005 {label: "BUPA_DATA_ALL-TEL_COUNTRY = T005-LAND1"}
BUPA_DATA_ALL ?--* TTZZ {label: "BUPA_DATA_ALL-TIME_ZONE = TTZZ-TZONE"}
BUPA_DATA_ALL 1--* TSAD2 {label: "BUPA_DATA_ALL-TITLE_ACA1 = TSAD2-TITLE_KEY"}
BUPA_DATA_ALL 1--* TSAD2 {label: "BUPA_DATA_ALL-TITLE_ACA2 = TSAD2-TITLE_KEY"}
BUPA_DATA_ALL 1--* TSAD5 {label: "BUPA_DATA_ALL-TITLE_ROYL = TSAD5-TITLE_KEY"}
BUPA_DATA_ALL ?--* ADRTOWNSHIP {label: "BUPA_DATA_ALL-TOWNSHIP_CODE = ADRTOWNSHIP-TOWNSHIP_CODE"}
BUPA_DATA_ALL ?--* TZONE {label: "BUPA_DATA_ALL-TRANSPZONE = TZONE-ZONE1"}
BUPA_DATA_ALL 1--* USR02 {label: "BUPA_DATA_ALL-XUBNAME = USR02-BNAME"}

E-R Diagram for table BUPA_DATA_ALL (Structure with BUT000 Data, ADDR1 + ADDR2 + comm. data)

Foreign Key tables (32)

ADDRC_DELI_SERV {Address Service Types}
ADRCITY {Postal cities}
ADRCITYPRT {Postal districts}
ADRCOUNTY {County codes}
ADRREGGRP {Regional structure grouping}
ADRSTREET {Streets}
ADRSTRTYPE {Street type}
ADRTOWNSHIP {Township codes}
T000 {Clients}
T002 {Language Keys (Component BC-I18)}
T005 {Countries}
T005N {Name formats}
T005S {Taxes: Region (Province) Key}
TB001 {BP groupings}
TB004 {BP types}
TB005 {BP data sources}
TB019 {BP legal forms}
TB023 {BP industries (Obsolete ==> TB038A)}
TB025 {BP group types}
TB027 {BP marital status}
TB028 {Occupations}
TB032 {BP Legal Entity}
TB037 {Authorization Groups}
TBDLS {Logical system}
TSAD12 {Reasons for Non-Delivery (Business Address Services)}
TSAD2 {Academic Title (Business Address Services)}
TSAD4 {Name Prefixes (Business Address Services)}
TSAD5 {Name Suffixes/Title (Key) (Business Address Services)}
TSAD6 {Source Address or Personal Data (Business Address Services)}
TTZZ {Time zones}
TZONE {Customers: Regional zones}
USR02 {Logon Data (Kernel-Side Use)}