P_RU_VATInvoiceClearingDP

DDL: P_RU_VATINVOICECLEARINGDP SQL: PRUVATINVCLRDP Type: view CONSUMPTION
12 Fields 3 Data Sources

P_RU_VATInvoiceClearingDP is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_JournalEntry, I_OperationalAcctgDocItem, I_OperationalAcctgDocItem) and exposes 12 fields.

Data Sources (3)

SourceAliasJoin Type
I_JournalEntry ClearingHeader inner
I_OperationalAcctgDocItem DPClearingItem inner
I_OperationalAcctgDocItem InvClearingItem from

Annotations (7)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode Receiver Company Code
AccountingDocument I_OperationalAcctgDocItem InvoiceReference Invoice Reference
FiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
AccountingDocumentItem I_OperationalAcctgDocItem InvoiceItemReference Item
AccountType I_OperationalAcctgDocItem FinancialAccountType Fin. Account Type
ClearingAccountingDocument I_OperationalAcctgDocItem AccountingDocument Journal Entry
ClearingFiscalYear I_OperationalAcctgDocItem FiscalYear G/L Fiscal Year
ClearingInformationIndex
ClearingInformationType
ClearedAccountingDocument I_OperationalAcctgDocItem InvoiceReference Invoice Reference
ClearedFiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear Invoice Reference Fiscal Year
ClearingLevel

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_VATInvoiceClearingDP.
-- 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: PRUVATINVCLRDP

CREATE VIEW P_RU_VATInvoiceClearingDP AS
SELECT
  InvClearingItem.CompanyCode AS CompanyCode,
  InvClearingItem.InvoiceReference AS AccountingDocument,
  InvClearingItem.InvoiceReferenceFiscalYear AS FiscalYear,
  InvClearingItem.InvoiceItemReference AS AccountingDocumentItem,
  InvClearingItem.FinancialAccountType AS AccountType,
  InvClearingItem.AccountingDocument AS ClearingAccountingDocument,
  InvClearingItem.FiscalYear AS ClearingFiscalYear,
  ' ' AS ClearingInformationIndex,
  ' ' AS ClearingInformationType,
  DPClearingItem.InvoiceReference AS ClearedAccountingDocument,
  DPClearingItem.InvoiceReferenceFiscalYear AS ClearedFiscalYear,
  'U' AS ClearingLevel
FROM I_OperationalAcctgDocItem AS InvClearingItem
INNER JOIN I_OperationalAcctgDocItem AS DPClearingItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntry AS ClearingHeader ON /* join condition not captured in parsed metadata */
;

Learn More