BUT050

Transparent Table Application Table
21 Fields 26 CDS Views

BP relationships/role definitions: General data

BUT050 is an SAP database table in S/4HANA. BP relationships/role definitions: General data. It contains 21 fields. 26 CDS views read from this table.

CDS Views using this table (26)

ViewTypeJoinVDMDescription
/BOFU/CV_BPRelationship view union BOPF: /BOFU/BuPa Node Relationship
/BOFU/CV_BPRelationship view from BOPF: /BOFU/BuPa Node Relationship
/BOFU/CV_BPRelshpContactPerson view from BOPF: /BOFU/BuPa Node Relshp Cntct Persn
/BOFU/VE_BPRCP view_entity from BOPF: Business Partner Contact Person
/BOFU/VE_BPRL view_entity from BOPF: Business Partner Relationship
/BOFU/VE_BPRL view_entity union BOPF: Business Partner Relationship
/dmbe/i_BusinessPartner_Relat view from Relationship Between Business Partners
I_BPContact view from BASIC Business Partner Contact
I_BPRelationship view from BASIC Business Partner Relationship
I_BPRelationship_2 view from BASIC Business Partner Relationship
I_BPRelationshipUnion view from BASIC Business Partner Relationship
I_BPRelationshipUnion view union_all BASIC Business Partner Relationship
I_BPReltdWithParentCompany view from BASIC Business Partner Relationship for Parent company/subsidiary
I_BPTranspSalesRepresentative view from BASIC Core View BP Transp Sales Representative
I_ContingentWorker view union_all BASIC Contingent Worker
I_CrdtMAccountAnalyst view from BASIC Credit Management Account Analyst
I_CrdtMAcctRelationship view from BASIC Credit Management Account Relationsship
I_EmployeeOp view left_outer BASIC Employee CDS view for OP
I_JITBusPartContact view_entity from BASIC JIT Customer Contact Person Relationship
I_ServicePerformerFor view from BASIC Service Performer
I_ServicePerformerToSuplr view from BASIC Service Performer to Supplier
P_BPContactToAddress view inner BP Contact person address
P_BusinessPartnerContacts view from BASIC
P_Businesspartnerpcontacts view from BASIC
v_ukm_cr_spec_view view from Credit Specialist
VFCLM_BAM_DDL_BPREL_FSB002 view from Business Partner Relationship for FSB002

Fields (21)

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
date_from BU_DATFROM Valid From
reltyp BU_RELTYP Relationsh.Cat.
xrf BU_XRF Role definition
dftval BU_DFTVAL Diff.type char.
rltyp BU_RLTYPE BP role
relkind BU_RELKIND RelationshpType
crusr BU_CRUSR Created by
crdat BU_CRDAT Created On
crtim BU_CRTIM Created at
chusr BU_CHUSR Changed by
chdat BU_CHDAT Changed on
chtim BU_CHTIM Changed at
xdfrel BU_XDFREL Standard
xdfrel2 BU_XDFREL Standard
db_key BUP_SETGUID SETGUID
db_key_td BUP_SETGUID SETGUID

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 relationships/role definitions: General data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE BUT050 (
    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]
    DATE_FROM,  -- Valid From [BU_DATFROM]
    RELTYP,     -- Relationsh.Cat. [BU_RELTYP]
    XRF,        -- Role definition [BU_XRF]
    DFTVAL,     -- Diff.type char. [BU_DFTVAL]
    RLTYP,      -- BP role [BU_RLTYPE]
    RELKIND,    -- RelationshpType [BU_RELKIND]
    CRUSR,      -- Created by [BU_CRUSR]
    CRDAT,      -- Created On [BU_CRDAT]
    CRTIM,      -- Created at [BU_CRTIM]
    CHUSR,      -- Changed by [BU_CHUSR]
    CHDAT,      -- Changed on [BU_CHDAT]
    CHTIM,      -- Changed at [BU_CHTIM]
    XDFREL,     -- Standard [BU_XDFREL]
    XDFREL2,    -- Standard [BU_XDFREL]
    DB_KEY,     -- SETGUID [BUP_SETGUID]
    DB_KEY_TD,  -- SETGUID [BUP_SETGUID]
    PRIMARY KEY (CLIENT, RELNR, PARTNER1, PARTNER2, DATE_TO)
);

Learn More