P_RU_DownPaymentClearing

DDL: P_RU_DOWNPAYMENTCLEARING SQL: PRUDWNPMNTCLRNG Type: view CONSUMPTION
31 Fields 7 Data Sources

P_RU_DownPaymentClearing is a Consumption CDS View in SAP S/4HANA. It reads from 7 data sources and exposes 31 fields with key fields ClearingCompanyCode, ClearingAccountingDocument, ClearingFiscalYear, ClearingInformationIndex, ClearingAccountingDocumentItem.

Data Sources (7)

SourceAliasJoin Type
I_ClrgInfoRelationForAcctgDoc ClearDocClr from
I_OperationalAcctgDocItem ClearDocItem inner
I_OperationalAcctgDocItem ClearDocItem union_all
P_RU_BSET ClearDocTax inner
P_RU_BSET ClearDocTax inner
I_OperationalAcctgDocItem OrigDocItem inner
I_OperationalAcctgDocItem OrigDocItem inner

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUDWNPMNTCLRNG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY ClearingCompanyCode I_ClrgInfoRelationForAcctgDoc ClearingInfoCompanyCode Company Code
KEY ClearingAccountingDocument I_ClrgInfoRelationForAcctgDoc ClearingAccountingDocument Journal Entry
KEY ClearingFiscalYear I_ClrgInfoRelationForAcctgDoc ClearingFiscalYear G/L Fiscal Year
KEY ClearingInformationIndex I_ClrgInfoRelationForAcctgDoc ClearingInformationIndex Clrg Info Seq. No.
KEY ClearingAccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
ClearingTaxItem P_RU_BSET TaxItem Tax Item
ClearingTaxTransactTypeDeterm P_RU_BSET TransactionTypeDetermination Transaction Key
ClearingTaxGLAccount P_RU_BSET GLAccount General Ledger
DownPaymentCompanyCode I_ClrgInfoRelationForAcctgDoc CompanyCode Receiver Company Code
DownPayment I_ClrgInfoRelationForAcctgDoc AccountingDocument Invoice Reference
DownPaymentFiscalYear I_ClrgInfoRelationForAcctgDoc FiscalYear Invoice Reference Fiscal Year
DownPaymentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
DownPaymentItem I_ClrgInfoRelationForAcctgDoc AccountingDocumentItem Item
DownPaymentDebitCreditCode I_ClrgInfoRelationForAcctgDoc DebitCreditCode Single-Character Flag
DownPaymentTaxCode I_OperationalAcctgDocItem TaxCode Tax Code
CompanyCodeasClearingCompanyCode
KEY ClearingAccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
KEY ClearingFiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
KEY ClearingInformationIndex Clrg Info Seq. No.
KEY ClearingAccountingDocumentItem I_OperationalAcctgDocItem AccountingDocumentItem Posting View Item
ClearingTaxItem P_RU_BSET TaxItem Tax Item
ClearingTaxTransactTypeDeterm P_RU_BSET TransactionTypeDetermination Transaction Key
ClearingTaxGLAccount P_RU_BSET GLAccount General Ledger
DownPaymentCompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
DownPayment I_OperationalAcctgDocItem InvoiceReference Invoice Reference
DownPaymentFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
DownPaymentType I_OperationalAcctgDocItem AccountingDocumentType Journal Entry Type
DownPaymentItem I_OperationalAcctgDocItem InvoiceItemReference Item
DownPaymentDebitCreditCode I_OperationalAcctgDocItem DebitCreditCode Single-Character Flag
DownPaymentTaxCode I_OperationalAcctgDocItem TaxCode Tax Code
ClearingType

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_RU_DownPaymentClearing.
-- 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: PRUDWNPMNTCLRNG

CREATE VIEW P_RU_DownPaymentClearing AS
SELECT
  ClearDocClr.ClearingInfoCompanyCode AS ClearingCompanyCode,
  ClearDocClr.ClearingAccountingDocument AS ClearingAccountingDocument,
  ClearDocClr.ClearingFiscalYear AS ClearingFiscalYear,
  ClearDocClr.ClearingInformationIndex AS ClearingInformationIndex,
  ClearDocItem.AccountingDocumentItem AS ClearingAccountingDocumentItem,
  ClearDocTax.TaxItem AS ClearingTaxItem,
  ClearDocTax.TransactionTypeDetermination AS ClearingTaxTransactTypeDeterm,
  ClearDocTax.GLAccount AS ClearingTaxGLAccount,
  ClearDocClr.CompanyCode AS DownPaymentCompanyCode,
  ClearDocClr.AccountingDocument AS DownPayment,
  ClearDocClr.FiscalYear AS DownPaymentFiscalYear,
  OrigDocItem.AccountingDocumentType AS DownPaymentType,
  ClearDocClr.AccountingDocumentItem AS DownPaymentItem,
  ClearDocClr.DebitCreditCode AS DownPaymentDebitCreditCode,
  OrigDocItem.TaxCode AS DownPaymentTaxCode,
  'I' as ClearingType AS CompanyCodeasClearingCompanyCode,
  'A' AS ClearingType
FROM I_ClrgInfoRelationForAcctgDoc AS ClearDocClr
INNER JOIN I_OperationalAcctgDocItem AS OrigDocItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_OperationalAcctgDocItem AS ClearDocItem ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_BSET AS ClearDocTax ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_OperationalAcctgDocItem
;

Learn More