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