P_RU_RealReversedDocument

DDL: P_RU_REALREVERSEDDOCUMENT SQL: PRURREVERSEDDOC Type: view CONSUMPTION
30 Fields 2 Data Sources

P_RU_RealReversedDocument is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, P_RU_AcctgDocReferenceID) and exposes 30 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry ReversalDoc from
P_RU_AcctgDocReferenceID ReversedDoc inner

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRURREVERSEDDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode P_RU_AcctgDocReferenceID CompanyCode Receiver Company Code
KEY AccountingDocument P_RU_AcctgDocReferenceID AccountingDocument Journal Entry
KEY FiscalYear P_RU_AcctgDocReferenceID FiscalYear G/L Fiscal Year
AccountingDocumentType P_RU_AcctgDocReferenceID AccountingDocumentType Journal Entry Type
PostingDate P_RU_AcctgDocReferenceID PostingDate Posting Date for GR
TaxReportingDate P_RU_AcctgDocReferenceID TaxReportingDate Tax Reporting Date
DocumentReferenceID P_RU_AcctgDocReferenceID DocumentReferenceID Reference
ReferenceDocumentType P_RU_AcctgDocReferenceID ReferenceDocumentType Reference Document Type
OriginalReferenceDocumentCntxt P_RU_AcctgDocReferenceID OriginalReferenceDocumentCntxt
OriginalReferenceDocumentNum P_RU_AcctgDocReferenceID OriginalReferenceDocumentNum
IsReversal P_RU_AcctgDocReferenceID IsReversal Reversal doc.
IsReversed P_RU_AcctgDocReferenceID IsReversed Reversed?
ReversalDocumentBKPF P_RU_AcctgDocReferenceID ReverseDocument Reversed With
ReversalDocumentFiscalYearBKPF P_RU_AcctgDocReferenceID ReverseDocumentFiscalYear Year
ReversalDocument I_JournalEntry AccountingDocument Journal Entry
ReversalDocumentFiscalYear I_JournalEntry FiscalYear G/L Fiscal Year
ReversalDocumentType I_JournalEntry AccountingDocumentType Journal Entry Type
ReversalDocumentPostingDate I_JournalEntry PostingDate Posting Date for GR
ReversalDocumentTaxRepDate I_JournalEntry TaxReportingDate Tax Reporting Date
ReversalDocumentReferenceID I_JournalEntry DocumentReferenceID Reference
ReversalDocumentRefDocType I_JournalEntry ReferenceDocumentType Reference Document Type
ReversalReferenceDocumentCntxt I_JournalEntry ReversalReferenceDocumentCntxt Reversal Reference Document Context
ReversalReferenceDocument I_JournalEntry ReversalReferenceDocument Reversal Reference Document
ReversalDocumentIsReversal I_JournalEntry IsReversal Reversal doc.
ReversalDocumentIsReversed I_JournalEntry IsReversed Reversed?
ReversedDocumentBKPF I_JournalEntry ReverseDocument Reversed With
ReversedDocumentFiscalYearBKPF I_JournalEntry ReverseDocumentFiscalYear Year
LedgerGroup I_JournalEntry LedgerGroup Ledger Group
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency Local Currency
RU_ReverseType

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_RealReversedDocument.
-- 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: PRURREVERSEDDOC

CREATE VIEW P_RU_RealReversedDocument AS
SELECT
  ReversedDoc.CompanyCode AS CompanyCode,
  ReversedDoc.AccountingDocument AS AccountingDocument,
  ReversedDoc.FiscalYear AS FiscalYear,
  ReversedDoc.AccountingDocumentType AS AccountingDocumentType,
  ReversedDoc.PostingDate AS PostingDate,
  ReversedDoc.TaxReportingDate AS TaxReportingDate,
  ReversedDoc.DocumentReferenceID AS DocumentReferenceID,
  ReversedDoc.ReferenceDocumentType AS ReferenceDocumentType,
  ReversedDoc.OriginalReferenceDocumentCntxt AS OriginalReferenceDocumentCntxt,
  ReversedDoc.OriginalReferenceDocumentNum AS OriginalReferenceDocumentNum,
  ReversedDoc.IsReversal AS IsReversal,
  ReversedDoc.IsReversed AS IsReversed,
  ReversedDoc.ReverseDocument AS ReversalDocumentBKPF,
  ReversedDoc.ReverseDocumentFiscalYear AS ReversalDocumentFiscalYearBKPF,
  ReversalDoc.AccountingDocument AS ReversalDocument,
  ReversalDoc.FiscalYear AS ReversalDocumentFiscalYear,
  ReversalDoc.AccountingDocumentType AS ReversalDocumentType,
  ReversalDoc.PostingDate AS ReversalDocumentPostingDate,
  ReversalDoc.TaxReportingDate AS ReversalDocumentTaxRepDate,
  ReversalDoc.DocumentReferenceID AS ReversalDocumentReferenceID,
  ReversalDoc.ReferenceDocumentType AS ReversalDocumentRefDocType,
  ReversalDoc.ReversalReferenceDocumentCntxt AS ReversalReferenceDocumentCntxt,
  ReversalDoc.ReversalReferenceDocument AS ReversalReferenceDocument,
  ReversalDoc.IsReversal AS ReversalDocumentIsReversal,
  ReversalDoc.IsReversed AS ReversalDocumentIsReversed,
  ReversalDoc.ReverseDocument AS ReversedDocumentBKPF,
  ReversalDoc.ReverseDocumentFiscalYear AS ReversedDocumentFiscalYearBKPF,
  ReversalDoc.LedgerGroup AS LedgerGroup,
  ReversalDoc.CompanyCodeCurrency AS CompanyCodeCurrency,
  'REAL' AS RU_ReverseType
FROM I_JournalEntry AS ReversalDoc
INNER JOIN P_RU_AcctgDocReferenceID AS ReversedDoc ON /* join condition not captured in parsed metadata */
;

Learn More