C_UpldMatlInvtryPricesMatlVH

DDL: C_UPLDMATLINVTRYPRICESMATLVH SQL: CUMIPMATLVH Type: view CONSUMPTION Package: ODATA_ML_UPLMATINVPR

Materials of Plants

C_UpldMatlInvtryPricesMatlVH is a Consumption CDS View that provides data about "Materials of Plants" in SAP S/4HANA. It reads from 1 data source (I_MaterialVH) and exposes 19 fields with key fields Material, Plant. It is exposed through 1 OData service (ASQL_F4006). Part of development package ODATA_ML_UPLMATINVPR.

Data Sources (1)

SourceAliasJoin Type
I_MaterialVH I_MaterialVH from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CUMIPMATLVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey Material view
Consumption.ranked true view
VDM.viewType #CONSUMPTION view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4006 ASQL_F4006 C2 NOT_RELEASED

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
KEY Plant _MaterialPlant Plant Valuation Area
MaterialName
MaterialType MaterialType Material Type
MaterialGroup MaterialGroup Product Group
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MaterialGrossWeight MaterialGrossWeight
MaterialNetWeight MaterialNetWeight
MaterialWeightUnit MaterialWeightUnit
MaterialManufacturerNumber MaterialManufacturerNumber Manufacturer
MaterialManufacturerPartNumber MaterialManufacturerPartNumber Mfr Part Number
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBatchManagementRequired IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
_BaseUnit _BaseUnit
_MaterialGroup _MaterialGroup
_MaterialPlant _MaterialPlant
_MaterialType _MaterialType
_Text _Text
_WeightUnit _WeightUnit

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_UpldMatlInvtryPricesMatlVH.
-- 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: CUMIPMATLVH

CREATE VIEW C_UpldMatlInvtryPricesMatlVH AS
SELECT
  Material,
  _MaterialPlant.Plant AS Plant,
  _Text[1:Language = $session.system_language].MaterialName AS MaterialName,
  MaterialType,
  MaterialGroup,
  MaterialBaseUnit,
  MaterialGrossWeight,
  MaterialNetWeight,
  MaterialWeightUnit,
  MaterialManufacturerNumber,
  MaterialManufacturerPartNumber,
  AuthorizationGroup,
  IsBatchManagementRequired
FROM I_MaterialVH
;