BUT_ADR12_DFT

Transparent Table Application Table
15 Fields 1 CDS Views

Draft table for entity I_BusPartWebsiteURLGovTP

BUT_ADR12_DFT is an SAP database table in S/4HANA. Draft table for entity I_BusPartWebsiteURLGovTP. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPWebsiteURLGovernanceDraft view_entity from BASIC Draft Access BP Website

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY businesspartneraddressuuid sysuuid_x UUID
KEY bpwebsiteurluuid 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
mdchgprocessstep mdc_process_step_no Step Number
isdefaulturladdress ad_flgdfad Standard addr.
searchurladdress ad_uri2 URI address
uniformresourceidentifiertype ad_uritype URI type
urlfieldlength ad_urilng URI length
websiteurl ad_uri URI

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_BusPartWebsiteURLGovTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR12_DFT (
    MANDT,                          -- Client [mandt]
    BUSINESSPARTNERUUID,            -- UUID [sysuuid_x]
    BUSINESSPARTNERADDRESSUUID,     -- UUID [sysuuid_x]
    BPWEBSITEURLUUID,               -- 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]
    MDCHGPROCESSSTEP,               -- Step Number [mdc_process_step_no]
    ISDEFAULTURLADDRESS,            -- Standard addr. [ad_flgdfad]
    SEARCHURLADDRESS,               -- URI address [ad_uri2]
    UNIFORMRESOURCEIDENTIFIERTYPE,  -- URI type [ad_uritype]
    URLFIELDLENGTH,                 -- URI length [ad_urilng]
    WEBSITEURL,                     -- URI [ad_uri]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, BUSINESSPARTNERADDRESSUUID, BPWEBSITEURLUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, ORDINALNUMBER)
);

Learn More