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".

Fields for table BUPA_ADRC_D

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6
DRAFTUUIDUUID serving as key (parent key, root key)X/BOBF/UUIDRAW16
PARENTDRAFTUUIDUUID serving as key (parent key, root key)/BOBF/UUIDRAW16
BUSINESSPARTNERBusiness Partner NumberBU_PARTNERCHAR20
ADDRESSNUMBERAddress NumberAD_ADDRNUMCHAR20
BUSINESSPARTNERFOREDITBusiness Partner NumberBU_PARTNERCHAR20
ADDRESSNUMBERFOREDITAddress NumberAD_ADDRNUMCHAR20
VALIDITYSTARTDATEValidity Start of a Business Partner AddressBU_ADDR_VALID_FROMDEC8
VALIDITYENDDATEValidity End of a Business Partner AddressBU_ADDR_VALID_TODEC8
ADDRESSVALIDITYSTARTDATEDATS16
ADDRESSVALIDITYENDDATEDATS16
CAREOFNAMEc/o nameAD_NAME_COCHAR80
STREETPREFIXNAMEStreet 2AD_STRSPP1CHAR80
ADDITIONALSTREETPREFIXNAMEStreet 3AD_STRSPP2CHAR80
HOUSENUMBERHouse NumberAD_HSNM1CHAR20
STREETNAMEStreetAD_STREETCHAR120
CUSTOMERSUPPLIERSTREETNAMEStreetAD_STREETCHAR120
HOUSENUMBERSUPPLEMENTTEXTHouse number supplementAD_HSNM2CHAR20
STREETSUFFIXNAMEStreet 4AD_STRSPP3CHAR80
ADDITIONALSTREETSUFFIXNAMEStreet 5AD_LCTNCHAR80
HOMECITYNAMECity (different from postal city)AD_CITY3CHAR80
DISTRICTDistrictAD_CITY2CHAR80
POSTALCODECity postal codeAD_PSTCD1CHAR20
CITYNAMECityAD_CITY1CHAR80
CUSTOMERSUPPLIERCITYNAMECityAD_CITY1CHAR80
COUNTRYCountry/Region KeyLAND1CHAR6
REGIONRegion (State, Province, County)REGIOCHAR6
ADDRESSTIMEZONEAddress time zoneAD_TZONECHAR12
TRANSPORTZONETransportation zone to or from which the goods are deliveredLZONECHAR20
TAXJURISDICTIONTax JurisdictionAD_TXJCDCHAR30
TAXJURISDICTIONBYPROVIDERTax JurisdictionAD_TXJCDCHAR30
COMPANYPOSTALCODECompany Postal Code (for Large Customers)AD_PSTCD3CHAR20
DELIVERYSERVICETYPECODEType of Delivery ServiceAD_DELIVERY_SERVICE_TYPECHAR8
DELIVERYSERVICENUMBERNumber of Delivery ServiceAD_DELIVERY_SERVICE_NUMBERCHAR20
POBOXPO BoxAD_POBXCHAR20
POBOXISWITHOUTNUMBERFlag: PO Box Without NumberAD_POBXNUMCHAR2
POBOXPOSTALCODEPO Box Postal CodeAD_PSTCD2CHAR20
POBOXLOBBYNAMEPO Box LobbyAD_PO_BOX_LBYCHAR80
POBOXDEVIATINGCITYNAMEPO Box cityAD_POBXLOCCHAR80
POBOXDEVIATINGREGIONRegion for PO Box (Country/Region, State, Province, ...)AD_POBXREGCHAR6
POBOXDEVIATINGCOUNTRYPO Box of Country/RegionAD_POBXCTYCHAR6
CORRESPONDENCELANGUAGELanguage KeySPRASLANG2
PRFRDCOMMMEDIUMTYPECommunication Method (Key) (Business Address Services)AD_COMMCHAR6
PHONENUMBERCHAR60
FAXNUMBERCHAR60
PHONENUMBERCOUNTRYCHAR6
PHONENUMBEREXTENSIONCHAR20
FAXCOUNTRYCHAR6
FAXNUMBEREXTENSIONCHAR20
MOBILEPHONENUMBERCHAR60
MOBILEPHONECOUNTRYCHAR6
EMAILADDRESSCHAR482
COUNTYCountyAD_COUNTYCHAR80
TOWNSHIPNAMETownshipAD_TOWNSHIPCHAR80
BPTARGETADDRESSIDNumber of Move Target Address for Address MovesBU_MOVE_ADDRCHAR20
BPADDRESSMOVEDATETIMEDate of Move for Address MovesBU_ADDR_MOVE_DATEDEC8
ADDRESSMOVEDATEDATS16
INTERNATIONALPHONENUMBERCHAR60
COMPLETEADDRESSCHAR354
BPTARGETADDRESSTEXTSSTR8
STANDARDUSAGEData element for domain BOOLE: TRUE (='X') and FALSE (=' ')BOOLE_DCHAR2
BPADDRESSISPROTECTEDBP: Sensitivity IndicatorBU_PROTECTEDCHAR2
HASACTIVEENTITYDraft - Indicator - Has active documentSDRAFT_HAS_ACTIVECHAR2
.INCLUDESDRAFT_WRITE_DRAFT_ADMIN0
DRAFTENTITYCREATIONDATETIMEDraft Created OnSDRAFT_CREATED_ATDEC11
DRAFTENTITYLASTCHANGEDATETIMEDraft Last Changed OnSDRAFT_LAST_CHANGED_ATDEC11
DRAFTADMINISTRATIVEDATAUUIDTechnical ID for the Administrative Data of a Draft DocumentSDRAFT_ADMIN_UUIDRAW16
DRAFTENTITYCONSISTENCYSTATUSDraft - Consistency StatusSDRAFT_CONSISTENCY_STATUSCHAR2
DRAFTENTITYOPERATIONCODEDraft - Operation CodeSDRAFT_OPERATION_CODECHAR2
URLFIELDLENGTHINT22
WEBSITEURLUniversal Resource Identifier (URI)AD_URILCHR4096
Privacy Policy