C_StRpVATReturnDocLineItem

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

CREATE VIEW C_StRpVATReturnDocLineItem AS
SELECT
  StatryRptgEntity,
  StatryRptCategory,
  StatryRptRunID,
  CompanyCode,
  FiscalYear,
  AccountingDocument,
  AccountingDocumentItem,
  DocumentItemNumber,
  cast('' as re_belnr) AS SupplierInvoice,
  cast('000000' as rblgp) AS SupplierInvoiceItem,
  cast('' as re_belnr) AS BillingDocument,
  cast('000000' as posnr_vf) AS BillingDocumentItem,
  TaxCode,
  TaxItemGroup,
  AccountingDocumentType,
  AccountingDocumentItemType,
  ReferenceDocumentType,
  TransactionTypeDetermination,
  PostingKey,
  DebitCreditCode,
  GLAccount,
  FinancialAccountType,
  AccountType,
  FiscalPeriod,
  ReportingDate,
  PostingDate,
  DocumentDate,
  DocumentCurrency,
  CompanyCodeCurrency,
  ReportingCurrency,
  DebitCreditCodeIsChanged,
  CountryCurrency,
  AdditionalCurrency1,
  AdditionalCurrency2,
  Material,
  DocumentItemText,
  QuantityInActlPostg,
  QuantityUnit,
  TaxRate,
  OriginalReferenceDocument,
  BusinessArea,
  Supplier,
  Customer,
  SupplierAccountGroup,
  ReportingCountry,
  CompanyCodeCountry,
  TaxNumber1,
  TaxNumber2,
  TaxNumber3,
  BusinessPartnerName,
  CustomerSupplierAddress,
  ReverseDocument,
  ReverseDocumentFiscalYear,
  InvoiceReference,
  InvoiceReferenceFiscalYear,
  ReferenceDocumentNumber,
  ReferenceDocumentFiscalYear,
  DistributedTaxAmountInCCrcy,
  DistrdTaxBaseAmountInCCrcy,
  DistributedTaxAmountInTC,
  DistrdTaxBaseAmountInTransCrcy,
  DistributedTaxAmtInCountryCrcy,
  DistrdTaxBaseAmountInCntryCrcy,
  DistrdTaxAmountInAddlCrcy1,
  DistrdTaxBaseAmountInAddlCrcy1,
  DistrdTaxAmountInAddlCrcy2,
  DistrdTaxBaseAmountInAddlCrcy2,
  cast( 0 as vfprc_element_value ) AS CashDiscountAmount,
  TaxCalculationProcedure,
  TaxRateValidityStartDate,
  DocumentReferenceID AS P_StatryRptgEntity,
  P_StatryRptCategory : $parameters.P_StatryRptCategory AS P_StatryRptCategory,
  cast ( CashDiscountBaseAmount as figlo_dbase_ccrcy ) AS CashDiscountBaseAmount,
  DocumentReferenceID
FROM C_AccountingVATReturnDocItem
-- UNION ALL with additional select branch(es): C_SupplierInvcVATReturnDocItem, C_BillingVATReturnDocItem
;