BUR_ADCP_PRC

Transparent Table Application Table
51 Fields 1 CDS Views

Process Records Of OTC 1405, Table ADCP

BUR_ADCP_PRC is an SAP database table in S/4HANA. Process Records Of OTC 1405, Table ADCP. It contains 51 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BPContactPersonAddressProc view_entity inner TRANSACTIONAL BP Contact Person Workplace Address

Fields (51)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY process_id MDC_PROCESS_ID Process ID
KEY process_step_no MDC_PROCESS_STEP_NO Step Number
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
KEY source_addrnumber AD_ADDRNUM Address Number
KEY date_from AD_DATE_FR From
KEY nation AD_NATION Address Version
addrnumber AD_ADDRNUM Address Number
persnumber AD_PERSNUM Person Number
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
source_recency MDC_RECENCY Last Changed On
source_modified MDC_SOURCE_MODIFIED Modified
source_modification_blip MDC_MODIFICATION_BLIP Modification
source_index MDC_SOURCE_INDEX Index

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.

-- Process Records Of OTC 1405, Table ADCP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUR_ADCP_PRC (
    CLIENT,                    -- Client [MANDT]
    PROCESS_ID,                -- Process ID [MDC_PROCESS_ID]
    PROCESS_STEP_NO,           -- Step Number [MDC_PROCESS_STEP_NO]
    SOURCE_SYSTEM,             -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,                 -- Source ID [MDC_SOURCE_ID]
    SOURCE_ADDRNUMBER,         -- Address Number [AD_ADDRNUM]
    DATE_FROM,                 -- From [AD_DATE_FR]
    NATION,                    -- Address Version [AD_NATION]
    ADDRNUMBER,                -- Address Number [AD_ADDRNUM]
    PERSNUMBER,                -- Person Number [AD_PERSNUM]
    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]
    SOURCE_RECENCY,            -- Last Changed On [MDC_RECENCY]
    SOURCE_MODIFIED,           -- Modified [MDC_SOURCE_MODIFIED]
    SOURCE_MODIFICATION_BLIP,  -- Modification [MDC_MODIFICATION_BLIP]
    SOURCE_INDEX,              -- Index [MDC_SOURCE_INDEX]
    PRIMARY KEY (CLIENT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, SOURCE_ADDRNUMBER, DATE_FROM, NATION)
);

Learn More