ADCP

Transparent Table Application Table
42 Fields 26 CDS Views

Person/Address Assignment (Business Address Services)

ADCP is an SAP database table in S/4HANA. Person/Address Assignment (Business Address Services). It contains 42 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
/BOFU/CV_BPAddr view left_outer BOPF: /BOFU/BuPa Address (Old)
/BOFU/CV_BPAddress view_entity left_outer BOPF: Business Partner Address
ESH_N_USER_USER_DETAILS view from ESH View for User Details
Fclm_Bm_Adcp view left_outer Linkage for adcp and adrc
Fclm_Bm_Contacts view left_outer Contact person for bank
FNDEI_ADCP_BlockingInfo view from Blocking Info View for table ADCP
fndei_adcp_filter view from Filter View for table ADCP
I_Address view left_outer BASIC Address
I_AddressRemark view_entity left_outer Address Texts
i_addressremark_copy view_entity left_outer Address Texts
I_AddressWorkplaceDetails view_entity from BASIC Person Workplace Address Details
I_BPContactPersonAddressGov view_entity inner TRANSACTIONAL Base Contact Person Workplace Address
I_BPRelshpCntctPersnAddrVersTP view_entity inner TRANSACTIONAL RAP BO Contact Person Address Versions
I_EmployeeHomeAddress view from BASIC Employee Home Address
I_LCMContactCardOrgData view from BASIC Basic view for Org Data of Contact card
I_LCMPersonAddrAssignment view from BASIC Person Address Assignment
I_ScriptedAddress view left_outer BASIC Interational Address Version
I_ScriptedPersonAddress view inner BASIC Interational Address Version for Persons
I_WorkplaceAddress view inner BASIC Employee Workplace Address
ICM_EMPLOYEE_CONTACT view inner Employee
ICM_PARTNER_CONTACT view inner BusinessPartner_contact
ICM_PARTNER_PERSON view inner BusinessPartner_person
P_EmplPrivCommData view from BASIC
P_SDM_ADRP_XPCPT view inner BASIC SDM View for ADRP-XPCPT
TSI_CONTACT_entry view inner
VFCP_DDL_BCM view left_outer

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY addrnumber AD_ADDRNUM Address Number
KEY persnumber AD_PERSNUM Person Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
date_to AD_DATE_TO To
comp_pers AD_CMP_PRS Company/Person
so_key AD_SO_KEY SO key
department AD_DPRTMNT Department
function AD_FNCTN Function
building AD_BLDNG_P Building code
floor AD_FLOOR Floor
roomnumber AD_ROOMNUM Room Number
id_code AD_ID_CODE Short name
ih_mail AD_IH_MAIL Internal mail
sort1 AD_SORTOLD Search Term 1
sort2 AD_SORTOLD Search Term 1
sort_phn AD_SRTPHN Phonet. Sort.
alt_compny AD_ALTCMPY Business addr
deflt_comm AD_COMM Comm. Method
tel_number AD_TLNMBR1 Telephone
tel_extens AD_TLXTNS1 Extension
fax_number AD_FXNMBR1 Fax
fax_extens AD_FXXTNS1 Extension
flagcomm2 AD_FLGCM02 Telephone...
flagcomm3 AD_FLGCM03 Fax...
flagcomm4 AD_FLGCM04 Teletex
flagcomm5 AD_FLGCM05 Telex
flagcomm6 AD_FLGCM06 E-Mail Defined
flagcomm7 AD_FLGCM07 R/Mail
flagcomm8 AD_FLGCM08 X.400
flagcomm9 AD_FLGCM09 RFC
flagcomm10 AD_FLGCM10 Printer
flagcomm11 AD_FLGCM11 SSF
flagcomm12 AD_FLGCM12 URI/FTP
flagcomm13 AD_FLGCM13 Pager
adcp_uuid AD_UUID Address UUID
uuid_belated AD_UUID_BELATED Subsequent UUID
id_category AD_ID_CATEGORY ID Category
adcp_err_status AD_ERR_STATUS Error Status
xpcpt AD_XPCPT PurposeComplete Flag
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Person/Address Assignment (Business Address Services)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ADCP (
    CLIENT,           -- Client [MANDT]
    ADDRNUMBER,       -- Address Number [AD_ADDRNUM]
    PERSNUMBER,       -- Person Number [AD_PERSNUM]
    DATE_FROM,        -- From [AD_DATE_FR]
    NATION,           -- Address Version [AD_NATION]
    DATE_TO,          -- To [AD_DATE_TO]
    COMP_PERS,        -- Company/Person [AD_CMP_PRS]
    SO_KEY,           -- SO key [AD_SO_KEY]
    DEPARTMENT,       -- Department [AD_DPRTMNT]
    FUNCTION,         -- Function [AD_FNCTN]
    BUILDING,         -- Building code [AD_BLDNG_P]
    FLOOR,            -- Floor [AD_FLOOR]
    ROOMNUMBER,       -- Room Number [AD_ROOMNUM]
    ID_CODE,          -- Short name [AD_ID_CODE]
    IH_MAIL,          -- Internal mail [AD_IH_MAIL]
    SORT1,            -- Search Term 1 [AD_SORTOLD]
    SORT2,            -- Search Term 1 [AD_SORTOLD]
    SORT_PHN,         -- Phonet. Sort. [AD_SRTPHN]
    ALT_COMPNY,       -- Business addr [AD_ALTCMPY]
    DEFLT_COMM,       -- Comm. Method [AD_COMM]
    TEL_NUMBER,       -- Telephone [AD_TLNMBR1]
    TEL_EXTENS,       -- Extension [AD_TLXTNS1]
    FAX_NUMBER,       -- Fax [AD_FXNMBR1]
    FAX_EXTENS,       -- Extension [AD_FXXTNS1]
    FLAGCOMM2,        -- Telephone... [AD_FLGCM02]
    FLAGCOMM3,        -- Fax... [AD_FLGCM03]
    FLAGCOMM4,        -- Teletex [AD_FLGCM04]
    FLAGCOMM5,        -- Telex [AD_FLGCM05]
    FLAGCOMM6,        -- E-Mail Defined [AD_FLGCM06]
    FLAGCOMM7,        -- R/Mail [AD_FLGCM07]
    FLAGCOMM8,        -- X.400 [AD_FLGCM08]
    FLAGCOMM9,        -- RFC [AD_FLGCM09]
    FLAGCOMM10,       -- Printer [AD_FLGCM10]
    FLAGCOMM11,       -- SSF [AD_FLGCM11]
    FLAGCOMM12,       -- URI/FTP [AD_FLGCM12]
    FLAGCOMM13,       -- Pager [AD_FLGCM13]
    ADCP_UUID,        -- Address UUID [AD_UUID]
    UUID_BELATED,     -- Subsequent UUID [AD_UUID_BELATED]
    ID_CATEGORY,      -- ID Category [AD_ID_CATEGORY]
    ADCP_ERR_STATUS,  -- Error Status [AD_ERR_STATUS]
    XPCPT,            -- PurposeComplete Flag [AD_XPCPT]
    _DATAAGING,       -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (CLIENT, ADDRNUMBER, PERSNUMBER, DATE_FROM, NATION)
);

Learn More