Which tables does A_WorkCenterCapOrderPerBucket use?

A_WorkCenterCapOrderPerBucket reads from 1 data source(s): I_WorkCenterCapOrderPerBucket.

A_WorkCenterCapOrderPerBucket

Q: How many fields does A_WorkCenterCapOrderPerBucket have?

A_WorkCenterCapOrderPerBucket has 49 fields. Key fields: Plant, MRPController, WorkCenter, WorkCenterTypeCode, CapacityCategoryAllocation.

DDL: A_WORKCENTERCAPORDERPERBUCKET SQL: AWCCAPORDER Type: view COMPOSITE

Operation Load Distribution

A_WorkCenterCapOrderPerBucket is a Composite CDS View that provides data about "Operation Load Distribution" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterCapOrderPerBucket) and exposes 49 fields with key fields Plant, MRPController, WorkCenter, WorkCenterTypeCode, CapacityCategoryAllocation. It has 10 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_WorkCenterCapOrderPerBucket	I_WorkCenterCapOrderPerBucket	from

Parameters (3)

Name	Type	Default
P_CapEvalStartDate	datum
P_CapEvalEndDate	datum
P_CapEvalBucketType	char1

Associations (10)

Cardinality	Target	Alias	Condition
[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	`CapacityPerDailyShift.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 (12)

Name	Value	Level
AbapCatalog.sqlViewName	AWCCAPORDER	view
AbapCatalog.compiler.compareFilter	true	view
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	#COMPOSITE	view
Metadata.ignorePropagatedAnnotations	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Operation Load Distribution	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view

Fields (49)

Key	Field	Source Table	Source Field
KEY	Plant	CapacityPerDailyShift	Plant
KEY	MRPController	CapacityPerDailyShift	MRPController
KEY	WorkCenter	CapacityPerDailyShift	WorkCenter
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
	CapEvalBucketType	CapacityPerDailyShift	CapEvalBucketType
	CapacityEvaluationTimePerdText
	FactoryCalendar	CapacityPerDailyShift	FactoryCalendar
	WorkCenterDesc
	WorkCenterResponsible	CapacityPerDailyShift	WorkCenterResponsible
	WorkCenterCategoryCode	CapacityPerDailyShift	WorkCenterCategoryCode
	WorkCenterInternalID	CapacityPerDailyShift	WorkCenterInternalID
	CapacityRequirementOrigin	CapacityPerDailyShift	CapacityRequirementOrigin
	CapacityRequirementUnit	CapacityPerDailyShift	CapacityRequirementUnit
	OrderType	CapacityPerDailyShift	OrderType
	OrderPlannedTotalQty	CapacityPerDailyShift	OrderPlannedTotalQty
	BaseUnit
	OrderCategory	CapacityPerDailyShift	OrderCategory
	ProductionVersion	CapacityPerDailyShift	ProductionVersion
	OperationPlanningStatusText
	OperationPlanningStatusCode	CapacityPerDailyShift	OperationPlanningStatusCode
	OperationLatestStartDate
	OperationLatestStartTime
	OperationLatestEndDate
	OperationLatestEndTime
	OrderStatusText
	OrderStatusCode	CapacityPerDailyShift	OrderStatusCode
	OrderFirmingStatusCode
	OrderFirmingStatusText
	OpLtstSchedldProcgStrtDte
	OpLtstSchedldProcgStrtTme
	OpLtstSchedldTrdwnStrtDte
	OpLtstSchedldTrdwnStrtTme
	RemainingCapReqOpSegSetupDurn	CapacityPerDailyShift	RemainingCapReqOpSegSetupDurn
	RemainingCapReqOpSegProcgDurn	CapacityPerDailyShift	RemainingCapReqOpSegProcgDurn
	RemainingCapReqOpSegTrdwnDurn	CapacityPerDailyShift	RemainingCapReqOpSegTrdwnDurn
	OrderInternalID	CapacityPerDailyShift	OrderInternalID
	CapacityStartTime	CapacityPerDailyShift	CapacityStartTime
	CapacityEndTime	CapacityPerDailyShift	CapacityEndTime
	WorkCenterAvailableCapacity	CapacityPerDailyShift	WorkCenterAvailableCapacity
	WorkCenterCapRqmtInCapUnit	CapacityPerDailyShift	WorkCenterCapRqmtInCapUnit
	WorkCenterCapacityUnit	CapacityPerDailyShift	WorkCenterCapacityUnit
	WorkCenterCapUnitText

@AbapCatalog.sqlViewName: 'AWCCAPORDER'
@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: 'Operation Load Distribution'
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
define view A_WorkCenterCapOrderPerBucket  with parameters
//    @Consumption.hidden: false

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

//                               resultElement: 'CapEvalStartDate',

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

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

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

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

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

//                               resultElement: 'CapEvalEndDate',

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

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

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

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

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

//                               resultElement: 'CapEvalBucketType',

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

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

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

    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
                                        
             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 CapacityPerDailyShift.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
              
{
  key CapacityPerDailyShift.Plant,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.MRPController,
  key CapacityPerDailyShift.WorkCenter,
  key CapacityPerDailyShift.WorkCenterTypeCode,
  key CapacityPerDailyShift.CapacityCategoryAllocation,
  key CapacityPerDailyShift.CapacityInternalID                                            as   CapacityInternalID,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.Material,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.OrderID                                                       as   OrderID,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.Operation                                                     as   Operation,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.CapacityEvaluationTimePeriod,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
  key CapacityPerDailyShift.ShiftName                                                     as   ShiftName,
  @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.CapEvalBucketType,
       @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _BucketTypeText[1:Language=$session.system_language].CapEvalBucketTypeText          as   CapacityEvaluationTimePerdText,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.FactoryCalendar,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _WorkCenterText[1:Language=$session.system_language].WorkCenterText                 as   WorkCenterDesc,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.WorkCenterResponsible,
      
      CapacityPerDailyShift.WorkCenterCategoryCode,
      
      CapacityPerDailyShift.WorkCenterInternalID,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.CapacityRequirementOrigin,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      @Semantics.unitOfMeasure: true
      CapacityPerDailyShift.CapacityRequirementUnit,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.OrderType,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      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.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      CapacityPerDailyShift.OrderPlannedTotalQty,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      @Semantics.unitOfMeasure: true
      cast(CapacityPerDailyShift.BaseUnit as meins)                                       as   BaseUnit,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.OrderCategory,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      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,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.ProductionVersion,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _OprPlanningText[1:Language=$session.system_language].CapacityRequirementStatusText as   OperationPlanningStatusText,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.OperationPlanningStatusCode,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OperationLatestStartDate as char8)                       as   OperationLatestStartDate,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OperationLatestStartTime as char6)                       as   OperationLatestStartTime,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OperationLatestEndDate as char8)                         as   OperationLatestEndDate,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OperationLatestEndTime as char6)                         as   OperationLatestEndTime,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _OrderStatusText[1:Language=$session.system_language].SystemStatusName              as   OrderStatusText,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.OrderStatusCode,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OrderFirmingStatusCode as char1)                         as   OrderFirmingStatusCode,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _FirmingStatusText[1:Language=$session.system_language].OrderFirmingStatusText      as   OrderFirmingStatusText,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OpLtstSchedldProcgStrtDte as char8)                      as   OpLtstSchedldProcgStrtDte,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OpLtstSchedldProcgStrtTme as char6)                      as   OpLtstSchedldProcgStrtTme,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OpLtstSchedldTrdwnStrtDte as char8)                      as   OpLtstSchedldTrdwnStrtDte,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      cast(CapacityPerDailyShift.OpLtstSchedldTrdwnStrtTme as char6)                      as   OpLtstSchedldTrdwnStrtTme,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
      CapacityPerDailyShift.RemainingCapReqOpSegSetupDurn,
      @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.RemainingCapReqOpSegProcgDurn,
      @Semantics.quantity.unitOfMeasure: 'CapacityRequirementUnit'
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.RemainingCapReqOpSegTrdwnDurn,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.OrderInternalID,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.CapacityStartTime,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'} 
      CapacityPerDailyShift.CapacityEndTime,

      //            CapacityPerDailyShift.WorkCenterInternalID,

      @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.WorkCenterAvailableCapacity,

      
      @Semantics.quantity.unitOfMeasure: 'WorkCenterCapacityUnit'
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.WorkCenterCapRqmtInCapUnit,
      @Semantics.unitOfMeasure: true
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      CapacityPerDailyShift.WorkCenterCapacityUnit,
      @ObjectModel.filter: {transformedBy: 'ABAP:CL_WORKCENTER_API_ORDB_FILT_EX'}
      _UOMText[1:Language=$session.system_language].UnitOfMeasureName   as WorkCenterCapUnitText
}

Depth:

A_WorkCenterCapOrderPerBucket view

I_WorkCenterCapOrderPerBucket view