P_PL_SAFTSalesInvItem

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_PL_SAFTSalesInvItem.
-- 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: PPLSAFTSLSINVITM
-- Parameters: P_StartDate : datum, P_EndDate : datum

CREATE VIEW P_PL_SAFTSalesInvItem AS
SELECT
  Entry.CompanyCode AS CompanyCode,
  Entry.AccountingDocument AS AccountingDocument,
  Entry.FiscalYear AS FiscalYear,
  Item.BillingDocument AS BillingDocument,
  Item.BillingDocumentItem AS BillingDocumentItem,
  Header.PL_SAFTInvoiceType AS PL_SAFTInvoiceType,
  Header.CancelledBillingDocument AS CancelledBillingDocument,
  Item.BillingDocumentItemText AS BillingDocumentItemText,
  Item.BillingQuantityUnit AS BillingQuantityUnit,
  Item.BillingQuantity AS BillingQuantity,
  cast( case when Item.BillingQuantity is not initial then division(Item.NetAmount,Item.BillingQuantity,2) else Item._SalesDocumentItem.NetPriceAmount end as netpr) as NetPriceAmount AS NetPriceAmountendasnetprasNetPriceAmount,
  Entry.CompanyCodeCurrency AS CompanyCodeCurrency,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.NetAmount AS NetAmount,
  Item.NetAmount + Item.TaxAmount AS GrossAmount,
  case when Header.BillingDocumentType = 'G2DP' and Header.PL_SAFTInvoiceType = 'KOREKTA' then 0 else Item.Subtotal1Amount - Item.NetAmount end as DiscountAmount AS NetAmountendasDiscountAmount,
  Item._PricingElement[ (ConditionApplication = 'V' or ConditionApplication = 'TX') and ConditionClass = 'D' and ConditionCategory = 'D' and ConditionInactiveReason = '' and ConditionIsForStatistics = '' ].TaxCode AS TaxCode,
  Tax.PL_SAFTTaxPercentageCode AS PL_SAFTTaxPercentageCode
INNER JOIN I_BillingDocumentItem AS Item ON /* join condition not captured in parsed metadata */
INNER JOIN P_PL_SAFTBillingDocumentBasic AS Header ON /* join condition not captured in parsed metadata */
INNER JOIN P_PL_SAFTInvoiceTax AS Tax ON /* join condition not captured in parsed metadata */
;