BUT051

Transparent Table Application Table
28 Fields 6 CDS Views

BP Relationship: Contact Person Relationship

BUT051 is an SAP database table in S/4HANA. BP Relationship: Contact Person Relationship. It contains 28 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/BOFU/CV_BPRelshpContactPerson view left_outer BOPF: /BOFU/BuPa Node Relshp Cntct Persn
/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

Fields (28)

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
reltyp BU_RELTYP Relationsh.Cat.
xrf BU_XRF Role definition
fnctn BU_FNCTN Function
pafkt BU_PAFKT Function
dprtmnt BU_DPRTMNT Company dept.
abtnr BU_ABTNR Department
paauth BU_PAAUTH Authority
pavip BU_PAVIP VIP
parem BU_PAREM Note
tel_number AD_TLNMBR Telephone
tel_extens AD_TLXTNS Extension
fax_number AD_FXNMBR Fax
fax_extens AD_FXXTNS Extension
smtp_address AD_SMTPADR E-Mail Address
rel_per BU_REL_PER Percentage
rel_amo BU_REL_AMO Amount
rel_cur BU_CURRID Curr.
call_ruleid BU_RULEID_C Rule ID/Call
visit_ruleid BU_RULEID_V Rule ID/Visit
call_guid BU_CALENDAR_SCHEME_CALL_GUID Calendar GUID
visit_guid BU_CALENDAR_SCHEME_VISIT_GUID Calendar GUID
bp_eew_but051 DUMMY Dummy function in length 1
bp_eew_but051_sp DUMMY Dummy function in length 1

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.

-- BP Relationship: Contact Person Relationship
-- 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]
    RELTYP,            -- Relationsh.Cat. [BU_RELTYP]
    XRF,               -- Role definition [BU_XRF]
    FNCTN,             -- Function [BU_FNCTN]
    PAFKT,             -- Function [BU_PAFKT]
    DPRTMNT,           -- Company dept. [BU_DPRTMNT]
    ABTNR,             -- Department [BU_ABTNR]
    PAAUTH,            -- Authority [BU_PAAUTH]
    PAVIP,             -- VIP [BU_PAVIP]
    PAREM,             -- Note [BU_PAREM]
    TEL_NUMBER,        -- Telephone [AD_TLNMBR]
    TEL_EXTENS,        -- Extension [AD_TLXTNS]
    FAX_NUMBER,        -- Fax [AD_FXNMBR]
    FAX_EXTENS,        -- Extension [AD_FXXTNS]
    SMTP_ADDRESS,      -- E-Mail Address [AD_SMTPADR]
    REL_PER,           -- Percentage [BU_REL_PER]
    REL_AMO,           -- Amount [BU_REL_AMO]
    REL_CUR,           -- Curr. [BU_CURRID]
    CALL_RULEID,       -- Rule ID/Call [BU_RULEID_C]
    VISIT_RULEID,      -- Rule ID/Visit [BU_RULEID_V]
    CALL_GUID,         -- Calendar GUID [BU_CALENDAR_SCHEME_CALL_GUID]
    VISIT_GUID,        -- Calendar GUID [BU_CALENDAR_SCHEME_VISIT_GUID]
    BP_EEW_BUT051,     -- Dummy function in length 1 [DUMMY]
    BP_EEW_BUT051_SP,  -- Dummy function in length 1 [DUMMY]
    PRIMARY KEY (CLIENT, RELNR, PARTNER1, PARTNER2, DATE_TO)
);

Learn More