P_RU_DSVATReporting3

DDL: P_RU_DSVATREPORTING3 SQL: PRUDSVATRPTG3 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
27 Fields 2 Data Sources

VAT Reporting: Original Document Determination

P_RU_DSVATReporting3 is a Consumption CDS View that provides data about "VAT Reporting: Original Document Determination" in SAP S/4HANA. It reads from 2 data sources (P_RU_VATOriginalDocument, P_RU_DSVATReporting2) and exposes 27 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (2)

SourceAliasJoin Type
P_RU_VATOriginalDocument OrigDoc inner
P_RU_DSVATReporting2 VatReporting from

Annotations (6)

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

Fields (27)

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

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_DSVATReporting3.
-- 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: PRUDSVATRPTG3

CREATE VIEW P_RU_DSVATReporting3 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.ReverseDocumentTaxRepDate AS ReverseDocumentTaxRepDate,
  VatReporting.ReverseTaxItem AS ReverseTaxItem,
  VatReporting.TaxItem AS TaxItem,
  VatReporting.TaxCode AS TaxCode,
  VatReporting.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatReporting.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  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_VATSubScenarioItem AS RU_VATSubScenarioItem,
  VatReporting.RU_SourceDocumentType AS RU_SourceDocumentType,
  VatReporting.IsCorrectionInvoice AS IsCorrectionInvoice,
  OrigDoc.OriginalDocument AS OriginalDocument,
  OrigDoc.OriginalDocumentYear AS OriginalDocumentYear,
  OrigDoc.OriginalDocumentType AS OriginalDocumentType,
  OrigDoc.OriginalDocumentIsReversal AS OriginalDocumentIsReversal,
  OrigDoc.OriginalDocumentIsReversed AS OriginalDocumentIsReversed
FROM P_RU_DSVATReporting2 AS VatReporting
INNER JOIN P_RU_VATOriginalDocument AS OrigDoc ON /* join condition not captured in parsed metadata */
;

Learn More