BUT050_PRC

Transparent Table Application Table

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

BUT050_PRC is an SAP database table in S/4HANA. MDC: Process table BUT050 (root) - BP Rel. Key data. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BPContactPersonAddressProc view_entity inner TRANSACTIONAL BP Contact Person Workplace Address
I_BusPartRelationshipProcess view_entity from BASIC Core Business Partner Relationship Proc

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
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

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: Process 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_PRC (
    CLIENT,           -- Client [mandt]
    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]
    PRIMARY KEY (CLIENT)
);