I_PT_SAFTInvoiceListItem

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_PT_SAFTInvoiceListItem.
-- 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: IPTSAFTLITEM

CREATE VIEW I_PT_SAFTInvoiceListItem AS
SELECT
  p.PortugueseInvoiceNumber AS PortugueseInvoiceNumber,
  cast(concat( a.BillingDocument, a.BillingDocumentItem) as abap.char(18)) AS FormattedDocumentKey,
  b.PortugueseInvoiceDate AS PortugueseInvoiceDate,
  cast(a.Material as matnr ) AS Material,
  a.Quantity AS Quantity,
  a.UnitOfMeasure AS UnitOfMeasure,
  case a.BillingDocumentItem when RoundDiff.BillingDocumentItem2Updt then case when t.ConditionAmount is not initial and t.ConditionAmount is not null then division(abs(a.NetAmount - abs(t.ConditionAmount) + Discount.FinalAmount + RoundDiff.RoundDifference),a.Quantity,2) when PrcgCndnItem.ConditionAmount is not initial and PrcgCndnItem.ConditionAmount is not null then division(abs(a.NetAmount - abs(PrcgCndnItem.ConditionAmount) + Discount.FinalAmount + RoundDiff.RoundDifference),a.Quantity,2) else abs(a.NetAmount + Discount.FinalAmount + RoundDiff.RoundDifference) end else case when t.ConditionAmount is not initial and t.ConditionAmount is not null then division(abs(a.NetAmount - abs(t.ConditionAmount) + Discount.FinalAmount),a.Quantity,2) when PrcgCndnItem.ConditionAmount is not initial and PrcgCndnItem.ConditionAmount is not null then division(abs(a.NetAmount - abs(PrcgCndnItem.ConditionAmount) + Discount.FinalAmount),a.Quantity,2) else division(abs(a.NetAmount + Discount.FinalAmount),a.Quantity,2) end end as NetPriceAmount AS Quantity2endendasNetPriceAmount,
  case a.BillingDocumentItem when RoundDiff.BillingDocumentItem2Updt then division(abs(a.NetAmount + Discount.FinalAmount + RoundDiff.RoundDifference),a.Quantity,2) else division(abs(a.NetAmount + Discount.FinalAmount),a.Quantity,2) end as NetAmount AS Quantity2endasNetAmount,
  coalesce(a._LineDiscount.ConditionAmount,0) AS ConditionAmount,
  a.BillingDocumentItemText AS BillingDocumentItemText,
  a.ReferenceSDDocument AS ReferenceSDDocument,
  a.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  a.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  a.SalesDocument AS SalesDocument,
  a.SalesDocumentItem AS SalesDocumentItem,
  a.SDDocumentReason AS SDDocumentReason,
  a.BillingDocument AS BillingDocument,
  a.BillingDocumentItem AS BillingDocumentItem,
  h.CompanyCode AS CompanyCode,
  b.CompanyCodeCurrency AS CompanyCodeCurrency,
  h.TransactionCurrency AS TransactionCurrency,
  p.SDDocumentCategory AS SDDocumentCategory,
  h.AccountingExchangeRate AS ExchangeRate,
  a.ExchangeRateDate AS ExchangeRateDate,
  cast (case when w.WorkType is not initial then w.WorkType when h.SDDocumentCategory = 'U' then 'PF' else ' ' end as abap.char(5)) as WorkType AS char5asWorkType,
  coalesce(ItemTax.TaxCode,'') AS TaxCode,
  coalesce(ItemTax.ConditionRateValue, 0) AS ConditionRateValue,
  case when TaxData.TargetTaxCode is not null or TaxData.TargetTaxCode is not initial then TaxData.TargetTaxCode else _TaxNotConf.TargetTaxCode end as ControlNature AS TargetTaxCodeendasControlNature,
  case when TaxData.TaxAmount is not null or TaxData.TaxAmount is not initial then TaxData.TaxAmount else _TaxNotConf.TaxAmount end as TaxAmount AS TaxAmountendasTaxAmount,
  cast(case when TaxData.TaxType is not null or TaxData.TaxType is not initial then TaxData.TaxType else _TaxNotConf.TaxType end as abap.char(4)) as ActiveTaxType AS char4asActiveTaxType,
  case when TaxData.TaxReturnCountry is not null or TaxData.TaxReturnCountry is not initial then TaxData.TaxReturnCountry else _TaxNotConf.TaxReturnCountry end as CountryCreditRating AS TaxReturnCountryendasCountryCreditRating,
  case when TaxData.ExemptionReason is not null or TaxData.ExemptionReason is not initial then TaxData.ExemptionReason when TaxData.TaxCode is null then _TaxNotConf.ExemptionReason else '' end as ExemptionReason AS ExemptionReasonelseendasExemptionReason,
  a.BillingPlanRule AS BillingPlanRule,
  h._CompanyCode AS _CompanyCode,
  h._TransactionCurrency AS _TransactionCurrency,
  a._BillingDocument AS _BillingDocument
FROM I_SAFTBillingItem AS a
INNER JOIN I_SAFTBillingHeader AS h ON /* join condition not captured in parsed metadata */
INNER JOIN I_PT_BillgDocDgtlSgntr AS b ON /* join condition not captured in parsed metadata */
INNER JOIN P_PT_SAFT_BillDocOnInvoiceList AS p ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PT_SAFTBillingTax AS _TaxInfo ON PortugueseInvoiceNumber = _TaxInfo.PortugueseInvoiceNumber AND TaxCode = _TaxInfo.TaxCode  -- association [0..1]
LEFT OUTER JOIN I_PT_SAFTBillgDocMatlHist AS _MaterialHist ON BillingDocument = _MaterialHist.BillingDocument AND Material = _MaterialHist.Material  -- association [1..1]
LEFT OUTER JOIN I_PT_SAFTTaxNotConfigured AS _TaxNotConf ON _TaxNotConf.TaxCode = ''  -- association [0..*]
;