BUR_ADR2_DFT

Transparent Table Application Table
21 Fields 1 CDS Views

Draft table for entity I_BPCNTCTPERSNTELNUMBERGOVTP

BUR_ADR2_DFT is an SAP database table in S/4HANA. Draft table for entity I_BPCNTCTPERSNTELNUMBERGOVTP. It contains 21 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPCntctPersnTelNmbrGovDraft view_entity from BASIC Draft Access Rel Workplace Phone

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bprelshpuuid sysuuid_x UUID
KEY bpcntctpersnaddruuid sysuuid_x UUID
KEY bptelephoneuuid sysuuid_x UUID
KEY masterdatachangeprocess mdc_process_id Process ID
KEY mdchgprocesssrcesystem mdc_business_system Source System
KEY mdchgprocesssrceobject mdc_source_id Source ID
KEY addressnumber ad_addrnum Address Number
KEY ordinalnumber ad_consnum Sequence Number
KEY bprelshpcatisinfwddirection abap.char
ordinalnumberforedit ad_consnum Sequence Number
mdchgprocessstep mdc_process_step_no Step Number
destinationlocationcountry ad_comctry Country/Region
telephonecountryprefix sktelfto Tel. to
isdefaultphonenumber boole_d TRUE
phonenumber ad_tlnmbr Telephone
phonenumberextension ad_tlxtns Extension
internationalphonenumber ad_telnrlg Telephone no.
phonenumbertype ad_flgmob Mobile phone
validitystartdatetime ad_valfrom Valid From
validityenddatetime ad_valto Valid To

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_BPCNTCTPERSNTELNUMBERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUR_ADR2_DFT (
    MANDT,                        -- Client [mandt]
    BPRELSHPUUID,                 -- UUID [sysuuid_x]
    BPCNTCTPERSNADDRUUID,         -- UUID [sysuuid_x]
    BPTELEPHONEUUID,              -- UUID [sysuuid_x]
    MASTERDATACHANGEPROCESS,      -- Process ID [mdc_process_id]
    MDCHGPROCESSSRCESYSTEM,       -- Source System [mdc_business_system]
    MDCHGPROCESSSRCEOBJECT,       -- Source ID [mdc_source_id]
    ADDRESSNUMBER,                -- Address Number [ad_addrnum]
    ORDINALNUMBER,                -- Sequence Number [ad_consnum]
    BPRELSHPCATISINFWDDIRECTION,  -- abap.char
    ORDINALNUMBERFOREDIT,         -- Sequence Number [ad_consnum]
    MDCHGPROCESSSTEP,             -- Step Number [mdc_process_step_no]
    DESTINATIONLOCATIONCOUNTRY,   -- Country/Region [ad_comctry]
    TELEPHONECOUNTRYPREFIX,       -- Tel. to [sktelfto]
    ISDEFAULTPHONENUMBER,         -- TRUE [boole_d]
    PHONENUMBER,                  -- Telephone [ad_tlnmbr]
    PHONENUMBEREXTENSION,         -- Extension [ad_tlxtns]
    INTERNATIONALPHONENUMBER,     -- Telephone no. [ad_telnrlg]
    PHONENUMBERTYPE,              -- Mobile phone [ad_flgmob]
    VALIDITYSTARTDATETIME,        -- Valid From [ad_valfrom]
    VALIDITYENDDATETIME,          -- Valid To [ad_valto]
    PRIMARY KEY (MANDT, BPRELSHPUUID, BPCNTCTPERSNADDRUUID, BPTELEPHONEUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, ORDINALNUMBER, BPRELSHPCATISINFWDDIRECTION)
);

Learn More