C_MaintItmEquipMatlSrlNmbrVH

DDL: C_MAINTITMEQUIPMATLSRLNMBRVH SQL: CE_MSNVH Type: view CONSUMPTION
15 Fields 1 Data Sources

Maintenance Item Equipment

C_MaintItmEquipMatlSrlNmbrVH is a Consumption CDS View that provides data about "Maintenance Item Equipment" in SAP S/4HANA. It reads from 1 data source (I_Equipment) and exposes 15 fields with key field Equipment.

Data Sources (1)

SourceAliasJoin Type
I_Equipment I_Equipment from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CE_MSNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Item Equipment view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.representativeKey Equipment view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY Equipment Equipment Equipment check
EquipmentName
Material Material Material ID
MaterialName Material Description
SerialNumber SerialNumber Serial Number
AuthorizationGroup AuthorizationGroup AuthorizGroup
Customer Customer Sold-to Party
Supplier Supplier Supplier
HasEquipmentData HasEquipmentData Equipment data
MaintenancePlanningPlant _CurrentTimeSegment MaintenancePlanningPlant Planning Plant
_EquipmentText _EquipmentText
_Customer _Customer
_Supplier _Supplier
_Material _Material
_CurrentTimeSegment _CurrentTimeSegment

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_MaintItmEquipMatlSrlNmbrVH.
-- 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: CE_MSNVH

CREATE VIEW C_MaintItmEquipMatlSrlNmbrVH AS
SELECT
  Equipment,
  _EquipmentText[1:Language=$session.system_language].EquipmentName AS EquipmentName,
  Material,
  _Material._Text[ 1: Language = $session.system_language ].MaterialName AS MaterialName,
  SerialNumber,
  AuthorizationGroup,
  Customer,
  Supplier,
  HasEquipmentData,
  _CurrentTimeSegment.MaintenancePlanningPlant AS MaintenancePlanningPlant
FROM I_Equipment
;

Learn More