ScmPrd_Locmap_Mdma

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 ScmPrd_Locmap_Mdma.
-- 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: SCMPRDLOMAPMDMA

CREATE VIEW ScmPrd_Locmap_Mdma AS
SELECT
  /sapapo/matplsta.matid AS matid,
  /sapapo/matplsta.locid AS locid,
  /sapapo/locmap.loctype AS loctype,
  /sapapo/matplsta.matnr AS matnr,
  mdma.werks AS werks,
  /sapapo/locmap.locno AS locno,
  mdma.berid AS berid,
  marc.fhori AS fhori,
  mdma.disgr AS disgr,
  marc.strgr AS strgr,
  marc.wzeit AS wzeit,
  marc.dzeit AS dzeit,
  marc.bearz AS bearz,
  marc.ruezt AS ruezt,
  marc.tranz AS tranz,
  case when /sapapo/matplsta.plstat = '9' then 'X' else '' end as lvorm AS plstat9thenXelseendaslvorm,
  marc.mtvfp AS mtvfp,
  marc.cuobj AS cuobj,
  marc.webaz AS webaz,
  mdma.lgrad AS lgrad,
  mdma.eisbe AS eisbe,
  mdma.fxhor AS fxhor,
  mdma.minbe AS minbe,
  mdma.mabst AS mabst,
  mdma.dispo AS dispo,
  marc.ekgrp AS ekgrp,
  marc.ladgr AS ladgr,
  marc.frtme AS frtme,
  marc.maabc AS maabc,
  marc.diber AS diber,
  marc.bwscl AS bwscl,
  mdma.bstfe AS bstfe,
  mdma.bstmi AS bstmi,
  mdma.bstma AS bstma,
  mdma.bstrf AS bstrf,
  mdma.ausss AS ausss,
  mdma.rdprf AS rdprf,
  mdma.shzet AS shzet,
  mdma.disls AS disls,
  marc.vrmod AS vrmod,
  marc.vint1 AS vint1,
  marc.vint2 AS vint2,
  marc.sbdkz AS sbdkz,
  marc.miskz AS miskz,
  marc.uneto AS uneto,
  marc.ueeto AS ueeto,
  marc.stdpd AS stdpd,
  mdfddb.mfxdt AS mfxdt,
  mdfddb.mfxti AS mfxti,
  marc.scm_conhap AS scm_conhap,
  marc.scm_heur_id AS scm_heur_id,
  marc.scm_hunit AS scm_hunit,
  marc.scm_lsuom AS scm_lsuom,
  marc.scm_reldt AS scm_reldt,
  marc.scm_rrp_type AS scm_rrp_type,
  marc.scm_stra1 AS scm_stra1,
  mdma.scm_tstrid AS scm_tstrid,
  marc.scm_whatbom AS scm_whatbom,
  mdma.shflg AS shflg,
  mdma.loekz AS loekz,
  marc.scm_prio AS scm_prio,
  marc.scm_profid AS scm_profid,
  mdma.scm_tpop AS scm_tpop,
  mdma.scm_safty_v AS scm_safty_v,
  mdma.scm_repsafty AS scm_repsafty,
  mdma.scm_reord_v AS scm_reord_v,
  mdma.scm_ndcostwe AS scm_ndcostwe,
  mdma.scm_ndcostwa AS scm_ndcostwa,
  mdma.scm_coninp AS scm_coninp,
  mdma.scm_iunit AS scm_iunit,
  marc.scm_sft_lock AS scm_sft_lock,
  mdma.convh AS convh
FROM /sapapo/matplsta
LEFT OUTER JOIN mdfddb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t460a ON /* join condition not captured in parsed metadata */
;