I_WORKCENTERCAPORDERPERBUCKET

@AbapCatalog.sqlViewName: 'IWCCAPORDER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Load Distribution at shift level for operations'
define view I_WorkCenterCapOrderPerBucket  with parameters
    P_CapEvalStartDate : datum,
    P_CapEvalEndDate   : datum,
    P_CapEvalBucketType  : char1
    
                              
   as select from P_WorkCenterCalcdField  as CapacityPerDailyShift
                                        
    
{
        key CapacityPerDailyShift.Plant,
        key CapacityPerDailyShift.MRPController, 
        key CapacityPerDailyShift.WorkCenter,
        key CapacityPerDailyShift.WorkCenterTypeCode,
        key CapacityPerDailyShift.CapacityCategoryAllocation,
        key CapacityPerDailyShift.CapacityInternalID as CapacityInternalID,
        key CapacityPerDailyShift.Material,
        key CapacityPerDailyShift.OrderID as OrderID,
        key CapacityPerDailyShift.Operation as Operation,
        //key CapacityPerDailyShift.CapacityEvaluationTimePeriod,  

//        key case $parameters.P_CapacityEvalTimePerdCode 

//          when 'D' then

//                 cast(CapacityPerDailyShift.CalendarDate as abap.char(10))

//          when  'W' then 

//                  cast(CapacityPerDailyShift.CalendarWeek as abap.char(10))

//          when  'M' then

//                  cast(CapacityPerDailyShift.CalendarMonth as abap.char(10))

//          when  'Y' then

//                  cast(CapacityPerDailyShift.CalendarYear as abap.char(10))

//          else

//                  cast(CapacityPerDailyShift.CalendarDate as abap.char(10))

//          end   as CapacityEvaluationTimePeriod,  

        key CapacityPerDailyShift.ShiftName as ShiftName,
            cast('' as abap.char(10)) as CapacityEvaluationTimePeriod,
            $parameters.P_CapEvalBucketType as CapEvalBucketType,
                
           
            CapacityPerDailyShift.FactoryCalendar,
            @EndUserText.label: 'Person Responsible'
            CapacityPerDailyShift.WorkCenterResponsible,
            @EndUserText.label: 'Work Center Category'
            CapacityPerDailyShift.WorkCenterCategoryCode,
            @EndUserText.label: 'Work Center Internal ID'
            CapacityPerDailyShift.WorkCenterInternalID,
            @EndUserText.label: 'Requirement Origin'
            CapacityPerDailyShift.CapacityRequirementOrigin,
            @EndUserText.label: 'Requirement Origin Unit'
            CapacityPerDailyShift.CapacityRequirementUnit,
            @EndUserText.label: 'Order Type'    
            CapacityPerDailyShift.OrderType,
            @EndUserText.label: 'Order Category'    
            CapacityPerDailyShift.OrderCategory,
            @EndUserText.label: 'Order Quantity'
            @Semantics.quantity.unitOfMeasure: 'BaseUnit'
            CapacityPerDailyShift.OrderPlannedTotalQty,
            CapacityPerDailyShift.BaseUnit,
            @EndUserText.label: 'Source Of Supply'
            CapacityPerDailyShift.ProductionVersion,
            @EndUserText.label: 'Operation Planning Status Code' 
            CapacityPerDailyShift.OperationPlanningStatusCode,
            @EndUserText.label: 'Latest Start Date' 
            CapacityPerDailyShift.OperationLatestStartDate,
            @EndUserText.label: 'Latest Start Time'
            CapacityPerDailyShift.OperationLatestStartTime,
            @EndUserText.label: 'Latest End Date'
            CapacityPerDailyShift.OperationLatestEndDate,
            @EndUserText.label: 'Latest End Time'
            CapacityPerDailyShift.OperationLatestEndTime,
            @EndUserText.label: 'Order Status Code'
            CapacityPerDailyShift.OrderStatusCode,
            @EndUserText.label: 'Firming Status Code'
            CapacityPerDailyShift.OrderFirmingStatusCode,
            @EndUserText.label: 'Scheduled Start Processing Time' 
            CapacityPerDailyShift.OpLtstSchedldProcgStrtDte,
            @EndUserText.label: 'Scheduled End Processing Time' 
            CapacityPerDailyShift.OpLtstSchedldProcgStrtTme,
            @EndUserText.label: 'Scheduled Start Teardown Time'
            CapacityPerDailyShift.OpLtstSchedldTrdwnStrtDte,
            @EndUserText.label: 'Scheduled End teardown Time'
            CapacityPerDailyShift.OpLtstSchedldTrdwnStrtTme,
            @EndUserText.label: 'Remaining Setup Duration'
            CapacityPerDailyShift.RemainingCapReqOpSegSetupDurn,
            @EndUserText.label: 'Remaining processing Duration'
            CapacityPerDailyShift.RemainingCapReqOpSegProcgDurn,
            @EndUserText.label: 'Remaining Teardown Duration'
            CapacityPerDailyShift.RemainingCapReqOpSegTrdwnDurn,
            @EndUserText.label: 'Order Internal ID'
            CapacityPerDailyShift.OrderInternalID, 
            
            @EndUserText.label:  'Capacity Start Time' 
           cast(CapacityPerDailyShift.CapacityStartTime as abap.dec(10,2) ) as CapacityStartTime,
            
            @EndUserText.label:  'Capacity End Time' 
            cast(CapacityPerDailyShift.CapacityEndTime as abap.dec(10,2) ) as CapacityEndTime,
            
//            CapacityPerDailyShift.WorkCenterInternalID,

            @EndUserText.label: 'Available Capacity'
            @Semantics.quantity.unitOfMeasure: 'WorkcenterCapacityUnit'
            cast(0 as abap.dec(10,2)) as WorkCenterAvailableCapacity,
            @EndUserText.label: 'Consumed Capacity'
            cast(0 as abap.dec(10,2)) as WorkCenterCapRqmtInCapUnit,
            @EndUserText.label: 'Work Center Capacity Unit'
            cast ('H' as meins) as  WorkCenterCapacityUnit
            //@EndUserText.label: 'Work Center Capacity Unit Text'

            //CapacityPerDailyShift.WorkCenterCapUnitText

}