BUT051

Transparent Table Application Table
5 Fields 5 CDS Views

GP-Beziehung: Ansprechpartnerbeziehung

BUT051 is an SAP database table in S/4HANA. GP-Beziehung: Ansprechpartnerbeziehung. It contains 5 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
/BOFU/VE_BPRCP view_entity left_outer BOPF: Business Partner Contact Person
Fclm_Bm_Contacts view inner Contact person for bank
I_BPContactToFuncAndDept view from BASIC BP Contact To Function and Department
I_JITBusPartContactPerson view_entity from BASIC JIT Contact Person
P_Bpcontacts_Func_Dept view from BASIC Business Partner Contacts Function And Department

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY relnr bu_relnr BP Rel. Number
KEY partner1 bu_partner Busn. Partner
KEY partner2 bu_partner Busn. Partner
KEY date_to bu_datto Valid 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.

-- GP-Beziehung: Ansprechpartnerbeziehung
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT051 (
    CLIENT,    -- Client [mandt]
    RELNR,     -- BP Rel. Number [bu_relnr]
    PARTNER1,  -- Busn. Partner [bu_partner]
    PARTNER2,  -- Busn. Partner [bu_partner]
    DATE_TO,   -- Valid To [bu_datto]
    PRIMARY KEY (CLIENT, RELNR, PARTNER1, PARTNER2, DATE_TO)
);

Learn More