I_BPRELATIONSHIP

CDS View
7 Fields 27 CDS Views

Business Partner Relationship

I_BPRELATIONSHIP is a CDS View in S/4HANA. Business Partner Relationship. It contains 7 fields. 27 CDS views read from this table.

CDS Views using this table (27)

ViewTypeJoinVDMDescription
/UCOM/C_BP_RELATIONSHIP view from CONSUMPTION Business Partner Related Information
C_LglCntntMExtContactByBPVH view from CONSUMPTION External Contact by General Data
I_CollectionContact view inner COMPOSITE Collection Contact
I_ContingentWorker_1 view union_all COMPOSITE Contingent Worker
I_InvgCsMLocVisibleReltdOrg view inner COMPOSITE Composite view for Visible ICM RelLocation to Organization
I_InvgCsMLocVisibleReltdPersn view inner COMPOSITE Composite view for Visible ICM Rel Location to Person
I_InvgCsMObjVisibleReltdOrg view inner COMPOSITE Composite view for Visible ICM Rel Object to Organization
I_InvgCsMObjVisibleReltdPersn view inner COMPOSITE Composite view for Visible ICM Relationship Object to Person
I_InvgCsMPersonLogInStaff view from COMPOSITE ICM Business Partner Logged In Staff
I_SupplierToEmployment view from COMPOSITE Supplier with his supported employments
I_SupplierToEmployment view inner COMPOSITE Supplier with his supported employments
I_SupplierToEmployment view union COMPOSITE Supplier with his supported employments
I_WorkForcePersonPayt view left_outer COMPOSITE Workforce Person Payment Details for Object Page
I_WrkfrcPersnRelshpToCoTP view_entity from Workforce Person Relationship to Company
P_CollabnApplCarrierUser view from CONSUMPTION
R_BPRelationshipCurrent view_entity from COMPOSITE BP Relationship Current (valid today)
R_BPRelationshipNext view_entity from COMPOSITE BP Relationship Next (valid in future)
R_BPRelationshipNextBase view_entity from COMPOSITE BP Relationship Next Base
R_BPRelationshipPrevious view_entity from COMPOSITE BP Relationship Previous (valid in past)
R_BPRelationshipPreviousBase view_entity from COMPOSITE BP Relationship Previous Base
R_BPRltnShipSupplierTP view_entity from TRANSACTIONAL TP View for Business Partner Relationship to suppliers
R_CrdtMAcctRelationshipTP view from TRANSACTIONAL Cred. Mgmt Account Relationship
R_CrdtMBPRelationshipTP view from TRANSACTIONAL Cred. Mgmt BP Relationship
R_TotalNumberOfBPRelationship view_entity from COMPOSITE Total number of BP Relationship
R_TotalNumberOfBPRelationship1 view_entity from COMPOSITE Total no of BP Rlshp based on Partner1
R_TotalNumberOfBPRelationship2 view_entity from COMPOSITE Total no of BP Rlshp based on Partner2
R_TotalNumberOfBPRelshpLatest view_entity from COMPOSITE Total number of BP Relationship Latest

Fields (7)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner1 BusinessPartner1,Supplier 1
KEY BusinessPartnerCompany BusinessPartnerCompany,BusinessPartnerRelshpSupplier 4
KEY BusinessPartnerPerson BusinessPartner,BusinessPartnerPerson 4
KEY RelationshipNumber RelationshipNumber 4
KEY ValidityEndDate BPRelationshipEndDateForEdit,ValidityEndDate 5
KEY ValidityStartDate StartDate,ValidityStartDate 5
RelationshipCategory RelationshipCategory 4

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.

-- Business Partner Relationship
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_BPRELATIONSHIP (
    BUSINESSPARTNER1,
    BUSINESSPARTNERCOMPANY,
    BUSINESSPARTNERPERSON,
    RELATIONSHIPNUMBER,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    RELATIONSHIPCATEGORY,
    PRIMARY KEY (BUSINESSPARTNER1, BUSINESSPARTNERCOMPANY, BUSINESSPARTNERPERSON, RELATIONSHIPNUMBER, VALIDITYENDDATE, VALIDITYSTARTDATE)
);

Learn More