SAP table BUPA_DATA_ALL (Structure with BUT000 Data, ADDR1 + ADDR2 + comm. data)

Field Description Data Type Length Decimals Checktable Data Element
CLIENT Client CLNT 3 0 T000 MANDT
PARTNER Business Partner Number CHAR 10 0 BU_PARTNER
TYPE Business Partner Category CHAR 1 0 BU_TYPE
1 Person
2 Organization
3 Group
BPKIND Business Partner Type CHAR 4 0 TB004 BU_BPKIND
BU_GROUP Business Partner Grouping CHAR 4 0 TB001 BU_GROUP
BPEXT Business Partner Number in External System CHAR 20 0 BU_BPEXT
BU_SORT1 Search Term 1 for Business Partner CHAR 20 0 BU_SORT1
BU_SORT2 Search Term 2 for Business Partner CHAR 20 0 BU_SORT2
SOURCE Data Origin Types CHAR 4 0 TB005 BU_SOURCE
TITLE Form-of-Address Key CHAR 4 0 AD_TITLE
XDELE Central Archiving Flag CHAR 1 0 BU_XDELE
XBLCK Central Block for Business Partner CHAR 1 0 BU_XBLCK
AUGRP Authorization Group CHAR 4 0 TB037 BU_AUGRP
TITLE_LET Salutation CHAR 50 0 BU_TITLE_LET
BU_LOGSYS Logical system CHAR 10 0 TBDLS LOGSYS
CONTACT Business Partner: Contact Permission CHAR 1 0 BU_CONTACT
1 Permitted
2 Forbidden
3 Check permission
NOT_RELEASED Indicator: Not Released CHAR 1 0 BU_XNOT_RELEASED
NOT_LG_COMPETENT Indicator: Not Legally Competent CHAR 1 0 BU_NOT_LEG_COMPETENT
PRINT_MODE Business Partner Print Format CHAR 1 0 BU_PRINT_MODE
1 Braille
2 Large Print
BP_EEW_DUMMY Dummy function in length 1 CHAR 1 0 DUMMY
RATE Cost Rate/Revenue Rate for Project Costing CHAR 15 0 DPR_RATES DPR_TV_RATE
NAME_ORG1 Name 1 of organization CHAR 40 0 BU_NAMEOR1
NAME_ORG2 Name 2 of organization CHAR 40 0 BU_NAMEOR2
NAME_ORG3 Name 3 of organization CHAR 40 0 BU_NAMEOR3
NAME_ORG4 Name 4 of organization CHAR 40 0 BU_NAMEOR4
LEGAL_ENTY BP: Legal form of organization CHAR 2 0 TB019 BU_LEGENTY
IND_SECTOR Industry sector CHAR 10 0 TB023 BU_INDSECT
LEGAL_ORG Legal Entity of Organization CHAR 2 0 TB032 BU_LEGAL_ORG
FOUND_DAT Date organization founded DATS 8 0 BU_FOUND_DAT
LIQUID_DAT Liquidation date of organization DATS 8 0 BU_LIQUID_DAT
LOCATION_1 International location number (part 1) NUMC 7 0 BBBNR
LOCATION_2 International location number (Part 2) NUMC 5 0 BBSNR
LOCATION_3 Check digit for the international location number NUMC 1 0 BUBKZ
NAME_LAST Last name of business partner (person) CHAR 40 0 BU_NAMEP_L
NAME_FIRST First name of business partner (person) CHAR 40 0 BU_NAMEP_F
NAME_LST2 Other Last Name of a Person CHAR 40 0 BU_NAMEPL2
NAME_LAST2 Name at birth of business partner CHAR 40 0 BU_BIRTHNM
NAMEMIDDLE Middle name or second forename of a person CHAR 40 0 BU_NAMEMID
TITLE_ACA1 Academic Title: Key CHAR 4 0 TSAD2 AD_TITLE1
TITLE_ACA2 Second academic title (key) CHAR 4 0 TSAD2 AD_TITLE2
TITLE_ROYL Name supplement, e.g. noble title (key) CHAR 4 0 TSAD5 AD_TITLES
PREFIX1 Name Prefix (Key) CHAR 4 0 TSAD4 AD_PREFIX
PREFIX2 2nd name prefix (key) CHAR 4 0 TSAD4 AD_PREFIX2
NAME1_TEXT Full Name CHAR 80 0 BU_NAME1TX
NICKNAME Nickname of Business Partner (Person) CHAR 40 0 BU_NICKNAM
INITIALS "Middle Initial" or personal initials CHAR 10 0 AD_INITS
NAMEFORMAT Name format CHAR 2 0 T005N AD_FORMAT
NAMCOUNTRY Country/Region for Name Format Rule CHAR 3 0 T005 AD_NAMCTRY
LANGU_CORR Business Partner: Correspondence Language LANG 1 0 T002 BU_LANGU_CORR
XSEXM Selection: Business partner is male CHAR 1 0 BU_XSEXM
XSEXF Selection: Business partner is female CHAR 1 0 BU_XSEXF
BIRTHPL Birthplace of business partner CHAR 40 0 BU_BIRTHPL
MARST Marital Status of Business Partner CHAR 1 0 TB027 BU_MARST
EMPLO Name of Employer of a Natural Person CHAR 35 0 BU_EMPLO
JOBGR Occupation/group CHAR 4 0 TB028 BU_JOBGR
NATIO Nationality CHAR 3 0 T005 BU_NATIO
CNTAX Obsolete Field CHAR 3 0 * BU_CNTAX
CNDSC Country/Region of Origin: Non-Resident Companies CHAR 3 0 T005 BU_CNDSC
PERSNUMBER Person Number CHAR 10 0 AD_PERSNUM
XSEXU Selection: Sex of business partner is not known CHAR 1 0 BU_XSEXU
XUBNAME Obsolete Field CHAR 12 0 USR02 BU_XUBNAME
BU_LANGU Business partner: Language LANG 1 0 T002 BU_LANGU
GENDER Sex of business partner (person) CHAR 1 0 TB995 BU_SEXID
BIRTHDT Date of Birth of Business Partner DATS 8 0 BU_BIRTHDT
DEATHDT Date of death of business partner DATS 8 0 BU_DEATHDT
PERNO Personnel Number NUMC 8 0 BU_PERNO
CHILDREN Obsolete Field NUMC 2 0 BU_CHILDREN
MEM_HOUSE Obsolete Field DEC 2 0 BU_MEM_HOUSE
BIRTHDT_STATUS Date of Birth: Status CHAR 1 0 BU_BIRTHDT_STATUS
Fully known
A Day and Month Unknown
B Month and Year Unknown
C Day and Year Unknown
D Day Unknown
K Fully Known
M Month Unknown
U Fully Unknown
Y Year Unknown
PARTGRPTYP Group type CHAR 4 0 TB025 BU_GRPTYP
NAME_GRP1 Name 1 (group) CHAR 40 0 BU_NAMEGR1
NAME_GRP2 Name 2 (group) CHAR 40 0 BU_NAMEGR2
MC_NAME1 Search Help Field 1 (Name 1/Last Name) CHAR 35 0 BU_MCNAME1
MC_NAME2 Search Help Field 2 (Name 2/First Name) CHAR 35 0 BU_MCNAME2
CRUSR User who created the object CHAR 12 0 BU_CRUSR
CRDAT Date on which the object was created DATS 8 0 BU_CRDAT
CRTIM Time at which the object was created TIMS 6 0 BU_CRTIM
CHUSR Last user to change object CHAR 12 0 BU_CHUSR
CHDAT Date when object was last changed DATS 8 0 BU_CHDAT
CHTIM Time at which object was last changed TIMS 6 0 BU_CHTIM
PARTNER_GUID Business Partner GUID RAW 16 0 BU_PARTNER_GUID
ADDRCOMM Address Number CHAR 10 0 * BU_ADDRCOMM
TD_SWITCH Planned Change Documents for Partner Were Converted CHAR 1 0 BU_TD_SWITCH
IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational Center CHAR 1 0 BU_IS_ORG_CENTRE
BP Is Not an Organizational Center
1 BP Is Also an Organizational Center - BP Existed First
2 BP Is Also an Organizational Center - Org.Cent.Existed First
DB_KEY UUID in X form (binary) RAW 16 0 SYSUUID_X
VALID_FROM Validity Start BUT000 BP Data DEC 15 0 BU_BP_VALID_FROM
VALID_TO Validity End BUT000 BP Data DEC 15 0 BU_BP_VALID_TO
XPCPT Business Purpose Completed Flag CHAR 1 0 BU_XPCPT
False
X True
NATPERS Business Partner Is a Natural Person Under the Tax Laws CHAR 1 0 BU_NATURAL_PERSON
Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
MILVE ID for mainly military use CHAR 1 0 MILVE
NUC_SEC Nuclear Sector (Indicator) CHAR 1 0 NUC_SEC
PAR_REL Business Partner Released CHAR 1 0 BP_PAR_REL
Released
X Not released
BP_SORT Sort Field for Phonetic Search; Obsolete CHAR 20 0 BP_SORT_PH
KBANKS Country/Region Key of Bank CHAR 3 0 * BANKS
KBANKL Bank Keys CHAR 15 0 BANKK
ADDRNUMBER Address Number CHAR 10 0 AD_ADDRNUM
DATE_FROM Validity Date (Valid From) DATS 8 0 BU_DATFROM
DATE_TO Validity Date (Valid To) DATS 8 0 BU_DATTO
NAME1 Name 1 CHAR 40 0 AD_NAME1
NAME2 Name 2 CHAR 40 0 AD_NAME2
NAME3 Name 3 CHAR 40 0 AD_NAME3
NAME4 Name 4 CHAR 40 0 AD_NAME4
NAME_TXT Converted name field (with form of address) CHAR 50 0 AD_NAMETXT
NAME_CO c/o name CHAR 40 0 AD_NAME_CO
CITY1 City CHAR 40 0 AD_CITY1
CITY2 District CHAR 40 0 AD_CITY2
CITY_CODE City code for city/street file CHAR 12 0 ADRCITY AD_CITYNUM
CITYP_CODE District code for City and Street file CHAR 8 0 ADRCITYPRT AD_CITYPNM
HOME_CITY City (different from postal city) CHAR 40 0 AD_CITY3
CITYH_CODE Different city for city/street file CHAR 12 0 ADRCITY AD_CITYHNM
CHCKSTATUS City file test status CHAR 1 0 AD_CHECKST
Not Checked
C checked against city index
D differs from city index
REGIOGROUP Regional structure grouping CHAR 8 0 ADRREGGRP REGIOGROUP
POST_CODE1 City postal code CHAR 10 0 AD_PSTCD1
POST_CODE2 PO Box Postal Code CHAR 10 0 AD_PSTCD2
POST_CODE3 Company Postal Code (for Large Customers) CHAR 10 0 AD_PSTCD3
PCODE1_EXT (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code CHAR 10 0 AD_PST1XT
PCODE2_EXT (Not Supported) PO Box Postal Code Extension CHAR 10 0 AD_PST2XT
PCODE3_EXT (Not Supported) Major Customer Postal Code Extension CHAR 10 0 AD_PST3XT
PO_BOX PO Box CHAR 10 0 AD_POBX
DONT_USE_P PO Box Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USEP
PO_BOX_NUM Flag: PO Box Without Number CHAR 1 0 AD_POBXNUM
PO_BOX_LOC PO Box city CHAR 40 0 AD_POBXLOC
CITY_CODE2 City PO box code (City file) CHAR 12 0 ADRCITY AD_CIT2NUM
PO_BOX_REG Region for PO Box (Country/Region, State, Province, ...) CHAR 3 0 T005S AD_POBXREG
PO_BOX_CTY PO Box of Country/Region CHAR 3 0 T005 AD_POBXCTY
POSTALAREA (Not Supported) Post Delivery District CHAR 15 0 AD_PSTLAR
TRANSPZONE Transportation zone to or from which the goods are delivered CHAR 10 0 TZONE LZONE
STREET Street CHAR 60 0 AD_STREET
DONT_USE_S Street Address Undeliverable Flag CHAR 4 0 TSAD12 AD_NO_USES
STREETCODE Street Number for City/Street File CHAR 12 0 ADRSTREET AD_STRNUM
STREETABBR (Not Supported) Abbreviation of Street Name CHAR 2 0 ADRSTRTYPE AD_STRABBR
HOUSE_NUM1 House Number CHAR 10 0 AD_HSNM1
HOUSE_NUM2 House number supplement CHAR 10 0 AD_HSNM2
HOUSE_NUM3 (Not supported) House Number Range CHAR 10 0 AD_HSNM3
STR_SUPPL1 Street 2 CHAR 40 0 AD_STRSPP1
STR_SUPPL2 Street 3 CHAR 40 0 AD_STRSPP2
STR_SUPPL3 Street 4 CHAR 40 0 AD_STRSPP3
LOCATION Street 5 CHAR 40 0 AD_LCTN
BUILDING Building (Number or Code) CHAR 20 0 AD_BLDNG
FLOOR Floor in building CHAR 10 0 AD_FLOOR
ROOMNUMBER Room or Apartment Number CHAR 10 0 AD_ROOMNUM
COUNTRY Country/Region Key CHAR 3 0 LAND1
LANGU Language Key LANG 1 0 T002 SPRAS
REGION Region (State, Province, County) CHAR 3 0 T005S REGIO
SORT1 Search Term 1 CHAR 20 0 AD_SORT1UL
SORT2 Search Term 2 CHAR 20 0 AD_SORT2UL
SORT_PHN (Not Supported) Phonetic Search Sort Field CHAR 20 0 AD_SRTPHN
ADDRORIGIN (Not Supported) Address Data Source (Key) CHAR 4 0 TSAD6 AD_ORIGINA
EXTENSION1 Extension (only for data conversion) (e.g. data line) CHAR 40 0 AD_EXTENS1
EXTENSION2 Extension (only for data conversion) (e.g. telebox) CHAR 40 0 AD_EXTENS2
TIME_ZONE Address time zone CHAR 6 0 TTZZ AD_TZONE
TAXJURCODE Tax Jurisdiction CHAR 15 0 AD_TXJCD
ADDRESS_ID (Not supported) Physical address ID CHAR 10 0 AD_ADDR_ID
REMARK Address notes CHAR 50 0 AD_REMARK1
LANGU_CREA Address record creation original language LANG 1 0 T002 AD_LANGUCR
PO_BOX_LOBBY PO Box Lobby CHAR 40 0 AD_PO_BOX_LBY
DELI_SERV_TYPE Type of Delivery Service CHAR 4 0 ADDRC_DELI_SERV AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBER Number of Delivery Service CHAR 10 0 AD_DELIVERY_SERVICE_NUMBER
COUNTY_CODE County code for county CHAR 8 0 ADRCOUNTY AD_CNTYNUM
COUNTY County CHAR 40 0 AD_COUNTY
TOWNSHIP_CODE Township code for Township CHAR 8 0 ADRTOWNSHIP AD_TWSHPNUM
TOWNSHIP Township CHAR 40 0 AD_TOWNSHIP
DEFLT_COMM Communication Method (Key) (Business Address Services) CHAR 3 0 AD_COMM
PERS_GROUP Person Group (Key) (Business Address Services) CHAR 4 0 AD_GROUP_P
ADDR_GROUP Address Group (Key) (Business Address Services) CHAR 4 0 AD_GROUP
TEL_CONSNUMBER Sequence Number NUMC 3 0 AD_CONSNUM
TEL_COUNTRY Country/Region for Telephone/Fax Number CHAR 3 0 T005 AD_COMCTRY
TEL_FLGDEFAULT Standard Sender Address in this Communication Type CHAR 1 0 AD_FLGDFNR
TEL_FLG_NOUSE Flag: This Communication Number is Not Used CHAR 1 0 AD_FLNOUSE
TEL_HOME_FLAG Recipient address in this communication type (mail sys.grp) CHAR 1 0 AD_FLGHOME
TEL_NUMBER Telephone no.: dialling code+number CHAR 30 0 AD_TLNMBR
TEL_EXTENS Telephone no.: Extension CHAR 10 0 AD_TLXTNS
TELNR_LONG Complete Number: Dialling Code+Number+Extension CHAR 30 0 AD_TELNRLG
TELNR_CALL Telephone number for determining caller CHAR 30 0 AD_TELNRCL
TEL_DFT_RECEIV Flag: Recipient is standard recipient for this number CHAR 1 0 AD_DFTRCNR
TEL_R3_USER Flag: Connected to an SAP System CHAR 1 0 AD_R3_USER
TEL_REMARK Communication link notes CHAR 50 0 AD_REMARK2
TEL_UPDATEFLAG Change operation code ('I'nsert, 'U'pdate, 'D'elete) CHAR 1 0 AD_OP_CODE
No change
D Delete
I Insert
U Update
FAX_CONSNUMBER Sequence Number NUMC 3 0 AD_CONSNUM
FAX_COUNTRY Country/Region for Telephone/Fax Number CHAR 3 0 T005 AD_COMCTRY
FAX_FLGDEFAULT Standard Sender Address in this Communication Type CHAR 1 0 AD_FLGDFNR
FAX_FLG_NOUSE Flag: This Communication Number is Not Used CHAR 1 0 AD_FLNOUSE
FAX_HOME_FLAG Recipient address in this communication type (mail sys.grp) CHAR 1 0 AD_FLGHOME
FAX_NUMBER Fax number: dialling code+number CHAR 30 0 AD_FXNMBR
FAX_EXTENS Fax no.: Extension CHAR 10 0 AD_FXXTNS
FAXNR_LONG Complete number: dialling code+number+extension CHAR 30 0 AD_FXNRLNG
FAXNR_CALL Fax number for finding sender CHAR 30 0 AD_FAXNRCL
FAX_GROUP Fax group (G3, G4, ...) CHAR 1 0 AD_FXGRP
3 G3
4 G4
FAX_DFT_RECEIV Flag: Recipient is standard recipient for this number CHAR 1 0 AD_DFTRCNR
FAX_R3_USER Flag: Connected to an SAP System CHAR 1 0 AD_R3_USER
FAX_REMARK Communication link notes CHAR 50 0 AD_REMARK2
FAX_UPDATEFLAG Change operation code ('I'nsert, 'U'pdate, 'D'elete) CHAR 1 0 AD_OP_CODE
No change
D Delete
I Insert
U Update
SMTP_CONSNUMBER Sequence Number NUMC 3 0 AD_CONSNUM
SMTP_FLGDEFAULT Standard Sender Address in this Communication Type CHAR 1 0 AD_FLGDFNR
SMTP_FLG_NOUSE Flag: This Communication Number is Not Used CHAR 1 0 AD_FLNOUSE
SMTP_HOME_FLAG Recipient address in this communication type (mail sys.grp) CHAR 1 0 AD_FLGHOME
SMTP_ADDR E-Mail Address CHAR 241 0 AD_SMTPADR
SMTP_SRCH E-Mail Address Search Field CHAR 20 0 AD_SMTPAD2
SMTP_DFT_RECEIV Flag: Recipient is standard recipient for this number CHAR 1 0 AD_DFTRCNR
SMTP_R3_USER Flag: Connected to an SAP System CHAR 1 0 AD_R3_USER
ENCODE Required Data Encoding (E-Mail) CHAR 1 0 AD_ENCODE
0 NONE
1 MIME
2 UUENCODE
TNEF Flag: Receiver can receive TNEF encoding by SMTP CHAR 1 0 AD_TNEF6
SMTP_REMARK Communication link notes CHAR 50 0 AD_REMARK2
SMTP_UPDATEFLAG Change operation code ('I'nsert, 'U'pdate, 'D'elete) CHAR 1 0 AD_OP_CODE
No change
D Delete
I Insert
U Update

BUPA_DATA_ALL foreign key relationships

Table Field Check Table Check Field
0 BUPA_DATA_ALL ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) CLIENT
0 BUPA_DATA_ALL ADDRORIGIN TSAD6 Source Address or Personal Data (Business Address Services) ORIGIN
1 BUPA_DATA_ALL BPKIND TB004 BP types BPKIND
0 BUPA_DATA_ALL BU_GROUP TB001 BP groupings MANDT
0 BUPA_DATA_ALL BU_GROUP TB001 BP groupings BU_GROUP
1 BUPA_DATA_ALL BU_LANGU T002 Language Keys (Component BC-I18) SPRAS
0 BUPA_DATA_ALL BU_LOGSYS TBDLS Logical system LOGSYS
1 BUPA_DATA_ALL CITYH_CODE ADRCITY Postal cities COUNTRY
1 BUPA_DATA_ALL CITYH_CODE ADRCITY Postal cities CITY_CODE
0 BUPA_DATA_ALL CITYP_CODE ADRCITYPRT Postal districts CLIENT
0 BUPA_DATA_ALL CITYP_CODE ADRCITYPRT Postal districts COUNTRY
0 BUPA_DATA_ALL CITYP_CODE ADRCITYPRT Postal districts CITY_CODE
1 BUPA_DATA_ALL CITY_CODE ADRCITY Postal cities COUNTRY
1 BUPA_DATA_ALL CITY_CODE ADRCITY Postal cities CITY_CODE
0 BUPA_DATA_ALL CITY_CODE2 ADRCITY Postal cities COUNTRY
0 BUPA_DATA_ALL CITY_CODE2 ADRCITY Postal cities CITY_CODE
1 BUPA_DATA_ALL CLIENT T000 Clients MANDT
0 BUPA_DATA_ALL CNDSC T005 Countries MANDT
0 BUPA_DATA_ALL CNDSC T005 Countries LAND1
1 BUPA_DATA_ALL COUNTY_CODE ADRCOUNTY County codes CLIENT
1 BUPA_DATA_ALL COUNTY_CODE ADRCOUNTY County codes COUNTRY
1 BUPA_DATA_ALL COUNTY_CODE ADRCOUNTY County codes REGION
1 BUPA_DATA_ALL COUNTY_CODE ADRCOUNTY County codes COUNTY_CODE
0 BUPA_DATA_ALL DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types CLIENT
0 BUPA_DATA_ALL DELI_SERV_TYPE ADDRC_DELI_SERV Address Service Types DELI_SERV_TYPE
1 BUPA_DATA_ALL DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
1 BUPA_DATA_ALL DONT_USE_P TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
0 BUPA_DATA_ALL DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) CLIENT
0 BUPA_DATA_ALL DONT_USE_S TSAD12 Reasons for Non-Delivery (Business Address Services) UNDELIVER
1 BUPA_DATA_ALL FAX_COUNTRY T005 Countries MANDT
1 BUPA_DATA_ALL FAX_COUNTRY T005 Countries LAND1
0 BUPA_DATA_ALL GENDER TB995 BP Gender GENDER
1 BUPA_DATA_ALL JOBGR TB028 Occupations JOBGR
0 BUPA_DATA_ALL LANGU_CORR T002 Language Keys (Component BC-I18) SPRAS
1 BUPA_DATA_ALL LANGU_CREA T002 Language Keys (Component BC-I18) SPRAS
0 BUPA_DATA_ALL LEGAL_ENTY TB019 BP legal forms LEGAL_ENTY
1 BUPA_DATA_ALL LEGAL_ORG TB032 BP Legal Entity LEGAL_ORG
0 BUPA_DATA_ALL MARST TB027 BP marital status MARST
1 BUPA_DATA_ALL NAMCOUNTRY T005 Countries MANDT
1 BUPA_DATA_ALL NAMCOUNTRY T005 Countries LAND1
0 BUPA_DATA_ALL NAMEFORMAT T005N Name formats MANDT
0 BUPA_DATA_ALL NAMEFORMAT T005N Name formats LAND1
0 BUPA_DATA_ALL NAMEFORMAT T005N Name formats NAMEFORMAT
1 BUPA_DATA_ALL NATIO T005 Countries MANDT
1 BUPA_DATA_ALL NATIO T005 Countries LAND1
0 BUPA_DATA_ALL PARTGRPTYP TB025 BP group types PARTGRPTYP
1 BUPA_DATA_ALL PO_BOX_CTY T005 Countries MANDT
1 BUPA_DATA_ALL PO_BOX_CTY T005 Countries LAND1
0 BUPA_DATA_ALL PO_BOX_REG T005S Taxes: Region (Province) Key LAND1
1 BUPA_DATA_ALL PREFIX1 TSAD4 Name Prefixes (Business Address Services) CLIENT
1 BUPA_DATA_ALL PREFIX1 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
0 BUPA_DATA_ALL PREFIX2 TSAD4 Name Prefixes (Business Address Services) CLIENT
0 BUPA_DATA_ALL PREFIX2 TSAD4 Name Prefixes (Business Address Services) PREFIX_KEY
1 BUPA_DATA_ALL REGIOGROUP ADRREGGRP Regional structure grouping CLIENT
0 BUPA_DATA_ALL REGION T005S Taxes: Region (Province) Key LAND1
1 BUPA_DATA_ALL SOURCE TB005 BP data sources SOURCE
0 BUPA_DATA_ALL STREETABBR ADRSTRTYPE Street type CLIENT
0 BUPA_DATA_ALL STREETABBR ADRSTRTYPE Street type COUNTRY
1 BUPA_DATA_ALL STREETCODE ADRSTREET Streets CLIENT
1 BUPA_DATA_ALL STREETCODE ADRSTREET Streets COUNTRY
1 BUPA_DATA_ALL STREETCODE ADRSTREET Streets STRT_CODE
0 BUPA_DATA_ALL TEL_COUNTRY T005 Countries MANDT
0 BUPA_DATA_ALL TEL_COUNTRY T005 Countries LAND1
1 BUPA_DATA_ALL TIME_ZONE TTZZ Time zones TZONE
0 BUPA_DATA_ALL TITLE_ACA1 TSAD2 Academic Title (Business Address Services) CLIENT
0 BUPA_DATA_ALL TITLE_ACA1 TSAD2 Academic Title (Business Address Services) TITLE_KEY
1 BUPA_DATA_ALL TITLE_ACA2 TSAD2 Academic Title (Business Address Services) CLIENT
1 BUPA_DATA_ALL TITLE_ACA2 TSAD2 Academic Title (Business Address Services) TITLE_KEY
0 BUPA_DATA_ALL TITLE_ROYL TSAD5 Name Suffixes/Title (Key) (Business Address Services) CLIENT
0 BUPA_DATA_ALL TITLE_ROYL TSAD5 Name Suffixes/Title (Key) (Business Address Services) TITLE_KEY
1 BUPA_DATA_ALL TOWNSHIP_CODE ADRTOWNSHIP Township codes COUNTRY
1 BUPA_DATA_ALL TOWNSHIP_CODE ADRTOWNSHIP Township codes REGION
1 BUPA_DATA_ALL TOWNSHIP_CODE ADRTOWNSHIP Township codes COUNTY_CODE
1 BUPA_DATA_ALL TOWNSHIP_CODE ADRTOWNSHIP Township codes TOWNSHIP_CODE
0 BUPA_DATA_ALL TRANSPZONE TZONE Customers: Regional zones MANDT
0 BUPA_DATA_ALL TRANSPZONE TZONE Customers: Regional zones LAND1
0 BUPA_DATA_ALL TRANSPZONE TZONE Customers: Regional zones ZONE1
1 BUPA_DATA_ALL XUBNAME USR02 Logon Data (Kernel-Side Use) BNAME