BUPA_PERS_ADDR_D
Draft table for entity I_BUSPARTSCRIPTEDPERSONADDRTP
BUPA_PERS_ADDR_D is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTSCRIPTEDPERSONADDRTP. It contains 88 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_BPScriptedPersonAddDraft | view_entity | from | BASIC | BP Scripted Person Address-Draft |
Fields (88)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | businesspartner | BU_PARTNER | Busn. Partner | |||
| KEY | addressnumber | AD_ADDRNUM | Address Number | |||
| KEY | addressrepresentationcode | AD_NATION | Address Version | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| parentdraftuuid | SDRAFT_UUID | Draft Document ID | ||||
| addrrepcodeforeditvalue | AD_NATION | Address Version | ||||
| validitystartdate | abap.dats | |||||
| validityenddate | abap.dats | |||||
| businesspartneraddressuuid | abap.char | |||||
| careofname | AD_NAME_CO | c/o | ||||
| additionalstreetsuffixname | AD_LCTN | Street 5 | ||||
| prfrdcommmediumtype | AD_COMM | Comm. Method | ||||
| pobox | AD_POBX | PO Box | ||||
| poboxiswithoutnumber | AD_POBXNUM | PO Box w/o No. | ||||
| poboxpostalcode | AD_PSTCD2 | PO Box Post Cde | ||||
| poboxlobbyname | AD_PO_BOX_LBY | PO Box Lobby | ||||
| poboxdeviatingcityname | AD_POBXLOC | PO Box City | ||||
| poboxdeviatingregion | AD_POBXREG | PO Region | ||||
| poboxdeviatingcountry | AD_POBXCTY | PO Box C/R | ||||
| deliveryservicetypecode | AD_DELIVERY_SERVICE_TYPE | Delvry Serv Type | ||||
| deliveryservicenumber | AD_DELIVERY_SERVICE_NUMBER | Delivery Service No. | ||||
| addresstimezone | AD_TZONE | Time Zone | ||||
| fullname | ADFULLNAME | Full Name | ||||
| cityname | AD_CITY1 | City | ||||
| district | AD_CITY2 | District | ||||
| districtname | AD_CITY2 | District | ||||
| homecityname | AD_CITY3 | Different City | ||||
| postalcode | AD_PSTCD1 | Postal Code | ||||
| companypostalcode | AD_PSTCD3 | Company Post Cd | ||||
| streetname | AD_STREET | Street | ||||
| streetprefixname | AD_STRSPP1 | Street 2 | ||||
| additionalstreetprefixname | AD_STRSPP2 | Street 3 | ||||
| streetsuffixname | AD_STRSPP3 | Street 4 | ||||
| housenumber | AD_HSNM1 | House Number | ||||
| housenumbersupplementtext | AD_HSNM2 | Supplement | ||||
| building | AD_BLDNG | Building Code | ||||
| floor | AD_FLOOR | Floor | ||||
| roomnumber | AD_ROOMNUM | Room Number | ||||
| country | LAND1 | Country/Reg. | ||||
| region | REGIO | Region | ||||
| county | AD_COUNTY | County | ||||
| bpcountytext | AD_COUNTY | County | ||||
| formattedaddress | abap.char | |||||
| taxjurisdiction | AD_TXJCD | Tax Jurisdiction | ||||
| transportzone | LZONE | Transport Zone | ||||
| formofaddress | AD_TITLE | Title Key | ||||
| person | AD_PERSNUM | Person Number | ||||
| searchterm1 | AD_SORT1 | Search Term 1 | ||||
| searchterm2 | AD_SORT2 | Search Term 2 | ||||
| firstname | AD_NAMEFIR | First Name | ||||
| lastname | AD_NAMELAS | Last Name | ||||
| businesspartnerbirthname | AD_NAME2_P | Name at Birth | ||||
| middlename | AD_NAMEMID | 2nd First Name | ||||
| additionallastname | AD_NAMLAS2 | 2nd Family Name | ||||
| personfullname | AD_NAMTEXT | Full Name | ||||
| academictitle | AD_TITLE1 | Academic Title | ||||
| academictitle2 | AD_TITLE2 | 2nd Academic | ||||
| lastnameprefix | AD_PREFIX | Prefix Key | ||||
| lastnamesecondprefix | AD_PREFIX2 | 2nd prefix | ||||
| businesspartnersupplementname | AD_TITLES | Name Supplement | ||||
| businesspartnernicknamelabel | AD_NICKNAM | Nickname | ||||
| initials | AD_INITS | Initials | ||||
| nameformat | AD_FORMAT | Name Format | ||||
| namecountry | AD_NAMCTRY | Country/Region | ||||
| bpfirstnamesearchhelp | AD_MC_NMFI | First Name | ||||
| bplastnamesearchhelp | AD_MC_NMLA | Last Name | ||||
| datacontrollerset | BU_XDCSET | Data Ctrlr. Set | ||||
| datacontroller1 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller2 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller3 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller4 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller5 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller6 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller7 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller8 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller9 | BU_DATA_CONTROLLER | Data Controller | ||||
| datacontroller10 | BU_DATA_CONTROLLER | Data Controller | ||||
| authorizationgroup | BU_AUGRP | Authorization Group | ||||
| isbusinesspurposecompleted | BU_XPCPT | Purpose Completed | ||||
| bpaddressisprotected | BU_PROTECTED | Sensitivity | ||||
| businesspartnerdraftuuid | SDRAFT_UUID | Draft Document ID | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Draft table for entity I_BUSPARTSCRIPTEDPERSONADDRTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_PERS_ADDR_D (
MANDT, -- Client [MANDT]
BUSINESSPARTNER, -- Busn. Partner [BU_PARTNER]
ADDRESSNUMBER, -- Address Number [AD_ADDRNUM]
ADDRESSREPRESENTATIONCODE, -- Address Version [AD_NATION]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
PARENTDRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
ADDRREPCODEFOREDITVALUE, -- Address Version [AD_NATION]
VALIDITYSTARTDATE, -- abap.dats
VALIDITYENDDATE, -- abap.dats
BUSINESSPARTNERADDRESSUUID, -- abap.char
CAREOFNAME, -- c/o [AD_NAME_CO]
ADDITIONALSTREETSUFFIXNAME, -- Street 5 [AD_LCTN]
PRFRDCOMMMEDIUMTYPE, -- Comm. Method [AD_COMM]
POBOX, -- PO Box [AD_POBX]
POBOXISWITHOUTNUMBER, -- PO Box w/o No. [AD_POBXNUM]
POBOXPOSTALCODE, -- PO Box Post Cde [AD_PSTCD2]
POBOXLOBBYNAME, -- PO Box Lobby [AD_PO_BOX_LBY]
POBOXDEVIATINGCITYNAME, -- PO Box City [AD_POBXLOC]
POBOXDEVIATINGREGION, -- PO Region [AD_POBXREG]
POBOXDEVIATINGCOUNTRY, -- PO Box C/R [AD_POBXCTY]
DELIVERYSERVICETYPECODE, -- Delvry Serv Type [AD_DELIVERY_SERVICE_TYPE]
DELIVERYSERVICENUMBER, -- Delivery Service No. [AD_DELIVERY_SERVICE_NUMBER]
ADDRESSTIMEZONE, -- Time Zone [AD_TZONE]
FULLNAME, -- Full Name [ADFULLNAME]
CITYNAME, -- City [AD_CITY1]
DISTRICT, -- District [AD_CITY2]
DISTRICTNAME, -- District [AD_CITY2]
HOMECITYNAME, -- Different City [AD_CITY3]
POSTALCODE, -- Postal Code [AD_PSTCD1]
COMPANYPOSTALCODE, -- Company Post Cd [AD_PSTCD3]
STREETNAME, -- Street [AD_STREET]
STREETPREFIXNAME, -- Street 2 [AD_STRSPP1]
ADDITIONALSTREETPREFIXNAME, -- Street 3 [AD_STRSPP2]
STREETSUFFIXNAME, -- Street 4 [AD_STRSPP3]
HOUSENUMBER, -- House Number [AD_HSNM1]
HOUSENUMBERSUPPLEMENTTEXT, -- Supplement [AD_HSNM2]
BUILDING, -- Building Code [AD_BLDNG]
FLOOR, -- Floor [AD_FLOOR]
ROOMNUMBER, -- Room Number [AD_ROOMNUM]
COUNTRY, -- Country/Reg. [LAND1]
REGION, -- Region [REGIO]
COUNTY, -- County [AD_COUNTY]
BPCOUNTYTEXT, -- County [AD_COUNTY]
FORMATTEDADDRESS, -- abap.char
TAXJURISDICTION, -- Tax Jurisdiction [AD_TXJCD]
TRANSPORTZONE, -- Transport Zone [LZONE]
FORMOFADDRESS, -- Title Key [AD_TITLE]
PERSON, -- Person Number [AD_PERSNUM]
SEARCHTERM1, -- Search Term 1 [AD_SORT1]
SEARCHTERM2, -- Search Term 2 [AD_SORT2]
FIRSTNAME, -- First Name [AD_NAMEFIR]
LASTNAME, -- Last Name [AD_NAMELAS]
BUSINESSPARTNERBIRTHNAME, -- Name at Birth [AD_NAME2_P]
MIDDLENAME, -- 2nd First Name [AD_NAMEMID]
ADDITIONALLASTNAME, -- 2nd Family Name [AD_NAMLAS2]
PERSONFULLNAME, -- Full Name [AD_NAMTEXT]
ACADEMICTITLE, -- Academic Title [AD_TITLE1]
ACADEMICTITLE2, -- 2nd Academic [AD_TITLE2]
LASTNAMEPREFIX, -- Prefix Key [AD_PREFIX]
LASTNAMESECONDPREFIX, -- 2nd prefix [AD_PREFIX2]
BUSINESSPARTNERSUPPLEMENTNAME, -- Name Supplement [AD_TITLES]
BUSINESSPARTNERNICKNAMELABEL, -- Nickname [AD_NICKNAM]
INITIALS, -- Initials [AD_INITS]
NAMEFORMAT, -- Name Format [AD_FORMAT]
NAMECOUNTRY, -- Country/Region [AD_NAMCTRY]
BPFIRSTNAMESEARCHHELP, -- First Name [AD_MC_NMFI]
BPLASTNAMESEARCHHELP, -- Last Name [AD_MC_NMLA]
DATACONTROLLERSET, -- Data Ctrlr. Set [BU_XDCSET]
DATACONTROLLER1, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER2, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER3, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER4, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER5, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER6, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER7, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER8, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER9, -- Data Controller [BU_DATA_CONTROLLER]
DATACONTROLLER10, -- Data Controller [BU_DATA_CONTROLLER]
AUTHORIZATIONGROUP, -- Authorization Group [BU_AUGRP]
ISBUSINESSPURPOSECOMPLETED, -- Purpose Completed [BU_XPCPT]
BPADDRESSISPROTECTED, -- Sensitivity [BU_PROTECTED]
BUSINESSPARTNERDRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
PRIMARY KEY (MANDT, BUSINESSPARTNER, ADDRESSNUMBER, ADDRESSREPRESENTATIONCODE, DRAFTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA