I_BusPartRelationshipTmpTP

DDL: I_BUSPARTRELATIONSHIPTMPTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_BO
14 Fields 1 Data Sources 2 Associations

BP Relationship Dummy Entity

I_BusPartRelationshipTmpTP is a Transactional CDS View that provides data about "BP Relationship Dummy Entity" in SAP S/4HANA. It reads from 1 data source (I_BusPartRelationshipTP) and exposes 14 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, BPRelshpCatIsInFwdDirection. It has 2 associations to related views. Part of development package MDC_BUPA_BO.

Data Sources (1)

SourceAliasJoin Type
I_BusPartRelationshipTP BusinessPartnerRelationshipTmp from

Associations (2)

CardinalityTargetAliasCondition
[1] I_BusPartRelationshipTP _BusinessPartnerRelationship2 $projection.BusinessPartner1 = _BusinessPartnerRelationship2.BusinessPartner1 and $projection.BusinessPartner2 = _BusinessPartnerRelationship2.BusinessPartner2 and $projection.ValidityEndDate = _BusinessPartnerRelationship2.ValidityEndDate and $projection.RelationshipCategory = _BusinessPartnerRelationship2.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _BusinessPartnerRelationship2.BPRelshpCatIsInFwdDirection
[0..*] I_BPRelshpCntctPersnAddressTP _BPRelshpCntctPersnAddress $projection.BusinessPartner1 = _BPRelshpCntctPersnAddress.BusinessPartner1 and $projection.BusinessPartner2 = _BPRelshpCntctPersnAddress.BusinessPartner2 and $projection.ValidityEndDate = _BPRelshpCntctPersnAddress.ValidityEndDate and $projection.RelationshipCategory = _BPRelshpCntctPersnAddress.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _BPRelshpCntctPersnAddress.BPRelshpCatIsInFwdDirection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label BP Relationship Dummy Entity view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartner1 Partner
KEY BusinessPartner2 BusinessPartner2 Partner
KEY ValidityEndDate ValidTo
KEY RelationshipCategory RelationshipCategory Relationsh.Cat.
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
BusinessPartner2ForEdit BusinessPartner2 Partner
RelationshipCategoryForEdit RelationshipCategory Relationsh.Cat.
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDateForEdit ValidityEndDateForEdit Valid To
BPRelshpCatIsInFwdDirForEdit BPRelshpCatIsInFwdDirection Boolean Variable (X = True, - = False, Space = Unknown)
IsStandardRelationship IsStandardRelationship Standard
_BusinessPartner _BusinessPartner
_BusinessPartnerRelationship2 _BusinessPartnerRelationship2
_BPRelshpCntctPersnAddress _BPRelshpCntctPersnAddress

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 I_BusPartRelationshipTmpTP.
-- 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 I_BusPartRelationshipTmpTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  cast( ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  RelationshipCategory,
  BPRelshpCatIsInFwdDirection,
  BusinessPartner2 AS BusinessPartner2ForEdit,
  RelationshipCategory AS RelationshipCategoryForEdit,
  ValidityStartDate,
  ValidityEndDateForEdit,
  BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirForEdit,
  IsStandardRelationship
FROM I_BusPartRelationshipTP AS BusinessPartnerRelationshipTmp
LEFT OUTER JOIN I_BusPartRelationshipTP AS _BusinessPartnerRelationship2 ON BusinessPartner1 = _BusinessPartnerRelationship2.BusinessPartner1 AND BusinessPartner2 = _BusinessPartnerRelationship2.BusinessPartner2 AND ValidityEndDate = _BusinessPartnerRelationship2.ValidityEndDate AND RelationshipCategory = _BusinessPartnerRelationship2.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BusinessPartnerRelationship2.BPRelshpCatIsInFwdDirection  -- association [1]
LEFT OUTER JOIN I_BPRelshpCntctPersnAddressTP AS _BPRelshpCntctPersnAddress ON BusinessPartner1 = _BPRelshpCntctPersnAddress.BusinessPartner1 AND BusinessPartner2 = _BPRelshpCntctPersnAddress.BusinessPartner2 AND ValidityEndDate = _BPRelshpCntctPersnAddress.ValidityEndDate AND RelationshipCategory = _BPRelshpCntctPersnAddress.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BPRelshpCntctPersnAddress.BPRelshpCatIsInFwdDirection  -- association [0..*]
;

Learn More