P_RU_DSVATReporting4Jrnl

DDL: P_RU_DSVATREPORTING4JRNL SQL: PRUDSVATRPTG4J Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
20 Fields 2 Data Sources

VAT Reporting: Restriction by Original/Correction (Journal)

P_RU_DSVATReporting4Jrnl is a Consumption CDS View that provides data about "VAT Reporting: Restriction by Original/Correction (Journal)" in SAP S/4HANA. It reads from 2 data sources (P_RU_CFinVATCorrectionDocument, P_RU_DSVATReporting3Jrnl) and exposes 20 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (2)

SourceAliasJoin Type
P_RU_CFinVATCorrectionDocument CorrDoc left_outer
P_RU_DSVATReporting3Jrnl VatReporting from

Annotations (6)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_DSVATReporting3Jrnl CompanyCode Receiver Company Code
AccountingDocument P_RU_DSVATReporting3Jrnl AccountingDocument Journal Entry
FiscalYear P_RU_DSVATReporting3Jrnl FiscalYear G/L Fiscal Year
PostingDate P_RU_DSVATReporting3Jrnl PostingDate Posting Date for GR
TaxReportingDate P_RU_DSVATReporting3Jrnl TaxReportingDate Tax Reporting Date
IsReversal P_RU_DSVATReporting3Jrnl IsReversal Reversal doc.
IsReversed P_RU_DSVATReporting3Jrnl IsReversed Reversed?
ReverseDocument P_RU_DSVATReporting3Jrnl ReverseDocument Reversed With
ReverseDocumentFiscalYear P_RU_DSVATReporting3Jrnl ReverseDocumentFiscalYear Year
TaxItem P_RU_DSVATReporting3Jrnl TaxItem Tax Item
TaxCode P_RU_DSVATReporting3Jrnl TaxCode Tax Code
RU_VATReturnVersion P_RU_DSVATReporting3Jrnl RU_VATReturnVersion VAT Return Version
RU_VATReturnSectionType P_RU_DSVATReporting3Jrnl RU_VATReturnSectionType Section Type
RU_VATReturnLine P_RU_DSVATReporting3Jrnl RU_VATReturnLine Line
RU_VATSubScenario P_RU_DSVATReporting3Jrnl RU_VATSubScenario Subscenario
RU_VATScenario P_RU_DSVATReporting3Jrnl RU_VATScenario VAT Scenario
RU_SourceDocumentType P_RU_DSVATReporting3Jrnl RU_SourceDocumentType
IsCorrectionInvoice P_RU_DSVATReporting3Jrnl IsCorrectionInvoice
OriginalDocument P_RU_DSVATReporting3Jrnl OriginalDocument Original Document
OriginalDocumentYear P_RU_DSVATReporting3Jrnl OriginalDocumentYear Orig. Doc. Year

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_DSVATReporting4Jrnl.
-- 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: PRUDSVATRPTG4J

CREATE VIEW P_RU_DSVATReporting4Jrnl AS
SELECT
  VatReporting.CompanyCode AS CompanyCode,
  VatReporting.AccountingDocument AS AccountingDocument,
  VatReporting.FiscalYear AS FiscalYear,
  VatReporting.PostingDate AS PostingDate,
  VatReporting.TaxReportingDate AS TaxReportingDate,
  VatReporting.IsReversal AS IsReversal,
  VatReporting.IsReversed AS IsReversed,
  VatReporting.ReverseDocument AS ReverseDocument,
  VatReporting.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  VatReporting.TaxItem AS TaxItem,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReporting.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatReporting.RU_VATReturnLine AS RU_VATReturnLine,
  VatReporting.RU_VATSubScenario AS RU_VATSubScenario,
  VatReporting.RU_VATScenario AS RU_VATScenario,
  VatReporting.RU_SourceDocumentType AS RU_SourceDocumentType,
  VatReporting.IsCorrectionInvoice AS IsCorrectionInvoice,
  VatReporting.OriginalDocument AS OriginalDocument,
  VatReporting.OriginalDocumentYear AS OriginalDocumentYear
FROM P_RU_DSVATReporting3Jrnl AS VatReporting
LEFT OUTER JOIN P_RU_CFinVATCorrectionDocument AS CorrDoc ON /* join condition not captured in parsed metadata */
;

Learn More