P_CollectionsInvoiceNote

DDL: P_COLLECTIONSINVOICENOTE Type: view COMPOSITE Package: UDM_COLL_CDS

Collections Invoice Note

P_CollectionsInvoiceNote is a Composite CDS View that provides data about "Collections Invoice Note" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 6 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem. It has 1 association to related views. Part of development package UDM_COLL_CDS.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] Sgbt_Nte_Cds_Cont _NoteContent $projection.ObjectKey = _NoteContent.objectid and _NoteContent.objectnodetype = 'CollectionsManagementAccount' and _NoteContent.notetype = 'COLL_PR_INVOICE'

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PCOLLSINVNOTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #COMPOSITE view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.representativeKey AccountingDocumentItem view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
KEY AccountingDocumentItem AccountingDocumentItem
ObjectKey
_NoteContent _NoteContent 
@AbapCatalog: { sqlViewName: 'PCOLLSINVNOTE',
                compiler: { compareFilter: true },
                preserveKey: true }
@AccessControl: { authorizationCheck: #NOT_REQUIRED,
                  personalData:       { blocking: #BLOCKED_DATA_EXCLUDED } } 
@VDM: { viewType: #COMPOSITE,
        private: true }
@ClientHandling: { algorithm: #SESSION_VARIABLE }
@ObjectModel: { usageType: { serviceQuality: #A,
                             sizeCategory: #L,
                             dataClass: #TRANSACTIONAL }, 
                representativeKey: 'AccountingDocumentItem' }

define view P_CollectionsInvoiceNote
  as select from I_OperationalAcctgDocItem
  // VDM Association

  association [0..*] to Sgbt_Nte_Cds_Cont as _NoteContent on  $projection.ObjectKey       = _NoteContent.objectid
                                                          and _NoteContent.objectnodetype = 'CollectionsManagementAccount'
                                                          and _NoteContent.notetype       = 'COLL_PR_INVOICE'

{

      // VDM Fields

  key CompanyCode,
  key AccountingDocument,
  key FiscalYear,
  key AccountingDocumentItem,

      // Get contacenated key

      concat( CompanyCode, concat( AccountingDocument, concat( FiscalYear, AccountingDocumentItem ) ) ) as ObjectKey,

      // Exposed Associations

      _NoteContent
}

Learn More