ADCP

Transparent Table Application Table
42 Fields 23 CDS Views

Zuordnung Person/Adresse (Business Address Services)

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

CDS Views using this table (23)

ViewTypeJoinVDMDescription
/BOFU/CV_BPAddress view left_outer BOPF: /BOFU/BuPa 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_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.

-- Zuordnung Person/Adresse (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