C_MaintJobWorkItemChecklist

DDL: C_MAINTJOBWORKITEMCHECKLIST Type: view_entity CONSUMPTION Package: VDM_EAM_MAINTJOB_MANAGE_CHKLST

Maintenance Work Item Check List

C_MaintJobWorkItemChecklist is a Consumption CDS View that provides data about "Maintenance Work Item Check List" in SAP S/4HANA. It reads from 1 data source (I_MaintOrderInspectionLot) and exposes 10 fields with key fields MaintenanceOrder, MaintenanceOrderOperation. It has 2 associations to related views. Part of development package VDM_EAM_MAINTJOB_MANAGE_CHKLST.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_MaintOrderInspectionLot I_MaintOrderInspectionLot from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintenanceOrderOperation _MaintenanceOrderOperation $projection.MaintenanceBusinessSubobject = _MaintenanceOrderOperation.MaintOrderOperationInternalID
[1..*] I_InspectionLotAggregate _InspectionLotAggregate $projection.InspectionLot = _InspectionLotAggregate.InspectionLot

Annotations (7)

NameValueLevelField
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceOrder MaintenanceOrder
KEY MaintenanceOrderOperation
MaintenanceBusinessSubobject MaintenanceBusinessSubobject
InspectionLot InspectionLot
Plant Plant
InspCharAcceptedCount _InspectionLotAggregate InspCharAcceptedCount
InspCharOpenCount _InspectionLotAggregate InspCharOpenCount
InspCharRejectedCount _InspectionLotAggregate InspCharRejectedCount
_MaintenanceOrderOperation _MaintenanceOrderOperation
_InspectionLotAggregate _InspectionLotAggregate 
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@AccessControl.authorizationCheck : #MANDATORY
@Metadata.allowExtensions: true
@VDM: {
    viewType: #CONSUMPTION
}
@VDM.lifecycle.status: #DEPRECATED
define view entity C_MaintJobWorkItemChecklist
  as select from I_MaintOrderInspectionLot
  association [0..1] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on $projection.MaintenanceBusinessSubobject = _MaintenanceOrderOperation.MaintOrderOperationInternalID
  association [1..*] to I_InspectionLotAggregate    as _InspectionLotAggregate    on $projection.InspectionLot = _InspectionLotAggregate.InspectionLot
{
  key  MaintenanceOrder,
  key  cast(_MaintenanceOrderOperation.MaintenanceOrderOperation as maintenanceorderoperation preserving type) as MaintenanceOrderOperation,
       MaintenanceBusinessSubobject,
       InspectionLot,
       Plant,
       // If Equipment is available in inspection lot, Technical Object will hold Equipment,

       // otherwise will hold Functional Location Data

       case when Equipment = '' then
                   cast( FunctionalLocation as eams_tec_obj )
              else cast( Equipment as eams_tec_obj ) end                                                       as TechnicalObject,
       // Technical Object Type : If Equipment is available in inspection lot, Technical Object will hold Equipment,

       // otherwise will hold Functional Location Data

       cast( case when Equipment = '' and FunctionalLocation = '' then ''
             else case when Equipment = '' then 'EAMS_FL'
             else 'EAMS_EQUI' end end as eams_tec_obj_type_value )                                             as TechObjIsEquipOrFuncnlLoc,
       //_association_name // Make association public

       _InspectionLotAggregate.InspCharAcceptedCount,
       _InspectionLotAggregate.InspCharOpenCount,
       _InspectionLotAggregate.InspCharRejectedCount,

       _MaintenanceOrderOperation,
       _InspectionLotAggregate
}

Learn More