I_WorkCenterVH
Work Center
I_WorkCenterVH is a Composite CDS View that provides data about "Work Center" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 79 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_WorkCenter | I_WorkCenter | from |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | IWC__VH3 | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| AccessControl.personalData.blocking | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| Consumption.ranked | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.dataCategory | #VALUE_HELP | view | |
| ObjectModel.representativeKey | WorkCenterInternalID | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| Search.searchable | true | view | |
| VDM.viewType | #COMPOSITE | view | |
| EndUserText.label | Work Center | view |
Fields (79)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkCenterInternalID | WorkCenterInternalID | ||
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | ||
| WorkCenter | WorkCenter | |||
| WorkCenterIsToBeDeleted | WorkCenterIsToBeDeleted | |||
| WorkCenterIsLocked | WorkCenterIsLocked | |||
| WorkCenterIsMntndForCosting | WorkCenterIsMntndForCosting | |||
| WorkCenterIsMntndForScheduling | WorkCenterIsMntndForScheduling | |||
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | |||
| WorkCenterCategoryCode | WorkCenterCategoryCode | |||
| WorkCenterLocation | WorkCenterLocation | |||
| WorkCenterLocationGroup | WorkCenterLocationGroup | |||
| WorkCenterUsage | WorkCenterUsage | |||
| WorkCenterResponsible | WorkCenterResponsible | |||
| Plant | Plant | |||
| SupplyArea | SupplyArea | |||
| CapacityInternalID | CapacityInternalID | |||
| MachineType | MachineType | |||
| OperationControlProfile | OperationControlProfile | |||
| MatlCompIsMarkedForBackflush | MatlCompIsMarkedForBackflush | |||
| WorkCenterSetupType | WorkCenterSetupType | |||
| FreeDefinedTableFieldSemantic | FreeDefinedTableFieldSemantic | |||
| ObjectInternalID | ObjectInternalID | |||
| StandardTextInternalID | StandardTextInternalID | |||
| EmployeeWageType | EmployeeWageType | |||
| EmployeeWageGroup | EmployeeWageGroup | |||
| EmployeeSuitability | EmployeeSuitability | |||
| NumberOfTimeTickets | NumberOfTimeTickets | |||
| PlanVersion | PlanVersion | |||
| ValidityStartDate | ValidityStartDate | |||
| ValidityEndDate | ValidityEndDate | |||
| StandardTextIDIsReferenced | StandardTextIDIsReferenced | |||
| EmployeeWageTypeIsReferenced | EmployeeWageTypeIsReferenced | |||
| NmbrOfTimeTicketsIsReferenced | NmbrOfTimeTicketsIsReferenced | |||
| EmployeeWageGroupIsReferenced | EmployeeWageGroupIsReferenced | |||
| EmplSuitabilityIsReferenced | EmplSuitabilityIsReferenced | |||
| WorkCenterSetpTypeIsReferenced | WorkCenterSetpTypeIsReferenced | |||
| OpControlProfileIsReferenced | OpControlProfileIsReferenced | |||
| NumberOfConfSlipsIsReferenced | NumberOfConfSlipsIsReferenced | |||
| WorkCenterStdQueueDurnUnit | WorkCenterStdQueueDurnUnit | |||
| WorkCenterStandardQueueDurn | WorkCenterStandardQueueDurn | |||
| WorkCenterMinimumQueueDurnUnit | WorkCenterMinimumQueueDurnUnit | |||
| WorkCenterMinimumQueueDuration | WorkCenterMinimumQueueDuration | |||
| WorkCenterStandardWorkQtyUnit1 | WorkCenterStandardWorkQtyUnit1 | |||
| WorkCenterStandardWorkQtyUnit2 | WorkCenterStandardWorkQtyUnit2 | |||
| WorkCenterStandardWorkQtyUnit3 | WorkCenterStandardWorkQtyUnit3 | |||
| WorkCenterStandardWorkQtyUnit4 | WorkCenterStandardWorkQtyUnit4 | |||
| WorkCenterStandardWorkQtyUnit5 | WorkCenterStandardWorkQtyUnit5 | |||
| WorkCenterStandardWorkQtyUnit6 | WorkCenterStandardWorkQtyUnit6 | |||
| StandardWorkQuantityUnit | StandardWorkQuantityUnit | |||
| StandardWorkFormulaParamGroup | StandardWorkFormulaParamGroup | |||
| _Plant | _Plant | |||
| _WorkCenter | _WorkCenter | |||
| _WorkCenterType | _WorkCenterType | |||
| _WorkCenterResponsible | _WorkCenterResponsible | |||
| _WorkCenterCategory | _WorkCenterCategory | |||
| _WorkCenterLocation | _WorkCenterLocation | |||
| _WorkCenterLocationGroup | _WorkCenterLocationGroup | |||
| _WorkCenterUsage | _WorkCenterUsage | |||
| _Text | _Text | |||
| _Capacity | _Capacity | |||
| _MachineType | _MachineType | |||
| _OperationControlProfile | _OperationControlProfile | |||
| _SupplyArea | _SupplyArea | |||
| _WorkCenterSetupType | _WorkCenterSetupType | |||
| _StandardTextInternalID | _StandardTextInternalID | |||
| _EmployeeWageGroup | _EmployeeWageGroup | |||
| _EmployeeSuitability | _EmployeeSuitability | |||
| _ValidityStartDate | _ValidityStartDate | |||
| _ValidityEndDate | _ValidityEndDate | |||
| _StandardQueueDurationUnit | _StandardQueueDurationUnit | |||
| _MinimumQueueDurationUnit | _MinimumQueueDurationUnit | |||
| _WorkQuantityUnit1 | _WorkQuantityUnit1 | |||
| _WorkQuantityUnit2 | _WorkQuantityUnit2 | |||
| _WorkQuantityUnit3 | _WorkQuantityUnit3 | |||
| _WorkQuantityUnit4 | _WorkQuantityUnit4 | |||
| _WorkQuantityUnit5 | _WorkQuantityUnit5 | |||
| _WorkQuantityUnit6 | _WorkQuantityUnit6 | |||
| _StandardWorkQuantityUnit | _StandardWorkQuantityUnit | |||
| _StandardWorkFmlaParamGroup | _StandardWorkFmlaParamGroup |
@AbapCatalog.sqlViewName: 'IWC__VH3'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@AccessControl.privilegedAssociations: ['_WorkCenterResponsible']
@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'WorkCenterInternalID'
@ObjectModel.supportedCapabilities: [#VALUE_HELP_PROVIDER, #SEARCHABLE_ENTITY]
@ObjectModel.usageType: {serviceQuality: #A, sizeCategory: #S, dataClass: #MASTER}
@Search.searchable: true
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Work Center'
define view I_WorkCenterVH as select from I_WorkCenter
{
@ObjectModel.text.association: '_Text'
@Search: {defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8}
key WorkCenterInternalID,
@ObjectModel.foreignKey.association: '_WorkCenterType'
@Search: {defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
key WorkCenterTypeCode,
@ObjectModel.foreignKey.association: '_WorkCenter'
@Search: {defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
WorkCenter,
WorkCenterIsToBeDeleted,
WorkCenterIsLocked,
WorkCenterIsMntndForCosting,
WorkCenterIsMntndForScheduling,
NumberOfConfirmationSlips,
@ObjectModel.foreignKey.association: '_WorkCenterCategory'
WorkCenterCategoryCode,
@ObjectModel.foreignKey.association: '_WorkCenterLocation'
WorkCenterLocation,
@ObjectModel.foreignKey.association: '_WorkCenterLocationGroup'
WorkCenterLocationGroup,
@ObjectModel.foreignKey.association: '_WorkCenterUsage'
WorkCenterUsage,
@ObjectModel.foreignKey.association: '_WorkCenterResponsible'
WorkCenterResponsible,
@ObjectModel.foreignKey.association: '_Plant'
@Search: {defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8}
Plant,
@ObjectModel.foreignKey.association: '_SupplyArea'
SupplyArea,
@ObjectModel.foreignKey.association: '_Capacity'
CapacityInternalID,
@ObjectModel.foreignKey.association: '_MachineType'
MachineType,
@ObjectModel.foreignKey.association: '_OperationControlProfile'
OperationControlProfile,
MatlCompIsMarkedForBackflush,
@ObjectModel.foreignKey.association: '_WorkCenterSetupType'
WorkCenterSetupType,
FreeDefinedTableFieldSemantic,
ObjectInternalID,
@ObjectModel.foreignKey.association: '_StandardTextInternalID'
StandardTextInternalID,
EmployeeWageType,
@ObjectModel.foreignKey.association: '_EmployeeWageGroup'
EmployeeWageGroup,
@ObjectModel.foreignKey.association: '_EmployeeSuitability'
EmployeeSuitability,
NumberOfTimeTickets,
PlanVersion,
@Semantics.calendarItem.dtStart: true
ValidityStartDate,
@Semantics.calendarItem.dtEnd: true
ValidityEndDate,
StandardTextIDIsReferenced,
EmployeeWageTypeIsReferenced,
NmbrOfTimeTicketsIsReferenced,
EmployeeWageGroupIsReferenced,
EmplSuitabilityIsReferenced,
WorkCenterSetpTypeIsReferenced,
OpControlProfileIsReferenced,
NumberOfConfSlipsIsReferenced,
@Semantics.unitOfMeasure: true
WorkCenterStdQueueDurnUnit,
@Semantics.calendarItem.duration: true
WorkCenterStandardQueueDurn,
@Semantics.unitOfMeasure: true
WorkCenterMinimumQueueDurnUnit,
@Semantics.calendarItem.duration: true
WorkCenterMinimumQueueDuration,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit1,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit2,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit3,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit4,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit5,
@Semantics.unitOfMeasure: true
WorkCenterStandardWorkQtyUnit6,
@Semantics.unitOfMeasure: true
StandardWorkQuantityUnit,
@ObjectModel.foreignKey.association: '_StandardWorkFmlaParamGroup'
StandardWorkFormulaParamGroup,
// Associations
@Consumption.hidden:true
_Plant,
@Consumption.hidden:true
_WorkCenter,
@Consumption.hidden:true
_WorkCenterType,
@Consumption.hidden:true
_WorkCenterResponsible,
@Consumption.hidden:true
_WorkCenterCategory,
@Consumption.hidden:true
_WorkCenterLocation,
@Consumption.hidden:true
_WorkCenterLocationGroup,
@Consumption.hidden:true
_WorkCenterUsage,
@Consumption.hidden:true
_Text,
@Consumption.hidden:true
_Capacity,
@Consumption.hidden:true
_MachineType,
@Consumption.hidden:true
_OperationControlProfile,
@Consumption.hidden:true
_SupplyArea,
@Consumption.hidden:true
_WorkCenterSetupType,
@Consumption.hidden:true
_StandardTextInternalID,
@Consumption.hidden:true
_EmployeeWageGroup,
@Consumption.hidden:true
_EmployeeSuitability,
@Consumption.hidden:true
_ValidityStartDate,
@Consumption.hidden:true
_ValidityEndDate,
@Consumption.hidden:true
_StandardQueueDurationUnit,
@Consumption.hidden:true
_MinimumQueueDurationUnit,
@Consumption.hidden:true
_WorkQuantityUnit1,
@Consumption.hidden:true
_WorkQuantityUnit2,
@Consumption.hidden:true
_WorkQuantityUnit3,
@Consumption.hidden:true
_WorkQuantityUnit4,
@Consumption.hidden:true
_WorkQuantityUnit5,
@Consumption.hidden:true
_WorkQuantityUnit6,
@Consumption.hidden:true
_StandardWorkQuantityUnit,
@Consumption.hidden:true
_StandardWorkFmlaParamGroup
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_WORKCENTER"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_CAPACITY",
"I_EMPLOYEESUITABILITY",
"I_EMPLOYEEWAGEGROUP",
"I_MACHINETYPE",
"I_OPERATIONCONTROLPROFILE",
"I_OPERATIONSETUPTYPE",
"I_OPERATIONSTANDARDTEXT",
"I_PLANT",
"I_PRODUCTIONRESOURCEUSAGE",
"I_PRODUCTIONSUPPLYAREA",
"I_STANDARDWORKFMLAPARAMGROUP",
"I_UNITOFMEASURE",
"I_WORKCENTERBYSEMANTICKEY",
"I_WORKCENTERCATEGORY",
"I_WORKCENTERLOCATION",
"I_WORKCENTERLOCATIONGROUP",
"I_WORKCENTERRESPONSIBLE",
"I_WORKCENTERTEXT",
"I_WORKCENTERTYPE"
],
"BASE":
[
"I_WORKCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA