P_DebitorPostingDoc

DDL: P_DEBITORPOSTINGDOC Type: view_entity CONSUMPTION Package: FINS_FIS_GRC_APPS

Debitor Posting Documents

P_DebitorPostingDoc is a Consumption CDS View that provides data about "Debitor Posting Documents" in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 16 fields with key fields CompanyCode, FiscalYear, AccountingDocument. Part of development package FINS_FIS_GRC_APPS.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem _I_JournalEntryDocItem from

Annotations (4)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument
FiscalPeriod
AccountingDocCreatedByUser
PostingDate
AccountingDocumentType
UnadjustedDebitCreditCode I_OperationalAcctgDocItem UnadjustedDebitCreditCode
Customer I_OperationalAcctgDocItem Customer
CustomerName _I_BusinessPartner BusinessPartnerName
AmountInCompanyCodeCurrency
AbsoluteAmountInCoCodeCrcy
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency
AmountInTransactionCurrency
AbsoluteAmountInTransacCrcy
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency 
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true

define view entity P_DebitorPostingDoc
  as select from           I_OperationalAcctgDocItem as _I_JournalEntryDocItem
    left outer to one join I_BusinessPartner         as _I_BusinessPartner on _I_JournalEntryDocItem.Customer = _I_BusinessPartner.BusinessPartner
{
  key _I_JournalEntryDocItem.CompanyCode,
  key _I_JournalEntryDocItem.FiscalYear,
  key _I_JournalEntryDocItem.AccountingDocument,
      _I_JournalEntryDocItem._JournalEntry.FiscalPeriod,
      _I_JournalEntryDocItem._JournalEntry.AccountingDocCreatedByUser,
      _I_JournalEntryDocItem._JournalEntry.PostingDate,
      _I_JournalEntryDocItem._JournalEntry.AccountingDocumentType,
      _I_JournalEntryDocItem.UnadjustedDebitCreditCode,
      _I_JournalEntryDocItem.Customer,
      _I_BusinessPartner.BusinessPartnerName                  as CustomerName,
      @Semantics: { amount : {currencyCode:'CompanyCodeCurrency'} }
      sum(_I_JournalEntryDocItem.AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
      @Semantics: { amount : {currencyCode:'CompanyCodeCurrency'} }
      sum(_I_JournalEntryDocItem.AbsoluteAmountInCoCodeCrcy) as AbsoluteAmountInCoCodeCrcy,      
      _I_JournalEntryDocItem.CompanyCodeCurrency,
      @Semantics: { amount : {currencyCode:'TransactionCurrency'} }
      sum(_I_JournalEntryDocItem.AmountInTransactionCurrency) as AmountInTransactionCurrency,
      @Semantics: { amount : {currencyCode:'TransactionCurrency'} }
      sum(_I_JournalEntryDocItem.AbsoluteAmountInTransacCrcy) as AbsoluteAmountInTransacCrcy,      
      _I_JournalEntryDocItem.TransactionCurrency
}
where
  _I_JournalEntryDocItem.FinancialAccountType = 'D'
group by
  _I_JournalEntryDocItem.CompanyCode,
  _I_JournalEntryDocItem.FiscalYear,
  _I_JournalEntryDocItem.AccountingDocument,
  _I_JournalEntryDocItem._JournalEntry.FiscalPeriod,
  _I_JournalEntryDocItem._JournalEntry.AccountingDocCreatedByUser,
  _I_JournalEntryDocItem._JournalEntry.PostingDate,
  _I_JournalEntryDocItem._JournalEntry.AccountingDocumentType,  
  _I_JournalEntryDocItem.UnadjustedDebitCreditCode,
  _I_JournalEntryDocItem._JournalEntry.IsReversal,
  _I_JournalEntryDocItem._JournalEntry.ReverseDocument,
  _I_JournalEntryDocItem.Customer,
  _I_BusinessPartner.BusinessPartnerName,
  _I_JournalEntryDocItem.CompanyCodeCurrency,
  _I_JournalEntryDocItem.TransactionCurrency

Learn More