BUT_ADR2_MOB_DFT

Transparent Table Application Table
25 Fields 1 CDS Views

Draft table for entity I_BUSPARTMOBILENUMBERGOVTP

BUT_ADR2_MOB_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTMOBILENUMBERGOVTP. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPMobileNumberGovDraft view_entity from BASIC Draft Access BP Mobile Number

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY businesspartneruuid SYSUUID_X UUID
KEY businesspartneraddressuuid SYSUUID_X UUID
KEY bpmobileuuid 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
ordinalnumberforedit AD_CONSNUM Sequence Number
mdchgprocessstep MDC_PROCESS_STEP_NO Step Number
mobilephonecountry AD_COMCTRY Country/Region
telephonecountryprefix SKTELFTO Tel. to
isdefaultphonenumber BOOLE_D TRUE
mobilephonenumber AD_TLNMBR Telephone
phoneissmsenabled AD_FLGSMS SMS-Enab.
phonenumbertype AD_FLGMOB Mobile phone
validitystartdatetime AD_VALFROM Valid From
validityenddatetime AD_VALTO Valid To
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_BUSPARTMOBILENUMBERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR2_MOB_DFT (
    MANDT,                          -- Client [MANDT]
    BUSINESSPARTNERUUID,            -- UUID [SYSUUID_X]
    BUSINESSPARTNERADDRESSUUID,     -- UUID [SYSUUID_X]
    BPMOBILEUUID,                   -- 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]
    ORDINALNUMBERFOREDIT,           -- Sequence Number [AD_CONSNUM]
    MDCHGPROCESSSTEP,               -- Step Number [MDC_PROCESS_STEP_NO]
    MOBILEPHONECOUNTRY,             -- Country/Region [AD_COMCTRY]
    TELEPHONECOUNTRYPREFIX,         -- Tel. to [SKTELFTO]
    ISDEFAULTPHONENUMBER,           -- TRUE [BOOLE_D]
    MOBILEPHONENUMBER,              -- Telephone [AD_TLNMBR]
    PHONEISSMSENABLED,              -- SMS-Enab. [AD_FLGSMS]
    PHONENUMBERTYPE,                -- Mobile phone [AD_FLGMOB]
    VALIDITYSTARTDATETIME,          -- Valid From [AD_VALFROM]
    VALIDITYENDDATETIME,            -- Valid To [AD_VALTO]
    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, BUSINESSPARTNERUUID, BUSINESSPARTNERADDRESSUUID, BPMOBILEUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, ORDINALNUMBER)
);

Learn More