I_SCHEDCAPACITYRQMTITEMCAP

@AbapCatalog.sqlViewName: 'ISCHEDCAPITMCAP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_StatusObjectStatus', '_OrderStatusObjectStatus']
//@Analytics.dataCategory: #DIMENSION

@ClientHandling.algorithm: #SESSION_VARIABLE
//@Metadata.allowExtensions: true

@Metadata.ignorePropagatedAnnotations: true 
//@ObjectModel.representativeKey: 'CapacityRqmtItemCapacity'

@ObjectModel.semanticKey: ['CapacityRequirement', 'CapacityRequirementItem', 'CapacityRqmtItemCapacity']
@ObjectModel.usageType: {serviceQuality: #B, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.viewType: #BASIC
@EndUserText.label: 'Capacity Requirement Item Capacity'
/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK", "CARDINALITY_CHECK" ]  } */
define view I_SchedCapacityRqmtItemCap

  as select from           kbed as kbed
    left outer to one join kbez as kbez on  kbed.bedid = kbez.bedid 
                                        and kbed.bedzl = kbez.bedzl
                                        and kbed.canum = kbez.canum
//    left outer to one join afko as afko on  kbed.aufpl = afko.aufpl 

//                                        and kbed.aufpl > '0000000000'


//  association [1..1] to I_CapacityRequirement          as _CapacityRequirement          on  $projection.CapacityRequirement = _CapacityRequirement.CapacityRequirement

//  association [1..1] to I_CapacityRequirementItem      as _CapacityRequirementItem      on  $projection.CapacityRequirement     = _CapacityRequirementItem.CapacityRequirement

//                                                                                        and $projection.CapacityRequirementItem = _CapacityRequirementItem.CapacityRequirementItem

//  association [1..1] to I_CapacityRequirementConf      as _CapacityRequirementConf      on  $projection.CapacityRqmtConfirmation= _CapacityRequirementConf.CapacityRqmtConfirmation

//  association [1..1] to I_Capacity                     as _Capacity                     on  $projection.CapacityInternalID = _Capacity.CapacityInternalID

//  association [0..1] to I_WorkCenter                   as _WorkCenter                   on  $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode 

//                                                                                        and $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID

//  association [1..1] to I_WorkCenterType               as _WorkCenterType               on  $projection.WorkCenterTypeCode = _WorkCenterType.WorkCenterTypeCode

//  association [0..1] to I_PlannedOrder                 as _PlannedOrder                 on  $projection.PlannedOrder = _PlannedOrder.PlannedOrder

//  association [0..1] to I_OrderInternalID              as _OrderInternalID              on  $projection.OrderInternalID = _OrderInternalID.OrderInternalID

//  association [0..1] to I_LogisticsOrder               as _Order                        on  $projection.OrderID = _Order.OrderID

 //  association [0..1] to I_LogisticsOrder               as _Order                       on  $projection.CapacityRequirement = _Order.CapacityRequirement

//  association [0..1] to I_OrderItem                    as _OrderItem                    on  $projection.OrderID  = _OrderItem.OrderID

//                                                                                        and _OrderItem.OrderItem = '0001'

//  association [0..1] to I_OrderOperation               as _OrderOperation               on  $projection.OrderInternalID          = _OrderOperation.OrderInternalID

//                                                                                        and $projection.OrderOperationInternalID = _OrderOperation.OrderOperationInternalID

//  association [0..1] to I_SalesOperationsPlanningOrder as _SalesOperationsPlanningOrder on  $projection.SalesOperationsPlanningOrder= _SalesOperationsPlanningOrder.SalesOperationsPlanningOrder

//  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_BillOfOperations             as _BillOfOperations             on  $projection.BillOfOperationsType  = _BillOfOperations.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup

//                                                                                        and $projection.BillOfOperations      = _BillOfOperations.BillOfOperationsVariant

//  association [0..1] to I_BillOfOperationsChangeState  as _BillOfOperationsChangeState  on  $projection.BillOfOperationsType          = _BillOfOperationsChangeState.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup         = _BillOfOperationsChangeState.BillOfOperationsGroup

//                                                                                        and $projection.BillOfOperations              = _BillOfOperationsChangeState.BillOfOperationsVariant

//                                                                                        and $projection.BillOfOperationsChangeStateID = _BillOfOperationsChangeState.BOOInternalVersionCounter

//  association [0..1] to I_MfgBillOfOperationsSequence  as _BillOfOperationsSequence     on  $projection.BillOfOperationsType     = _BillOfOperationsSequence.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup    = _BillOfOperationsSequence.BillOfOperationsGroup

//                                                                                        and $projection.BillOfOperations         = _BillOfOperationsSequence.BillOfOperationsVariant

//                                                                                        and $projection.BillOfOperationsSequence = _BillOfOperationsSequence.BillOfOperationsSequence

//  association [0..1] to I_BOOOperationInternalID       as _BOOOperationInternalID       on  $projection.BillOfOperationsType   = _BOOOperationInternalID.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup  = _BOOOperationInternalID.BillOfOperationsGroup

//                                                                                        and $projection.BOOOperationInternalID = _BOOOperationInternalID.BOOOperationInternalID

//  association [0..1] to I_BillOfOperationsOpBasic      as _BOOOperationInternalVersion  on  $projection.BillOfOperationsType        = _BOOOperationInternalVersion.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup       = _BOOOperationInternalVersion.BillOfOperationsGroup

//                                                                                        and $projection.BOOOperationInternalID      = _BOOOperationInternalVersion.BOOOperationInternalID

//                                                                                        and $projection.BOOOpInternalVersionCounter = _BOOOperationInternalVersion.BOOOpInternalVersionCounter

//  association [0..1] to I_BOOOperationInternalID       as _BOOSubOperationInternalID    on  $projection.BillOfOperationsType      = _BOOSubOperationInternalID.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup     = _BOOSubOperationInternalID.BillOfOperationsGroup

//                                                                                        and $projection.BOOSubOperationInternalID = _BOOSubOperationInternalID.BOOOperationInternalID

//  association [0..1] to I_BillOfOperationsOpBasic      as _BOOSubOperationInternalVers  on  $projection.BillOfOperationsType           = _BOOSubOperationInternalVers.BillOfOperationsType

//                                                                                        and $projection.BillOfOperationsGroup          = _BOOSubOperationInternalVers.BillOfOperationsGroup

//                                                                                        and $projection.BOOSubOperationInternalID      = _BOOSubOperationInternalVers.BOOOperationInternalID

//                                                                                        and $projection.BOOSubOperationInternalVersion = _BOOSubOperationInternalVers.BOOOpInternalVersionCounter

//  association [0..1] to I_Employee                     as _Employee                     on  $projection.PersonnelNumber = _Employee.Employee

//  association [0..1] to I_Employment                   as _Employment                   on  $projection.PersonnelNumber = _Employment.EmploymentInternalID

//  association [0..1] to I_StatusObjectStatus           as _StatusObjectStatus           on  $projection.ObjectInternalID = _StatusObjectStatus.StatusObject 

//                                                                                        and _StatusObjectStatus.StatusCode = 'I0117'

//  association [0..1] to I_StatusObjectStatus           as _OrderStatusObjectStatus      on  $projection.OrderObjectInternalID = _OrderStatusObjectStatus.StatusObject 

//                                                                                        and _OrderStatusObjectStatus.StatusCode = 'I0117'

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit1            on  $projection.StandardWorkQuantityUnit1 = _WorkQuantityUnit1.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit2            on  $projection.StandardWorkQuantityUnit2 = _WorkQuantityUnit2.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit3            on  $projection.StandardWorkQuantityUnit3 = _WorkQuantityUnit3.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit4            on  $projection.StandardWorkQuantityUnit4 = _WorkQuantityUnit4.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit5            on  $projection.StandardWorkQuantityUnit5 = _WorkQuantityUnit5.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _WorkQuantityUnit6            on  $projection.StandardWorkQuantityUnit6 = _WorkQuantityUnit6.UnitOfMeasure

//  association [0..1] to I_UnitOfMeasure                as _UnitOfMeasure                on  $projection.CapacityRequirementUnit = _UnitOfMeasure.UnitOfMeasure

{
      // Key

  //    @ObjectModel.foreignKey.association: '_CapacityRequirement'

  key kbed.bedid as CapacityRequirement,
 //     @ObjectModel.foreignKey.association: '_CapacityRequirementItem'

  key cast(kbed.bedzl as pph_bedzl preserving type) as CapacityRequirementItem,
  key cast(kbed.canum as pph_canum preserving type) as CapacityRqmtItemCapacity,

//    key kbed.canum as CapacityCategoryAllocation,


      // Assignments

//      @ObjectModel.foreignKey.association: '_CapacityRequirementConf'    

      kbed.bstkz as CapacityRqmtConfirmation,
//      @ObjectModel.foreignKey.association: '_WorkCenter'

      kbed.arbid as WorkCenterInternalID,
//      @ObjectModel.foreignKey.association: '_WorkCenterType'

//      cast('A' as pph_arbty preserving type)                  as WorkCenterTypeCode,

      cast('A' as cr_objty )                  as WorkCenterTypeCode,
//      @ObjectModel.foreignKey.association: '_Capacity'

      kbed.kapid as CapacityInternalID,
//      @ObjectModel.foreignKey.association: '_PlannedOrder'

      kbed.plnum as PlannedOrder,
//      @ObjectModel.foreignKey.association: '_OrderInternalID'

      cast(kbed.aufpl as pph_aufpl preserving type)           as OrderInternalID,
 //     @ObjectModel.foreignKey.association: '_Order'

//      afko.aufnr as OrderID,

//      _Order.OrderID as OrderID,

//      @ObjectModel.foreignKey.association: '_OrderOperation'

      cast(kbed.aplzl as operationinternalid preserving type) as OrderOperationInternalID,
      kbed.vornr as Operation,
//      @ObjectModel.foreignKey.association: '_SalesOperationsPlanningOrder'

      kbed.safnr as SalesOperationsPlanningOrder,
//      @ObjectModel.foreignKey.association: '_Employment'

      kbed.pernr as PersonnelNumber,
      kbed.kpver as CapacityRequirementDistrKey,
      @Semantics.booleanIndicator: true
      kbed.phase_kz as OperationIsPhase,
      cast(kbed.bedzlf as pph_sumnr preserving type)          as SuperiorOperationInternalID,

      // Assignments BOO Header

//      @ObjectModel.foreignKey.association: '_BillOfOperationsType'

      cast(kbed.plnty as billofoperationstype    preserving type)  as BillOfOperationsType,
//      @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'

      cast(kbed.plnnr as billofoperations        preserving type)  as BillOfOperationsGroup,
//      @ObjectModel.foreignKey.association: '_BillOfOperations'

//      cast(kbed.plnal as billofoperationsvariant preserving type)  as BillOfOperations,

//      @ObjectModel.foreignKey.association: '_BillOfOperationsChangeState'

      cast(kbed.zaehl as billofoperationschgstate preserving type) as BillOfOperationsChangeStateID,
      // Assignments BOO Sequence

//      @ObjectModel.foreignKey.association: '_BillOfOperationsSequence'

      kbed.plnfl                                                   as BillOfOperationsSequence,
      // Assignments BOO Operation

//      @ObjectModel.foreignKey.association: '_BOOOperationInternalID'

      kbed.plnkn                                                   as BOOOperationInternalID,
//      @ObjectModel.foreignKey.association: '_BOOOperationInternalVersion'

      kbed.zaehp                                                   as BOOOpInternalVersionCounter,
      // Assignments BOO SubOperation

//      @ObjectModel.foreignKey.association: '_BOOSubOperationInternalID'

      kbed.splkn                                                   as BOOSubOperationInternalID,
//      @ObjectModel.foreignKey.association: '_BOOSubOperationInternalVers'

      kbed.szaehl                                                  as BOOSubOperationInternalVersion,

      // Capacity Durations

   //   @Semantics.unitOfMeasure: true

      kbed.keinh    as CapacityRequirementUnit,
      kbed.kruesoll as ScheduledCapReqOpSegSetupDurn,
      kbed.kruerest as RemainingCapReqOpSegSetupDurn,
      kbed.kbeasoll as ScheduledCapReqOpSegProcgDurn,
      kbed.kbearest as RemainingCapReqOpSegProcgDurn,
      kbed.kabrsoll as ScheduledCapReqOpSegTrdwnDurn,
      kbed.kabrrest as RemainingCapReqOpSegTrdwnDurn,

      // Dates and Times

      kbed.fstad as OperationEarliestStartDate,
      kbed.fstau as OperationEarliestStartTime,
      kbed.fendd as OperationEarliestEndDate,
      kbed.fendu as OperationEarliestEndTime,
      kbed.sstad as OperationLatestStartDate,
      kbed.sstau as OperationLatestStartTime,
      kbed.sendd as OperationLatestEndDate,
      kbed.sendu as OperationLatestEndTime,
      kbed.istad as ActualStartDate,
      kbed.istau as ActualStartTime,
      kbed.iendd as ActualEndDate,
      kbed.iendu as ActualEndTime,
      cast(kbed.pendd as pph_pedd preserving type)  as ActualForecastEndDate,
      cast(kbed.pendu as pph_pedz preserving type)  as ActualForecastEndTime,

      // Time Events

      cast(kbed.fssbd as pph_fssbd preserving type) as ErlstSchedldProcStrtDte,
      cast(kbed.fssbz as pph_fssbz preserving type) as ErlstSchedldProcStrtTime,
      cast(kbed.fssad as pph_fssad preserving type) as ErlstSchedldTrdwnStrtDte,
      cast(kbed.fssaz as pph_fssaz preserving type) as ErlstSchedldTrdwnStrtTime,
      cast(kbed.sssbd as pph_sssbd preserving type) as LtstSchedldProcStrtDte,
      cast(kbed.sssbz as pph_sssbz preserving type) as LtstSchedldProcStrtTime,
      cast(kbed.sssad as pph_sssad preserving type) as LtstSchedldTrdwnStrtDte,
      cast(kbed.sssaz as pph_sssaz preserving type) as LtstSchedldTrdwnStrtTime,

      // Split data

      kbed.ispli                                    as ActualNumberOfSplits,
   //   cast(kbed.split as pph_split preserving type) as CapacityRequirementSplit,

 //     kbed.split  as CapacityRequirementSplit,

      
      // Object status 

      kbed.kbsta                                    as ObjectInternalID,
      cast(kbed.obsta as pph_obsta preserving type) as OrderObjectInternalID,

      // Work Quantities 1-6

      cast(kbez.vge01 as pph_vge01 preserving type) as StandardWorkQuantityUnit1,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit1'
      @DefaultAggregation: #SUM
      cast(kbez.vgw01 as vdm_vgw01 preserving type) as StandardWorkQuantity1,
      @Semantics.unitOfMeasure: true
      cast(kbez.vge02 as pph_vge02 preserving type) as StandardWorkQuantityUnit2,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit2'
      @DefaultAggregation: #SUM
      cast(kbez.vgw02 as vdm_vgw02 preserving type) as StandardWorkQuantity2,
      @Semantics.unitOfMeasure: true
      cast(kbez.vge03 as pph_vge03 preserving type) as StandardWorkQuantityUnit3,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit3'
      @DefaultAggregation: #SUM
      cast(kbez.vgw03 as vdm_vgw03 preserving type) as StandardWorkQuantity3,
      @Semantics.unitOfMeasure: true
      cast(kbez.vge04 as pph_vge04 preserving type) as StandardWorkQuantityUnit4,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit4'
      @DefaultAggregation: #SUM
      cast(kbez.vgw04 as vdm_vgw04 preserving type) as StandardWorkQuantity4,
      @Semantics.unitOfMeasure: true
      cast(kbez.vge05 as pph_vge05 preserving type) as StandardWorkQuantityUnit5,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit5'
      @DefaultAggregation: #SUM
      cast(kbez.vgw05 as vdm_vgw05 preserving type) as StandardWorkQuantity5,
      @Semantics.unitOfMeasure: true
      cast(kbez.vge06 as pph_vge06 preserving type) as StandardWorkQuantityUnit6,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit6'
      @DefaultAggregation: #SUM
      cast(kbez.vgw06 as vdm_vgw06 preserving type) as StandardWorkQuantity6,         

      // Work Quantity PM & PS

      @Semantics.unitOfMeasure: true
      kbez.arbeh as StandardWorkQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit'
      @DefaultAggregation: #SUM
      kbez.arbei as PlannedWorkQuantity,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit'
      @DefaultAggregation: #SUM
      kbez.ismnw as ActualWorkQuantity,
      @Semantics.quantity.unitOfMeasure: 'StandardWorkQuantityUnit'
      @DefaultAggregation: #SUM
      kbez.ofmnw as ForecastedWorkQty

      // Associations

//      _CapacityRequirement,

//      _CapacityRequirementItem,

//      _CapacityRequirementConf,

//      _Capacity,

//      _PlannedOrder,

 //     _Order

//      _OrderItem,

//      _OrderOperation,

//      @Consumption.hidden: true

//      _OrderInternalID,

//      _SalesOperationsPlanningOrder,

//      _Employee,

//      _Employment,

//      _WorkCenter,

//      @Consumption.hidden: true

//      _WorkCenterType,

//      _BillOfOperationsType,

//      _BillOfOperationsGroup,

//      _BillOfOperations,

//      _BillOfOperationsChangeState,

//      _BillOfOperationsSequence,

//      @Consumption.hidden: true

//      _BOOOperationInternalID,

//      _BOOOperationInternalVersion,

//      @Consumption.hidden: true

//      _BOOSubOperationInternalID,

//      _BOOSubOperationInternalVers,

//      _StatusObjectStatus,

//      _OrderStatusObjectStatus,

//      _WorkQuantityUnit1,

//      _WorkQuantityUnit2,

//      _WorkQuantityUnit3,

//      _WorkQuantityUnit4,

//      _WorkQuantityUnit5,

//      _WorkQuantityUnit6,

//      _UnitOfMeasure

};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KBED",
"KBEZ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/