P_Prdscm_Locmap_Marc

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_Prdscm_Locmap_Marc.
-- 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: PRDSCMLOCMAPMARC

CREATE VIEW P_Prdscm_Locmap_Marc AS
SELECT
  /sapapo/matplsta.matid AS matid,
  /sapapo/matplsta.locid AS locid,
  /sapapo/locmap.loctype AS loctype,
  marc.matnr AS matnr,
  marc.werks AS werks,
  marc.fhori AS fhori,
  marc.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,
  marc.mtvfp AS mtvfp,
  marc.cuobj AS cuobj,
  marc.webaz AS webaz,
  marc.plifz AS plifz,
  marc.lgrad AS lgrad,
  marc.eisbe AS eisbe,
  marc.fxhor AS fxhor,
  marc.minbe AS minbe,
  marc.mabst AS mabst,
  marc.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,
  marc.bstfe AS bstfe,
  marc.bstmi AS bstmi,
  marc.bstma AS bstma,
  marc.bstrf AS bstrf,
  marc.ausss AS ausss,
  marc.rdprf AS rdprf,
  marc.shzet AS shzet,
  marc.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,
  mdfd.mfxdt AS mfxdt,
  mdfd.mfxti AS mfxti,
  marc.stdpd AS stdpd,
  marc.scm_conhap AS scm_conhap,
  marc.scm_giprt AS scm_giprt,
  marc.scm_grprt AS scm_grprt,
  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_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,
  marc.shflg AS shflg,
  marc.scm_prio AS scm_prio,
  marc.scm_profid AS scm_profid,
  marc.scm_tpop AS scm_tpop,
  marc.scm_safty_v AS scm_safty_v,
  marc.scm_repsafty AS scm_repsafty,
  marc.scm_reord_v AS scm_reord_v,
  marc.scm_ndcostwe AS scm_ndcostwe,
  marc.scm_ndcostwa AS scm_ndcostwa,
  marc.scm_coninp AS scm_coninp,
  marc.scm_iunit AS scm_iunit,
  marc.scm_sft_lock AS scm_sft_lock,
  marc_aps_ext.maxdos_pen AS maxdos_pen,
  marc_aps_ext.maxdos_flg AS maxdos_flg,
  marc_aps_ext.convh AS convh,
  marc.sgt_covs AS sgt_covs
FROM /sapapo/matplsta
LEFT OUTER JOIN mdfd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN marc_aps_ext ON /* join condition not captured in parsed metadata */
;