C_MassUpdtMatlGrpVH

DDL: C_MASSUPDTMATLGRPVH SQL: CMASSMATLGRP_VH Type: view CONSUMPTION
3 Fields 1 Data Sources

Material Group Value Help

C_MassUpdtMatlGrpVH is a Consumption CDS View that provides data about "Material Group Value Help" in SAP S/4HANA. It reads from 1 data source (I_MaterialGroup) and exposes 3 fields with key field MaterialGroup.

Data Sources (1)

SourceAliasJoin Type
I_MaterialGroup MaterialGroup from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CMASSMATLGRP_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
Search.searchable true view
ObjectModel.semanticKey MaterialGroup view
ObjectModel.representativeKey MaterialGroup view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Material Group Value Help view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY MaterialGroup MaterialGroup Product Group
MaterialGroupName
MaterialAuthorizationGroup MaterialAuthorizationGroup AuthorizGroup

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 C_MassUpdtMatlGrpVH.
-- 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: CMASSMATLGRP_VH

CREATE VIEW C_MassUpdtMatlGrpVH AS
SELECT
  MaterialGroup,
  _Text[1: Language = $session.system_language].MaterialGroupName AS MaterialGroupName,
  MaterialAuthorizationGroup
FROM I_MaterialGroup AS MaterialGroup
;

Learn More