I_BusPartRelationshipTmpTP

DDL: I_BUSPARTRELATIONSHIPTMPTP Type: view_entity TRANSACTIONAL Package: MDC_BUPA_BO

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.

1 data source(s) 14 fields

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
KEY BusinessPartner2 BusinessPartner2
KEY ValidityEndDate
KEY RelationshipCategory RelationshipCategory
KEY BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection
BusinessPartner2ForEdit BusinessPartner2
RelationshipCategoryForEdit RelationshipCategory
ValidityStartDate ValidityStartDate
ValidityEndDateForEdit ValidityEndDateForEdit
BPRelshpCatIsInFwdDirForEdit BPRelshpCatIsInFwdDirection
IsStandardRelationship IsStandardRelationship
_BusinessPartner _BusinessPartner
_BusinessPartnerRelationship2 _BusinessPartnerRelationship2
_BPRelshpCntctPersnAddress _BPRelshpCntctPersnAddress 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'BP Relationship Dummy Entity'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BusPartRelationshipTmpTP
  as select from I_BusPartRelationshipTP  as BusinessPartnerRelationshipTmp
   association        to parent I_BusinessPartnerTP_2  as _BusinessPartner              on  $projection.BusinessPartner1 = _BusinessPartner.BusinessPartner
//                                                                                       and $projection.BPDrftUUID       = _BusinessPartner.BPDrftUUID

  
  association [1]    to I_BusPartRelationshipTP       as _BusinessPartnerRelationship2 on  
//  $projection.BPDrftUUID           = _BusinessPartnerRelationship2.BPDrftUUID

//                                                                                       and $projection.BPRelshpUUID         = _BusinessPartnerRelationship2.BPRelshpUUID

                                                                                        $projection.BusinessPartner1     = _BusinessPartnerRelationship2.BusinessPartner1
                                                                                       and $projection.BusinessPartner2     = _BusinessPartnerRelationship2.BusinessPartner2
                                                                                       and $projection.ValidityEndDate      = _BusinessPartnerRelationship2.ValidityEndDate
                                                                                       and $projection.RelationshipCategory = _BusinessPartnerRelationship2.RelationshipCategory
                                                                                       and $projection.BPRelshpCatIsInFwdDirection = _BusinessPartnerRelationship2.BPRelshpCatIsInFwdDirection

 

  association [0..*] to I_BPRelshpCntctPersnAddressTP as _BPRelshpCntctPersnAddress  on  
//    $projection.BPDrftUUID           = _BPRelshpCntctPersnAddress.BPDrftUUID

//                                                                                       and $projection.BPRelshpUUID         = _BPRelshpCntctPersnAddress.BPRelshpUUID

                                                                                         $projection.BusinessPartner1     = _BPRelshpCntctPersnAddress.BusinessPartner1
                                                                                       and $projection.BusinessPartner2     = _BPRelshpCntctPersnAddress.BusinessPartner2
                                                                                       and $projection.ValidityEndDate      = _BPRelshpCntctPersnAddress.ValidityEndDate
                                                                                       and $projection.RelationshipCategory = _BPRelshpCntctPersnAddress.RelationshipCategory
                                                                                       and $projection.BPRelshpCatIsInFwdDirection = _BPRelshpCntctPersnAddress.BPRelshpCatIsInFwdDirection      

{
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPDrftUUID,

//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x ) as BPRelshpUUID,

  key BusinessPartner1,
  key BusinessPartner2,
  key cast( ValidityEndDate as abap.char( 17 ))                          as ValidityEndDate,
  key RelationshipCategory,
  key BPRelshpCatIsInFwdDirection,
      @ObjectModel.editableFieldFor: 'BusinessPartner2'
      BusinessPartner2                                                   as BusinessPartner2ForEdit,
      @ObjectModel.editableFieldFor: 'RelationshipCategory'
      RelationshipCategory                                               as RelationshipCategoryForEdit,
      ValidityStartDate,
      @ObjectModel.editableFieldFor: 'ValidityEndDate'
      ValidityEndDateForEdit,
      @ObjectModel.editableFieldFor: 'BPRelshpCatIsInFwdDirection'
      BPRelshpCatIsInFwdDirection                                        as BPRelshpCatIsInFwdDirForEdit,
      IsStandardRelationship,
      _BusinessPartner,
      _BusinessPartnerRelationship2,
      _BPRelshpCntctPersnAddress

}
where ( ( $projection.relationshipcategory = 'BUR001' and BPRelshpCatIsInFwdDirection = ' ' ) or
        $projection.relationshipcategory != 'BUR001' )

Learn More