I_SerialNumberJITCall

DDL: I_SERIALNUMBERJITCALL Type: view_entity COMPOSITE Package: LO_SN_DB

Serial Number in JIT Call

I_SerialNumberJITCall is a Composite CDS View that provides data about "Serial Number in JIT Call" in SAP S/4HANA. It reads from 2 data sources (I_MaintenanceObjectListItem, I_MaintObjListJITCall) and exposes 11 fields with key fields Equipment, CompGrpNumber. Part of development package LO_SN_DB.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_MaintenanceObjectListItem _MaintenanceObjectListItem inner
I_MaintObjListJITCall _MaintObjListJITCall from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Serial Number in JIT Call view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Equipment I_MaintenanceObjectListItem Equipment
InternalJITCallNumber
KEY CompGrpNumber I_MaintObjListJITCall CompGrpNumber
JITCallItemNumber
Material I_MaintenanceObjectListItem Material
SerialNumber I_MaintenanceObjectListItem SerialNumber
_Equipment I_MaintenanceObjectListItem _Equipment
_HandlingUnit
_CompGrpNumber
_HandlingUnitItem
_Product I_MaintenanceObjectListItem _Product 
@AccessControl: {
  --Waiting for JITCall VDM
  --authorizationCheck: #CHECK,
  authorizationCheck: #PRIVILEGED_ONLY,
  personalData.blocking: #NOT_REQUIRED
}

@VDM.viewType: #COMPOSITE
--Waiting for JIT Call VDM release
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API

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

@EndUserText.label: 'Serial Number in JIT Call'
@Metadata.ignorePropagatedAnnotations:true
define view entity I_SerialNumberJITCall
  as select from I_MaintObjListJITCall as _MaintObjListJITCall
  -- 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 _MaintObjListJITCall.MaintenanceObjectList = _MaintenanceObjectListItem.MaintenanceObjectList
{
  @ObjectModel.foreignKey.association: '_Equipment'
  key _MaintenanceObjectListItem.Equipment,

  --@ObjectModel.foreignKey.association: '_HandlingUnit'
  key _MaintObjListJITCall.InternalJITCallNumber,
  key _MaintObjListJITCall.CompGrpNumber,
  --@ObjectModel.foreignKey.association: '_HandlingUnitItem'
  key _MaintObjListJITCall.JITCallItemNumber,

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

  _MaintenanceObjectListItem._Equipment,
  --_MaintObjListJITCall._HandlingUnit,
  --_MaintObjListJITCall._CompGrpNumber,
  --_MaintObjListJITCall._HandlingUnitItem,
  _MaintenanceObjectListItem._Product
}

Learn More