I_DebitCreditDocumentPostgDte

DDL: I_DEBITCREDITDOCUMENTPOSTGDTE Type: view_entity COMPOSITE Package: ODATA_ML_DSPMATLDBCRDOCS

Debit Credit Aggregated data documents

I_DebitCreditDocumentPostgDte is a Composite CDS View that provides data about "Debit Credit Aggregated data documents" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_DebitCreditDocumentItem) and exposes 7 fields with key fields MaterialLedgerDocument, MaterialLedgerDocumentYear. Part of development package ODATA_ML_DSPMATLDBCRDOCS.

2 data source(s) 7 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode CompanyCode inner
I_DebitCreditDocumentItem Item from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY MaterialLedgerDocument I_DebitCreditDocumentItem MaterialLedgerDocument
KEY MaterialLedgerDocumentYear I_DebitCreditDocumentItem MaterialLedgerDocumentYear
CompanyCode
CompanyCodeName
PostingDate
FiscalYear
FiscalPeriod 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #MIXED
}
@VDM: {
  viewType: #COMPOSITE,
  private: true
}
define view entity I_DebitCreditDocumentPostgDte
  as select from I_DebitCreditDocumentItem as Item
    inner join   I_CompanyCode           as CompanyCode on Item.CompanyCode = CompanyCode.CompanyCode
{
  key Item.MaterialLedgerDocument,
  key Item.MaterialLedgerDocumentYear,
      max(Item.CompanyCode)            as CompanyCode,
      max(CompanyCode.CompanyCodeName) as CompanyCodeName,
      min(Item.PostingDate)            as PostingDate,
      min(Item.FiscalYear)             as FiscalYear,
      min(Item.FiscalPeriod)           as FiscalPeriod
}

group by
  Item.MaterialLedgerDocument,
  Item.MaterialLedgerDocumentYear

Learn More