BUPA_EMAIL_D_2

Transparent Table Application Table
29 Fields 1 CDS Views

Draft table for entity I_BUSPARTEMAILADDRESSTP_2

BUPA_EMAIL_D_2 is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTEMAILADDRESSTP_2. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPEmailAddressDraft view_entity from BASIC BP Email Address-Draft

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY addressnumber ad_addrnum Address Number
KEY ordinalnumber ad_consnum Sequence Number
KEY person ad_persnum Person Number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
ordinalnumberforedit ad_consnum Sequence Number
isdefaultemailaddress ad_emailcurdflt Email is Cur Dflt
emailaddress ad_smtpadr E-Mail Address
ishomeemailaddress ad_flghome Home Address
validitystartdatetime ad_valfrom Valid From
validityenddatetime ad_valto Valid To
validitystartdate abap.dats
validityenddate abap.dats
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
authorizationgroup bu_augrp Authorization Group
isbusinesspurposecompleted bu_xpcpt Purpose Completed
businesspartnerdraftuuid sdraft_uuid Draft Document ID

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_BUSPARTEMAILADDRESSTP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_EMAIL_D_2 (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    ADDRESSNUMBER,               -- Address Number [ad_addrnum]
    ORDINALNUMBER,               -- Sequence Number [ad_consnum]
    PERSON,                      -- Person Number [ad_persnum]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    ORDINALNUMBERFOREDIT,        -- Sequence Number [ad_consnum]
    ISDEFAULTEMAILADDRESS,       -- Email is Cur Dflt [ad_emailcurdflt]
    EMAILADDRESS,                -- E-Mail Address [ad_smtpadr]
    ISHOMEEMAILADDRESS,          -- Home Address [ad_flghome]
    VALIDITYSTARTDATETIME,       -- Valid From [ad_valfrom]
    VALIDITYENDDATETIME,         -- Valid To [ad_valto]
    VALIDITYSTARTDATE,           -- abap.dats
    VALIDITYENDDATE,             -- abap.dats
    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]
    AUTHORIZATIONGROUP,          -- Authorization Group [bu_augrp]
    ISBUSINESSPURPOSECOMPLETED,  -- Purpose Completed [bu_xpcpt]
    BUSINESSPARTNERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, ADDRESSNUMBER, ORDINALNUMBER, PERSON, DRAFTUUID)
);

Learn More