I_WORKCENTERALLCAPACITY

CDS View

All Capacities of Work Center

I_WORKCENTERALLCAPACITY is a CDS View in S/4HANA. All Capacities of Work Center. It contains 12 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 12 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
A_WorkCenterAllCapacity view from COMPOSITE Capacity Assignment

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CapacityCategoryAllocation CapacityCategoryAllocation 1
KEY CapacityInternalID CapacityInternalID 1
KEY WorkCenterInternalID WorkCenterInternalID 1
KEY WorkCenterTypeCode WorkCenterTypeCode 1
CapacityCategoryCode CapacityCategoryCode 1
Plant Plant 1
SupplyArea SupplyArea 1
WorkCenter WorkCenter 1
WorkCenterCategoryCode WorkCenterCategoryCode 1
WorkCenterDesc WorkCenterDesc 1
WorkCenterResponsible WorkCenterResponsible 1
WorkCenterUsage WorkCenterUsage 1 
@AbapCatalog.sqlViewName: 'IWORKCTRALLCAP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM: {
  viewType: #COMPOSITE
}
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #XL, dataClass: #MIXED}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'All Capacities of Work Center'
define view I_WorkCenterAllCapacity
as select from I_WorkCenterCapacity    as WorkCenterCapacity

 {
                    @EndUserText.label:'Work Center Internal Id'
  key               WorkCenterCapacity.WorkCenterInternalID,
                    @EndUserText.label:'Work Center Type Code'
  key               WorkCenterCapacity.WorkCenterTypeCode,
  key               WorkCenterCapacity.CapacityInternalID,
  key               WorkCenterCapacity.CapacityCategoryAllocation,
                    WorkCenterCapacity.WorkCenter,
                    WorkCenterCapacity._WorkCenter._Text[1:Language=$session.system_language].WorkCenterText as WorkCenterDesc,
                    WorkCenterCapacity.Plant,
                    WorkCenterCapacity._WorkCenter.WorkCenterCategoryCode,
                    WorkCenterCapacity._WorkCenter.WorkCenterResponsible,
                    WorkCenterCapacity._WorkCenter.SupplyArea,
                    WorkCenterCapacity._WorkCenter.WorkCenterUsage,
                    WorkCenterCapacity.CapacityCategoryCode
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTER",
"I_WORKCENTERCAPACITY",
"I_WORKCENTERTEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More