P_RU_VATOperationType

DDL: P_RU_VATOPERATIONTYPE SQL: PRUVATOPT Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
24 Fields 2 Data Sources

VAT Reporting: Operation Types

P_RU_VATOperationType is a Consumption CDS View that provides data about "VAT Reporting: Operation Types" in SAP S/4HANA. It reads from 2 data sources (P_RU_VATReporting1, P_RU_VATReporting1) and exposes 24 fields. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (2)

SourceAliasJoin Type
P_RU_VATReporting1 P_RU_VATReporting1 from
P_RU_VATReporting1 P_RU_VATReporting1 union_all

Annotations (6)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode Receiver Company Code
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
SourceDocument SourceDocument Document
SourceDocumentFiscalYear SourceDocumentFiscalYear
RU_VATReturnVersion RU_VATReturnVersion VAT Return Version
RU_VATReturnSectionType RU_VATReturnSectionType Section Type
RU_VATSubScenario RU_VATSubScenario Subscenario
BusinessPartnerIsNatrualPerson
RU_VATOperationType RU_OrgOperationType
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
AccountingDocument AccountingDocument Journal Entry
FiscalYear FiscalYear G/L Fiscal Year
SourceDocument SourceDocument Document
SourceDocumentFiscalYear SourceDocumentFiscalYear
RU_VATReturnVersion RU_VATReturnVersion VAT Return Version
RU_VATReturnSectionType RU_VATReturnSectionType Section Type
RU_VATSubScenario RU_VATSubScenario Subscenario
BusinessPartnerIsNatrualPerson
RU_VATOperationType RU_PersonOperationType
StatryRptgEntity StatryRptgEntity Reporting Entity
StatryRptCategory StatryRptCategory Report ID
StatryRptRunID StatryRptRunID Report Run ID

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_VATOperationType.
-- 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: PRUVATOPT

CREATE VIEW P_RU_VATOperationType AS
SELECT
  CompanyCode,
  AccountingDocument,
  FiscalYear,
  SourceDocument,
  SourceDocumentFiscalYear,
  RU_VATReturnVersion,
  RU_VATReturnSectionType,
  RU_VATSubScenario,
  '' AS BusinessPartnerIsNatrualPerson,
  RU_OrgOperationType AS RU_VATOperationType,
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID
FROM P_RU_VATReporting1
-- UNION ALL with additional select branch(es): P_RU_VATReporting1
;

Learn More