I_RU_VATSubScenarioItem

DDL: I_RU_VATSUBSCENARIOITEM SQL: IRUVATSUBSCITEM Type: view BASIC

Russian VAT Subscenario Item

I_RU_VATSubScenarioItem is a Basic CDS View that provides data about "Russian VAT Subscenario Item" in SAP S/4HANA. It reads from 1 data source (firud_vatsubit) and exposes 10 fields with key fields RU_VATSubScenarioVersion, RU_VATSubScenario, RU_VATSubScenarioItem.

Data Sources (1)

SourceAliasJoin Type
firud_vatsubit firud_vatsubit from

Annotations (10)

NameValueLevelField
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IRUVATSUBSCITEM view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Russian VAT Subscenario Item view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RU_VATSubScenarioVersion vers_subs Subscenario Version
KEY RU_VATSubScenario subscenario Subscenario
KEY RU_VATSubScenarioItem item_num Transfer Item No.
TaxCode mwskz Tax Code
AccountingDocumentType blart Rep. rec. doc. type
DebitCreditCode shkzg Returns
TaxItemClassification ktosl Transaction
RU_SourceDocumentType originaldocument_blart Original Doc. Type
IsCorrectionInvoice corr_flag Correction Type
VATReturnOperation operation_code Operation Code

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 I_RU_VATSubScenarioItem.
-- 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: IRUVATSUBSCITEM

CREATE VIEW I_RU_VATSubScenarioItem AS
SELECT
  vers_subs AS RU_VATSubScenarioVersion,
  subscenario AS RU_VATSubScenario,
  item_num AS RU_VATSubScenarioItem,
  mwskz AS TaxCode,
  blart AS AccountingDocumentType,
  shkzg AS DebitCreditCode,
  ktosl AS TaxItemClassification,
  originaldocument_blart AS RU_SourceDocumentType,
  corr_flag AS IsCorrectionInvoice,
  operation_code AS VATReturnOperation
FROM firud_vatsubit
;