P_ChmlSuplrMatlDataMntr

DDL: P_CHMLSUPLRMATLDATAMNTR Type: view CONSUMPTION Package: EHFND_CNS_CSM
15 Fields 1 Data Sources

Material Data of Supplier and Raw Material for Monitor

P_ChmlSuplrMatlDataMntr is a Consumption CDS View that provides data about "Material Data of Supplier and Raw Material for Monitor" in SAP S/4HANA. It reads from 1 data source (I_ChmlSuplrMatl) and exposes 15 fields. Part of development package EHFND_CNS_CSM.

Data Sources (1)

SourceAliasJoin Type
I_ChmlSuplrMatl SupplierMaterial from

Annotations (8)

NameValueLevelField
EndUserText.label Material Data of Supplier and Raw Material for Monitor view
AbapCatalog.sqlViewName PCSMMATLDTMNTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (15)

KeyFieldSource TableSource FieldDescription
ChmlSuplrMatlUUID
ChmlCmplncInfoUUID
ChmlCmplncInfoCombinedName
Material1endasChmlCmplncInfoNameAndNmbr
ChmlCmplncInternalNameasProduct
Material
MaterialName
ChmlCmplncInternalName
Specification
ProductHierarchy
ProductHierarchyText
Division
DivisionName
ExternalProductGroup
ExternalProductGroupName

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 P_ChmlSuplrMatlDataMntr.
-- 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.

CREATE VIEW P_ChmlSuplrMatlDataMntr AS
SELECT
  RawMaterialData._MaterialData._ProductHierarchy._Text[1: Language = $session.system_language ].ProductHierarchyText AS ProductHierarchyText,
  RawMaterialData._MaterialData._Division._Text[1: Language = $session.system_language ].DivisionName AS DivisionName,
  RawMaterialData._MaterialData._ExternalProductGroup._Text[1: Language = $session.system_language ].ExternalProductGroupName AS ExternalProductGroupName
FROM I_ChmlSuplrMatl AS SupplierMaterial
;

Learn More