C_ProcmtHubMaterialVH

DDL: C_PROCMTHUBMATERIALVH SQL: CMATERIAL_VH Type: view CONSUMPTION Package: HUBERPI_MM_ODATA_F4
13 Fields 1 Data Sources 1 Associations

Material Value help for Hub Scenario

C_ProcmtHubMaterialVH is a Consumption CDS View that provides data about "Material Value help for Hub Scenario" in SAP S/4HANA. It reads from 1 data source (C_MM_MaterialValueHelp) and exposes 13 fields with key fields Material, Plant. It has 1 association to related views. Part of development package HUBERPI_MM_ODATA_F4.

Data Sources (1)

SourceAliasJoin Type
C_MM_MaterialValueHelp C_MM_MaterialValueHelp from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Producttype _ProductType $projection.MaterialType = _ProductType.ProductType

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CMATERIAL_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Material Value help for Hub Scenario view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant Plant Valuation Area
MaterialName MaterialName Material Description
PlantName PlantName Plant Name
MaterialGroup MaterialGroup Product Group
MaterialGroupName MaterialGroupName prod Grp Desc.
MaterialType MaterialType Material Type
MaterialTypeName MaterialTypeName Mat.Type Desc.
MaterialBaseUnit MaterialBaseUnit Valuation Unit
AuthorizationGroup AuthorizationGroup AuthorizGroup
ProductTypeCode _ProductType ProductTypeCode Product Type Group
Name
Language

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_ProcmtHubMaterialVH.
-- 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: CMATERIAL_VH

CREATE VIEW C_ProcmtHubMaterialVH AS
SELECT
  Material,
  Plant,
  MaterialName,
  PlantName,
  MaterialGroup,
  MaterialGroupName,
  MaterialType,
  MaterialTypeName,
  MaterialBaseUnit,
  AuthorizationGroup,
  _ProductType.ProductTypeCode AS ProductTypeCode,
  _ProductType._ProductTypeCode._Text[1: Language = $session.system_language].Name AS Name,
  $session.system_language AS Language
FROM C_MM_MaterialValueHelp
LEFT OUTER JOIN I_Producttype AS _ProductType ON MaterialType = _ProductType.ProductType  -- association [0..1]
;

Learn More