BUT051

Transparent Table Application Table

GP-Beziehung: Ansprechpartnerbeziehung

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
/BOFU/CV_BPRelshpContactPerson view left_outer BOPF: /BOFU/BuPa Node Relshp Cntct Persn
Fclm_Bm_Contacts view inner Contact person for bank
I_BPContactToFuncAndDept view from BASIC BP Contact To Function and Department
P_Bpcontacts_Func_Dept view from BASIC

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)
);