BUT_ADR3_DFT

Transparent Table Application Table
16 Fields 1 CDS Views

Draft table for entity I_BUSPARTFAXNUMBERGOVTP

BUT_ADR3_DFT is an SAP database table in S/4HANA. Draft table for entity I_BUSPARTFAXNUMBERGOVTP. It contains 16 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_BPFaxNumberGovDraft view_entity from BASIC Draft Access BP Fax Number

Fields (16)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY businesspartneruuid sysuuid_x UUID
KEY businesspartneraddressuuid sysuuid_x UUID
KEY bpfaxuuid 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
isdefaultfaxnumber ad_flgdfnr Standard No.
faxcountry ad_comctry Country/Region
addressfaxnumber ad_fxnmbr Fax
faxnumberextension ad_fxxtns Extension
internationalfaxnumber ad_fxnrlng Fax Number
telephonecountryprefix sktelfto Tel. to

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_BUSPARTFAXNUMBERGOVTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT_ADR3_DFT (
    MANDT,                       -- Client [mandt]
    BUSINESSPARTNERUUID,         -- UUID [sysuuid_x]
    BUSINESSPARTNERADDRESSUUID,  -- UUID [sysuuid_x]
    BPFAXUUID,                   -- 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]
    ISDEFAULTFAXNUMBER,          -- Standard No. [ad_flgdfnr]
    FAXCOUNTRY,                  -- Country/Region [ad_comctry]
    ADDRESSFAXNUMBER,            -- Fax [ad_fxnmbr]
    FAXNUMBEREXTENSION,          -- Extension [ad_fxxtns]
    INTERNATIONALFAXNUMBER,      -- Fax Number [ad_fxnrlng]
    TELEPHONECOUNTRYPREFIX,      -- Tel. to [sktelfto]
    PRIMARY KEY (MANDT, BUSINESSPARTNERUUID, BUSINESSPARTNERADDRESSUUID, BPFAXUUID, MASTERDATACHANGEPROCESS, MDCHGPROCESSSRCESYSTEM, MDCHGPROCESSSRCEOBJECT, ADDRESSNUMBER, ORDINALNUMBER)
);

Learn More