I_WORKCENTERVH
Work Center
I_WORKCENTERVH is a CDS View in S/4HANA. Work Center. It contains 79 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| C_MfgOperatorWrkCtrRespVH | view | from | CONSUMPTION | Value Help for Work Center |
Fields (79)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | WorkCenterInternalID | WorkCenterInternalID | 1 |
| KEY | WorkCenterTypeCode | WorkCenterTypeCode | 1 |
| _Capacity | _Capacity | 1 | |
| _EmployeeSuitability | _EmployeeSuitability | 1 | |
| _EmployeeWageGroup | _EmployeeWageGroup | 1 | |
| _MachineType | _MachineType | 1 | |
| _MinimumQueueDurationUnit | _MinimumQueueDurationUnit | 1 | |
| _OperationControlProfile | _OperationControlProfile | 1 | |
| _Plant | _Plant | 1 | |
| _StandardQueueDurationUnit | _StandardQueueDurationUnit | 1 | |
| _StandardTextInternalID | _StandardTextInternalID | 1 | |
| _StandardWorkFmlaParamGroup | _StandardWorkFmlaParamGroup | 1 | |
| _StandardWorkQuantityUnit | _StandardWorkQuantityUnit | 1 | |
| _SupplyArea | _SupplyArea | 1 | |
| _Text | _Text | 1 | |
| _ValidityEndDate | _ValidityEndDate | 1 | |
| _ValidityStartDate | _ValidityStartDate | 1 | |
| _WorkCenter | _WorkCenter | 1 | |
| _WorkCenterCategory | _WorkCenterCategory | 1 | |
| _WorkCenterLocation | _WorkCenterLocation | 1 | |
| _WorkCenterLocationGroup | _WorkCenterLocationGroup | 1 | |
| _WorkCenterResponsible | _WorkCenterResponsible | 1 | |
| _WorkCenterSetupType | _WorkCenterSetupType | 1 | |
| _WorkCenterType | _WorkCenterType | 1 | |
| _WorkCenterUsage | _WorkCenterUsage | 1 | |
| _WorkQuantityUnit1 | _WorkQuantityUnit1 | 1 | |
| _WorkQuantityUnit2 | _WorkQuantityUnit2 | 1 | |
| _WorkQuantityUnit3 | _WorkQuantityUnit3 | 1 | |
| _WorkQuantityUnit4 | _WorkQuantityUnit4 | 1 | |
| _WorkQuantityUnit5 | _WorkQuantityUnit5 | 1 | |
| _WorkQuantityUnit6 | _WorkQuantityUnit6 | 1 | |
| CapacityInternalID | CapacityInternalID | 1 | |
| EmployeeSuitability | EmployeeSuitability | 1 | |
| EmployeeWageGroup | EmployeeWageGroup | 1 | |
| EmployeeWageGroupIsReferenced | EmployeeWageGroupIsReferenced | 1 | |
| EmployeeWageType | EmployeeWageType | 1 | |
| EmployeeWageTypeIsReferenced | EmployeeWageTypeIsReferenced | 1 | |
| EmplSuitabilityIsReferenced | EmplSuitabilityIsReferenced | 1 | |
| FreeDefinedTableFieldSemantic | FreeDefinedTableFieldSemantic | 1 | |
| MachineType | MachineType | 1 | |
| MatlCompIsMarkedForBackflush | MatlCompIsMarkedForBackflush | 1 | |
| NmbrOfTimeTicketsIsReferenced | NmbrOfTimeTicketsIsReferenced | 1 | |
| NumberOfConfirmationSlips | NumberOfConfirmationSlips | 1 | |
| NumberOfConfSlipsIsReferenced | NumberOfConfSlipsIsReferenced | 1 | |
| NumberOfTimeTickets | NumberOfTimeTickets | 1 | |
| ObjectInternalID | ObjectInternalID | 1 | |
| OpControlProfileIsReferenced | OpControlProfileIsReferenced | 1 | |
| OperationControlProfile | OperationControlProfile | 1 | |
| Plant | Plant | 1 | |
| PlanVersion | PlanVersion | 1 | |
| StandardTextIDIsReferenced | StandardTextIDIsReferenced | 1 | |
| StandardTextInternalID | StandardTextInternalID | 1 | |
| StandardWorkFormulaParamGroup | StandardWorkFormulaParamGroup | 1 | |
| StandardWorkQuantityUnit | StandardWorkQuantityUnit | 1 | |
| SupplyArea | SupplyArea | 1 | |
| ValidityEndDate | ValidityEndDate | 1 | |
| ValidityStartDate | ValidityStartDate | 1 | |
| WorkCenter | WorkCenter | 1 | |
| WorkCenterCategoryCode | WorkCenterCategoryCode | 1 | |
| WorkCenterIsLocked | WorkCenterIsLocked | 1 | |
| WorkCenterIsMntndForCosting | WorkCenterIsMntndForCosting | 1 | |
| WorkCenterIsMntndForScheduling | WorkCenterIsMntndForScheduling | 1 | |
| WorkCenterIsToBeDeleted | WorkCenterIsToBeDeleted | 1 | |
| WorkCenterLocation | WorkCenterLocation | 1 | |
| WorkCenterLocationGroup | WorkCenterLocationGroup | 1 | |
| WorkCenterMinimumQueueDuration | WorkCenterMinimumQueueDuration | 1 | |
| WorkCenterMinimumQueueDurnUnit | WorkCenterMinimumQueueDurnUnit | 1 | |
| WorkCenterResponsible | WorkCenterResponsible | 1 | |
| WorkCenterSetpTypeIsReferenced | WorkCenterSetpTypeIsReferenced | 1 | |
| WorkCenterSetupType | WorkCenterSetupType | 1 | |
| WorkCenterStandardQueueDurn | WorkCenterStandardQueueDurn | 1 | |
| WorkCenterStandardWorkQtyUnit1 | WorkCenterStandardWorkQtyUnit1 | 1 | |
| WorkCenterStandardWorkQtyUnit2 | WorkCenterStandardWorkQtyUnit2 | 1 | |
| WorkCenterStandardWorkQtyUnit3 | WorkCenterStandardWorkQtyUnit3 | 1 | |
| WorkCenterStandardWorkQtyUnit4 | WorkCenterStandardWorkQtyUnit4 | 1 | |
| WorkCenterStandardWorkQtyUnit5 | WorkCenterStandardWorkQtyUnit5 | 1 | |
| WorkCenterStandardWorkQtyUnit6 | WorkCenterStandardWorkQtyUnit6 | 1 | |
| WorkCenterStdQueueDurnUnit | WorkCenterStdQueueDurnUnit | 1 | |
| WorkCenterUsage | WorkCenterUsage | 1 |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Work Center
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKCENTERVH (
WORKCENTERINTERNALID,
WORKCENTERTYPECODE,
_CAPACITY,
_EMPLOYEESUITABILITY,
_EMPLOYEEWAGEGROUP,
_MACHINETYPE,
_MINIMUMQUEUEDURATIONUNIT,
_OPERATIONCONTROLPROFILE,
_PLANT,
_STANDARDQUEUEDURATIONUNIT,
_STANDARDTEXTINTERNALID,
_STANDARDWORKFMLAPARAMGROUP,
_STANDARDWORKQUANTITYUNIT,
_SUPPLYAREA,
_TEXT,
_VALIDITYENDDATE,
_VALIDITYSTARTDATE,
_WORKCENTER,
_WORKCENTERCATEGORY,
_WORKCENTERLOCATION,
_WORKCENTERLOCATIONGROUP,
_WORKCENTERRESPONSIBLE,
_WORKCENTERSETUPTYPE,
_WORKCENTERTYPE,
_WORKCENTERUSAGE,
_WORKQUANTITYUNIT1,
_WORKQUANTITYUNIT2,
_WORKQUANTITYUNIT3,
_WORKQUANTITYUNIT4,
_WORKQUANTITYUNIT5,
_WORKQUANTITYUNIT6,
CAPACITYINTERNALID,
EMPLOYEESUITABILITY,
EMPLOYEEWAGEGROUP,
EMPLOYEEWAGEGROUPISREFERENCED,
EMPLOYEEWAGETYPE,
EMPLOYEEWAGETYPEISREFERENCED,
EMPLSUITABILITYISREFERENCED,
FREEDEFINEDTABLEFIELDSEMANTIC,
MACHINETYPE,
MATLCOMPISMARKEDFORBACKFLUSH,
NMBROFTIMETICKETSISREFERENCED,
NUMBEROFCONFIRMATIONSLIPS,
NUMBEROFCONFSLIPSISREFERENCED,
NUMBEROFTIMETICKETS,
OBJECTINTERNALID,
OPCONTROLPROFILEISREFERENCED,
OPERATIONCONTROLPROFILE,
PLANT,
PLANVERSION,
STANDARDTEXTIDISREFERENCED,
STANDARDTEXTINTERNALID,
STANDARDWORKFORMULAPARAMGROUP,
STANDARDWORKQUANTITYUNIT,
SUPPLYAREA,
VALIDITYENDDATE,
VALIDITYSTARTDATE,
WORKCENTER,
WORKCENTERCATEGORYCODE,
WORKCENTERISLOCKED,
WORKCENTERISMNTNDFORCOSTING,
WORKCENTERISMNTNDFORSCHEDULING,
WORKCENTERISTOBEDELETED,
WORKCENTERLOCATION,
WORKCENTERLOCATIONGROUP,
WORKCENTERMINIMUMQUEUEDURATION,
WORKCENTERMINIMUMQUEUEDURNUNIT,
WORKCENTERRESPONSIBLE,
WORKCENTERSETPTYPEISREFERENCED,
WORKCENTERSETUPTYPE,
WORKCENTERSTANDARDQUEUEDURN,
WORKCENTERSTANDARDWORKQTYUNIT1,
WORKCENTERSTANDARDWORKQTYUNIT2,
WORKCENTERSTANDARDWORKQTYUNIT3,
WORKCENTERSTANDARDWORKQTYUNIT4,
WORKCENTERSTANDARDWORKQTYUNIT5,
WORKCENTERSTANDARDWORKQTYUNIT6,
WORKCENTERSTDQUEUEDURNUNIT,
WORKCENTERUSAGE,
PRIMARY KEY (WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA