P_RU_VatSubscenarioItem

DDL: P_RU_VATSUBSCENARIOITEM SQL: PRUVATSUBSCITEM Type: view BASIC
11 Fields 1 Data Sources

P_RU_VatSubscenarioItem is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (firud_vatsubit) and exposes 11 fields.

Data Sources (1)

SourceAliasJoin Type
firud_vatsubit VatSubscenarioItem from

Annotations (5)

NameValueLevelField
VDM.private true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName PRUVATSUBSCITEM view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (11)

KeyFieldSource TableSource FieldDescription
SubscenarioVersion firud_vatsubit vers_subs Subscenario Version
Subscenario firud_vatsubit subscenario Subscenario
RU_VATSubScenarioVersion firud_vatsubit vers_subs Subscenario Version
RU_VATSubScenario firud_vatsubit subscenario Subscenario
ItemNumber firud_vatsubit item_num Transfer Item No.
TaxCode firud_vatsubit mwskz Tax Code
AccountingDocumentType firud_vatsubit blart Rep. rec. doc. type
DebitCreditCode firud_vatsubit shkzg Returns
TaxItemClassification firud_vatsubit ktosl Transaction
IsCorrectionInvoice firud_vatsubit corr_flag Correction Type
VATReturnOperation firud_vatsubit 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 P_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: PRUVATSUBSCITEM

CREATE VIEW P_RU_VatSubscenarioItem AS
SELECT
  VatSubscenarioItem.vers_subs AS SubscenarioVersion,
  VatSubscenarioItem.subscenario AS Subscenario,
  VatSubscenarioItem.vers_subs AS RU_VATSubScenarioVersion,
  VatSubscenarioItem.subscenario AS RU_VATSubScenario,
  VatSubscenarioItem.item_num AS ItemNumber,
  VatSubscenarioItem.mwskz AS TaxCode,
  VatSubscenarioItem.blart AS AccountingDocumentType,
  VatSubscenarioItem.shkzg AS DebitCreditCode,
  VatSubscenarioItem.ktosl AS TaxItemClassification,
  VatSubscenarioItem.corr_flag AS IsCorrectionInvoice,
  VatSubscenarioItem.operation_code AS VATReturnOperation
FROM firud_vatsubit AS VatSubscenarioItem
;

Learn More