I_BPRelshpCompanyInterestTP

DDL: I_BPRELSHPCOMPANYINTERESTTP Type: view_entity TRANSACTIONAL

RAP BO view for BP shareholder data

I_BPRelshpCompanyInterestTP is a Transactional CDS View that provides data about "RAP BO view for BP shareholder data" in SAP S/4HANA. It reads from 1 data source (P_BPRelshpCompanyIntUnion) and exposes 13 fields with key fields BusinessPartner1, BusinessPartner2, ValidityEndDate, RelationshipCategory.

Data Sources (1)

SourceAliasJoin Type
P_BPRelshpCompanyIntUnion P_BPRelshpCompanyIntUnion from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label RAP BO view for BP shareholder data view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
VDM.viewType #TRANSACTIONAL view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BusinessPartner1 BusinessPartnerCompany
KEY BusinessPartner2 BusinessPartnerPerson
KEY ValidityEndDate
KEY RelationshipCategory RelationshipCategory
RelationshipNumber RelationshipNumber
BPCoCapitalInterestPercentage BPCoCapitalInterestPercentage
BPCompanyCapitalInterestAmount BPCompanyCapitalInterestAmount
Currency Currency
IsShareholderControlledCompany
BPRelshpCatIsInFwdDirection BPRelshpCatIsInFwdDirection
_BusinessPartner1 _BusinessPartnerCompany
_BusinessPartner2 _BusinessPartnerPerson
_BusPartRelationship _BusPartRelationship
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'RAP BO view for BP shareholder data'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
define view entity I_BPRelshpCompanyInterestTP
  as select from P_BPRelshpCompanyIntUnion
//I_BPRelshpCompanyInterest


  association to parent I_BusPartRelationshipTP as _BusPartRelationship 
//                                                                        on  $projection.BPDrftUUID           = _BusPartRelationship.BPDrftUUID

//                                                                        and $projection.BPRelshpUUID         = _BusPartRelationship.BPRelshpUUID

                                                                        on $projection.BusinessPartner1     = _BusPartRelationship.BusinessPartner1
                                                                        and $projection.BusinessPartner2     = _BusPartRelationship.BusinessPartner2
                                                                        and $projection.ValidityEndDate      = _BusPartRelationship.ValidityEndDate
                                                                        and $projection.RelationshipCategory = _BusPartRelationship.RelationshipCategory
                                                                        and $projection.BPRelshpCatIsInFwdDirection = _BusPartRelationship.BPRelshpCatIsInFwdDirection                         
{
//  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x )   as BPDrftUUID,

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

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

      @Search.defaultSearchElement: true
  key BusinessPartnerCompany                                               as BusinessPartner1,
      @Search.defaultSearchElement: true
  key BusinessPartnerPerson                                                as BusinessPartner2,
  key cast( ValidityEndDate as abap.char( 17 )) as ValidityEndDate,
      @Search.defaultSearchElement: true
  key RelationshipCategory,
      RelationshipNumber,
      BPCoCapitalInterestPercentage,
      @Semantics.amount.currencyCode: 'CURRENCY'
      BPCompanyCapitalInterestAmount,
      Currency,
      cast(IsShareholderControlledCompany as abap_boolean preserving type) as IsShareholderControlledCompany,
      BPRelshpCatIsInFwdDirection,

      /* Associations */
      _BusinessPartnerCompany                                              as _BusinessPartner1,
      _BusinessPartnerPerson                                               as _BusinessPartner2,
      _BusPartRelationship
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BPRELSHPCOMPANYINTUNION"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_BUSPARTRELATIONSHIPTP"
],
"BASE":
[
"P_BPRELSHPCOMPANYINTUNION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/