BUPA_ADRU_D_2

Transparent Table Application Table
26 Fields 1 CDS Views

Draft table for entity I_BUSINESSPARTNERADDRUSAGETP_2

BUPA_ADRU_D_2 is an SAP database table in S/4HANA. Draft table for entity I_BUSINESSPARTNERADDRUSAGETP_2. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPAddressUsageDraft view_entity from BASIC BusinessPartner Address Usage-Draft

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartner bu_partner Busn. Partner
KEY addressnumber ad_addrnum Address Number
KEY addressusage bu_adrkind Address Type
KEY validityenddate abap.char
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
addressusageforeditvalue bu_adrkind Address Type
validityenddateforedit abap.dats
validitystartdate abap.dats
standardusage bu_xdfadu Standard Usage
authorizationgroup bu_augrp Authorization Group
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
isbusinesspurposecompleted bu_xpcpt Purpose Completed
bpaddressisprotected bu_protected Sensitivity
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_BUSINESSPARTNERADDRUSAGETP_2
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUPA_ADRU_D_2 (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNER,             -- Busn. Partner [bu_partner]
    ADDRESSNUMBER,               -- Address Number [ad_addrnum]
    ADDRESSUSAGE,                -- Address Type [bu_adrkind]
    VALIDITYENDDATE,             -- abap.char
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    ADDRESSUSAGEFOREDITVALUE,    -- Address Type [bu_adrkind]
    VALIDITYENDDATEFOREDIT,      -- abap.dats
    VALIDITYSTARTDATE,           -- abap.dats
    STANDARDUSAGE,               -- Standard Usage [bu_xdfadu]
    AUTHORIZATIONGROUP,          -- Authorization Group [bu_augrp]
    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]
    ISBUSINESSPURPOSECOMPLETED,  -- Purpose Completed [bu_xpcpt]
    BPADDRESSISPROTECTED,        -- Sensitivity [bu_protected]
    BUSINESSPARTNERDRAFTUUID,    -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, BUSINESSPARTNER, ADDRESSNUMBER, ADDRESSUSAGE, VALIDITYENDDATE, DRAFTUUID)
);

Learn More