P_RU_DSVATReporting4

DDL: P_RU_DSVATREPORTING4 SQL: PRUDSVATRPTG4 Type: view CONSUMPTION
25 Fields 1 Data Sources

P_RU_DSVATReporting4 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_DSVATReporting3) and exposes 25 fields.

Data Sources (1)

SourceAliasJoin Type
P_RU_DSVATReporting3 VatReporting from

Annotations (6)

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

Fields (25)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_DSVATReporting3 CompanyCode Receiver Company Code
AccountingDocument P_RU_DSVATReporting3 AccountingDocument Journal Entry
FiscalYear P_RU_DSVATReporting3 FiscalYear G/L Fiscal Year
PostingDate P_RU_DSVATReporting3 PostingDate Posting Date for GR
TaxReportingDate P_RU_DSVATReporting3 TaxReportingDate Tax Reporting Date
IsReversal P_RU_DSVATReporting3 IsReversal Reversal doc.
IsReversed P_RU_DSVATReporting3 IsReversed Reversed?
ReverseDocument P_RU_DSVATReporting3 ReverseDocument Reversed With
ReverseDocumentFiscalYear P_RU_DSVATReporting3 ReverseDocumentFiscalYear Year
ReverseDocumentTaxRepDate P_RU_DSVATReporting3 ReverseDocumentTaxRepDate
TaxItem P_RU_DSVATReporting3 TaxItem Tax Item
TaxCode P_RU_DSVATReporting3 TaxCode Tax Code
RU_VATReturnVersion P_RU_DSVATReporting3 RU_VATReturnVersion VAT Return Version
RU_VATSubScenarioVersion P_RU_DSVATReporting3 RU_VATSubScenarioVersion Subscenario Version
RU_VATReturnSectionType P_RU_DSVATReporting3 RU_VATReturnSectionType Section Type
RU_VATReturnLine P_RU_DSVATReporting3 RU_VATReturnLine Line
RU_VATSubScenario P_RU_DSVATReporting3 RU_VATSubScenario Subscenario
RU_VATScenario P_RU_DSVATReporting3 RU_VATScenario VAT Scenario
RU_VATSubScenarioItem P_RU_DSVATReporting3 RU_VATSubScenarioItem
RU_SourceDocumentType P_RU_DSVATReporting3 RU_SourceDocumentType
IsCorrectionInvoice P_RU_DSVATReporting3 IsCorrectionInvoice
OriginalDocument P_RU_DSVATReporting3 OriginalDocument Original Document
OriginalDocumentYear P_RU_DSVATReporting3 OriginalDocumentYear Orig. Doc. Year
OriginalDocumentIsReversal P_RU_DSVATReporting3 OriginalDocumentIsReversal
OriginalDocumentIsReversed P_RU_DSVATReporting3 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_DSVATReporting4.
-- 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: PRUDSVATRPTG4

CREATE VIEW P_RU_DSVATReporting4 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.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,
  VatReporting.OriginalDocument AS OriginalDocument,
  VatReporting.OriginalDocumentYear AS OriginalDocumentYear,
  VatReporting.OriginalDocumentIsReversal AS OriginalDocumentIsReversal,
  VatReporting.OriginalDocumentIsReversed AS OriginalDocumentIsReversed
FROM P_RU_DSVATReporting3 AS VatReporting
;

Learn More