view_sdi_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_sdi_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_SDI_ITEMS_P

CREATE VIEW view_sdi_items_p AS
SELECT
  vbeln,
  posnr,
  waerk,
  kdgrp_auft,
  matnr,
  arktx,
  matkl,
  shkzg,
  werks,
  lgort,
  charg,
  mwsk1 AS mwskz,
  txjcd,
  kostl,
  prctr,
  vgtyp,
  vgbel,
  vgpos,
  aktnr,
  vrkme,
  meins,
  fkimg,
  umvkz,
  umvkn,
  fklmg,
  netwr,
  mat_group
FROM vbrp
LEFT OUTER JOIN t151 AS customer_group ON kdgrp_auft = customer_group.kdgrp  -- association [0..1]
LEFT OUTER JOIN t151t AS customer_group_texts ON kdgrp_auft = customer_group_texts.kdgrp  -- association [0..*]
LEFT OUTER JOIN t023 AS mat_group ON matkl = mat_group.matkl  -- association [0..1]
LEFT OUTER JOIN t023t AS mat_group_texts ON matkl = mat_group_texts.matkl  -- association [0..*]
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 vgtyp = triggering_doc_category_texts.domvalue_l AND triggering_doc_category_texts.domname = 'VBTYPL' AND triggering_doc_category_texts.as4local = 'A'  -- association [0..*]
;