ScmPrd_V_Mat2

DDL: SCMPRD_V_MAT2 SQL: SCMPRDVMAT2 Type: view
74 Fields 1 Data Sources

Product Scm redirect for V_MAT2

ScmPrd_V_Mat2 is a CDS View that provides data about "Product Scm redirect for V_MAT2" in SAP S/4HANA. It reads from 1 data source (ScmPrd_Matkey) and exposes 74 fields.

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matkey matkey from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName SCMPRDVMAT2 view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #AUTOMATED view
EndUserText.label Product Scm redirect for V_MAT2 view

Fields (74)

KeyFieldSource TableSource FieldDescription
LOCID matloc LOCID Single-Character Flag
MATID matloc MATID Product ID
MATNR MATNR Vehicle Model
MEINS MEINS Valuation Unit
DISST DISST Low-Level Code
BRGEW BRGEW Weight
GEWEI GEWEI Weight Unit
VOLUM VOLUM Volume
VOLEH VOLEH Volume Unit
KOSCH ScmPrd_Matkey KOSCH Prod.allocation
COMPL COMPL This field is no longer used
LVORM ScmPrd_Matkey LVORM Stock del. flag
KOSCH_GRP ScmPrd_Matkey KOSCH_GRP Procedure Seq.
MATKL MATKL Product Sold Group
LIKEID LIKEID
PHIN_FROM PHIN_FROM
PHIN_TO PHIN_TO
PHIN_TSID PHIN_TSID
PHOUT_FROM PHOUT_FROM
PHOUT_TO PHOUT_TO
PHOUT_TSID PHOUT_TSID
FLAGCLASS FLAGCLASS Classified
DIUOM DIUOM
PLANNER_PPS PLANNER_PPS
PLANNER_SNP PLANNER_SNP SNP Planner
PLANNER_DEMAND PLANNER_DEMAND
PLANNER_TRANS PLANNER_TRANS
MANOT MANOT
MTVFP MTVFP Avail. check
ATP_CHMOD ATP_CHMOD
WHATBOM WHATBOM Plan Explosion
DIBER DIBER MRP area exists
CONHAP CONHAP GR Handlg Cap. Cons.
HUNIT HUNIT UoM:HandlCap GR
CONINP CONINP Stor. Consumptn
IUNIT IUNIT Unit of Meas.
KDMATID KDMATID
CHKHOR CHKHOR
CHKHORCAL CHKHORCAL
LSZID LSZID Internal ID:Lot size/days'supply profile in material master
DPRID DPRID Ret. Income Res.
SPRID SPRID Supply Profile
DPLID DPLID Deploymt Profle
MATSTORE MATSTORE Mat. StLoc resource
GRPRT GRPRT GR Processng Time
GIPRT GIPRT GI Processng Time
SAFTY SAFTY Safety stock
STOCK_UID STOCK_UID UUID 22 char.
SW_SCZPRF SW_SCZPRF TSL Calculation
PLIFZ PLIFZ Plnd Deliv.Time
RQMID RQMID Internal Number for Requirement Profile in Product Master
LGRAD matloc LGRAD Target Service Level
RRP_TYPE RRP_TYPE PP Plng Proced.
EKGRP EKGRP Sub. purchasing grp
BESKZ BESKZ Procuremt Type
PRIO PRIO Profile priority
loctype loctype Location Type
locno locno Location
tzone tzone Time Zone Difference
xpos xpos Longitude
ypos ypos Latitude
handl handl GUID
store store Plant
ppcal ppcal Production Cal.
sdcal sdcal Shipping Cal.
stcal stcal Warehouse Cal.
locprio locprio Priority
STFAC STFAC Stacking Factor
ATT01 ATT01 Free Attribute 1
ATT02 ATT02 Free Attribute 2
ATT03 ATT03 Free Attribute 3
ATT04 ATT04 Free Attribute
ATT05 ATT05 Free Attribute
VEGRP VEGRP Cust.'s Pur. Grp

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_Mat2.
-- 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: SCMPRDVMAT2

CREATE VIEW ScmPrd_V_Mat2 AS
SELECT
  matloc.LOCID AS LOCID,
  matloc.MATID AS MATID,
  MATNR,
  MEINS,
  DISST,
  BRGEW,
  GEWEI,
  VOLUM,
  VOLEH,
  matkey.KOSCH AS KOSCH,
  COMPL,
  matkey.LVORM AS LVORM,
  matkey.KOSCH_GRP AS KOSCH_GRP,
  MATKL,
  LIKEID,
  PHIN_FROM,
  PHIN_TO,
  PHIN_TSID,
  PHOUT_FROM,
  PHOUT_TO,
  PHOUT_TSID,
  FLAGCLASS,
  DIUOM,
  PLANNER_PPS,
  PLANNER_SNP,
  PLANNER_DEMAND,
  PLANNER_TRANS,
  MANOT,
  MTVFP,
  ATP_CHMOD,
  WHATBOM,
  DIBER,
  CONHAP,
  HUNIT,
  CONINP,
  IUNIT,
  KDMATID,
  CHKHOR,
  CHKHORCAL,
  LSZID,
  DPRID,
  SPRID,
  DPLID,
  MATSTORE,
  GRPRT,
  GIPRT,
  SAFTY,
  STOCK_UID,
  SW_SCZPRF,
  PLIFZ,
  RQMID,
  matloc.LGRAD AS LGRAD,
  RRP_TYPE,
  EKGRP,
  BESKZ,
  PRIO,
  loctype,
  locno,
  tzone,
  xpos,
  ypos,
  handl,
  store,
  ppcal,
  sdcal,
  stcal,
  locprio,
  STFAC,
  ATT01,
  ATT02,
  ATT03,
  ATT04,
  ATT05,
  VEGRP
FROM ScmPrd_Matkey AS matkey
;

Learn More