ScmPrd_V_Matmap

DDL: SCMPRD_V_MATMAP SQL: SCMPRDVMATMAP Type: view
17 Fields 1 Data Sources

Product Scm redirect for V_MATMAP

ScmPrd_V_Matmap is a CDS View that provides data about "Product Scm redirect for V_MATMAP" in SAP S/4HANA. It reads from 1 data source (ScmPrd_Matmap) and exposes 17 fields.

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matmap matmap from

Annotations (8)

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

Fields (17)

KeyFieldSource TableSource FieldDescription
mandt ScmPrd_Matmap mandt Editing Client
matid ScmPrd_Matmap matid Product ID
matnr ScmPrd_Matmap matnr Vehicle Model
ext_matnr ext_matnr Ext. Product
logqs logqs Bus. System Grp
LANGU LANGU Primary lang.
MEINS MEINS Valuation Unit
MAKTX MAKTX Product Description
MATKL MATKL Product Sold Group
BRGEW BRGEW Weight
GEWEI GEWEI Weight Unit
VOLUM VOLUM Volume
VOLEH VOLEH Volume Unit
KOSCH KOSCH Prod.allocation
COMPL COMPL This field is no longer used
LVORM LVORM Stock del. flag
MAKTG MAKTG Description

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_Matmap.
-- 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: SCMPRDVMATMAP

CREATE VIEW ScmPrd_V_Matmap AS
SELECT
  matmap.mandt AS mandt,
  matmap.matid AS matid,
  matmap.matnr AS matnr,
  ext_matnr,
  logqs,
  LANGU,
  MEINS,
  MAKTX,
  MATKL,
  BRGEW,
  GEWEI,
  VOLUM,
  VOLEH,
  KOSCH,
  COMPL,
  LVORM,
  MAKTG
FROM ScmPrd_Matmap AS matmap
;

Learn More