m_v_m2s_pd_itm

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 m_v_m2s_pd_itm.
-- 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_M_M2S_PD_ITM

CREATE VIEW m_v_m2s_pd_itm AS
SELECT
  ekpo.ebelp AS ebelp,
  ekpo.matnr AS matnr,
  ekpo.matkl AS matkl,
  ekpo.werks AS werks,
  ekpo.lmein AS lmein,
  ekpo.lgort AS lgort,
  ekpo.bukrs AS bukrs,
  ekpo.meins AS meins,
  ekpo.bprme AS bprme,
  ekpo.knttp AS knttp,
  ekpo.loekz AS loekz_i,
  ekpo.banfn AS banfn,
  ekpo.bnfpo AS bnfpo,
  ekpo.ematn AS ematn,
  ekpo.menge AS menge,
  ekpo.peinh AS peinh,
  ekpo.netpr AS netpr,
  ekpo.netwr AS netwr,
  ekpo.ktmng AS ktmng,
  ekpo.zwert AS zwert,
  ekpo.statu AS statu,
  ekpo.pstyp AS pstyp,
  ekpo.stapo AS stapo,
  ekpo.retpo AS retpo,
  ekpo.umren AS umren,
  ekpo.umrez AS umrez,
  ekpo.elikz AS elikz,
  ekpo.erekz AS erekz,
  ekpo.wepos AS wepos,
  ekpo.webre AS webre,
  ekpo.repos AS repos,
  _PurchasingDocument.bstyp AS bstyp,
  _PurchasingDocument.bsart AS bsart,
  _PurchasingDocument.aedat AS aedat,
  _PurchasingDocument.ernam AS ernam,
  _PurchasingDocument.lifnr AS lifnr,
  _PurchasingDocument.zterm AS zterm,
  _PurchasingDocument.ekorg AS ekorg,
  _PurchasingDocument.ekgrp AS ekgrp,
  _PurchasingDocument.waers AS waers,
  _PurchasingDocument.bedat AS bedat,
  _PurchasingDocument.kdatb AS kdatb,
  _PurchasingDocument.kdate AS kdate,
  _PurchasingDocument.kufix AS kufix,
  _PurchasingDocument.konnr AS konnr,
  _PurchasingDocument.reswk AS reswk,
  _PurchasingDocument.loekz AS loekz_h,
  _PurchasingDocument.angdt AS angdt,
  _PurchasingDocument.submi AS submi,
  _PurchasingDocument.ktwrt AS ktwrt,
  _PurchasingDocument.description AS description,
  _PurchasingDocument.iseopblocked AS iseopblocked,
  lfa1.sortl AS sortl,
  t024.eknam AS eknam,
  t024e.ekotx AS ekotx,
  t001.butxt AS butxt,
  t001w.name1 AS name1_p,
  t001w_sp.name1 AS name1_sp,
  adrp.name_text AS name_text,
  pdi_calc.wemng AS wemng,
  pdi_calc.wewrt AS wewrt,
  pdi_calc.remng AS remng,
  pdi_calc.rewrt AS rewrt,
  pdi_calc.qtymismatch AS qtymismatch,
  pdi_calc.confmiss AS confmiss,
  pdi_calc.wesbs AS wesbs,
  cast('' as abap.char(20)) AS wgbez,
  cast('' as abap.char(20)) AS batxt,
  cast('' as abap.char(40)) AS statustext,
  cast(0 as abap.int4) AS cntf,
  cast(0 as abap.int4) AS cntk,
  cast(0 as abap.int4) AS cntl,
  cast(0 as abap.curr(19,2)) AS releasevalue
FROM ekpo
INNER JOIN ekko AS _PurchasingDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t024e ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t024 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t001w AS t001w_sp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN usr21 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN m_v_m2s_pd_i_c AS pdi_calc ON /* join condition not captured in parsed metadata */
;