P_CollMgmtRblsItmForKeyDte1

DDL: P_COLLMGMTRBLSITMFORKEYDTE1 SQL: PCMRBLSKDATDUE1 Type: view COMPOSITE

P_CollMgmtRblsItmForKeyDte1 is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_CollectionsCompanyCode, I_BPCollectionProfileAssgmt, I_CollsSgmtCompanyCodeAssgmt, I_BPCollectionsSegmentAssgmt) and exposes 6 fields with key fields CompanyCode, CollectionSegment, BusinessPartner.

4 data source(s) 6 fields

Data Sources (4)

SourceAliasJoin Type
I_CollectionsCompanyCode _UdmCoCode inner
I_BPCollectionProfileAssgmt _UdmProfile inner
I_CollsSgmtCompanyCodeAssgmt _UdmSegCoCode inner
I_BPCollectionsSegmentAssgmt _UdmSegments from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCMRBLSKDATDUE1 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 (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CollsSgmtCompanyCodeAssgmt CompanyCode
KEY CollectionSegment I_BPCollectionsSegmentAssgmt CollectionSegment
KEY BusinessPartner I_BPCollectionsSegmentAssgmt BusinessPartner
CollectionProfile I_BPCollectionProfileAssgmt CollectionProfile
CollectionSpecialist I_BPCollectionsSegmentAssgmt CollectionSpecialist
CollectionGroup I_BPCollectionsSegmentAssgmt CollectionGroup 
@AbapCatalog.sqlViewName: 'PCMRBLSKDATDUE1'
@AbapCatalog.compiler.compareFilter:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@VDM.private:true

define view P_CollMgmtRblsItmForKeyDte1
  with parameters
    P_KeyDate          : sydate
    
  as select from     I_BPCollectionsSegmentAssgmt as _UdmSegments 

  // BP Coll Profile

   inner join I_BPCollectionProfileAssgmt    as _UdmProfile   on _UdmProfile.BusinessPartner = _UdmSegments.BusinessPartner

////  // link Segment <-> CoCode

   inner join I_CollsSgmtCompanyCodeAssgmt   as _UdmSegCoCode on  _UdmSegCoCode.CollectionSegment = _UdmSegments.CollectionSegment
                                                                                  
  //  // CoCode exists in Coll Mgmt

   inner join I_CollectionsCompanyCode       as _UdmCoCode    on _UdmCoCode.CompanyCode = _UdmSegCoCode.CompanyCode

{
  key _UdmSegCoCode.CompanyCode,
  key _UdmSegments.CollectionSegment,
  key _UdmSegments.BusinessPartner,
      _UdmProfile.CollectionProfile,  
      _UdmSegments.CollectionSpecialist,
      _UdmSegments.CollectionGroup
}
where
      _UdmProfile.BPCollPrflAssignmentValidTo    >= $parameters.P_KeyDate
  and _UdmProfile.BPCollPrflAssignmentValidFrom  <= $parameters.P_KeyDate
  and _UdmSegments.BPCollSgmtAssignmentValidTo   >= $parameters.P_KeyDate
  and _UdmSegments.BPCollSgmtAssignmentValidFrom <= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BPCOLLECTIONPROFILEASSGMT",
"I_BPCOLLECTIONSSEGMENTASSGMT",
"I_COLLECTIONSCOMPANYCODE",
"I_COLLSSGMTCOMPANYCODEASSGMT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More