BUPA_ADRC_D - I_BUSINESSPARTNERTP I_BUSINESSPARTNERADDRESSTP
I_BUSINESSPARTNERTP I_BUSINESSPARTNERADDRESSTP information is stored in SAP table BUPA_ADRC_D.
It is part of development package VDM_MD_BP in software component LO-MD-BP. This development package consists of objects that can be grouped under "VDM Master Data BP".
It is part of development package VDM_MD_BP in software component LO-MD-BP. This development package consists of objects that can be grouped under "VDM Master Data BP".
Fields for table BUPA_ADRC_D
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| DRAFTUUID | UUID serving as key (parent key, root key) | X | /BOBF/UUID | RAW | 16 | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW | 16 | ||
| BUSINESSPARTNER | Business Partner Number | BU_PARTNER | CHAR | 20 | ||
| ADDRESSNUMBER | Address Number | AD_ADDRNUM | CHAR | 20 | ||
| BUSINESSPARTNERFOREDIT | Business Partner Number | BU_PARTNER | CHAR | 20 | ||
| ADDRESSNUMBERFOREDIT | Address Number | AD_ADDRNUM | CHAR | 20 | ||
| VALIDITYSTARTDATE | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 8 | ||
| VALIDITYENDDATE | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 8 | ||
| ADDRESSVALIDITYSTARTDATE | DATS | 16 | ||||
| ADDRESSVALIDITYENDDATE | DATS | 16 | ||||
| CAREOFNAME | c/o name | AD_NAME_CO | CHAR | 80 | ||
| STREETPREFIXNAME | Street 2 | AD_STRSPP1 | CHAR | 80 | ||
| ADDITIONALSTREETPREFIXNAME | Street 3 | AD_STRSPP2 | CHAR | 80 | ||
| HOUSENUMBER | House Number | AD_HSNM1 | CHAR | 20 | ||
| STREETNAME | Street | AD_STREET | CHAR | 120 | ||
| CUSTOMERSUPPLIERSTREETNAME | Street | AD_STREET | CHAR | 120 | ||
| HOUSENUMBERSUPPLEMENTTEXT | House number supplement | AD_HSNM2 | CHAR | 20 | ||
| STREETSUFFIXNAME | Street 4 | AD_STRSPP3 | CHAR | 80 | ||
| ADDITIONALSTREETSUFFIXNAME | Street 5 | AD_LCTN | CHAR | 80 | ||
| HOMECITYNAME | City (different from postal city) | AD_CITY3 | CHAR | 80 | ||
| DISTRICT | District | AD_CITY2 | CHAR | 80 | ||
| POSTALCODE | City postal code | AD_PSTCD1 | CHAR | 20 | ||
| CITYNAME | City | AD_CITY1 | CHAR | 80 | ||
| CUSTOMERSUPPLIERCITYNAME | City | AD_CITY1 | CHAR | 80 | ||
| COUNTRY | Country/Region Key | LAND1 | CHAR | 6 | ||
| REGION | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| ADDRESSTIMEZONE | Address time zone | AD_TZONE | CHAR | 12 | ||
| TRANSPORTZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 20 | ||
| TAXJURISDICTION | Tax Jurisdiction | AD_TXJCD | CHAR | 30 | ||
| TAXJURISDICTIONBYPROVIDER | Tax Jurisdiction | AD_TXJCD | CHAR | 30 | ||
| COMPANYPOSTALCODE | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 20 | ||
| DELIVERYSERVICETYPECODE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 8 | ||
| DELIVERYSERVICENUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 20 | ||
| POBOX | PO Box | AD_POBX | CHAR | 20 | ||
| POBOXISWITHOUTNUMBER | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 2 | ||
| POBOXPOSTALCODE | PO Box Postal Code | AD_PSTCD2 | CHAR | 20 | ||
| POBOXLOBBYNAME | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 80 | ||
| POBOXDEVIATINGCITYNAME | PO Box city | AD_POBXLOC | CHAR | 80 | ||
| POBOXDEVIATINGREGION | Region for PO Box (Country/Region, State, Province, ...) | AD_POBXREG | CHAR | 6 | ||
| POBOXDEVIATINGCOUNTRY | PO Box of Country/Region | AD_POBXCTY | CHAR | 6 | ||
| CORRESPONDENCELANGUAGE | Language Key | SPRAS | LANG | 2 | ||
| PRFRDCOMMMEDIUMTYPE | Communication Method (Key) (Business Address Services) | AD_COMM | CHAR | 6 | ||
| PHONENUMBER | CHAR | 60 | ||||
| FAXNUMBER | CHAR | 60 | ||||
| PHONENUMBERCOUNTRY | CHAR | 6 | ||||
| PHONENUMBEREXTENSION | CHAR | 20 | ||||
| FAXCOUNTRY | CHAR | 6 | ||||
| FAXNUMBEREXTENSION | CHAR | 20 | ||||
| MOBILEPHONENUMBER | CHAR | 60 | ||||
| MOBILEPHONECOUNTRY | CHAR | 6 | ||||
| EMAILADDRESS | CHAR | 482 | ||||
| COUNTY | County | AD_COUNTY | CHAR | 80 | ||
| TOWNSHIPNAME | Township | AD_TOWNSHIP | CHAR | 80 | ||
| BPTARGETADDRESSID | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 20 | ||
| BPADDRESSMOVEDATETIME | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 8 | ||
| ADDRESSMOVEDATE | DATS | 16 | ||||
| INTERNATIONALPHONENUMBER | CHAR | 60 | ||||
| COMPLETEADDRESS | CHAR | 354 | ||||
| BPTARGETADDRESSTEXT | SSTR | 8 | ||||
| STANDARDUSAGE | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | BOOLE_D | CHAR | 2 | ||
| BPADDRESSISPROTECTED | BP: Sensitivity Indicator | BU_PROTECTED | CHAR | 2 | ||
| HASACTIVEENTITY | Draft - Indicator - Has active document | SDRAFT_HAS_ACTIVE | CHAR | 2 | ||
| .INCLUDE | SDRAFT_WRITE_DRAFT_ADMIN | 0 | ||||
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC | 11 | ||
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC | 11 | ||
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW | 16 | ||
| DRAFTENTITYCONSISTENCYSTATUS | Draft - Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR | 2 | ||
| DRAFTENTITYOPERATIONCODE | Draft - Operation Code | SDRAFT_OPERATION_CODE | CHAR | 2 | ||
| URLFIELDLENGTH | INT2 | 2 | ||||
| WEBSITEURL | Universal Resource Identifier (URI) | AD_URI | LCHR | 4096 |