C_DspMatlValChnMaterialVH

DDL: C_DSPMATLVALCHNMATERIALVH SQL: CDMVCMATLVH Type: view CONSUMPTION Package: ODATA_ML_MATLVCA_DISP
21 Fields 1 Data Sources 10 OData Services 3 Fiori Apps

DMVC Material

C_DspMatlValChnMaterialVH is a Consumption CDS View that provides data about "DMVC Material" in SAP S/4HANA. It reads from 1 data source (P_DMVCMaterialVH) and exposes 21 fields with key field Material. It is exposed through 10 OData services (ASQL_F4006, ASQL_F4095, ASQL_F4898, ...). It is used in 3 Fiori applications: Display Material Value Chain - Estimated Cost, Display Actual Costing Result, Monitor Material Prices. Part of development package ODATA_ML_MATLVCA_DISP.

Data Sources (1)

SourceAliasJoin Type
P_DMVCMaterialVH P_DMVCMaterialVH from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CDMVCMATLVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A 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 (10)

ServiceBindingVersionContractRelease
ASQL_F4006 ASQL_F4006 C2 NOT_RELEASED
ASQL_F4095 ASQL_F4095 C2 NOT_RELEASED
ASQL_F4898 ASQL_F4898 C2 NOT_RELEASED
ASQL_F6073 ASQL_F6073 C2 NOT_RELEASED
ASQL_F6489 ASQL_F6489 C2 NOT_RELEASED
ASQL_F6684 ASQL_F6684 C2 NOT_RELEASED
ASQL_F7245 ASQL_F7245 C2 NOT_RELEASED
FIN_ML_ACR_DISP FIN_ML_ACR_DISP V2 C1 NOT_RELEASED
FML_DMVC_ESTIMATED_COSTS FML_DMVC_ESTIMATED_COSTS V2 C1 NOT_RELEASED
UI_FML_MNTRMATLPRICES UI_FML_MNTRMATLPRICES V2 C1 NOT_RELEASED

Fiori Apps (3)

App IDApp NameTypeDescription
F4898 Display Material Value Chain - Estimated Cost Analytical
F6073 Display Actual Costing Result Analytical With this app, you can display the results of the actual costing run.
F7245 Monitor Material Prices Transactional With this app, you can analyze material prices across all your valuations. You can choose from two views. One view allows to you to analyze price variations through a detailed price comparison in two selected valuations. The other view displays material prices over time in all your valuations.

Display Material Value Chain - Estimated Cost

Business Role: Cost Accountant - Inventory

You use this app to see the progression of material quantities and values along a product value chain. The value you chain can consist of procurement, transfers, production, or sales processes across organizational units (for example, plants, company codes, and divisions). You can see a visual flow of the valuated transactions for a product in a plant during a certain period, along with the results of the actual costing with price and exchange rate differences. Color-coded nodes display material value records and the connectors between the nodes display the valuated transactions.

Display Actual Costing Result

Business Role: Cost Accountant - Inventory

With this app, you can display the results of the actual costing run.

Monitor Material Prices

Business Role: Cost Accountant - Inventory

With this app, you can analyze material prices across all your valuations. You can choose from two views. One view allows to you to analyze price variations through a detailed price comparison in two selected valuations. The other view displays material prices over time in all your valuations. You can only use Monitor Material Prices if you have activated the business function Universal Parallel Accounting (FINS_PARALLEL_ACCOUNTING_BF, short: UPA).If you have not activated the UPA business function, you can use Manage Material Valuations (F2680) instead.

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY Material Material Vehicle Model
MaterialExternalID External Material ID
MaterialName MaterialName Material Description
MaterialType MaterialType Material Type
MaterialGroup MaterialGroup Product Group
MaterialBaseUnit MaterialBaseUnit Valuation Unit
MaterialGrossWeight MaterialGrossWeight
MaterialNetWeight MaterialNetWeight
MaterialWeightUnit MaterialWeightUnit
MaterialManufacturerNumber MaterialManufacturerNumber
MaterialManufacturerPartNumber MaterialManufacturerPartNumber
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBatchManagementRequired IsBatchManagementRequired Batch Mgmt Rqt(Plnt)
_BaseUnit _BaseUnit
_MaterialGroup _MaterialGroup
_MaterialPlant _MaterialPlant
_MaterialType _MaterialType
_Text _Text
_WeightUnit _WeightUnit
_ProductType _ProductType
_ProductGroup _ProductGroup

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_DspMatlValChnMaterialVH.
-- 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: CDMVCMATLVH

CREATE VIEW C_DspMatlValChnMaterialVH AS
SELECT
  Material,
  cast( MaterialExternalID as char_40 preserving type ) AS MaterialExternalID,
  MaterialName,
  MaterialType,
  MaterialGroup,
  MaterialBaseUnit,
  MaterialGrossWeight,
  MaterialNetWeight,
  MaterialWeightUnit,
  MaterialManufacturerNumber,
  MaterialManufacturerPartNumber,
  AuthorizationGroup,
  IsBatchManagementRequired
FROM P_DMVCMaterialVH
;

Learn More