I_RO_SAFTSalesInvoiceLineItem

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_RO_SAFTSalesInvoiceLineItem.
-- 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.

CREATE VIEW I_RO_SAFTSalesInvoiceLineItem AS
SELECT
  _InvoiceLineItem.AccountingDocument AS AccountingDocument,
  _InvoiceLineItem.CompanyCode AS CompanyCode,
  _InvoiceLineItem.FiscalYear AS FiscalYear,
  _InvoiceLineItem.AccountingDocumentItem AS AccountingDocumentItem,
  _InvoiceLineItem.AccountingDocumentItemRef AS AccountingDocumentItemRef,
  _InvoiceLineItem.TargetGLAccount AS TargetGLAccount,
  _InvoiceLineItem.SalesOrder AS SalesOrder,
  _Analysis.RO_SAFTAnalysisType AS RO_SAFTAnalysisType,
  _Analysis.CostCenter AS CostCenter,
  _OrderReference.SalesDocumentDate AS SalesOrderDate,
  _OrderReference.SalesDocument AS OriginSDDocument,
  _InvoiceLineItem.Product AS Product,
  _description.ProductName AS ProductDescription,
  _InvoiceLineItem.Quantity AS Quantity,
  _InvoiceLineItem.BaseUnit AS BaseUnit,
  _Uom.SourceUnitOfMeasureFactor AS SourceUnitOfMeasureFactor,
  _ProductUom.AlternativeUnit AS AlternativeUnit,
  _ProductUom.QuantityNumerator AS QuantityNumerator,
  _ProductUom.QuantityDenominator AS QuantityDenominator,
  _InvoiceLineAmt.TransactionAmountInLocalCrcy AS TotalAmountInLocalCurrency,
  _InvoiceLineAmt.TransactionCurrency AS TransactionCurrency,
  _InvoiceLineAmt.InvoiceAmountInInvoiceDocCrcy AS TotalAmountInSourceCurrency,
  cast(round(_InvoiceLineAmt.ExchangeRate, 4) as saft_ro_exchange_rate) AS ExchangeRate,
  _InvoiceLineItem.DebitCreditCode AS DebitCreditCode,
  _InvoiceLineItem.ProductPriceUnitQuantity AS ProductPriceUnitQuantity,
  _TaxInfo.RO_SAFTTaxType AS RO_SAFTTaxType,
  _TaxInfo.RO_SAFTTaxCode AS RO_SAFTTaxCode,
  _TaxInfo.TaxRateInPercent AS TaxRateInPercent,
  _TaxInfo.TaxRate AS TaxRate,
  _TaxInfo.RO_SAFTTaxBaseDescription AS RO_SAFTTaxBaseDescription,
  _TaxInfo.TotalVATAmtInCoCodeCrcy AS TotalTaxAmount,
  _TaxInfo.TransactionCurrency AS SDTransactionCurrency,
  _TaxInfo.TaxAmountInDocCry AS TaxAmountInDocCry,
  cast(round(_TaxInfo.ExchangeRate, 4) as saft_ro_exchange_rate) AS TaxExchangeRate,
  _TaxInfo.TaxExemptCode AS TaxExemptCode,
  _TaxInfo.GenerationYear AS GenerationYear
LEFT OUTER JOIN I_ProductText AS _description ON Product = _description.Product AND _description.Language = '4'  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTUnitOfMeasureMap AS _Uom ON BaseUnit = _Uom.SourceUnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_ProductUnitsOfMeasure AS _ProductUom ON Product = _ProductUom.Product  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTSalesInvcAnalysisType AS _Analysis ON CompanyCode = _Analysis.CompanyCode AND _InvoiceLineItem.CostCenter = _Analysis.CostCenter  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentBasic AS _OrderReference ON _InvoiceLineItem.SalesOrder = _OrderReference.SalesDocument  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTPurInvoiceItemAmount AS _InvoiceLineAmt ON _InvoiceLineItem.CompanyCode = _InvoiceLineAmt.CompanyCode AND _InvoiceLineItem.AccountingDocument = _InvoiceLineAmt.AccountingDocument AND _InvoiceLineItem.FiscalYear = _InvoiceLineAmt.FiscalYear AND _InvoiceLineItem.AccountingDocumentItem = _InvoiceLineAmt.AccountingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_RO_SAFTPurInvoiceTaxInfo AS _TaxInfo ON _InvoiceLineItem.CompanyCode = _TaxInfo.CompanyCode AND _InvoiceLineItem.AccountingDocument = _TaxInfo.AccountingDocument AND _InvoiceLineItem.FiscalYear = _TaxInfo.FiscalYear AND _InvoiceLineItem.AccountingDocumentItem = _TaxInfo.AccountingDocumentItem  -- association [0..1]
;