ScmPrd_V_Locmat

DDL: SCMPRD_V_LOCMAT SQL: SCMPRDVLOCMAT Type: view
9 Fields 1 Data Sources

Product Scm Locmat redirect view

ScmPrd_V_Locmat is a CDS View that provides data about "Product Scm Locmat redirect view" in SAP S/4HANA. It reads from 1 data source (ScmPrd_Matkey) and exposes 9 fields.

Data Sources (1)

SourceAliasJoin Type
ScmPrd_Matkey matkey from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName SCMPRDVLOCMAT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED 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 Locmat redirect view view

Fields (9)

KeyFieldSource TableSource FieldDescription
MATID ScmPrd_Matkey MATID Product ID
MATNR ScmPrd_Matkey MATNR Vehicle Model
LOCID matloc LOCID Single-Character Flag
PLANNER_PPS matloc PLANNER_PPS
PLANNER_SNP matloc PLANNER_SNP SNP Planner
PLANNER_TRANS matloc PLANNER_TRANS
loctype loc loctype Location Type
locno loc locno Location
EKGRP matloc EKGRP Sub. purchasing 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_Locmat.
-- 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: SCMPRDVLOCMAT

CREATE VIEW ScmPrd_V_Locmat AS
SELECT
  matkey.MATID AS MATID,
  matkey.MATNR AS MATNR,
  matloc.LOCID AS LOCID,
  matloc.PLANNER_PPS AS PLANNER_PPS,
  matloc.PLANNER_SNP AS PLANNER_SNP,
  matloc.PLANNER_TRANS AS PLANNER_TRANS,
  loc.loctype AS loctype,
  loc.locno AS locno,
  matloc.EKGRP AS EKGRP
FROM ScmPrd_Matkey AS matkey
;

Learn More