P_CollsInvcEarliestRelatedRsm

DDL: P_COLLSINVCEARLIESTRELATEDRSM Type: view_entity COMPOSITE

P_CollsInvcEarliestRelatedRsm is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CollsInvoiceRelatedResubmsn) and exposes 6 fields with key fields LogicalSystem, ObjectType, ObjectKey, RelationToLinkedObject.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoiceRelatedResubmsn I_CollsInvoiceRelatedResubmsn from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey RelationToLinkedObject view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY LogicalSystem LogicalSystem
KEY ObjectType ObjectType
KEY ObjectKey ObjectKey
KEY RelationToLinkedObject RelationToLinkedObject
CreationDateTime
ResubmissionDueDate ResubmissionDueDate 
@AccessControl: { authorizationCheck: #NOT_REQUIRED }
@VDM: { viewType: #COMPOSITE,
        private:  true }
@ObjectModel: { usageType:         { serviceQuality: #X,
                                     sizeCategory:   #XL,
                                     dataClass:      #TRANSACTIONAL },
                representativeKey: 'RelationToLinkedObject' }

define view entity P_CollsInvcEarliestRelatedRsm
  as select from I_CollsInvoiceRelatedResubmsn
{

      // VDM Fields

  key LogicalSystem,
  key ObjectType,
  key ObjectKey,
  key RelationToLinkedObject,

      min ( _CollectionsResubmission.CreationDateTime ) as CreationDateTime,

      ResubmissionDueDate

}

group by
  LogicalSystem,
  ObjectType,
  ObjectKey,
  RelationToLinkedObject,
  ResubmissionDueDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COLLECTIONSRESUBMISSION",
"I_COLLSINVOICERELATEDRESUBMSN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More