BUT050_SRC

Transparent Table Application Table
10 Fields 1 CDS Views

MDC: Source table BUT050 (root) - BP Rel. Key data

BUT050_SRC is an SAP database table in S/4HANA. MDC: Source table BUT050 (root) - BP Rel. Key data. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BusPartRelationshipSource view from BASIC Core BPRel Source Packages

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY source_system MDC_BUSINESS_SYSTEM Source System
KEY source_id MDC_SOURCE_ID Source ID
source_partner1 MDC_BPREL_SOURCE_PARTNER Partner
source_partner2 MDC_BPREL_SOURCE_PARTNER Partner
reltyp BU_RELTYP Relationsh.Cat.
partner1 BU_PARTNER Busn. Partner
partner2 BU_PARTNER Busn. Partner
source_recency MDC_RECENCY Last Changed On
source_filter MDC_SOURCE_FILTER Data Package

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.

-- MDC: Source table BUT050 (root) - BP Rel. Key data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT050_SRC (
    CLIENT,           -- Client [MANDT]
    SOURCE_SYSTEM,    -- Source System [MDC_BUSINESS_SYSTEM]
    SOURCE_ID,        -- Source ID [MDC_SOURCE_ID]
    SOURCE_PARTNER1,  -- Partner [MDC_BPREL_SOURCE_PARTNER]
    SOURCE_PARTNER2,  -- Partner [MDC_BPREL_SOURCE_PARTNER]
    RELTYP,           -- Relationsh.Cat. [BU_RELTYP]
    PARTNER1,         -- Busn. Partner [BU_PARTNER]
    PARTNER2,         -- Busn. Partner [BU_PARTNER]
    SOURCE_RECENCY,   -- Last Changed On [MDC_RECENCY]
    SOURCE_FILTER,    -- Data Package [MDC_SOURCE_FILTER]
    PRIMARY KEY (CLIENT, SOURCE_SYSTEM, SOURCE_ID)
);

Learn More