P_PH_PaytClrdReceivablePyblItm

DDL: P_PH_PAYTCLRDRECEIVABLEPYBLITM SQL: PPHPAYTCLRPITM Type: view COMPOSITE
36 Fields 4 Data Sources

P_PH_PaytClrdReceivablePyblItm is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_OperationalAcctgDocItem, I_OperationalAcctgDocItem, I_AccountingDocument, I_AccountingDocument) and exposes 36 fields with key fields CompanyCode, AccountingDocument, FiscalYear, AccountingDocumentItem, InvoiceReference.

Data Sources (4)

SourceAliasJoin Type
I_OperationalAcctgDocItem _InvoiceApArItem left_outer
I_OperationalAcctgDocItem _PaymentClearingItem from
I_AccountingDocument _SourceInvoiceHeader left_outer
I_AccountingDocument _SourceInvoiceHeader1 left_outer

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPHPAYTCLRPITM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (36)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
KEY AccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY FiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY AccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
KEY InvoiceReference I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY InvoiceReferenceFiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY InvoiceItemReference I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
BusinessPlace
PostingDate I_OperationalAcctgDocItem PostingDate Posting Date for GR
AccountingDocumentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
FinancialAccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
IsUsedInPaymentTransaction I_OperationalAcctgDocItem IsUsedInPaymentTransaction Is Used In Payment Transaction
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry Clrng doc.
ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear Fiscal Year of Clearing Journal Entry
ClearingDate I_OperationalAcctgDocItem ClearingDate Clearing Date
GLAccount I_OperationalAcctgDocItem GLAccount General Ledger
DebitCreditCodeendasDebitCreditCode
Customer I_OperationalAcctgDocItem Customer Sold-to Party
Supplier I_OperationalAcctgDocItem Supplier Supplier
InvoiceDebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
TransactionCurrency I_OperationalAcctgDocItem TransactionCurrency Transaction Currency
InvoiceAmtInTransactionCrcy
PaymentAmtInTransactionCrcy
CompanyCodeCurrency I_OperationalAcctgDocItem CompanyCodeCurrency Local Currency
InvoiceAmtInCompanyCodeCrcy
PaymentAmtInCompanyCodeCrcy
AdditionalCurrency1 I_OperationalAcctgDocItem AdditionalCurrency1 Local curr. 2
InvoiceAmtInAdditionalCrcy1
PaytAmtInAdditionalCrcy1
AdditionalCurrency2 I_OperationalAcctgDocItem AdditionalCurrency2 Local curr. 3
InvoiceAmtInAdditionalCrcy2
PaytAmtInAdditionalCrcy2
InvoiceCompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
_Customer I_OperationalAcctgDocItem _Customer
_Supplier I_OperationalAcctgDocItem _Supplier
_OneTimeAccountBP I_OperationalAcctgDocItem _OneTimeAccountBP

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_PH_PaytClrdReceivablePyblItm.
-- 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.
-- SQL view name: PPHPAYTCLRPITM

CREATE VIEW P_PH_PaytClrdReceivablePyblItm AS
SELECT
  _PaymentClearingItem.CompanyCode AS CompanyCode,
  _PaymentClearingItem.AccountingDocument AS AccountingDocument,
  _PaymentClearingItem.FiscalYear AS FiscalYear,
  _PaymentClearingItem.AccountingDocumentItem AS AccountingDocumentItem,
  _InvoiceApArItem.AccountingDocument AS InvoiceReference,
  _InvoiceApArItem.FiscalYear AS InvoiceReferenceFiscalYear,
  _InvoiceApArItem.AccountingDocumentItem AS InvoiceItemReference,
  coalesce( _PaymentClearingItem.BusinessPlace, _InvoiceApArItem.BusinessPlace ) AS BusinessPlace,
  _PaymentClearingItem.PostingDate AS PostingDate,
  _PaymentClearingItem.AccountingDocumentType AS AccountingDocumentType,
  _PaymentClearingItem.FinancialAccountType AS FinancialAccountType,
  _PaymentClearingItem.IsUsedInPaymentTransaction AS IsUsedInPaymentTransaction,
  _PaymentClearingItem.ClearingJournalEntry AS ClearingAccountingDocument,
  _PaymentClearingItem.ClearingJournalEntryFiscalYear AS ClearingDocFiscalYear,
  _PaymentClearingItem.ClearingDate AS ClearingDate,
  _PaymentClearingItem.GLAccount AS GLAccount,
  case _PaymentClearingItem.IsNegativePosting when 'X' then case _PaymentClearingItem.DebitCreditCode when 'H' then 'S' when 'S' then 'H' end else _PaymentClearingItem.DebitCreditCode end as DebitCreditCode AS DebitCreditCodeendasDebitCreditCode,
  _PaymentClearingItem.Customer AS Customer,
  _PaymentClearingItem.Supplier AS Supplier,
  _InvoiceApArItem.DebitCreditCode AS InvoiceDebitCreditCode,
  _InvoiceApArItem.TransactionCurrency AS TransactionCurrency,
  abs( _InvoiceApArItem.AmountInTransactionCurrency) AS InvoiceAmtInTransactionCrcy,
  abs(_PaymentClearingItem.AmountInTransactionCurrency) AS PaymentAmtInTransactionCrcy,
  _InvoiceApArItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  abs( _InvoiceApArItem.AmountInCompanyCodeCurrency) AS InvoiceAmtInCompanyCodeCrcy,
  abs(_PaymentClearingItem.AmountInCompanyCodeCurrency) AS PaymentAmtInCompanyCodeCrcy,
  _InvoiceApArItem.AdditionalCurrency1 AS AdditionalCurrency1,
  abs(_InvoiceApArItem.AmountInAdditionalCurrency1) AS InvoiceAmtInAdditionalCrcy1,
  abs(_PaymentClearingItem.AmountInAdditionalCurrency1) AS PaytAmtInAdditionalCrcy1,
  _InvoiceApArItem.AdditionalCurrency2 AS AdditionalCurrency2,
  abs(_InvoiceApArItem.AmountInAdditionalCurrency2) AS InvoiceAmtInAdditionalCrcy2,
  abs(_PaymentClearingItem.AmountInAdditionalCurrency2) AS PaytAmtInAdditionalCrcy2,
  _InvoiceApArItem.CompanyCode AS InvoiceCompanyCode,
  _PaymentClearingItem._Customer AS _Customer,
  _PaymentClearingItem._Supplier AS _Supplier,
  _InvoiceApArItem._OneTimeAccountBP AS _OneTimeAccountBP
FROM I_OperationalAcctgDocItem AS _PaymentClearingItem
LEFT OUTER JOIN I_OperationalAcctgDocItem AS _InvoiceApArItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountingDocument AS _SourceInvoiceHeader ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_AccountingDocument AS _SourceInvoiceHeader1 ON /* join condition not captured in parsed metadata */
;

Learn More