C_AccountingVATReturnDocItem

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 C_AccountingVATReturnDocItem.
-- 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: CACVATRETDOCITM
-- Parameters: P_StatryRptgEntity : srf_reporting_entity, P_StatryRptCategory : srf_rep_cat_id, P_StatryRptRunID : srf_report_run_id

CREATE VIEW C_AccountingVATReturnDocItem AS
SELECT
  _Item.StatryRptgEntity AS StatryRptgEntity,
  _Item.StatryRptCategory AS StatryRptCategory,
  _Item.StatryRptRunID AS StatryRptRunID,
  _Item.CompanyCode AS CompanyCode,
  _Item.AccountingDocument AS AccountingDocument,
  _Item.FiscalYear AS FiscalYear,
  _Item.AccountingDocumentItem AS AccountingDocumentItem,
  concat('000',_Item.AccountingDocumentItem) AS DocumentItemNumber,
  _Item.TaxCode AS TaxCode,
  _Item.TaxItemGroup AS TaxItemGroup,
  _Item.AccountingDocumentType AS AccountingDocumentType,
  _Item.AccountingDocumentItemType AS AccountingDocumentItemType,
  _Item.ReferenceDocumentType AS ReferenceDocumentType,
  _Item.TransactionTypeDetermination AS TransactionTypeDetermination,
  _Item.PostingKey AS PostingKey,
  _Item.DebitCreditCode AS DebitCreditCode,
  _Item.GLAccount AS GLAccount,
  _Item.FinancialAccountType AS FinancialAccountType,
  _Item.FinancialAccountType AS AccountType,
  _Item.FiscalPeriod AS FiscalPeriod,
  _Item.ReportingDate AS ReportingDate,
  _Item.PostingDate AS PostingDate,
  _Item.DocumentDate AS DocumentDate,
  _Item.DocumentCurrency AS DocumentCurrency,
  _Item.CompanyCodeCurrency AS CompanyCodeCurrency,
  _Item.ReportingCurrency AS ReportingCurrency,
  _Item.DebitCreditCodeIsChanged AS DebitCreditCodeIsChanged,
  _Item.CountryCurrency AS CountryCurrency,
  _Item.AdditionalCurrency1 AS AdditionalCurrency1,
  _Item.AdditionalCurrency2 AS AdditionalCurrency2,
  _Item.Material AS Material,
  _Item.DocumentItemText AS DocumentItemText,
  _Item.QuantityInActlPostg AS QuantityInActlPostg,
  _Item.QuantityUnit AS QuantityUnit,
  _Item.TaxRate AS TaxRate,
  _Item.OriginalReferenceDocument AS OriginalReferenceDocument,
  _Item.BusinessArea AS BusinessArea,
  _Item.Supplier AS Supplier,
  _Item.Customer AS Customer,
  _Item.SupplierAccountGroup AS SupplierAccountGroup,
  _Item.ReportingCountry AS ReportingCountry,
  _Item.CompanyCodeCountry AS CompanyCodeCountry,
  _Item.TaxNumber1 AS TaxNumber1,
  _Item.TaxNumber2 AS TaxNumber2,
  _Item.TaxNumber3 AS TaxNumber3,
  _Item.BusinessPartnerName AS BusinessPartnerName,
  _Item.CustomerSupplierAddress AS CustomerSupplierAddress,
  _Item.ReverseDocument AS ReverseDocument,
  _Item.ReverseDocumentFiscalYear AS ReverseDocumentFiscalYear,
  _Item.InvoiceReference AS InvoiceReference,
  _Item.InvoiceReferenceFiscalYear AS InvoiceReferenceFiscalYear,
  TaxCalculationProcedure,
  TaxRateValidityStartDate,
  DocumentReferenceID
FROM P_AccountingVATReturnDocItem
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductDescription AS _ProductText ON Material = _ProductText.Product  -- association [0..*]
;