A_ProdnOrderItemSerialNumber

DDL: A_PRODNORDERITEMSERIALNUMBER Type: view_entity COMPOSITE Package: ODATA_PP_API_PRODORDER_2

Production Order Serial Numbers

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MfgOrderItemSerialNumber I_MfgOrderItemSerialNumber from

Annotations (9)

NameValueLevelField
EndUserText.label Production Order Serial Numbers view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.deleteEnabled true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ManufacturingOrder ManufacturingOrder
KEY ManufacturingOrderItem ManufacturingOrderItem
KEY SerialNumber SerialNumber
SerialNumberProfile SerialNumberProfile
Product Product
ProductionPlant ProductionPlant
ManufacturingOrderCategory ManufacturingOrderCategory
ManufacturingOrderType ManufacturingOrderType
DocumentDate DocumentDate
LastChangeTimeendasLastChangeDateTime 
@EndUserText.label: 'Production Order Serial Numbers'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AccessControl: {
  authorizationCheck: #MANDATORY,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #XL
   }
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.deleteEnabled: true
define view entity A_ProdnOrderItemSerialNumber
  as select from I_MfgOrderItemSerialNumber
{

         // Key

  key    ManufacturingOrder,
  key    ManufacturingOrderItem,
  key    SerialNumber,
         SerialNumberProfile,
         Product,
         ProductionPlant,
         ManufacturingOrderCategory,
         ManufacturingOrderType,

         // Date

         @Semantics.businessDate.at:true
         DocumentDate,
         @Semantics.durationInSeconds: true
         @Semantics.dateTime: false
         case I_MfgOrderItemSerialNumber._MfgOrder.LastChangeDate
         when '00000000' then
          concat(I_MfgOrderItemSerialNumber._MfgOrder.MfgOrderCreationDate,
                 I_MfgOrderItemSerialNumber._MfgOrder.MfgOrderCreationTime)
         else
          concat(I_MfgOrderItemSerialNumber._MfgOrder.LastChangeDate,
                 I_MfgOrderItemSerialNumber._MfgOrder.LastChangeTime)
         end  as LastChangeDateTime
}

Learn More