I_SERIALNUMBERMANUFACTURINGORD

CDS View

Serial Number in Manufacturing Order

I_SERIALNUMBERMANUFACTURINGORD is a CDS View in S/4HANA. Serial Number in Manufacturing Order. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_MfgOrdItmNmbrOfSerialNumbers view from COMPOSITE
P_MfgOrdOpSerialNumberForSplit view union_all CONSUMPTION Serial Number that can be split at an Order Operation

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Material Material 1
KEY SerialNumber SerialNumber 1
ManufacturingOrder ManufacturingOrder 1 
@AccessControl: { authorizationCheck: #CHECK,
                  personalData.blocking: #NOT_REQUIRED }

@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType: {
                            serviceQuality: #A,
                            sizeCategory:   #XL,
                            dataClass:      #TRANSACTIONAL
                           },
                 supportedCapabilities: [
                            #SQL_DATA_SOURCE,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET
                                        ],
                 modelingPattern: #ANALYTICAL_DIMENSION                                  
              }

@EndUserText.label: 'Serial Number in Manufacturing Order'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_SerialNumberManufacturingOrd
  as select from I_MaintObjListManufacturingOrd as _MaintObjListManufacturingOrd
  -- data source association to list item cannot be used due to current CDS restrictions
  -- (could be done implicitly in field list by _A._B[inner].C, but non-maskable warnings ensue)
  -- ... join needs foreign key relationship to be defined again
    inner join I_MaintenanceObjectListItem as _MaintenanceObjectListItem
      on _MaintObjListManufacturingOrd.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
{
  @ObjectModel.foreignKey.association: '_Equipment'
  key _MaintenanceObjectListItem.Equipment,

  @ObjectModel.foreignKey.association: '_ManufacturingOrder'
  key _MaintObjListManufacturingOrd.ManufacturingOrder,
  @ObjectModel.foreignKey.association: '_ManufacturingOrderItem'
  key _MaintObjListManufacturingOrd.ManufacturingOrderItem,

  @ObjectModel.foreignKey.association: '_Product'
  _MaintenanceObjectListItem.Material,
  _MaintenanceObjectListItem.SerialNumber,

  _MaintenanceObjectListItem._Equipment,
  _MaintObjListManufacturingOrd._ManufacturingOrder,
  _MaintObjListManufacturingOrd._ManufacturingOrderItem,
  _MaintenanceObjectListItem._Product
}

Learn More