R_MAINTJOBWORKITEMCHECKLIST

CDS View

Maintenance Work Item Checklist

R_MAINTJOBWORKITEMCHECKLIST is a CDS View in S/4HANA. Maintenance Work Item Checklist. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_MaintJobWorkItemChecklist view_entity from CONSUMPTION
R_MaintChklstCharcAggregate view_entity from COMPOSITE View for Maintenance Checklist Characteristics aggregate 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Maintenance Work Item Checklist'
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
define view entity R_MaintJobWorkItemChecklist as select from I_MaintOrderInspectionLot
  association [0..1] to I_MaintenanceOrderOperation as _MaintenanceOrderOperation on $projection.MaintenanceBusinessSubobject = _MaintenanceOrderOperation.MaintOrderOperationInternalID
  association [1..1] to I_InspectionLotAggregate    as _InspectionLotAggregate    on $projection.InspectionLot = _InspectionLotAggregate.InspectionLot
  association [1..1] to I_InspectionLot             as _InspectionLot             on $projection.InspectionLot = _InspectionLot.InspectionLot
  association [1..1] to I_TechnicalObject           as _TechnicalObject           on $projection.TechnicalObject = _TechnicalObject.TechnicalObject
                                                                                  and $projection.TechObjIsEquipOrFuncnlLoc = _TechnicalObject.TechObjIsEquipOrFuncnlLoc
{
  key  MaintenanceOrder,
       @ObjectModel.text.element: ['InspectionLotText']
  key  InspectionLot,
  key cast(_MaintenanceOrderOperation.MaintenanceOrderOperation as maintenanceorderoperation preserving type) as MaintenanceOrderOperation,
       MaintenanceBusinessSubobject,
       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,
       MainChecklistIsDeactivated,
       //_association_name // Make association public

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

       _InspectionLot.InspectionLotText,
       _TechnicalObject,

       _MaintenanceOrderOperation,
       _InspectionLotAggregate
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONLOT",
"I_INSPECTIONLOTAGGREGATE",
"I_MAINTENANCEORDEROPERATION",
"I_MAINTORDERINSPECTIONLOT"
],
"ASSOCIATED":
[
"I_INSPECTIONLOTAGGREGATE",
"I_MAINTENANCEORDEROPERATION",
"I_TECHNICALOBJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More