view_gr_items_p

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 view_gr_items_p.
-- 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: CDS_GR_ITEMS_P

CREATE VIEW view_gr_items_p AS
SELECT
  mblnr,
  mjahr,
  zeile,
  lifnr,
  kunnr,
  bukrs,
  smbln,
  sjahr,
  matnr,
  ebeln,
  ebelp,
  shkzg,
  werks,
  lgort,
  charg,
  mwskz,
  txjcd,
  kostl,
  prctr,
  aktnr,
  erfme,
  meins,
  waers,
  erfmg,
  menge,
  dmbtr,
  vendor_name
FROM nsdm_e_mseg
LEFT OUTER JOIN view_PO_items_p AS purchase_order_item ON ebeln = purchase_order_item.ebeln AND ebelp = purchase_order_item.ebelp  -- association [0..1]
LEFT OUTER JOIN dd07t AS itemcat_texts ON itemcat_texts.domname = 'WB2_WSHKZG_BUSVOL' AND itemcat_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN dd07t AS triggering_doc_category_texts ON triggering_doc_category_texts.domname = 'WFTYP_V' AND triggering_doc_category_texts.domvalue_l = '17' AND triggering_doc_category_texts.as4local = 'A'  -- association [0..*]
LEFT OUTER JOIN view_lfa1_name_p AS vendor_name ON lifnr = vendor_name.vendor_account  -- association [0..1]
LEFT OUTER JOIN view_Kna1_name_p AS customer_name ON kunnr = customer_name.customer_account  -- association [0..1]
;