P_CollMgmtRblsItmForKeyDte3

DDL: P_COLLMGMTRBLSITMFORKEYDTE3 SQL: PCMRBLSKDATDUE3 Type: view COMPOSITE

P_CollMgmtRblsItmForKeyDte3 is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_BusinessPartnerCustomer, I_CollectionGroup, P_CollMgmtRblsItmForKeyDte2) and exposes 8 fields with key fields CompanyCode, CollectionSegment, BusinessPartner.

3 data source(s) 8 fields

Data Sources (3)

SourceAliasJoin Type
I_BusinessPartnerCustomer _BPCustomer inner
I_CollectionGroup _CollectionGroup inner
P_CollMgmtRblsItmForKeyDte2 P_CollMgmtRblsItmForKeyDte2 from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCMRBLSKDATDUE3 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode _CollectionsPartner CompanyCode
KEY CollectionSegment _CollectionsPartner CollectionSegment
KEY BusinessPartner _CollectionsPartner BusinessPartner
Customer I_BusinessPartnerCustomer Customer
CollectionProfile _CollectionsPartner CollectionProfile
CollectionGroup _CollectionsPartner CollectionGroup
CollectionSpecialist _CollectionsPartner CollectionSpecialist
CollectionStrategy I_CollectionGroup CollectionStrategy 
@AbapCatalog.sqlViewName: 'PCMRBLSKDATDUE3'
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view P_CollMgmtRblsItmForKeyDte3
  with parameters
    P_KeyDate          : sydate
    
  as select from P_CollMgmtRblsItmForKeyDte2( P_KeyDate: :P_KeyDate) as _CollectionsPartner   
                                                                         
  inner join I_BusinessPartnerCustomer as _BPCustomer       on _BPCustomer.BusinessPartner = _CollectionsPartner.BusinessPartner  
  inner join I_CollectionGroup         as _CollectionGroup  on _CollectionGroup.CollectionGroup = _CollectionsPartner.CollectionGroup


{
  key _CollectionsPartner.CompanyCode,
  key _CollectionsPartner.CollectionSegment,
  key _CollectionsPartner.BusinessPartner,
      _BPCustomer.Customer,
      
      _CollectionsPartner.CollectionProfile,  
      _CollectionsPartner.CollectionGroup,
      _CollectionsPartner.CollectionSpecialist,
      _CollectionGroup.CollectionStrategy
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BUSINESSPARTNERCUSTOMER",
"I_COLLECTIONGROUP",
"P_COLLMGMTRBLSITMFORKEYDTE2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More