ScmPrd_V_Ml4

DDL: SCMPRD_V_ML4 SQL: SCMPRDVML4 Type: view
20 Fields 1 Data Sources

Product Scm redirect for V_ML4

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

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matloc matloc from

Annotations (8)

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

Fields (20)

KeyFieldSource TableSource FieldDescription
MATID MATID Product ID
LOCID ScmPrd_Matloc LOCID Single-Character Flag
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_Ml4.
-- 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: SCMPRDVML4

CREATE VIEW ScmPrd_V_Ml4 AS
SELECT
  MATID,
  matloc.LOCID AS LOCID,
  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
;

Learn More