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 |