P_RU_DSVATReporting3Jrnl

DDL: P_RU_DSVATREPORTING3JRNL SQL: PRUDSVATRPTG3J Type: view CONSUMPTION
21 Fields 1 Data Sources

P_RU_DSVATReporting3Jrnl is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (P_RU_DSVATReporting2) and exposes 21 fields.

Data Sources (1)

SourceAliasJoin Type
P_RU_DSVATReporting2 VatReporting from

Annotations (6)

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

Fields (21)

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
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_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_SourceDocumentType P_RU_DSVATReporting2 RU_SourceDocumentType
IsCorrectionInvoice P_RU_DSVATReporting2 IsCorrectionInvoice
OriginalDocument P_RU_DSVATReporting2 SrcDocNmbrForOriginalDocument
OriginalDocumentYear P_RU_DSVATReporting2 SrcDocYearForOriginalDocument
OriginalDocumentType P_RU_DSVATReporting2 SrcDocTypeForOriginalDocument

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_DSVATReporting3Jrnl.
-- 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: PRUDSVATRPTG3J

CREATE VIEW P_RU_DSVATReporting3Jrnl 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.SrcDocNmbrForOriginalDocument AS OriginalDocument,
  VatReporting.SrcDocYearForOriginalDocument AS OriginalDocumentYear,
  VatReporting.SrcDocTypeForOriginalDocument AS OriginalDocumentType
FROM P_RU_DSVATReporting2 AS VatReporting
;

Learn More