What is C_BOMMaterialVH in SAP S/4HANA?

C_BOMMaterialVH is a consumption CDS view in SAP S/4HANA. Material It contains 9 fields.

Which tables does C_BOMMaterialVH read from?

C_BOMMaterialVH reads data from: I_ProductStdVH.

What VDM layer is C_BOMMaterialVH?

C_BOMMaterialVH is classified as a Consumption view optimized for specific business scenarios and reporting.

C_BOMMaterialVH

DDL: C_BOMMATERIALVH SQL: CBOMMATVH Type: view CONSUMPTION

9 Fields 1 Data Sources

Material

C_BOMMaterialVH (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

R&D Engineering

C_BOMMaterialVH is a Consumption CDS View that provides data about "Material" in SAP S/4HANA. It reads from 1 data source (I_ProductStdVH) and exposes 9 fields with key field Material.

SAP Help Documentation

Category	CDS Views for Bill of Material

Purpose
This CDS view is designed to provide value help for BOM (Bill of Materials) applications by offering a searchable list of materials. It serves as a consumption view that facilitates the selection and identification of materials within BOM-related processes. This CDS view provides the data to answer the following business questions: What materials are available for use in BOM applications? How can users efficiently search and identify materials based on descriptions and other attributes? What are the details associated with each material, such as authorization group and external product ID? How can users leverage fuzzy search capabilities to find materials with similar names or descriptions? Business question> To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have a role with the following restriction types set to read access: M_MATE_MAN - Material Master: Data at Client Level M_MATE_MAR - Material Master: Material Types M_MATE_MAT - Material Master: Materials M_MATE_WGR - Material Master: Material Groups These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description AuthorizationGroup Authorization Group MaterialDescription Material Description ProductExternalID Product External Number Material Material Product Product ProductGroup Product Group ProductType Product Type

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	R&D Engineering
Application Component	LO-MD-BOM
Capabilities	Data Provider for Value Help
Package	R&D Engineering for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_ProductStdVH	I_ProductStdVH	from

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CBOMMATVH	view
VDM.viewType	#CONSUMPTION	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.representativeKey	Material	view
ObjectModel.dataCategory	#VALUE_HELP	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XXL	view
ObjectModel.usageType.dataClass	#MASTER	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Material	view
Search.searchable	true	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Consumption.ranked	true	view

Fields (9)

Key	Field	Source Field	Description
KEY	Material		Material Number
	MaterialDescription		Material Description
	AuthorizationGroup	AuthorizationGroup	Authorization Group
	Product	Product	Product Number
	ProductExternalID	ProductExternalID	External Representation of Material Number
	ProductType	ProductType	Product Type Group
	ProductGroup	ProductGroup	Product Sold Group
	_ProductType	_ProductType
	_ProductGroup_2	_ProductGroup_2

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_BOMMaterialVH.
-- 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: CBOMMATVH

CREATE VIEW C_BOMMaterialVH AS
SELECT
  cast (Product as matnr preserving type ) AS Material,
  cast( _Text[1: Language=$session.system_language].ProductName as maktx) AS MaterialDescription,
  AuthorizationGroup,
  Product,
  ProductExternalID,
  ProductType,
  ProductGroup
FROM I_ProductStdVH
;

Depth:

C_BOMMaterialVH view

I_ProductStdVH view