P_AdvncdPlngLocmapMdma

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 P_AdvncdPlngLocmapMdma.
-- 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: PAPLOCMDMA

CREATE VIEW P_AdvncdPlngLocmapMdma AS
SELECT
  /sapapo/locmap.locid AS locid,
  /sapapo/locmap.loctype AS loctype,
  marc.mandt AS mandt,
  /sapapo/locmap.locno AS locno,
  mdma.berid AS berid,
  marc.matnr AS matnr,
  marc.werks AS werks,
  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,
  mdma.scm_conhap AS scm_conhap,
  cast(case when mdma.scm_grprt = 0 or mdma.scm_grprt is null and marc.scm_grprt is not null then cast( marc.scm_grprt as /sapapo/grprt) else mdma.scm_grprt end as /sapapo/grprt) as scm_GRPRT AS scm_grprtendassapapogrprtasscm_GRPRT,
  cast(case when mdma.scm_giprt = 0 or mdma.scm_giprt is null and marc.scm_giprt is not null then cast( marc.scm_giprt as /sapapo/giprt) else mdma.scm_giprt end as /sapapo/giprt) as scm_GIPRT AS scm_giprtendassapapogiprtasscm_GIPRT,
  mdma.scm_heur_id AS scm_heur_id,
  mdma.scm_hunit AS scm_hunit,
  marc.scm_lsuom AS scm_lsuom,
  marc.scm_reldt AS scm_reldt,
  mdma.scm_rrp_type AS scm_rrp_type,
  marc.scm_scost AS scm_scost,
  marc.scm_sspen AS scm_sspen,
  marc.scm_stra1 AS scm_stra1,
  marc.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.maxdos_pen AS maxdos_pen,
  mdma.maxdos_flg AS maxdos_flg
FROM /sapapo/locmap
;