ScmPrd_V_Mat5

DDL: SCMPRD_V_MAT5 SQL: SCMPRDVMAT5 Type: view
40 Fields 1 Data Sources

Product Scm redirect for V_MAT5

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

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matkey matkey from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName SCMPRDVMAT5 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_MAT5 view

Fields (40)

KeyFieldSource TableSource FieldDescription
MATNR MATNR Vehicle Model
MEINS MEINS Valuation Unit
DISST ScmPrd_Matkey 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 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
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
matid matmod matid Product ID
locid matmod locid Single-Character Flag
model model Vehicle Model
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

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_Mat5.
-- 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: SCMPRDVMAT5

CREATE VIEW ScmPrd_V_Mat5 AS
SELECT
  MATNR,
  MEINS,
  matkey.DISST AS DISST,
  BRGEW,
  GEWEI,
  VOLUM,
  VOLEH,
  matkey.KOSCH AS KOSCH,
  COMPL,
  matkey.LVORM AS LVORM,
  KOSCH_GRP,
  MATKL,
  LIKEID,
  PHIN_FROM,
  PHIN_TO,
  PHIN_TSID,
  PHOUT_FROM,
  PHOUT_TO,
  PHOUT_TSID,
  FLAGCLASS,
  loctype,
  locno,
  tzone,
  xpos,
  ypos,
  handl,
  store,
  ppcal,
  sdcal,
  stcal,
  locprio,
  matmod.matid AS matid,
  matmod.locid AS locid,
  model,
  STFAC,
  ATT01,
  ATT02,
  ATT03,
  ATT04,
  ATT05
FROM ScmPrd_Matkey AS matkey
;

Learn More