sepm_sddl_purchaseorder_item

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 sepm_sddl_purchaseorder_item.
-- 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: SEPM_SDDL_V_POI

CREATE VIEW sepm_sddl_purchaseorder_item AS
SELECT
  node_key AS item_key,
  product_guid AS product_key,
  note_guid AS note_key,
  gross_amount,
  net_amount,
  tax_amount,
  note_texts,
  product,
  currency
FROM snwd_po_i
LEFT OUTER JOIN sepm_sddl_purchaseorder_itemsl AS schedule_line ON item_key = schedule_line.purchase_order_item_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_text_original_langu AS original_note_language ON note_key = original_note_language.text_original_language_key  -- association [0..1]
LEFT OUTER JOIN sepm_sddl_text_data AS note_texts ON note_key = note_texts.original_lanuage_key  -- association [0..*]
LEFT OUTER JOIN sepm_sddl_product AS product ON product_key = product.product_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_purchaseorder_header AS purchase_order ON purchase_order_key = purchase_order.purchase_order_key  -- association [1]
LEFT OUTER JOIN sepm_sddl_goods_receipt_item AS goods_receipt_item ON item_key = goods_receipt_item.item_key  -- association [0..1]
LEFT OUTER JOIN sepm_sddl_goods_receipt_item AS purchase_invoice_item ON item_key = purchase_invoice_item.item_key  -- association [0..1]
LEFT OUTER JOIN tcurc AS currency ON currency_code = waers  -- association [1]
;