C_InhRepairSerialNumberVH

DDL: C_INHREPAIRSERIALNUMBERVH Type: view CONSUMPTION
11 Fields 1 Data Sources

Serial Number of Equipment

C_InhRepairSerialNumberVH is a Consumption CDS View that provides data about "Serial Number of Equipment" in SAP S/4HANA. It reads from 1 data source (I_EquipMaterialSerialNumberVH) and exposes 11 fields with key fields SerialNumber, Product.

Data Sources (1)

SourceAliasJoin Type
I_EquipMaterialSerialNumberVH I_EquipMaterialSerialNumberVH from

Annotations (15)

NameValueLevelField
EndUserText.label Serial Number of Equipment view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey SerialNumber view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CIHRSERIALNMBRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
Consumption.ranked true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SerialNumber Serial Number
KEY Product Vehicle Model
ProductName Material Description
Equipment Equipment Equipment check
EquipmentName Tech. Obj. Desc
Customer Customer Sold-to Party
Supplier Supplier Supplier
AuthorizationGroup AuthorizationGroup AuthorizGroup
_Supplier _Supplier
_Customer _Customer
HasEquipmentData HasEquipmentData

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_InhRepairSerialNumberVH.
-- 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_InhRepairSerialNumberVH AS
SELECT
  cast(SerialNumber as crms4_repa_equip_serialnumber preserving type) AS SerialNumber,
  cast(Material as productnumber preserving type) AS Product,
  cast(MaterialName as productdescription preserving type ) AS ProductName,
  Equipment,
  cast(EquipmentName as crms4_repa_equip_descr_lbl preserving type ) AS EquipmentName,
  Customer,
  Supplier,
  AuthorizationGroup,
  HasEquipmentData
FROM I_EquipMaterialSerialNumberVH
;

Learn More