P_RU_VATReportingCustSubs3

DDL: P_RU_VATREPORTINGCUSTSUBS3 SQL: PRUVATRPTGCUSTS3 Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU
11 Fields 1 Data Sources

VAT Reporting Customizing: Subscenario - 3

P_RU_VATReportingCustSubs3 is a Consumption CDS View that provides data about "VAT Reporting Customizing: Subscenario - 3" in SAP S/4HANA. It reads from 1 data source (P_RU_VATReportingCustSubs2) and exposes 11 fields with key fields RU_VATSubScenarioVersion, RU_VATSubScenario, RU_VATSubScenarioItem, TaxCode, AccountingDocumentType. Part of development package GLO_FIN_IS_VAT_RU.

Data Sources (1)

SourceAliasJoin Type
P_RU_VATReportingCustSubs2 Customizing from

Annotations (7)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RU_VATSubScenarioVersion P_RU_VATReportingCustSubs2 RU_VATSubScenarioVersion Subscenario Version
KEY RU_VATSubScenario P_RU_VATReportingCustSubs2 RU_VATSubScenario Subscenario
KEY RU_VATSubScenarioItem P_RU_VATReportingCustSubs2 RU_VATSubScenarioItem
KEY TaxCode P_RU_VATReportingCustSubs2 TaxCode Tax Code
KEY AccountingDocumentType AccDocType AccountingDocumentType Journal Entry Type
KEY DebitCreditCode
KEY TaxItemClassification P_RU_VATReportingCustSubs2 TaxItemClassification
KEY RU_SourceDocumentType
KEY IsCorrectionInvoice
VATReturnOperation VATReturnOperation Operation Code
Rank Rank Sequence No.

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_VATReportingCustSubs3.
-- 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: PRUVATRPTGCUSTS3

CREATE VIEW P_RU_VATReportingCustSubs3 AS
SELECT
  Customizing.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  Customizing.RU_VATSubScenario AS RU_VATSubScenario,
  Customizing.RU_VATSubScenarioItem AS RU_VATSubScenarioItem,
  Customizing.TaxCode AS TaxCode,
  AccDocType.AccountingDocumentType AS AccountingDocumentType,
  cast(DebCredCode.DebitCreditCode as shkzg ) AS DebitCreditCode,
  Customizing.TaxItemClassification AS TaxItemClassification,
  cast(SrcDocType.AccountingDocumentType as firu_original_document_type preserving type ) AS RU_SourceDocumentType,
  cast(CorrType.CorrectionType as firu_vatcorrfl) AS IsCorrectionInvoice,
  VATReturnOperation,
  Rank
FROM P_RU_VATReportingCustSubs2 AS Customizing
;

Learn More