BUPA_INMOB_D_2

Transparent Table Application Table

Draft table for entity I_BPADDRESSINDEPENDNTMOBTP_2

BUPA_INMOB_D_2 is an SAP database table in S/4HANA. Draft table for entity I_BPADDRESSINDEPENDNTMOBTP_2. It contains 36 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPAddrIndependentMobileDraft view_entity from BASIC BP AddrIndependentMobile-Draft

Fields (36)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY addressid ad_addrnum Address Number
KEY person ad_persnum Person Number
KEY ordinalnumber ad_consnum Sequence Number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
addressidforedit ad_addrnum Address Number
ordinalnumberforedit ad_consnum Sequence Number
mobilephonecountry ad_comctry Country/Region
telephonecountryprefix sktelfto Tel. to
isdefaultphonenumber boole_d TRUE
commnumberisnotused ad_flnouse Do not use
mobilephonenumber ad_tlnmbr Telephone
phonenumberextension ad_tlxtns Extension
completetelephonenumber ad_telnrlg Telephone no.
phoneissmsenabled ad_flgsms SMS-Enab.
phonenumbertype ad_phonenumbertype Phone number type
authorizationgroup bu_augrp Authorization Group
addresscommunicationremarktext ad_remark2 Notes
isbusinesspurposecompleted bu_xpcpt Purpose Completed
validitystartdate abap.dats
validityenddate abap.dats
validitystartdatetime ad_valfrom Valid From
validityenddatetime ad_valto Valid To
datacontrollerset bu_xdcset Data Ctrlr. Set
datacontroller1 bu_data_controller Data Controller
datacontroller2 bu_data_controller Data Controller
datacontroller3 bu_data_controller Data Controller
datacontroller4 bu_data_controller Data Controller
datacontroller5 bu_data_controller Data Controller
datacontroller6 bu_data_controller Data Controller
datacontroller7 bu_data_controller Data Controller
datacontroller8 bu_data_controller Data Controller
datacontroller9 bu_data_controller Data Controller
datacontroller10 bu_data_controller Data Controller

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_BPADDRESSINDEPENDNTMOBTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_INMOB_D_2 (
    MANDT,                           -- Client [mandt]
    BUSINESSPARTNER,                 -- Busn. Partner [bu_partner]
    ADDRESSID,                       -- Address Number [ad_addrnum]
    PERSON,                          -- Person Number [ad_persnum]
    ORDINALNUMBER,                   -- Sequence Number [ad_consnum]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    ADDRESSIDFOREDIT,                -- Address Number [ad_addrnum]
    ORDINALNUMBERFOREDIT,            -- Sequence Number [ad_consnum]
    MOBILEPHONECOUNTRY,              -- Country/Region [ad_comctry]
    TELEPHONECOUNTRYPREFIX,          -- Tel. to [sktelfto]
    ISDEFAULTPHONENUMBER,            -- TRUE [boole_d]
    COMMNUMBERISNOTUSED,             -- Do not use [ad_flnouse]
    MOBILEPHONENUMBER,               -- Telephone [ad_tlnmbr]
    PHONENUMBEREXTENSION,            -- Extension [ad_tlxtns]
    COMPLETETELEPHONENUMBER,         -- Telephone no. [ad_telnrlg]
    PHONEISSMSENABLED,               -- SMS-Enab. [ad_flgsms]
    PHONENUMBERTYPE,                 -- Phone number type [ad_phonenumbertype]
    AUTHORIZATIONGROUP,              -- Authorization Group [bu_augrp]
    ADDRESSCOMMUNICATIONREMARKTEXT,  -- Notes [ad_remark2]
    ISBUSINESSPURPOSECOMPLETED,      -- Purpose Completed [bu_xpcpt]
    VALIDITYSTARTDATE,               -- abap.dats
    VALIDITYENDDATE,                 -- abap.dats
    VALIDITYSTARTDATETIME,           -- Valid From [ad_valfrom]
    VALIDITYENDDATETIME,             -- Valid To [ad_valto]
    DATACONTROLLERSET,               -- Data Ctrlr. Set [bu_xdcset]
    DATACONTROLLER1,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER2,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER3,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER4,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER5,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER6,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER7,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER8,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER9,                 -- Data Controller [bu_data_controller]
    DATACONTROLLER10,                -- Data Controller [bu_data_controller]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, ADDRESSID, PERSON, ORDINALNUMBER, DRAFTUUID)
);