ScmPrd_V_Matloc

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_V_Matloc.
-- 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: SCMPRDVMATLOC

CREATE VIEW ScmPrd_V_Matloc AS
SELECT
  matkey.MATNR AS MATNR,
  locno,
  matloc.MATID AS MATID,
  matloc.LOCID AS LOCID,
  loctype,
  PLANNER_PPS,
  PLANNER_SNP,
  PLANNER_DEMAND,
  PLANNER_TRANS,
  EKGRP,
  PRIO,
  VEGRP,
  MATLOCID,
  BESKZ,
  matloc.KZKFG AS KZKFG,
  matloc.LVORM AS LVORM,
  DIUOM,
  MTVFP,
  ATP_CHMOD,
  CHKHOR,
  CHKHORCAL,
  RCRRCPHOR,
  matloc.KOSCH AS KOSCH,
  matloc.KOSCH_GRP AS KOSCH_GRP,
  matloc.CUOBJ AS CUOBJ,
  matloc.SATID AS SATID,
  GRPRT,
  GIPRT,
  PLIFZ,
  matloc.LGRAD AS LGRAD,
  SCOST,
  LSZID,
  DPRID,
  SPRID,
  DPLID,
  MATSTORE,
  SAFTY,
  STOCK_UID,
  SW_SCZPRF,
  RQMID,
  RRP_TYPE,
  ERHOR,
  FREIZ,
  FIXHZ,
  HEUR_ID,
  PACKAGE_ID,
  PART_OF_PACKAGE,
  WHATBOM,
  EXPLDATE_FINDER,
  CONVH,
  CTHOR,
  ND_STORDU,
  ND_MEANPROD_WEEK,
  NDCOSTWE,
  NDCOSTWA,
  DTQID,
  PROC_COST,
  PROD_COST,
  SSPEN,
  MSDP_SB_METHOD,
  FIXTI,
  COSID,
  SCOST_PER_DAY,
  REORD,
  MAXSTOCK,
  GET_ALERTS,
  CONHAP,
  HUNIT,
  CONINP,
  IUNIT,
  KDMATID,
  CONHAP_OUT,
  HUNIT_OUT,
  LADGR,
  CONF_PROPAGATION,
  CONF_COMPONENTS,
  CONF_DURATION,
  CONF_GMSYNC,
  PROFID,
  MANOT,
  DIBER,
  SUBLOCID,
  AT101,
  AT102,
  AT103,
  AT104,
  AT105,
  matloc.CREATEUSER AS CREATEUSER,
  matloc.CREATEUTC AS CREATEUTC,
  matloc.CHANGEUSER AS CHANGEUSER,
  matloc.CHANGEUTC AS CHANGEUTC,
  AJHOZ,
  PACKAGE_TYPE,
  SELHORZ,
  EARLYSHIP,
  RRP_SEL_GROUP,
  SHELF_LIFE_LOC,
  matloc.SHELF_LIFE_DUR AS SHELF_LIFE_DUR,
  matloc.MATURITY_DUR AS MATURITY_DUR,
  matloc.SHLF_LFE_REQ_MIN AS SHLF_LFE_REQ_MIN,
  matloc.SHLF_LFE_REQ_MAX AS SHLF_LFE_REQ_MAX,
  matloc.VMIKOSCH AS VMIKOSCH,
  matloc.VMIKOSCH_GRP AS VMIKOSCH_GRP,
  PLANNER_PUR,
  FRTME,
  FEDEM,
  FERLD,
  PIPRT,
  TLPRT,
  SNPCHKHOR,
  COSTPROF,
  PLANNER_VMI,
  PLANNER_SMI,
  PRO_ORD,
  PRO_LTP,
  OS_LIMIT,
  DEADPILE,
  SHIPPING,
  ARRIVAL,
  ACT_STATUS,
  HUGRP,
  MAXCOVER,
  MAXCOVERUP,
  MIXTP,
  USETP,
  PSSFLAG,
  SAFTYC_MAX,
  SAFTYC_MIN,
  RELDT,
  matloc.ATDSP AS ATDSP,
  matloc.ATDDM AS ATDDM,
  MAABC,
  TDFIELDS
FROM ScmPrd_Matloc AS matloc
;