I_WORKCENTER

CDS View
66 Fields 48 CDS Views

Work Center

I_WORKCENTER is a CDS View in S/4HANA. Work Center. It contains 66 fields. 48 CDS views read from this table.

CDS Views using this table (48)

ViewTypeJoinVDMDescription
A_WorkCenters view from COMPOSITE Header
C_CapEvalWorkCenterOverView view from CONSUMPTION
C_InspRsltRecgWorkCenter view_entity from CONSUMPTION Work Center Details
C_MaintenanceWorkCenterTeam view_entity from CONSUMPTION WorkCenter Entity in Teams Configuration
C_MaintenanceWorkCenterTeamVH view_entity from CONSUMPTION Performing Work Center
C_PMWorkCenterVH view from CONSUMPTION Work Center
C_Pppiworkcenterobjpg view from CONSUMPTION Resources Object Page
C_ProdnSupplyAreaWorkCenter view_entity from CONSUMPTION Work Center of PSA Where Used
C_ProdnSupplyAreaWrkCtrCount view_entity left_outer CONSUMPTION Count of Work Centers use PSA
C_RSHMaintSchedMissingWrkCtr view inner CONSUMPTION Unassigned Work Centers in Schedule
C_RSHOperationWorkCenterVH view from CONSUMPTION Performing Work Center
C_RSHWorkCenterVH view from CONSUMPTION Value help for work centers
C_SchedProdnProdVersDay view inner CONSUMPTION Production Versions In Day Bucket
C_SchedProdnProdVersShift view inner CONSUMPTION Production versions in shift bucket
C_SchedProdnProdVersWeek view inner CONSUMPTION Production Versions In Week Bucket
C_SchedProdnSalesDocumentVH view inner CONSUMPTION Sales Document
C_WorkCenterObjPg view from CONSUMPTION Work Center Object Page
C_WrkCtrMntrReschedule view inner CONSUMPTION Monitor Work Center Reschedule
C_WrkCtrMntrUtilznChtPeriods view from CONSUMPTION WC Monitor - Utilization Chart Periods
C_WrkPmtWrkCtrPersRespVH view from CONSUMPTION WorkPermit workcentre person responsible
ESH_N_RESOURCES view from
ESH_N_WORKCENTERS view from
I_CapEvalByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
I_DFS_ObjToWrkCtrRelshpDEX view_entity from COMPOSITE Defense Workcenter Extractor
I_EvaltCapWrkCtrGrpAreaOfRespy view_entity inner COMPOSITE Work Center Group Area of Responsibility
I_MaintOrderConfActivityTypeVH view inner COMPOSITE Activity types for Order confirmation
I_RSHMaintSchedWrkCtrCap view inner BASIC Work Center Capacity of Frozen Schedules
I_SchedProdnVersRtgDetails view inner COMPOSITE Production Version Routing Details
I_SchedProdnWrkCtrSqncVH view inner COMPOSITE Work Ctr Filter for dispatch by sequence
I_WorkCenterBySemanticKey view from BASIC Work Center By Semantic Key
I_WorkCenterStdVH view from COMPOSITE Work Center
I_WorkCenterVH view from COMPOSITE Work Center
I_WrkCtrCapByAreaOfRespy view inner COMPOSITE Work Center By Area Of Responsibility
N_CapacityRequirementItemCap view left_outer Capacity Requirement Item Capacity Aux
P_ALTERNATEPRODLINES view inner BASIC
P_EBPAO_ActlPlanDebitCostWC view inner COMPOSITE
P_EBPAO_PCCActualCostDebitWC view inner COMPOSITE
P_EvaltCapWrkCtrCapOperations view_entity inner COMPOSITE
P_NUMBEROFSOS view inner BASIC
P_ProdnModOperationWorkCenter view_entity from COMPOSITE Production Model WorkCenter
P_Qm_Headerwithoperations view left_outer BASIC
P_RSHWCHeaderCapacity_Cache view inner CONSUMPTION
P_SchedProdnAltvProdnVers view inner BASIC
P_WorkCenterActivity1 view_entity from COMPOSITE
P_WorkCenterCapPplineOp view inner COMPOSITE
P_WORKCENTERCAPREQS view inner COMPOSITE
P_WrkCtrMntrSchedShift view inner CONSUMPTION Work Center Shifts
R_WorkCenterTP view_entity from TRANSACTIONAL Work Center Header

Fields (66)

KeyField CDS FieldsUsed in Views
KEY WorkCenter WorkCenter 19
KEY WorkCenterInternalID AltWorkCenterInternalID,ProductionResourceInternalID,WorkCenterInternalID 22
KEY WorkCenterTypeCode AltWorkCenterTypeCode,ProductionResourceType,WorkCenterTypeCode 15
_Plant _Plant 1
_StandardWorkFmlaParamGroup _StandardWorkFmlaParamGroup 1
_Text _Text 1
_WorkCenter _WorkCenter 1
_WorkCenterCategory _WorkCenterCategory 2
_WorkCenterCostCenter _WorkCenterCostCenter 2
_WorkCenterType _WorkCenterType 1
CapacityInternalID AltCapacityInternalID,CapacityInternalID 4
EmployeeSuitability EmployeeSuitability 1
EmployeeWageGroup EmployeeWageGroup 1
EmployeeWageGroupIsReferenced EmployeeWageGroupIsReferenced 1
EmployeeWageType EmployeeWageType 1
EmployeeWageTypeIsReferenced EmployeeWageTypeIsReferenced 1
EmplSuitabilityIsReferenced EmplSuitabilityIsReferenced 1
NmbrOfTimeTicketsIsReferenced NmbrOfTimeTicketsIsReferenced 1
NumberOfConfirmationSlips NumberOfConfirmationSlips 1
NumberOfConfSlipsIsReferenced NumberOfConfSlipsIsReferenced 1
NumberOfTimeTickets NumberOfTimeTickets 1
OpControlProfileIsReferenced OpControlProfileIsReferenced 1
OperationControlProfile OperationControlProfile 1
Plant Plant 10
StandardWorkFormulaParamGroup StandardWorkFormulaParamGroup 1
SupplyArea SupplyArea 1
ValidityEndDate ValidityEndDate 3
ValidityStartDate ValidityStartDate 1
WorkCenterCategoryCode WorkCenterCategoryCode 11
WorkCenterFmlaParamUnit1 WorkCenterFmlaParamUnit1 1
WorkCenterFmlaParamUnit2 WorkCenterFmlaParamUnit2 1
WorkCenterFmlaParamUnit3 WorkCenterFmlaParamUnit3 1
WorkCenterFmlaParamUnit4 WorkCenterFmlaParamUnit4 1
WorkCenterFmlaParamUnit5 WorkCenterFmlaParamUnit5 1
WorkCenterFmlaParamUnit6 WorkCenterFmlaParamUnit6 1
WorkCenterFmlaParamValue1 WorkCenterFmlaParamValue1 1
WorkCenterFmlaParamValue2 WorkCenterFmlaParamValue2 1
WorkCenterFmlaParamValue3 WorkCenterFmlaParamValue3 1
WorkCenterFmlaParamValue4 WorkCenterFmlaParamValue4 1
WorkCenterFmlaParamValue5 WorkCenterFmlaParamValue5 1
WorkCenterFmlaParamValue6 WorkCenterFmlaParamValue6 1
WorkCenterFormulaParam1 WorkCenterFormulaParam1 1
WorkCenterFormulaParam2 WorkCenterFormulaParam2 1
WorkCenterFormulaParam3 WorkCenterFormulaParam3 1
WorkCenterFormulaParam4 WorkCenterFormulaParam4 1
WorkCenterFormulaParam5 WorkCenterFormulaParam5 1
WorkCenterFormulaParam6 WorkCenterFormulaParam6 1
WorkCenterMinimumQueueDuration WorkCenterMinimumQueueDuration 1
WorkCenterMinimumQueueDurnUnit WorkCenterMinimumQueueDurnUnit 1
WorkCenterResponsible WorkCenterResponsible 7
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
WrkCtrStdValMaintRule1 WrkCtrStdValMaintRule1 1
WrkCtrStdValMaintRule2 WrkCtrStdValMaintRule2 1
WrkCtrStdValMaintRule3 WrkCtrStdValMaintRule3 1
WrkCtrStdValMaintRule4 WrkCtrStdValMaintRule4 1
WrkCtrStdValMaintRule5 WrkCtrStdValMaintRule5 1
WrkCtrStdValMaintRule6 WrkCtrStdValMaintRule6 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_WORKCENTER (
    WORKCENTER,
    WORKCENTERINTERNALID,
    WORKCENTERTYPECODE,
    _PLANT,
    _STANDARDWORKFMLAPARAMGROUP,
    _TEXT,
    _WORKCENTER,
    _WORKCENTERCATEGORY,
    _WORKCENTERCOSTCENTER,
    _WORKCENTERTYPE,
    CAPACITYINTERNALID,
    EMPLOYEESUITABILITY,
    EMPLOYEEWAGEGROUP,
    EMPLOYEEWAGEGROUPISREFERENCED,
    EMPLOYEEWAGETYPE,
    EMPLOYEEWAGETYPEISREFERENCED,
    EMPLSUITABILITYISREFERENCED,
    NMBROFTIMETICKETSISREFERENCED,
    NUMBEROFCONFIRMATIONSLIPS,
    NUMBEROFCONFSLIPSISREFERENCED,
    NUMBEROFTIMETICKETS,
    OPCONTROLPROFILEISREFERENCED,
    OPERATIONCONTROLPROFILE,
    PLANT,
    STANDARDWORKFORMULAPARAMGROUP,
    SUPPLYAREA,
    VALIDITYENDDATE,
    VALIDITYSTARTDATE,
    WORKCENTERCATEGORYCODE,
    WORKCENTERFMLAPARAMUNIT1,
    WORKCENTERFMLAPARAMUNIT2,
    WORKCENTERFMLAPARAMUNIT3,
    WORKCENTERFMLAPARAMUNIT4,
    WORKCENTERFMLAPARAMUNIT5,
    WORKCENTERFMLAPARAMUNIT6,
    WORKCENTERFMLAPARAMVALUE1,
    WORKCENTERFMLAPARAMVALUE2,
    WORKCENTERFMLAPARAMVALUE3,
    WORKCENTERFMLAPARAMVALUE4,
    WORKCENTERFMLAPARAMVALUE5,
    WORKCENTERFMLAPARAMVALUE6,
    WORKCENTERFORMULAPARAM1,
    WORKCENTERFORMULAPARAM2,
    WORKCENTERFORMULAPARAM3,
    WORKCENTERFORMULAPARAM4,
    WORKCENTERFORMULAPARAM5,
    WORKCENTERFORMULAPARAM6,
    WORKCENTERMINIMUMQUEUEDURATION,
    WORKCENTERMINIMUMQUEUEDURNUNIT,
    WORKCENTERRESPONSIBLE,
    WORKCENTERSETPTYPEISREFERENCED,
    WORKCENTERSETUPTYPE,
    WORKCENTERSTANDARDQUEUEDURN,
    WORKCENTERSTANDARDWORKQTYUNIT1,
    WORKCENTERSTANDARDWORKQTYUNIT2,
    WORKCENTERSTANDARDWORKQTYUNIT3,
    WORKCENTERSTANDARDWORKQTYUNIT4,
    WORKCENTERSTANDARDWORKQTYUNIT5,
    WORKCENTERSTANDARDWORKQTYUNIT6,
    WORKCENTERSTDQUEUEDURNUNIT,
    WRKCTRSTDVALMAINTRULE1,
    WRKCTRSTDVALMAINTRULE2,
    WRKCTRSTDVALMAINTRULE3,
    WRKCTRSTDVALMAINTRULE4,
    WRKCTRSTDVALMAINTRULE5,
    WRKCTRSTDVALMAINTRULE6,
    PRIMARY KEY (WORKCENTER, WORKCENTERINTERNALID, WORKCENTERTYPECODE)
);

Learn More