C_MfgOrderItemSerialNumber

DDL: C_MFGORDERITEMSERIALNUMBER Type: view_entity CONSUMPTION Package: PP_MFGORDER_UI

Mfg Order Serial Numbers

C_MfgOrderItemSerialNumber is a Consumption CDS View that provides data about "Mfg Order Serial Numbers" in SAP S/4HANA. It reads from 1 data source (I_MfgOrderItemSerialNumber) and exposes 8 fields with key fields ManufacturingOrder, ManufacturingOrderItem, SerialNumber. Part of development package PP_MFGORDER_UI.

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItemSerialNumber I_MfgOrderItemSerialNumber from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Mfg Order Serial Numbers view
ObjectModel.representativeKey SerialNumber view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
KEY ManufacturingOrderItem ManufacturingOrderItem
KEY SerialNumber SerialNumber
Product Product
ProductionPlant ProductionPlant
SerialNumberProfile SerialNumberProfile
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Mfg Order Serial Numbers'
@ObjectModel.representativeKey: 'SerialNumber'
@ObjectModel.semanticKey: ['ManufacturingOrder', 'ManufacturingOrderItem', 'SerialNumber']
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@VDM.viewType: #CONSUMPTION
@UI.presentationVariant: [{requestAtLeast: ['ProductionPlant'] }]

define view entity C_MfgOrderItemSerialNumber as select from I_MfgOrderItemSerialNumber {
  @UI.hidden: true
  key ManufacturingOrder,  
  
  key ManufacturingOrderItem,
   
  @UI.lineItem: [ {position: 10, type: #WITH_INTENT_BASED_NAVIGATION, semanticObjectAction: 'manage'}]                   
  @Consumption.semanticObject: 'EquipmentMaterialSerialNumber'      
  key SerialNumber,
  
  @UI.lineItem: [ {position: 20, type: #WITH_INTENT_BASED_NAVIGATION,  semanticObjectAction: 'displayMatlSerialNumberList'} ]
  @Consumption.semanticObject: 'Material'
  Product,
  
  @UI.lineItem: [ {position: 30, type: #WITH_INTENT_BASED_NAVIGATION, semanticObjectAction: 'displayMatlSerialNumber'}] 
  @Consumption.semanticObject: 'MaintenanceObject'
  @Consumption.valueHelpDefinition: [ { entity: { name: 'I_EquipmentStdVH', element: 'Equipment' } } ]
  case 
    when _Equipment_2.HasEquipmentData = 'X'
    then Equipment_2
    end  as Equipment,
      
  ProductionPlant,
  
  @Consumption.valueHelpDefinition: [ { entity: { name: 'I_SerialNumberProfileVH', element: 'SerialNumberProfile' } } ]
  SerialNumberProfile,
  
  @UI.hidden: true
  ManufacturingOrderCategory,
  
  @UI.hidden: true
  ManufacturingOrderType
}