C_MaintenanceOrderDEX

@EndUserText.label: 'Maintenance Order Data Extractor'
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {
 authorizationCheck: #MANDATORY,
 personalData.blocking: #REQUIRED
}
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.sapObjectNodeType.name: 'MaintenanceOrder'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@ObjectModel.supportedCapabilities:[ #EXTRACTION_DATA_SOURCE ]
@ObjectModel.modelingPattern: #NONE
@Analytics: {
  dataCategory: #FACT,
  dataExtraction: {
    enabled: true,
        delta.changeDataCapture: {
            mapping:[
                      {
                        table: 'AFIH', role: #MAIN,
                        viewElement: ['MaintenanceOrder'],
                        tableElement: ['AUFNR']
                      },
                      {
                        table: 'AUFK', role:  #LEFT_OUTER_TO_ONE_JOIN,
                        viewElement: ['MaintenanceOrder'],
                        tableElement: ['AUFNR']
                      },
                      {
                        table: 'AFKO', role:  #LEFT_OUTER_TO_ONE_JOIN,
                        viewElement: ['MaintenanceOrder'],
                        tableElement: ['AUFNR']
                      }
                    ]
                 }
              }
}

define view entity C_MaintenanceOrderDEX
  as select from I_MaintenanceOrder as MaintenanceOrder
{
       /* start suppress warning shlporigin_not_inherited */
  key  MaintenanceOrder,
       MaintOrderRoutingNumber,
       MaintenanceOrderType,
       MaintenanceOrderDesc,
       MaintOrdBasicStartDate,
       MaintOrdBasicStartTime,
       MaintOrdBasicEndDate,
       MaintOrdBasicEndTime,
       ScheduledBasicStartDate,
       ScheduledBasicStartTime,
       ScheduledBasicEndDate,
       ScheduledBasicEndTime,
       MaintOrderReferenceDate,
       MaintOrderReferenceTime,
       MainWorkCompletedDateTime,
       MaintenanceNotification,
       @Semantics.booleanIndicator: true
       OrdIsNotSchedldAutomatically,
       ControllingArea,
       WorkCenterInternalID                                                                    as MainWorkCenterInternalID,
       WorkCenterTypeCode                                                                      as MainWorkCenterTypeCode,
       MainWorkCenter,
       MainWorkCenterPlant,
       MaintenancePlanningPlant,
       MaintenancePlant,
       Assembly,
       MaintOrdProcessPhaseCode,
       MaintOrdProcessSubPhaseCode,
       BusinessArea,
       CompanyCode,
       CostingSheet,
       ReferenceElement,
       FunctionalArea,
       AdditionalDeviceData,
       Equipment,
       MaintenanceOrderPlanningCode,
       MaintenancePlannerGroup,
       MaintenanceActivityType,
       MaintPriority,
       MaintPriorityType,
       OrderProcessingGroup,
       ProfitCenter,
       ResponsibleCostCenter,
       Currency,
       MaintenanceRevision,
       SerialNumber,
       Material                                                                                as Product,
       SuperiorProjectNetwork,
       OperationSystemCondition,
       WBSElementInternalID,
       cast( ProjectInternalID as ps_s4_proj_pspnr )                                           as ProjectInternalID,
       ControllingObjectClass,
       MaintenanceOrderInternalID,
       MaintenanceItemObjectList                                                               as MaintenanceObjectList,
       MaintObjectLocAcctAssgmtNmbr,
       BasicSchedulingType,
       LatestAcceptableCompletionDate,
       MaintOrdPersonResponsible,
       LastChangeByUser,
       @Semantics.systemDateTime.lastChangedAt: true
       cast( LastChangeDateTime as rslastchangedat preserving type )                           as LastChangeDateTime,
       CreatedByUser,
       OrderHasLongText,
       MaintenanceOrderOverheadCode,
       PlannedCostsCostingVariant,
       ActualCostsCostingVariant,
       MaintenancePlan,
       MaintenanceCall,
       MaintenanceItem,
       LeadingOrder,
       TaskListType,
       TaskListGroup,
       TaskListGroupCounter,
       MaintOrderProcessingContext
//       The below fields belong to private cloud, the fields can be exposed

//       with featur parity

//       MaintenanceOrderCreationMode,

//       MaintOrdCostDetnStatus,

       /* end suppress warning shlporigin_not_inherited */
}