P_CustomerPostingDoc

DDL: P_CUSTOMERPOSTINGDOC Type: view_entity CONSUMPTION Package: FINS_FIS_GRC_APPS

Customer Posting Documents

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

1 data source(s) 15 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 (15)

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

define view entity P_CustomerPostingDoc
  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,
      cast( case _I_JournalEntryDocItem._JournalEntry.IsReversal
        when 'X' then _I_JournalEntryDocItem._JournalEntry.ReverseDocument
        else '' end  as stblg preserving type )               as ReverseDocument,
      _I_JournalEntryDocItem.Customer,
      _I_BusinessPartner.BusinessPartnerName                  as CustomerName,
      @Semantics: { amount : {currencyCode:'CompanyCodeCurrency'} }
      sum(_I_JournalEntryDocItem.AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
      @Semantics: { amount : {currencyCode:'TransactionCurrency'} }
      sum(_I_JournalEntryDocItem.AmountInTransactionCurrency) as AmountInTransactionCurrency,
      @Semantics: { amount : {currencyCode:'CompanyCodeCurrency'} }
      sum(_I_JournalEntryDocItem.AbsoluteAmountInCoCodeCrcy) as AbsoluteAmountInCoCodeCrcy,
      _I_JournalEntryDocItem.CompanyCodeCurrency,
      @Semantics: { amount : {currencyCode:'TransactionCurrency'} }
      sum(_I_JournalEntryDocItem.AbsoluteAmountInTransacCrcy) as AbsoluteAmountInTransacCrcy,
      _I_JournalEntryDocItem.TransactionCurrency
}
where
      _I_JournalEntryDocItem.FinancialAccountType = 'D'
  and _I_JournalEntryDocItem.UnadjustedDebitCreditCode = 'H'
  and _I_JournalEntryDocItem._JournalEntry.AccountingDocumentType <> 'DZ' 
  and _I_JournalEntryDocItem._JournalEntry.AccountingDocumentType <> 'DG'
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._JournalEntry.IsReversal,
  _I_JournalEntryDocItem._JournalEntry.ReverseDocument,
  _I_JournalEntryDocItem.Customer,
  _I_BusinessPartner.BusinessPartnerName,
  _I_JournalEntryDocItem.CompanyCodeCurrency,
  _I_JournalEntryDocItem.TransactionCurrency

Learn More