P_DebitorPostingDoc

DDL: P_DEBITORPOSTINGDOC Type: view_entity CONSUMPTION
16 Fields 1 Data Sources

P_DebitorPostingDoc is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 16 fields with key fields CompanyCode, FiscalYear, AccountingDocument.

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 Receiver Company Code
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
FiscalPeriod
AccountingDocCreatedByUser
PostingDate
AccountingDocumentType
UnadjustedDebitCreditCode I_OperationalAcctgDocItem UnadjustedDebitCreditCode
Customer I_OperationalAcctgDocItem Customer Sold-to Party
CustomerName _I_BusinessPartner BusinessPartnerName Extracted Customer Name
AmountInCompanyCodeCurrency
AbsoluteAmountInCoCodeCrcy
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
AmountInTransactionCurrency
AbsoluteAmountInTransacCrcy
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_DebitorPostingDoc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_DebitorPostingDoc AS
SELECT
  _I_JournalEntryDocItem.CompanyCode AS CompanyCode,
  _I_JournalEntryDocItem.FiscalYear AS FiscalYear,
  _I_JournalEntryDocItem.AccountingDocument AS AccountingDocument,
  _I_JournalEntryDocItem._JournalEntry.FiscalPeriod AS FiscalPeriod,
  _I_JournalEntryDocItem._JournalEntry.AccountingDocCreatedByUser AS AccountingDocCreatedByUser,
  _I_JournalEntryDocItem._JournalEntry.PostingDate AS PostingDate,
  _I_JournalEntryDocItem._JournalEntry.AccountingDocumentType AS AccountingDocumentType,
  _I_JournalEntryDocItem.UnadjustedDebitCreditCode AS UnadjustedDebitCreditCode,
  _I_JournalEntryDocItem.Customer AS Customer,
  _I_BusinessPartner.BusinessPartnerName AS CustomerName,
  sum(_I_JournalEntryDocItem.AmountInCompanyCodeCurrency) AS AmountInCompanyCodeCurrency,
  sum(_I_JournalEntryDocItem.AbsoluteAmountInCoCodeCrcy) AS AbsoluteAmountInCoCodeCrcy,
  _I_JournalEntryDocItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  sum(_I_JournalEntryDocItem.AmountInTransactionCurrency) AS AmountInTransactionCurrency,
  sum(_I_JournalEntryDocItem.AbsoluteAmountInTransacCrcy) AS AbsoluteAmountInTransacCrcy,
  _I_JournalEntryDocItem.TransactionCurrency AS TransactionCurrency
FROM I_OperationalAcctgDocItem AS _I_JournalEntryDocItem
;

Learn More