I_BPRelshpContactPersonTmpTP

DDL: I_BPRELSHPCONTACTPERSONTMPTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 2 Associations

Contact Person Temp View

I_BPRelshpContactPersonTmpTP is a Transactional CDS View that provides data about "Contact Person Temp View" in SAP S/4HANA. It reads from 1 data source (I_BusPartRelationshipTP) and exposes 16 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory, BPRelshpCatIsInFwdDirection. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BusPartRelationshipTP BPRelContactPersonTmp from

Associations (2)

CardinalityTargetAliasCondition
[1] I_BusPartRelationshipTP _BusinessPartnerRelationship1 $projection.BusinessPartner1 = _BusinessPartnerRelationship1.BusinessPartner1 and $projection.BusinessPartner2 = _BusinessPartnerRelationship1.BusinessPartner2 and $projection.ValidityEndDate = _BusinessPartnerRelationship1.ValidityEndDate and $projection.RelationshipCategory = _BusinessPartnerRelationship1.RelationshipCategory and $projection.BPRelshpCatIsInFwdDirection = _BusinessPartnerRelationship1.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 (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Contact Person Temp View view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (16)

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)
BusinessPartner1ForEdit BusinessPartner1 Partner
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
FormOfAddress _BusinessPartner1 FormOfAddress Title Key
_BusinessPartner _BusinessPartner
_BusinessPartnerRelationship1 _BusinessPartnerRelationship1
_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_BPRelshpContactPersonTmpTP.
-- 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_BPRelshpContactPersonTmpTP AS
SELECT
  BusinessPartner1,
  BusinessPartner2,
  cast( ValidityEndDate as abap.char( 17 )) AS ValidityEndDate,
  RelationshipCategory,
  BPRelshpCatIsInFwdDirection,
  BusinessPartner1 AS BusinessPartner1ForEdit,
  BusinessPartner2 AS BusinessPartner2ForEdit,
  RelationshipCategory AS RelationshipCategoryForEdit,
  ValidityStartDate,
  ValidityEndDateForEdit,
  BPRelshpCatIsInFwdDirection AS BPRelshpCatIsInFwdDirForEdit,
  IsStandardRelationship,
  _BusinessPartner1.FormOfAddress AS FormOfAddress
FROM I_BusPartRelationshipTP AS BPRelContactPersonTmp
LEFT OUTER JOIN I_BusPartRelationshipTP AS _BusinessPartnerRelationship1 ON BusinessPartner1 = _BusinessPartnerRelationship1.BusinessPartner1 AND BusinessPartner2 = _BusinessPartnerRelationship1.BusinessPartner2 AND ValidityEndDate = _BusinessPartnerRelationship1.ValidityEndDate AND RelationshipCategory = _BusinessPartnerRelationship1.RelationshipCategory AND BPRelshpCatIsInFwdDirection = _BusinessPartnerRelationship1.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