I_WorkCenterVH

DDL: I_WORKCENTERVH SQL: IWC__VH3 Type: view COMPOSITE
79 Fields 1 Data Sources

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)

SourceAliasJoin Type
I_WorkCenter I_WorkCenter from

Annotations (16)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID WorkCenterInternalID Work Center
KEY WorkCenterTypeCode WorkCenterTypeCode Object Type
WorkCenter WorkCenter Work Center
WorkCenterIsToBeDeleted WorkCenterIsToBeDeleted Stock del. flag
WorkCenterIsLocked WorkCenterIsLocked Locked
WorkCenterIsMntndForCosting WorkCenterIsMntndForCosting Costs
WorkCenterIsMntndForScheduling WorkCenterIsMntndForScheduling Scheduling
NumberOfConfirmationSlips NumberOfConfirmationSlips No. of Conf. Slips
WorkCenterCategoryCode WorkCenterCategoryCode Work Center Category
WorkCenterLocation WorkCenterLocation Std Class Type
WorkCenterLocationGroup WorkCenterLocationGroup Location Group
WorkCenterUsage WorkCenterUsage
WorkCenterResponsible WorkCenterResponsible Responsible
Plant Plant Valuation Area
SupplyArea SupplyArea Supply Area
CapacityInternalID CapacityInternalID Capacity ID
MachineType MachineType Machine Type
OperationControlProfile OperationControlProfile Control Key
MatlCompIsMarkedForBackflush MatlCompIsMarkedForBackflush Backflush
WorkCenterSetupType WorkCenterSetupType
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
ObjectInternalID ObjectInternalID Object number
StandardTextInternalID StandardTextInternalID
EmployeeWageType EmployeeWageType Wage type
EmployeeWageGroup EmployeeWageGroup Wage Group
EmployeeSuitability EmployeeSuitability
NumberOfTimeTickets NumberOfTimeTickets No.TimeTickets
PlanVersion PlanVersion
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
StandardTextIDIsReferenced StandardTextIDIsReferenced Std Text Referenced
EmployeeWageTypeIsReferenced EmployeeWageTypeIsReferenced Wage Type Ref.
NmbrOfTimeTicketsIsReferenced NmbrOfTimeTicketsIsReferenced No. Time Ticktes Ref
EmployeeWageGroupIsReferenced EmployeeWageGroupIsReferenced Wage Group Ref.
EmplSuitabilityIsReferenced EmplSuitabilityIsReferenced Suitability Ref.
WorkCenterSetpTypeIsReferenced WorkCenterSetpTypeIsReferenced Setup Type Ref.
OpControlProfileIsReferenced OpControlProfileIsReferenced Control Profile Ref.
NumberOfConfSlipsIsReferenced NumberOfConfSlipsIsReferenced No. Conf. Slips Ref.
WorkCenterStdQueueDurnUnit WorkCenterStdQueueDurnUnit Std Queue Unit
WorkCenterStandardQueueDurn WorkCenterStandardQueueDurn Min. Queue Time
WorkCenterMinimumQueueDurnUnit WorkCenterMinimumQueueDurnUnit Std Queue Unit
WorkCenterMinimumQueueDuration WorkCenterMinimumQueueDuration Min. Queue Time
WorkCenterStandardWorkQtyUnit1 WorkCenterStandardWorkQtyUnit1
WorkCenterStandardWorkQtyUnit2 WorkCenterStandardWorkQtyUnit2
WorkCenterStandardWorkQtyUnit3 WorkCenterStandardWorkQtyUnit3
WorkCenterStandardWorkQtyUnit4 WorkCenterStandardWorkQtyUnit4
WorkCenterStandardWorkQtyUnit5 WorkCenterStandardWorkQtyUnit5
WorkCenterStandardWorkQtyUnit6 WorkCenterStandardWorkQtyUnit6
StandardWorkQuantityUnit StandardWorkQuantityUnit Work Unit
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup Std Value Key
_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

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkCenterVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IWC__VH3

CREATE VIEW I_WorkCenterVH AS
SELECT
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenter,
  WorkCenterIsToBeDeleted,
  WorkCenterIsLocked,
  WorkCenterIsMntndForCosting,
  WorkCenterIsMntndForScheduling,
  NumberOfConfirmationSlips,
  WorkCenterCategoryCode,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WorkCenterUsage,
  WorkCenterResponsible,
  Plant,
  SupplyArea,
  CapacityInternalID,
  MachineType,
  OperationControlProfile,
  MatlCompIsMarkedForBackflush,
  WorkCenterSetupType,
  FreeDefinedTableFieldSemantic,
  ObjectInternalID,
  StandardTextInternalID,
  EmployeeWageType,
  EmployeeWageGroup,
  EmployeeSuitability,
  NumberOfTimeTickets,
  PlanVersion,
  ValidityStartDate,
  ValidityEndDate,
  StandardTextIDIsReferenced,
  EmployeeWageTypeIsReferenced,
  NmbrOfTimeTicketsIsReferenced,
  EmployeeWageGroupIsReferenced,
  EmplSuitabilityIsReferenced,
  WorkCenterSetpTypeIsReferenced,
  OpControlProfileIsReferenced,
  NumberOfConfSlipsIsReferenced,
  WorkCenterStdQueueDurnUnit,
  WorkCenterStandardQueueDurn,
  WorkCenterMinimumQueueDurnUnit,
  WorkCenterMinimumQueueDuration,
  WorkCenterStandardWorkQtyUnit1,
  WorkCenterStandardWorkQtyUnit2,
  WorkCenterStandardWorkQtyUnit3,
  WorkCenterStandardWorkQtyUnit4,
  WorkCenterStandardWorkQtyUnit5,
  WorkCenterStandardWorkQtyUnit6,
  StandardWorkQuantityUnit,
  StandardWorkFormulaParamGroup
FROM I_WorkCenter
;

Learn More