P_RU_VATReturnSettingItem

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_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: PRUVATSPSETIT

CREATE VIEW P_RU_VATReturnSettingItem AS
SELECT
  VatCustDecl.RU_VATReturnVersion AS RU_VATReturnVersion,
  VatCustDecl.RU_VATSubScenarioVersion AS RU_VATSubScenarioVersion,
  VatCustDecl.RU_VATReturnSectionType AS RU_VATReturnSectionType,
  VatCustDecl.RU_VATReturnSection AS RU_VATReturnSection,
  VatCustDecl.RU_VATReturnLine AS RU_VATReturnLine,
  '|' AS s1,
  VatCustDecl.RU_VATSubScenario AS RU_VATSubScenario,
  VatCustDecl.RU_VATScenario AS RU_VATScenario,
  VatCustSubs.RU_VATSubScenarioItem AS RU_VATSubScenarioItem,
  VatCustSubs.TaxCode AS TaxCode,
  VatCustSubs.AccountingDocumentType AS AccountingDocumentType,
  VatCustSubs.DebitCreditCode AS DebitCreditCode,
  VatCustSubs.TaxItemClassification AS TaxItemClassification,
  VatCustSubs.RU_SourceDocumentType AS RU_SourceDocumentType,
  VatCustSubs.IsCorrectionInvoice AS IsCorrectionInvoice,
  VatCustSubs.VATReturnOperation AS VATReturnOperation,
  '|' AS s2,
  VatCustDecl.RU_TotalAmountCalcType AS RU_TotalAmountCalcType,
  VatCustDecl.RU_TaxBaseAmountCalcType AS RU_TaxBaseAmountCalcType,
  VatCustDecl.RU_TaxAmountCalcType AS RU_TaxAmountCalcType,
  VatCustDecl.SignIsInverted AS SignIsInverted,
  VatCustDecl.BusinessPartnerType AS BusinessPartnerType,
  VatCustDecl.AgentType AS AgentType,
  VatCustDecl.PaymentOrderOutputType AS PaymentOrderOutputType,
  VatCustDecl.ImprtCstmsDeclnIsRead AS ImprtCstmsDeclnIsRead,
  VatCustDecl.MatlRcptDateIsRead AS MatlRcptDateIsRead,
  VatCustDecl.RU_CustomerOutputType AS RU_CustomerOutputType,
  VatCustDecl.RU_SupplierAgentOutputType AS RU_SupplierAgentOutputType,
  VatCustDecl.RU_SupplierOutputType AS RU_SupplierOutputType,
  VatCustDecl.RU_SubagentOutputType AS RU_SubagentOutputType,
  VatCustDecl.SalesDealType AS SalesDealType,
  VatCustDecl.RU_OrgOperationType AS RU_OrgOperationType,
  VatCustDecl.RU_PersonOperationType AS RU_PersonOperationType
FROM I_RU_VATReturnSettingItem AS VatCustDecl
-- UNION ALL with additional select branch(es): I_RU_VATSubScenarioItem
;