P_SuplrInvcItm

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_SuplrInvcItm.
-- 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: PPURGDOCITMINV

CREATE VIEW P_SuplrInvcItm AS
SELECT
  Item.SupplierInvoice AS SupplierInvoice,
  SupplierInvoiceItem,
  Item.FiscalYear AS FiscalYear,
  _SuppInvcAcctAssgmt.OrdinalNumber AS OrdinalNumber,
  cast (concat(concat(concat(concat(Item.SupplierInvoice, '/'), SupplierInvoiceItem),'/'), Item.FiscalYear) as abap.char(22) ) AS SupplierInvoiceWithItem,
  SupplierInvoiceItemText AS MaterialDocumentItemText,
  PurchaseOrderItemMaterial AS Material,
  PurchaseOrder,
  cast (concat(concat(PurchaseOrder, '/'), PurchaseOrderItem) as vdm_formattedpurchaseorditm) AS FormattedPurchaseOrderItem,
  '' AS PurchaseOrderHistIsDisplayed,
  case when DebitCreditCode is not null and DebitCreditCode = 'H' then -_SuppInvcAcctAssgmt.Quantity else _SuppInvcAcctAssgmt.Quantity end as Quantity AS QuantityendasQuantity,
  cast('3' as numc1) AS ObjectType,
  _SuppInvcAcctAssgmt.CostCenter AS CostCenter,
  _SuppInvcAcctAssgmt.ControllingArea AS ControllingArea,
  _SuppInvcAcctAssgmt.SalesOrder AS SalesOrder,
  case when _SuppInvcAcctAssgmt.SalesOrderItem is null or _SuppInvcAcctAssgmt.SalesOrderItem = '000000' then '' else concat(concat(_SuppInvcAcctAssgmt.SalesOrder, '/'),_SuppInvcAcctAssgmt.SalesOrderItem) end as SalesOrderItem AS SalesOrderItemendasSalesOrderItem,
  SupplierInvoice.CompanyCode AS CompanyCode,
  DebitCreditCode,
  SupplierInvoice.InvoicingParty AS InvoicingParty,
  TaxCode,
  TaxJurisdiction,
  _SuppInvcAcctAssgmt.WBSElementExternalID AS WBSElementExternalID,
  PurchaseOrderQuantityUnit,
  SupplierInvoice.DocumentCurrency AS DocumentCurrency,
  SupplierInvoice._CompanyCode.Currency AS CompanyCodeCurrency,
  '' AS ServicePerformer,
  '' AS WorkItem,
  '' AS SupplyingPlant,
  '' AS AccountAssignmentCategory,
  '_' AS PurchasingDocumentItemCategory,
  cast ('00000000' as mm_a_delivery_date) AS DeliveryDate,
  Item.SupplierInvoice AS PurchasingDocument,
  PurchaseOrderItem,
  SupplierInvoice._CompanyCode AS _CompanyCode,
  SupplierInvoice.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked
FROM P_ITEM_ONLINE AS Item
INNER JOIN I_SupplierInvoice AS SupplierInvoice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_SuplrInvcItmAcctAssgmt AS _SuppInvcAcctAssgmt ON SupplierInvoice = _SuppInvcAcctAssgmt.SupplierInvoice AND FiscalYear = _SuppInvcAcctAssgmt.FiscalYear AND SupplierInvoiceItem = _SuppInvcAcctAssgmt.SupplierInvoiceItem  -- association [0..*]
;