C_MaterialSerialNumberVH

DDL: C_MATERIALSERIALNUMBERVH Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

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. It is exposed through 1 OData service (UI_MANAGEINHREPAIRS). It is used in 1 Fiori application: Manage In-House Services.

Data Sources (1)

SourceAliasJoin Type
I_MaterialSerialNumberVH I_MaterialSerialNumberVH from

Annotations (9)

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

OData Services (1)

ServiceBindingVersionContractRelease
UI_MANAGEINHREPAIRS UI_MANAGEINHREPAIRS V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4025 Manage In-House Services Transactional You can use this app to create and process in-house services, and add in-house objects (service object) for which you want to perform maintenance or repair. You can filter, sort, and group a list of all in-house services in the system. You can also call up in-house services, and change their data.

Manage In-House Services

Business Role: Service Manager

You can use this app to create and process in-house repairs, and add the objects to be repaired. You can filter, sort, and group a list of all in-house repairs in the system. You can also call up in-house repairs, and change their data.

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