ScmPrd_V_Ml2

DDL: SCMPRD_V_ML2 SQL: SCMPRDVML2 Type: view

Product Scm redirect for V_ML2

ScmPrd_V_Ml2 is a CDS View that provides data about "Product Scm redirect for V_ML2" in SAP S/4HANA. It reads from 1 data source (ScmPrd_Matloc) and exposes 28 fields.

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matloc matloc from

Annotations (8)

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

Fields (28)

KeyFieldSource TableSource FieldDescription
MATID ScmPrd_Matloc MATID Product ID
LOCID ScmPrd_Matloc LOCID Single-Character Flag
MATNR MATNR Vehicle Model
PRODUCT_TYPE PRODUCT_TYPE Product Type
MATKL MATKL Product Sold Group
ATT01 ATT01 Free Attribute 1
ATT02 ATT02 Free Attribute 2
ATT03 ATT03 Free Attribute 3
ATT04 ATT04 Free Attribute
ATT05 ATT05 Free Attribute
locno locno Location
loctype loctype Location Type
PLANNER_PPS PLANNER_PPS MRP Controller
PLANNER_SNP PLANNER_SNP SNP Planner
PLANNER_DEMAND PLANNER_DEMAND
PLANNER_TRANS PLANNER_TRANS
LVORM ScmPrd_Matloc LVORM Stock del. flag
EKGRP EKGRP Sub. purchasing grp
PRIO PRIO Profile priority
VEGRP VEGRP Cust.'s Pur. Grp
MATLOCID MATLOCID Loc. Prod. ID
BESKZ BESKZ Procuremt Type
AT101 AT101 Free Attribute 1
AT102 AT102 Free Attribute 2
AT103 AT103 Free Attribute 3
AT104 AT104 Free Attribute
AT105 AT105 Free Attribute
RRP_SEL_GROUP RRP_SEL_GROUP Planning Group

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_Ml2.
-- 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: SCMPRDVML2

CREATE VIEW ScmPrd_V_Ml2 AS
SELECT
  matloc.MATID AS MATID,
  matloc.LOCID AS LOCID,
  MATNR,
  PRODUCT_TYPE,
  MATKL,
  ATT01,
  ATT02,
  ATT03,
  ATT04,
  ATT05,
  locno,
  loctype,
  PLANNER_PPS,
  PLANNER_SNP,
  PLANNER_DEMAND,
  PLANNER_TRANS,
  matloc.LVORM AS LVORM,
  EKGRP,
  PRIO,
  VEGRP,
  MATLOCID,
  BESKZ,
  AT101,
  AT102,
  AT103,
  AT104,
  AT105,
  RRP_SEL_GROUP
FROM ScmPrd_Matloc AS matloc
;