I_RU_VATReturnSettingItem

DDL: I_RU_VATRETURNSETTINGITEM SQL: IRUVATSPSETIT Type: view BASIC
22 Fields 4 Data Sources

S/P Ledgers VAT Decl Customizing Data

I_RU_VATReturnSettingItem is a Basic CDS View that provides data about "S/P Ledgers VAT Decl Customizing Data" in SAP S/4HANA. It reads from 4 data sources (P_RU_VatReturnSection, P_RU_VatSubscenario, P_RU_VatSubscenarioAssignment, P_RU_VatReturnVersion) and exposes 22 fields with key fields RU_VATReturnVersion, RU_VATSubScenarioVersion, RU_VATReturnSection, RU_VATReturnLine, RU_VATSubScenario.

Data Sources (4)

SourceAliasJoin Type
P_RU_VatReturnSection Section inner
P_RU_VatSubscenario Subs inner
P_RU_VatSubscenarioAssignment SubsAss inner
P_RU_VatReturnVersion Version from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IRUVATSPSETIT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
EndUserText.label S/P Ledgers VAT Decl Customizing Data view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY RU_VATReturnVersion P_RU_VatReturnVersion RU_VATReturnVersion VAT Return Version
KEY RU_VATSubScenarioVersion P_RU_VatReturnVersion RU_VATSubScenarioVersion Subscenario Version
KEY RU_VATReturnSection P_RU_VatReturnSection RU_VATReturnSection VAT Return Section
KEY RU_VATReturnLine P_RU_VatSubscenarioAssignment RU_VATReturnLine Line
KEY RU_VATSubScenario P_RU_VatSubscenarioAssignment RU_VATSubScenario Subscenario
RU_VATScenario P_RU_VatSubscenario RU_VATScenario VAT Scenario
RU_VATReturnSectionType P_RU_VatReturnSection RU_VATReturnSectionType Section Type
SignIsInverted P_RU_VatSubscenarioAssignment SignIsInverted Invert D/C Sign
BusinessPartnerType P_RU_VatSubscenarioAssignment BusinessPartnerType Undefined range (can be used for patch levels)
AgentType P_RU_VatSubscenarioAssignment AgentType Bus. Partner Agent
PaymentOrderOutputType P_RU_VatSubscenarioAssignment PaymentOrderOutputType Payment Order
ImprtCstmsDeclnIsRead P_RU_VatSubscenarioAssignment ImprtCstmsDeclnIsRead ImCD/RNPT Option
MatlRcptDateIsRead P_RU_VatSubscenarioAssignment MatlRcptDateIsRead Date of Material Rec
RU_CustomerOutputType P_RU_VatSubscenarioAssignment RU_CustomerOutputType Real Buyer Source
RU_SupplierAgentOutputType P_RU_VatSubscenarioAssignment RU_SupplierAgentOutputType Real Seller Source
RU_SupplierOutputType P_RU_VatSubscenarioAssignment RU_SupplierOutputType Seller
RU_SubagentOutputType P_RU_VatSubscenarioAssignment RU_SubagentOutputType Subagent Source
SalesDealType P_RU_VatSubscenarioAssignment SalesDealType Deal Type
RU_OrgOperationType P_RU_VatSubscenarioAssignment RU_OrgOperationType Oper.TypeCode Org.
RU_PersonOperationType P_RU_VatSubscenarioAssignment RU_PersonOperationType Oper.TypeCode Person
RU_InvoiceSupplierOutputType P_RU_VatSubscenarioAssignment RU_InvoiceSupplierOutputType Seller in Inv.Output
RU_InvoiceCustomerOutputType P_RU_VatSubscenarioAssignment RU_InvoiceCustomerOutputType Buyer in Inv. Output

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_VATReturnSettingItem.
-- 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: IRUVATSPSETIT

CREATE VIEW I_RU_VATReturnSettingItem AS
SELECT
  Version.RU_VATReturnVersion AS RU_VATReturnVersion,
  Version.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  Section.RU_VATReturnSection AS RU_VATReturnSection,
  SubsAss.RU_VATReturnLine AS RU_VATReturnLine,
  SubsAss.RU_VATSubScenario AS RU_VATSubScenario,
  Subs.RU_VATScenario AS RU_VATScenario,
  Section.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  SubsAss.SignIsInverted AS SignIsInverted,
  SubsAss.BusinessPartnerType AS BusinessPartnerType,
  SubsAss.AgentType AS AgentType,
  SubsAss.PaymentOrderOutputType AS PaymentOrderOutputType,
  SubsAss.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  SubsAss.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  SubsAss.RU_CustomerOutputType AS RU_CustomerOutputType,
  SubsAss.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
  SubsAss.RU_SupplierOutputType AS RU_SupplierOutputType,
  SubsAss.RU_SubagentOutputType AS RU_SubagentOutputType,
  SubsAss.SalesDealType AS SalesDealType,
  SubsAss.RU_OrgOperationType AS RU_OrgOperationType,
  SubsAss.RU_PersonOperationType AS RU_PersonOperationType,
  SubsAss.RU_InvoiceSupplierOutputType AS RU_InvoiceSupplierOutputType,
  SubsAss.RU_InvoiceCustomerOutputType AS RU_InvoiceCustomerOutputType
FROM P_RU_VatReturnVersion AS Version
INNER JOIN P_RU_VatReturnSection AS Section ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_VatSubscenarioAssignment AS SubsAss ON /* join condition not captured in parsed metadata */
INNER JOIN P_RU_VatSubscenario AS Subs ON /* join condition not captured in parsed metadata */
;

Learn More