I_OrderProdnResourceTool

@AbapCatalog.sqlViewName: 'IORDPRODNRSCTOOL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_CreatedByUser', '_LastChangedByUser']
@Analytics.dataCategory: #DIMENSION
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #CDS_MODELING_DATA_SOURCE, #SQL_DATA_SOURCE]
@ObjectModel.representativeKey: 'OrderProdnRsceToolInternalID'
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Order Production Resource Tool'
// basic view for PRTs assigned to any category of orders


/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_OrderProdnResourceTool
  as select from           affh  as affh
    left outer to one join caufv as aufv on aufv.aufpl = affh.aufpl

  association [1..1] to I_OrdInternalBillOfOperations as _OrdInternalBillOfOperations   on  $projection.OrderInternalBillOfOperations = _OrdInternalBillOfOperations.OrderInternalBillOfOperations
  association [1..1] to I_OrderInternalID             as _OrderInternalID               on  $projection.OrderInternalBillOfOperations = _OrderInternalID.OrderInternalID 
  association [0..1] to I_LogisticsOrder              as _Order                         on  $projection.OrderID = _Order.OrderID
  association [0..1] to I_OrderCategory               as _OrderCategory                 on  $projection.OrderCategory = _OrderCategory.OrderCategory
  association [0..1] to I_OrderType                   as _OrderType                     on  $projection.OrderType = _OrderType.OrderType
  association [1..1] to I_OrderOperationBasic         as _OrderOperation                on  $projection.OrderInternalBillOfOperations = _OrderOperation.OrderInternalID
                                                                                        and $projection.OrderIntBillOfOperationsItem  = _OrderOperation.OrderOperationInternalID
  association [0..1] to I_Plant                       as _Plant                         on  $projection.Plant = _Plant.Plant
  association [0..1] to I_ProdnRsceToolControlProfile as _ProdnRsceToolControlProfile   on  $projection.ProdnRsceToolControlProfile = _ProdnRsceToolControlProfile.ProdnRsceToolControlProfile
  association [0..1] to I_ProductionResourceType      as _ProductionResourceType        on  $projection.ProductionResourceType = _ProductionResourceType.ProductionResourceType
  association [1..1] to I_ProdnRsceToolByInternalKey  as _ProdnRsceToolByInternalKey    on  $projection.ProductionResourceType       = _ProdnRsceToolByInternalKey.ProductionResourceType
                                                                                        and $projection.ProductionResourceInternalID = _ProdnRsceToolByInternalKey.ProductionResourceInternalID
  association [1..1] to I_ProdnRsceToolMasterData     as _ProdnRsceToolMasterData       on  $projection.ProductionResourceType       = _ProdnRsceToolMasterData.ProductionResourceType
                                                                                        and $projection.ProductionResourceInternalID = _ProdnRsceToolMasterData.ProductionResourceInternalID
  association [1..1] to I_User                        as _CreatedByUser                 on  $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                        as _LastChangedByUser             on  $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to I_Language                    as _Language                      on  $projection.Language = _Language.Language
  association [0..1] to I_BillOfOperationsType        as _BillOfOperationsType          on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  association [0..1] to I_BillOfOperationsGroup       as _BillOfOperationsGroup         on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                                        and $projection.BillOfOperationsGroup = _BillOfOperationsGroup.BillOfOperationsGroup
  association [0..1] to I_UnitOfMeasure               as _ProdnRsceToolUsageDurnUnit    on  $projection.ProdnRsceToolUsageDurnUnit = _ProdnRsceToolUsageDurnUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _ProdnRsceToolStdWorkQtyUnit   on  $projection.ProdnRsceToolStdWorkQtyUnit = _ProdnRsceToolStdWorkQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _PlannedProdnRsceToolQtyUnit   on  $projection.PlannedProdnRsceToolQtyUnit = _PlannedProdnRsceToolQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _ConfirmedProdnRsceToolQtyUnit on  $projection.ConfirmedProdnRsceToolQtyUnit = _ConfirmedProdnRsceToolQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _RemainingProdnRsceToolQtyUnit on  $projection.RemainingProdnRsceToolQtyUnit = _RemainingProdnRsceToolQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _ProdnRsceToolUsageQtyUnit     on  $projection.ProdnRsceToolUsageQuantityUnit = _ProdnRsceToolUsageQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _PlndProdnRsceToolUsageQtyUnit on  $projection.PlndProdnRsceToolUsageQtyUnit  = _PlndProdnRsceToolUsageQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _ConfdProdnRsceToolUsgeQtyUnit on  $projection.ConfdProdnRsceToolUsageQtyUnit = _ConfdProdnRsceToolUsgeQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure               as _RmngProdnRsceToolUsageQtyUnit on  $projection.RmngProdnRsceToolUsageQtyUnit  = _RmngProdnRsceToolUsageQtyUnit.UnitOfMeasure
{
      // Key

      @ObjectModel.foreignKey.association: '_OrderInternalID'
  key cast(affh.aufpl as pph_aufpl preserving type)           as OrderInternalBillOfOperations,
      @ObjectModel.text.element: ['OrderProdnRsceToolText']
  key affh.pzlfh                                              as OrderProdnRsceToolInternalID,

      // Admin Data

      affh.loekz                                              as IsDeleted,
      @Semantics.systemDate.createdAt: true
      affh.datui                                              as CreationDate,
      @Semantics.user.createdBy: true
      affh.useri                                              as CreatedByUser,
      @Semantics.systemDate.lastChangedAt: true
      affh.datuc                                              as LastChangeDate,
      @Semantics.user.lastChangedBy: true
      affh.userc                                              as LastChangedByUser,

      // Text

      @Semantics.text: true
      affh.txtz1                                              as OrderProdnRsceToolText,
      @ObjectModel.foreignKey.association: '_Language'
      affh.txtsp                                              as Language,

      // Order Data

      @ObjectModel.foreignKey.association: '_Order'
      aufv.aufnr                                              as OrderID,
      @ObjectModel.foreignKey.association: '_OrderCategory'
      cast(aufv.autyp as pph_autyp preserving type)           as OrderCategory,
      @ObjectModel.foreignKey.association: '_OrderType'
      aufv.auart                                              as OrderType,
      @ObjectModel.foreignKey.association: '_Plant'
      aufv.werks                                              as Plant,
      @ObjectModel.foreignKey.association: '_OrderOperation'
      cast(affh.aplzl as operationinternalid preserving type) as OrderIntBillOfOperationsItem,
      // for DCL

      aufv.dispo                                              as MRPController,

      // PRT Data

      @ObjectModel.foreignKey.association: '_ProductionResourceType'
      affh.objty                                              as ProductionResourceType,
      @ObjectModel.foreignKey.association: '_ProdnRsceToolByInternalKey'
      affh.objid                                              as ProductionResourceInternalID,
      @ObjectModel.foreignKey.association: '_ProdnRsceToolControlProfile'
      affh.steuf                                              as ProdnRsceToolControlProfile,
      @ObjectModel.text.element: ['OrderProdnRsceToolText']
      affh.psnfh                                              as ProdnRsceToolItemNumber,
--    @ObjectModel.foreignKey.association:    
      affh.objnr                                              as ObjectInternalID,

      // BOO Data

      @ObjectModel.foreignKey.association: '_BillOfOperationsType'
      affh.plnty_key                                          as BillOfOperationsType,
      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
      affh.plnnr_key                                          as BillOfOperationsGroup,      
      affh.pzlfh_key                                          as BOOOperationPRTInternalID,
      affh.zaehl_key                                          as BOOOperationPRTIntVersCounter,

      // Dates and Times

      @Semantics.calendarItem.dtStart: true
      affh.fsfhd                                              as EarliestSchedldUsageStartDate,
      affh.fsfhz                                              as EarliestSchedldUsageStartTime,
      @Semantics.calendarItem.dtEnd: true
      affh.fefhd                                              as EarliestSchedldUsageEndDate,
      affh.fefhz                                              as EarliestSchedldUsageEndTime,
      @Semantics.calendarItem.dtStart: true
      affh.ssfhd                                              as LatestSchedldUsageStartDate,
      affh.ssfhz                                              as LatestSchedldUsageStartTime,
      @Semantics.calendarItem.dtEnd: true
      affh.sefhd                                              as LatestSchedldUsageEndDate,
      affh.sefhz                                              as LatestSchedldUsageEndTime,
      @Semantics.calendarItem.dtStart: true
      affh.isfhd                                              as ActualUsageStartDate,
      affh.isfhz                                              as ActualUsageStartTime,
      @Semantics.calendarItem.dtEnd: true
      affh.iefhd                                              as ActualUsageEndDate,
      affh.iefhz                                              as ActualUsageEndTime,

      // Duration

      @Semantics.unitOfMeasure: true
      affh.daueh                                              as ProdnRsceToolUsageDurnUnit,
      @Semantics.calendarItem.duration: true
      affh.daufl                                              as ProdnRsceToolUsageDuration,

      // Quantities and UoMs

      @Semantics.unitOfMeasure: true
      affh.mgeinh                                             as ProdnRsceToolStdWorkQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolStdWorkQtyUnit'
      @Aggregation.default: #SUM
      affh.mgvgw                                              as ProdnRsceToolStandardWorkQty,

      @Semantics.unitOfMeasure: true
      cast(affh.mgsoleh as pph_mgsoleh preserving type)       as PlannedProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'PlannedProdnRsceToolQtyUnit'
      @DefaultAggregation: #SUM
      affh.mgsol                                              as PlannedTotalProdnRsceToolQty,

      @Semantics.unitOfMeasure: true
      cast(affh.mgisteh as pph_mgisteh preserving type)       as ConfirmedProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'ConfirmedProdnRsceToolQtyUnit'
      @Aggregation.default: #SUM
      affh.mgist                                              as ConfirmedProdnRsceToolQty,

      @Semantics.unitOfMeasure: true
      cast(affh.mgrsteh as pph_mgrsteh preserving type)       as RemainingProdnRsceToolQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'RemainingProdnRsceToolQtyUnit'
      @Aggregation.default: #SUM
      affh.mgrst                                              as RemainingProdnRsceToolQty,

      // Usage Quantities and UoMs

      @Semantics.unitOfMeasure: true
      affh.eweinh                                             as ProdnRsceToolUsageQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'ProdnRsceToolUsageQuantityUnit'
      @Aggregation.default: #SUM
      affh.ewvgw                                              as ProdnRsceToolUsageQuantity,

      @Semantics.unitOfMeasure: true
      cast(affh.ewsoleh as vdm_ewsoleh preserving type)       as PlndProdnRsceToolUsageQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'PlndProdnRsceToolUsageQtyUnit'
      @Aggregation.default: #SUM
      affh.ewsol                                              as PlannedProdnRsceToolUsageQty,

      @Semantics.unitOfMeasure: true
      cast(affh.ewisteh as vdm_ewisteh preserving type)       as ConfdProdnRsceToolUsageQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'ConfdProdnRsceToolUsageQtyUnit'
      @Aggregation.default: #SUM
      affh.ewist                                              as ConfirmedProdnRsceToolUsageQty,

      @Semantics.unitOfMeasure: true
      cast(affh.ewrsteh as vdm_ewrsteh preserving type)       as RmngProdnRsceToolUsageQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'RmngProdnRsceToolUsageQtyUnit'
      @Aggregation.default: #SUM
      affh.ewrst                                              as RemainingProdnRsceToolUsageQty,

      //Formula

      affh.mgform                                             as ProdnRsceToolTotQtyCalcFormula,
      affh.ewform                                             as ProdnRsceToolUsageQtyCalcFmla,

      affh.registrable                                        as ProdnRsceToolRegnIsAllowed,
      
/*    // Cloud system indicator to switch visibility of User Status

      @UI.hidden: true
      @ObjectModel : {
        readOnly : true,
        virtualElement: true,                            <<<< Virtual Elements are NOT allowed in basic dimension views!
        virtualElementCalculatedBy: 'ABAP:CL_EAM_OBJPG_MNTORD_PHMOD_EXIT'
      } */
      cast( '' as char1 ) as IsCloudSystem,
 
      // Associations

      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: '_OrderInternalID'
      _OrdInternalBillOfOperations,
      _OrderInternalID,
      _Order,
      _OrderCategory,
      _OrderType,
      _OrderOperation,
      _Plant,
      _ProdnRsceToolControlProfile,
      _ProductionResourceType,
      _ProdnRsceToolByInternalKey,
      _ProdnRsceToolMasterData,
      _CreatedByUser,
      _LastChangedByUser,
      _Language,
      _BillOfOperationsType,
      _BillOfOperationsGroup,
      _ProdnRsceToolUsageDurnUnit,
      _ProdnRsceToolStdWorkQtyUnit,
      _PlannedProdnRsceToolQtyUnit,
      _ConfirmedProdnRsceToolQtyUnit,
      _RemainingProdnRsceToolQtyUnit,
      _ProdnRsceToolUsageQtyUnit,
      _PlndProdnRsceToolUsageQtyUnit,
      _ConfdProdnRsceToolUsgeQtyUnit,
      _RmngProdnRsceToolUsageQtyUnit
}
where affh.loekz is initial;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"AFFH",
"CAUFV"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSGROUP",
"I_BILLOFOPERATIONSTYPE",
"I_LANGUAGE",
"I_LOGISTICSORDER",
"I_ORDERCATEGORY",
"I_ORDERINTERNALID",
"I_ORDEROPERATIONBASIC",
"I_ORDERTYPE",
"I_ORDINTERNALBILLOFOPERATIONS",
"I_PLANT",
"I_PRODNRSCETOOLBYINTERNALKEY",
"I_PRODNRSCETOOLCONTROLPROFILE",
"I_PRODNRSCETOOLMASTERDATA",
"I_PRODUCTIONRESOURCETYPE",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/