C_WorkCenterCapOrderPerBucket

DDL: C_WORKCENTERCAPORDERPERBUCKET Type: view_entity CONSUMPTION Package: ODATA_PP_CAP_EVAL

Load Distribution at shift level for operations

C_WorkCenterCapOrderPerBucket is a Consumption CDS View that provides data about "Load Distribution at shift level for operations" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapOrderPerBucket) and exposes 49 fields with key fields WorkCenterInternalID, WorkCenterTypeCode, CapacityCategoryAllocation, CapacityInternalID, Material. It has 10 associations to related views. Part of development package ODATA_PP_CAP_EVAL.

1 data source(s) 49 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterCapOrderPerBucket I_WorkCenterCapOrderPerBucket from

Parameters (3)

NameTypeDefault
P_CapEvalStartDate datum
P_CapEvalEndDate datum
P_CapEvalBucketType char1

Associations (10)

CardinalityTargetAliasCondition
[0..*] I_WorkCenterText _WorkCenterText $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode
[0..*] I_PlannedOrderTypeText _PlannedOrderText $projection.OrderType = _PlannedOrderText.PlannedOrderType
[0..*] I_OrderTypeText _WorkOrderText $projection.OrderType = _WorkOrderText.OrderType
[0..*] I_CapEvalCapRqmtStsText _OprPlanningText $projection.OperationPlanningStatusCode = _OprPlanningText.CapacityRequirementStatusCode
[0..*] I_SystemStatusText _OrderStatusText $projection.OrderStatusCode = _OrderStatusText.SystemStatus
[0..*] I_CapEvalFirmingStsText _FirmingStatusText $projection.OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode
[0..*] I_CapEvalBucketTypeText _BucketTypeText $projection.CapEvalBucketType = _BucketTypeText.CapEvalBucketTypeCode
[0..*] I_UnitOfMeasureText _UOMText $projection.WorkCenterCapacityUnit = _UOMText.UnitOfMeasure
[0..*] I_OrderCategoryText _WorkOrderCategoryText $projection.OrderCategory = _WorkOrderCategoryText.OrderCategory
[0..*] I_PlannedOrderCategoryText _PlannedOrderCategoryText $projection.OrderCategory = _PlannedOrderCategoryText.PlannedOrderCategory

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Load Distribution at shift level for operations view

Fields (49)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID CapacityPerDailyShift WorkCenterInternalID Work Center Internal ID
KEY WorkCenterTypeCode CapacityPerDailyShift WorkCenterTypeCode
KEY CapacityCategoryAllocation CapacityPerDailyShift CapacityCategoryAllocation
KEY CapacityInternalID CapacityPerDailyShift CapacityInternalID
KEY Material CapacityPerDailyShift Material
KEY OrderID CapacityPerDailyShift OrderID
KEY Operation CapacityPerDailyShift Operation
KEY CapacityEvaluationTimePeriod CapacityPerDailyShift CapacityEvaluationTimePeriod
KEY ShiftName CapacityPerDailyShift ShiftName
Plant CapacityPerDailyShift Plant
MRPController CapacityPerDailyShift MRPController
WorkCenter CapacityPerDailyShift WorkCenter
CapEvalBucketType CapacityPerDailyShift CapEvalBucketType
CapacityEvaluationTimePerdText Bucket Type Text
FactoryCalendar CapacityPerDailyShift FactoryCalendar
WorkCenterDesc WorkCenter Description
WorkCenterResponsible CapacityPerDailyShift WorkCenterResponsible Person Responsible
WorkCenterCategoryCode CapacityPerDailyShift WorkCenterCategoryCode Work Center Category
CapacityRequirementOrigin CapacityPerDailyShift CapacityRequirementOrigin Requirement Origin
CapacityRequirementUnit CapacityPerDailyShift CapacityRequirementUnit Requirement Origin Unit
OrderType CapacityPerDailyShift OrderType Order Type
BaseUnit
OrderPlannedTotalQty CapacityPerDailyShift OrderPlannedTotalQty Order Quantity
OrderCategory CapacityPerDailyShift OrderCategory Order Category
ProductionVersion CapacityPerDailyShift ProductionVersion Source Of Supply
OperationPlanningStatusText Operation Planning Status
OperationPlanningStatusCode CapacityPerDailyShift OperationPlanningStatusCode Operation Planning Status Code
OperationLatestStartDate CapacityPerDailyShift OperationLatestStartDate Latest Start Date
OperationLatestStartTime CapacityPerDailyShift OperationLatestStartTime Latest Start Time
OperationLatestEndDate CapacityPerDailyShift OperationLatestEndDate Latest End Date
OperationLatestEndTime CapacityPerDailyShift OperationLatestEndTime Latest End Time
OrderStatusText Order Status
OrderStatusCode CapacityPerDailyShift OrderStatusCode Order Status Code
OrderFirmingStatusCode CapacityPerDailyShift OrderFirmingStatusCode Firming Status Code
OrderFirmingStatusText Firming Status Text
OpLtstSchedldProcgStrtDte CapacityPerDailyShift OpLtstSchedldProcgStrtDte Scheduled Start Processing Time
OpLtstSchedldProcgStrtTme CapacityPerDailyShift OpLtstSchedldProcgStrtTme Scheduled End Processing Time
OpLtstSchedldTrdwnStrtDte CapacityPerDailyShift OpLtstSchedldTrdwnStrtDte Scheduled Start Teardown Time
OpLtstSchedldTrdwnStrtTme CapacityPerDailyShift OpLtstSchedldTrdwnStrtTme Scheduled End teardown Time
RemainingCapReqOpSegSetupDurn CapacityPerDailyShift RemainingCapReqOpSegSetupDurn Remaining Setup Duration
RemainingCapReqOpSegProcgDurn CapacityPerDailyShift RemainingCapReqOpSegProcgDurn Remaining processing Duration
RemainingCapReqOpSegTrdwnDurn CapacityPerDailyShift RemainingCapReqOpSegTrdwnDurn Remaining Teardown Duration
OrderInternalID CapacityPerDailyShift OrderInternalID Order Internal ID
CapacityStartTime CapacityPerDailyShift CapacityStartTime Capacity Start Time
CapacityEndTime CapacityPerDailyShift CapacityEndTime Capacity End Time
WorkCenterAvailableCapacity CapacityPerDailyShift WorkCenterAvailableCapacity Available Capacity
WorkCenterCapRqmtInCapUnit CapacityPerDailyShift WorkCenterCapRqmtInCapUnit Consumed Capacity
WorkCenterCapacityUnit CapacityPerDailyShift WorkCenterCapacityUnit Work Center Capacity Unit
WorkCenterCapUnitText Work Center Capacity Unit Text 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality:#D, sizeCategory: #XL, dataClass: #TRANSACTIONAL}
@VDM.viewType: #CONSUMPTION
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Load Distribution at shift level for operations'
define view entity C_WorkCenterCapOrderPerBucket  with parameters
//        @Consumption.hidden: false

//        @Consumption.derivation: { lookupEntity: 'I_DEFAULTPARAMVALUES',

//                                   resultElement: 'StartDate',

//                        binding: [{ targetParameter: 'P_StartDate',type:#PARAMETER,value:'P_StartDate' },

//                                  { targetParameter: 'P_EndDate',type:#PARAMETER,value:'P_EndDate' },

//                                  { targetParameter: 'P_Bucket',type:#PARAMETER,value:'P_Bucket' }]}

        P_CapEvalStartDate : datum,
//        @Consumption.hidden: false

//        @Consumption.derivation: { lookupEntity: 'I_DEFAULTPARAMVALUES',

//                                   resultElement: 'EndDate',

//                        binding: [{ targetParameter: 'P_StartDate',type:#PARAMETER,value:'P_StartDate' },

//                                  { targetParameter: 'P_EndDate',type:#PARAMETER,value:'P_EndDate' },

//                                  { targetParameter: 'P_Bucket',type:#PARAMETER,value:'P_Bucket' }]}

        P_CapEvalEndDate   : datum,
//        @Consumption.hidden: false

//        @Consumption.derivation: { lookupEntity: 'I_DEFAULTPARAMVALUES',

//                                   resultElement: 'Bucket',

//                        binding: [{ targetParameter: 'P_StartDate',type:#PARAMETER,value:'P_StartDate' },

//                                  { targetParameter: 'P_EndDate',type:#PARAMETER,value:'P_EndDate' },

//                                  { targetParameter: 'P_Bucket',type:#PARAMETER,value:'P_Bucket' }]}

        P_CapEvalBucketType  : char1
    
        as select from I_WorkCenterCapOrderPerBucket( P_CapEvalStartDate : $parameters.P_CapEvalStartDate, 
                                       P_CapEvalEndDate : $parameters.P_CapEvalEndDate,
                                         P_CapEvalBucketType : $parameters. P_CapEvalBucketType)  as CapacityPerDailyShift     
//        inner join I_CapEvalByAreaOfRespy(P_CapacityPlanningEndDate: $parameters.P_CapEvalEndDate) as AOR

//                    on AOR.CapacityInternalID = CapacityPerDailyShift.CapacityInternalID

//                    and AOR.WorkCenter = CapacityPerDailyShift.WorkCenter

//                    and AOR.Plant = CapacityPerDailyShift.Plant


          association [0..*] to I_WorkCenterText             as _WorkCenterText                       on  $projection.WorkCenterInternalID = _WorkCenterText.WorkCenterInternalID
                                                                                                         and $projection.WorkCenterTypeCode = _WorkCenterText.WorkCenterTypeCode 
             association [0..*] to I_PlannedOrderTypeText as _PlannedOrderText on $projection.OrderType = _PlannedOrderText.PlannedOrderType
             association [0..*] to I_OrderTypeText as _WorkOrderText          on $projection.OrderType = _WorkOrderText.OrderType
             association [0..*] to I_CapEvalCapRqmtStsText as _OprPlanningText          on $projection.OperationPlanningStatusCode = _OprPlanningText.CapacityRequirementStatusCode
             association [0..*] to I_SystemStatusText as _OrderStatusText          on $projection.OrderStatusCode = _OrderStatusText.SystemStatus
             association [0..*] to I_CapEvalFirmingStsText as _FirmingStatusText          on $projection.OrderFirmingStatusCode = _FirmingStatusText.OrderFirmingStatusCode
              association [0..*] to I_CapEvalBucketTypeText as _BucketTypeText          on $projection.CapEvalBucketType = _BucketTypeText.CapEvalBucketTypeCode
              association [0..*] to I_UnitOfMeasureText as _UOMText on $projection.WorkCenterCapacityUnit = _UOMText.UnitOfMeasure
              association [0..*] to I_OrderCategoryText as _WorkOrderCategoryText on $projection.OrderCategory = _WorkOrderCategoryText.OrderCategory
             association [0..*] to I_PlannedOrderCategoryText as _PlannedOrderCategoryText on $projection.OrderCategory = _PlannedOrderCategoryText.PlannedOrderCategory
              
                                        
{
        @EndUserText.label: 'Work Center Internal ID'
        key CapacityPerDailyShift.WorkCenterInternalID as WorkCenterInternalID,
        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 CapacityPerDailyShift.ShiftName as ShiftName,
            CapacityPerDailyShift.Plant,
            CapacityPerDailyShift.MRPController, 
            CapacityPerDailyShift.WorkCenter,
            CapacityPerDailyShift.CapEvalBucketType,
            
             @EndUserText.label:  'Bucket Type Text'
             _BucketTypeText[1:Language=$session.system_language].CapEvalBucketTypeText as CapacityEvaluationTimePerdText,
             
            
            
            CapacityPerDailyShift.FactoryCalendar,
            
             @EndUserText.label: 'WorkCenter Description'
            _WorkCenterText[1:Language=$session.system_language].WorkCenterText as WorkCenterDesc,
            @EndUserText.label: 'Person Responsible'
            CapacityPerDailyShift.WorkCenterResponsible,
            @EndUserText.label: 'Work Center Category'
            CapacityPerDailyShift.WorkCenterCategoryCode,
            @EndUserText.label: 'Requirement Origin'
            CapacityPerDailyShift.CapacityRequirementOrigin,
            @EndUserText.label: 'Requirement Origin Unit'
            CapacityPerDailyShift.CapacityRequirementUnit,
            @EndUserText.label: 'Order Type'    
            CapacityPerDailyShift.OrderType,
            @EndUserText.label: 'Order Type Name'
             case CapacityPerDailyShift.CapacityRequirementOrigin
            when '1'
                  then _WorkOrderText[1:Language=$session.system_language].OrderTypeName
            when '2'
                  then _PlannedOrderText[1:Language=$session.system_language].PlannedOrderTypeName
            else ''
            end  as   OrderTypeName,
        @ObjectModel.readOnly: true
        cast(CapacityPerDailyShift.BaseUnit as meins) as BaseUnit,
            @EndUserText.label: 'Order Quantity'
             @Semantics.quantity.unitOfMeasure: 'BaseUnit'
            CapacityPerDailyShift.OrderPlannedTotalQty,
            
             @EndUserText.label: 'Order Category'
        CapacityPerDailyShift.OrderCategory,
        @EndUserText.label: 'Order Category Name'
         case CapacityPerDailyShift.CapacityRequirementOrigin
            when '1'
                  then _WorkOrderCategoryText[1:Language=$session.system_language].OrderCategoryName
            when '2'
                  then _PlannedOrderCategoryText[1:Language=$session.system_language].PlannedOrderCategoryName
            else ''
            end  as   OrderCategoryName,
            @EndUserText.label: 'Source Of Supply'
            CapacityPerDailyShift.ProductionVersion,
            @EndUserText.label: 'Operation Planning Status' 
            _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText as OperationPlanningStatusText,
            @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'
            _OrderStatusText[1:Language=$session.system_language].SystemStatusName as OrderStatusText,
            @EndUserText.label: 'Order Status Code'
            CapacityPerDailyShift.OrderStatusCode,
            @EndUserText.label: 'Firming Status Code'
            CapacityPerDailyShift.OrderFirmingStatusCode,
            
            @EndUserText.label: 'Firming Status Text'
            _FirmingStatusText[1:Language=$session.system_language].OrderFirmingStatusText as OrderFirmingStatusText,
            @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'
            @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
            CapacityPerDailyShift.RemainingCapReqOpSegSetupDurn,
            @EndUserText.label: 'Remaining processing Duration'
            @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
            CapacityPerDailyShift.RemainingCapReqOpSegProcgDurn,
            @EndUserText.label: 'Remaining Teardown Duration'
            @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
            CapacityPerDailyShift.RemainingCapReqOpSegTrdwnDurn,
            @EndUserText.label: 'Order Internal ID'
            CapacityPerDailyShift.OrderInternalID, 
            
            @EndUserText.label:  'Capacity Start Time' 
            CapacityPerDailyShift.CapacityStartTime,
            
            @EndUserText.label:  'Capacity End Time' 
            CapacityPerDailyShift.CapacityEndTime,
            
//            CapacityPerDailyShift.WorkCenterInternalID,

            @EndUserText.label: 'Available Capacity'
            @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
            CapacityPerDailyShift.WorkCenterAvailableCapacity,
            @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
            @EndUserText.label: 'Consumed Capacity'
            CapacityPerDailyShift.WorkCenterCapRqmtInCapUnit,
            @EndUserText.label: 'Work Center Capacity Unit'
            CapacityPerDailyShift.WorkCenterCapacityUnit,
            @EndUserText.label: 'Work Center Capacity Unit Text'
            _UOMText[1:Language=$session.system_language].UnitOfMeasureName as WorkCenterCapUnitText
}

Learn More