I_MaintenanceOrderConfTP

@AbapCatalog.sqlViewName: 'IMAINTORDCONFTP'
@EndUserText.label: 'Maintenance Order Confirmation'
@ObjectModel.compositionRoot: true
@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeDraftPersistence: 'MAINTORDCONF_D'
@ObjectModel.draftEnabled:true
@VDM.viewType: #TRANSACTIONAL
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true
@ObjectModel.semanticKey:  [ 'MaintOrderConf', 'MaintOrderConfCntrValue' ]

@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL


define view I_MaintenanceOrderConfTP
  as select from I_MaintenanceOrderConfirmation as Document
  association [0..*] to I_MaintOrdConfGoodsMovementTP  as _MaintOrdConfGoodsMovementTP on  _MaintOrdConfGoodsMovementTP.MaintOrderConf          = $projection.MaintOrderConf
                                                                                       and _MaintOrdConfGoodsMovementTP.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue
  association [0..1] to I_WorkCenter                   as _ActualWorkCenter            on  _ActualWorkCenter.WorkCenterInternalID = $projection.WorkCenterInternalID
                                                                                       and _ActualWorkCenter.WorkCenterTypeCode   = 'A'
  association [0..1] to I_Indicator                    as _IsReversed                  on  _IsReversed.IndicatorValue = $projection.IsReversed
  association [0..1] to I_Indicator                    as _IsReversal                  on  _IsReversal.IndicatorValue = $projection.IsReversal
  association [0..1] to I_Indicator                    as _IsFinalConfirmation         on  _IsFinalConfirmation.IndicatorValue = $projection.IsFinalConfirmation
  association [0..1] to I_Indicator                    as _OpenReservationsIsCleared   on  _OpenReservationsIsCleared.IndicatorValue = $projection.OpenReservationsIsCleared
  association [0..1] to I_Indicator                    as _NoFurtherWorkQuantityIsExpd on  _NoFurtherWorkQuantityIsExpd.IndicatorValue = $projection.NoFurtherWorkQuantityIsExpd
  association [0..1] to I_Indicator                    as _LongTextExists              on  _LongTextExists.IndicatorValue = $projection.LongTextExists
  --association [0..1] to I_MaintenanceOrder            as _MaintenanceOrder            on  _MaintenanceOrder.MaintenanceOrder = $projection.MaintenanceOrder
  association [0..1] to I_User                         as _EnteredByUser               on  _EnteredByUser.UserID = $projection.EnteredByUser
  association [0..1] to I_User                         as _LastChangeByUser            on  _LastChangeByUser.UserID = $projection.LastChangedByUser
  association [0..1] to I_VarianceReason               as _VarianceReason              on  $projection.Plant              = _VarianceReason.Plant
                                                                                       and $projection.VarianceReasonCode = _VarianceReason.VarianceReasonCode
  association [0..1] to I_Language                     as _Language                    on  _Language.Language = $projection.Language
  association [1..*] to I_MaintOrdConfMessageTP        as _MaintOrdConfMessageTP       on
                                                                                           //   _MaintOrdConfMessageTP.MaintenanceOrder          = $projection.MaintenanceOrder

                                                                                           //                                                                                      and _MaintOrdConfMessageTP.MaintenanceOrderOperation = $projection.MaintenanceOrderOperation

                                                                                           _MaintOrdConfMessageTP.MaintOrderConf          = $projection.MaintOrderConf
                                                                                       and _MaintOrdConfMessageTP.MaintOrderConfCntrValue = $projection.MaintOrderConfCntrValue

  -- Extensions, do not expose as association:
  association [0..1] to E_MaintenanceOrder             as _MaintenanceOrderExtension   on  $projection.MaintenanceOrder = _MaintenanceOrderExtension.MaintenanceOrder
  association [0..1] to E_MaintenanceOrderConfirmation as _MaintOrdConfExtension       on  Document.MaintOrderConf          = _MaintOrdConfExtension.MaintOrderConf
                                                                                       and Document.MaintOrderConfCntrValue = _MaintOrdConfExtension.MaintOrderConfCntrValue
{
  key Document.MaintOrderConf,

  key Document.MaintOrderConfCntrValue,

      Document.MaintOrderConf                                                              as MaintOrderConfForEdit,
      Document.MaintOrderConfCntrValue                                                     as MaintOrderConfCntrValueForEdit,

      Document.MaintOrderConfirmationEntryDte,

      Document.MaintOrderOperationCounter,

      Document.EnteredByUser,

      Document.LastChangeDate,

      Document.LastChangedByUser,

      Document.PostingDate,

      Document.WorkCenterInternalID,

      Document.ConfirmationText,

      Document.Language,

      Document.LongTextExists,

      Document.ActualWorkQuantity,

      Document.ActualWorkQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'ActualWorkExternalQuantityUnit'
      cast( 0 as ismnw_2 )                                                                 as ActualWorkQtyInExternalUnit,

      ActualWorkExternalQuantityUnit,

      Document.ActivityType,

      Document.ActualDuration,

      Document.ActualDurationUnit,

      Document.EmployeeWageType,

      Document.ConfirmationYieldQuantity,

      Document.ConfirmationScrapQuantity,

      Document.ConfirmationUnit,

      Document.VarianceReasonCode,

      Document.PersonnelNumber,

      Document.OperationConfirmedStartDate,

      Document.OperationConfirmedStartTime,

      @Semantics.dateTime: true
      Document.MaintOrdOpWrkExecStartDateTime,

      Document.OperationConfirmedEndDate,

      Document.OperationConfirmedEndTime,

      @Semantics.dateTime: true
      Document.MaintOrdOpWrkExecEndDateTime,

      Document.ActyConfFcstdEndDate,

      Document.ActyConfFcstdEndTime,

      @Semantics.dateTime: true
      Document.MaintOrdOpFcstdEndDateTime,

      @Semantics.timeZone: true
      Document.AddressTimeZone,

      @Semantics.timeZone: true
      Document.UserEnteredTimeZone,

      @Semantics.timeZone: true
      Document.PlantTimeZone,

      Document.IsFinalConfirmation,

      Document.OpenReservationsIsCleared,

      Document.MaintenanceOrder,

      Document._MaintenanceOrder.MaintenanceOrderDesc,

      Document.MaintenanceOrderOperation,

      Document._MaintenanceOrderOperation.OperationDescription,

      Document.MaintenanceOrderSubOperation,

      Document.RemainingWorkQuantity,

      Document.RemainingWorkQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'RemainingWorkExtQuantityUnit'
      cast( 0 as remnw_2 )                                                                 as RemainingWorkQtyInExternalUnit,

      RemainingWorkExtQuantityUnit,

      Document.NoFurtherWorkQuantityIsExpd,

      Document.IsReversed,

      Document.IsReversal,

      //      Document.CancldMaintOrderConfCntrValue,


      Document.ConfirmationReworkQuantity,

      Document.MaintOrderConfirmationEntryTme,

      Document.AccountingIndicatorCode,

      Document.EnteredByExternalUser,

      Document.ConfirmationExternalEntryDate,

      Document.ConfirmationExternalEntryTime,

      Document.Plant,

      Document.FactoryCalendar,

      Document.MaintOrderOperationInternalID,

      Document._ActualWorkCenter.WorkCenter,

      //cast('' as abap.char( 300 ))                                                         as SystemMessageText,


      cast ('' as abap.char( 10 ))                                                         as MaintOrderConfUploadRowNumber,

      //cast ('' as abap.char( 10 ))                                                         as NumberOfRecords,


      cast ('' as pm_source_appl )                                                         as MaintOrdConfSourceApplication,

      cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as MaintOrdConfUploadUUID,

      cast ( '' as symsgty )                                                               as MaintOrderConfUploadMsgType,

      cast (0 as abap.int1)                                                                as MaintOrdConfUploadMsgCritlty,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintOrdConfGoodsMovementTP,

      _Plant,

      _ActualWorkCenter,

      Document._MaintenanceOrder,

      _EnteredByUser,

      _LastChangeByUser,

      _LongTextExists,

      _IsReversed,

      _IsReversal,

      _IsFinalConfirmation,

      _OpenReservationsIsCleared,

      _NoFurtherWorkQuantityIsExpd,

      _ActualWorkExtQuantityUnit,

      _RemainingWorkExtQuantityUnit,

      _VarianceReason,

      Document._PersonnelName,

      _Language,

      @ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
      _MaintOrdConfMessageTP


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MAINTENANCEORDER",
"I_MAINTENANCEORDERCONFIRMATION",
"I_MAINTENANCEORDEROPERATION",
"I_WORKCENTER"
],
"ASSOCIATED":
[
"E_MAINTENANCEORDER",
"E_MAINTENANCEORDERCONFIRMATION",
"I_INDICATOR",
"I_LANGUAGE",
"I_MAINTENANCEORDER",
"I_MAINTORDCONFGOODSMOVEMENTTP",
"I_MAINTORDCONFMESSAGETP",
"I_PLANT",
"I_UNITOFMEASURE",
"I_USER",
"I_VARIANCEREASON",
"I_WORKCENTER",
"I_WORKFORCEPERSON"
],
"BASE":
[
"I_MAINTENANCEORDERCONFIRMATION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/