R_BPRelationshipLatest

DDL: R_BPRELATIONSHIPLATEST Type: view_entity COMPOSITE
16 Fields 3 Data Sources

BP Relationship Latest

R_BPRelationshipLatest is a Composite CDS View that provides data about "BP Relationship Latest" in SAP S/4HANA. It reads from 3 data sources (R_BPRelationshipCurrent, R_BPRelationshipNext, R_BPRelationshipPrevious) and exposes 16 fields with key fields RelationshipNumber, BusinessPartnerCompany, BusinessPartnerPerson, ValidityEndDate, BusinessPartnerCompany.

Data Sources (3)

SourceAliasJoin Type
R_BPRelationshipCurrent R_BPRelationshipCurrent from
R_BPRelationshipNext R_BPRelationshipNext union_all
R_BPRelationshipPrevious R_BPRelationshipPrevious union_all

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BP Relationship Latest view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY RelationshipNumber RelationshipNumber BP Rel. Number
KEY BusinessPartnerCompany BusinessPartnerCompany Busn. Partner
KEY BusinessPartnerPerson BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
RelationshipNumber BP Rel. Number
KEY BusinessPartnerCompany R_BPRelationshipNext BusinessPartnerCompany Busn. Partner
KEY BusinessPartnerPerson R_BPRelationshipNext BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate R_BPRelationshipNext ValidityEndDate ValidTo
ValidityStartDate R_BPRelationshipNext ValidityStartDate Validity Start Date
RelationshipNumber BP Rel. Number
KEY BusinessPartnerCompany R_BPRelationshipPrevious BusinessPartnerCompany Busn. Partner
KEY BusinessPartnerPerson R_BPRelationshipPrevious BusinessPartnerPerson Busn. Partner
KEY ValidityEndDate R_BPRelationshipPrevious ValidityEndDate ValidTo
ValidityStartDate R_BPRelationshipPrevious ValidityStartDate Validity Start Date
RelationshipCategory R_BPRelationshipPrevious RelationshipCategory Relationsh.Cat.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_BPRelationshipLatest.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_BPRelationshipLatest AS
SELECT
  RelationshipNumber,
  BusinessPartnerCompany,
  BusinessPartnerPerson,
  ValidityEndDate,
  ValidityStartDate,
  R_BPRelationshipPrevious.RelationshipCategory AS RelationshipCategory
FROM R_BPRelationshipCurrent
-- UNION ALL with additional select branch(es): R_BPRelationshipNext, R_BPRelationshipPrevious
;

Learn More