C_MaterialSerialNumberVH

DDL: C_MATERIALSERIALNUMBERVH Type: view_entity CONSUMPTION
10 Fields 1 Data Sources

List of Material Serial Numbers

C_MaterialSerialNumberVH is a Consumption CDS View that provides data about "List of Material Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_MaterialSerialNumberVH) and exposes 10 fields with key fields SerialNumber, Equipment, Material.

Data Sources (1)

SourceAliasJoin Type
I_MaterialSerialNumberVH I_MaterialSerialNumberVH from

Annotations (11)

NameValueLevelField
EndUserText.label List of Material Serial Numbers view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.representativeKey Equipment view
ObjectModel.dataCategory #VALUE_HELP view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
Search.searchable true view
Consumption.ranked true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber SerialNumber Serial Number
KEY Equipment
KEY Material Material Vehicle Model
UniqueItemIdentifier UniqueItemIdentifier UII
Customer Customer Sold-to Party
Supplier Supplier Supplier
AuthorizationGroup AuthorizationGroup AuthorizGroup
_Customer _Customer
EquipmentName Equipment Description
_Supplier _Supplier

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_MaterialSerialNumberVH.
-- 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.

CREATE VIEW C_MaterialSerialNumberVH AS
SELECT
  SerialNumber,
  case HasEquipmentData when 'X' then Equipment else '' end AS Equipment,
  Material,
  UniqueItemIdentifier,
  Customer,
  Supplier,
  AuthorizationGroup,
  _EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName
FROM I_MaterialSerialNumberVH
;

Learn More