What is I_WorkCenterBySemanticKey in SAP S/4HANA?

I_WorkCenterBySemanticKey is a basic CDS view in SAP S/4HANA. Work Center By Semantic Key It contains 87 fields.

Which tables does I_WorkCenterBySemanticKey read from?

I_WorkCenterBySemanticKey reads data from: I_WorkCenter.

What VDM layer is I_WorkCenterBySemanticKey?

I_WorkCenterBySemanticKey is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_WorkCenterBySemanticKey

DDL: I_WORKCENTERBYSEMANTICKEY SQL: IPPWRKCNTRBYSEMK Type: view BASIC Package: VDM_PP_MD_WKC

87 Fields 1 Data Sources 1 Associations 5 OData Services

Work Center By Semantic Key

I_WorkCenterBySemanticKey (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Public Edition with built-in and side-by-side extension capabilities.

Manufacturing

I_WorkCenterBySemanticKey is a Basic CDS View (Dimension) that provides data about "Work Center By Semantic Key" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 87 fields with key fields Plant, WorkCenter. It has 1 association to related views. It is exposed through 5 OData services (ASQL_F2262, ASQL_F2264, ASQL_F4989, ...). Part of development package VDM_PP_MD_WKC.

SAP API Hub

Category	Basic
State	C1
Line of Business	Manufacturing
Application Component	PP-VDM-MD-2CL
Capabilities	Analytical Dimension,Association Target for Defining CDS Entities,Data Source in SQL Select,Data Source for Defining CDS Entities,Data Source for Search
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Manufacturing for SAP S/4HANA Cloud Public Edition
Description	<p>With this CDS view, you can retrieve the work center master data (table CRHD) by semantic key. </p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li> <p>Which work centers are maintained in a plant?</p> </li> <li> <p>What is the internal key of a work center?</p> </li> <li> <p>What are the validity start and end dates of a work center?</p> </li> <li> <p>Who is the person responsible of a work center?</p> </li> <li> <p>What are the work center category and usage codes?</p> </li> <li> <p>Which standard work quantity (activity) unit of measures are maintained?</p> </li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_WorkCenter	I_WorkCenter	from

Associations (1)

Cardinality	Target	Alias	Condition
[0..*]	I_WorkCenterTextBySemanticKey	_WorkCenterTextBySemanticKey	`$projection.WorkCenter = _WorkCenterTextBySemanticKey.WorkCenter and $projection.Plant = _WorkCenterTextBySemanticKey.Plant`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	IPPWRKCNTRBYSEMK	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#NOT_REQUIRED	view
Analytics.dataCategory	#DIMENSION	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#CLIENT_DEPENDENT	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	WorkCenter	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
Search.searchable	true	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view
EndUserText.label	Work Center By Semantic Key	view

OData Services (5)

Service	Binding	Version	Contract	Release
ASQL_F2262	ASQL_F2262		C2	NOT_RELEASED
ASQL_F2264	ASQL_F2264		C2	NOT_RELEASED
ASQL_F4989	ASQL_F4989		C2	NOT_RELEASED
ASQL_F5723	ASQL_F5723		C2	NOT_RELEASED
UI_KANBANCONTAINER_MONITOR	UI_KANBANCONTAINER_MONITOR	V4	C1	NOT_RELEASED

Fields (87)

Key	Field	Source Field	Description
KEY	Plant	Plant	Valuation Area
KEY	WorkCenter	WorkCenter	Work Center
	WorkCenterInternalID	WorkCenterInternalID	Object ID of the resource
	WorkCenterTypeCode	WorkCenterTypeCode	Object types of the CIM resource
	WorkCenterIsToBeDeleted	WorkCenterIsToBeDeleted	Deletion flag for work center
	WorkCenterIsLocked	WorkCenterIsLocked	Indicator: Work center is locked
	WorkCenterIsMntndForCosting	WorkCenterIsMntndForCosting	Indicator: Work center is maintained for costing
	WorkCenterIsMntndForScheduling	WorkCenterIsMntndForScheduling	Indicator: Work center is maintained for scheduling
	NumberOfConfirmationSlips	NumberOfConfirmationSlips	Number of Confirmation Slips
	AdvancedPlanningIsSupported	AdvancedPlanningIsSupported	Indicator for Advanced Planning
	LaborTrackingIsRequired	LaborTrackingIsRequired	Indicates Whether Labor Tracking is Required for Execution
	WorkCenterCategoryCode	WorkCenterCategoryCode	Work Center Category
	WorkCenterLocation	WorkCenterLocation	Work center location
	WorkCenterLocationGroup	WorkCenterLocationGroup	Location Group
	WorkCenterUsage	WorkCenterUsage	Work Center Usage in Bill of Operations
	WorkCenterResponsible	WorkCenterResponsible	Person Responsible for the Work Center
	SupplyArea	SupplyArea	Production Supply Area
	CapacityInternalID	CapacityInternalID	Capacity ID
	MachineType	MachineType	Machine Type
	OperationControlProfile	OperationControlProfile	Operation Control Profile
	MatlCompIsMarkedForBackflush	MatlCompIsMarkedForBackflush	Indicator: Backflushing
	WorkCenterSetupType	WorkCenterSetupType	Work Center Setup Type
	FreeDefinedTableFieldSemantic	FreeDefinedTableFieldSemantic	Free Defined Table Field Semantic ID
	ObjectInternalID	ObjectInternalID	Object number
	StandardTextInternalID	StandardTextInternalID	Operation Standard Text Internal ID
	EmployeeWageType	EmployeeWageType	Employee Wage Type
	EmployeeWageGroup	EmployeeWageGroup	Employee Wage Group
	EmployeeSuitability	EmployeeSuitability	Employee Suitability
	NumberOfTimeTickets	NumberOfTimeTickets	Number of Time Tickets
	PlanVersion	PlanVersion	Plan Version
	ValidityStartDate	ValidityStartDate	Validity Start Date
	ValidityEndDate	ValidityEndDate	Valid-To Date
	StandardTextIDIsReferenced	StandardTextIDIsReferenced	Indicator: Standard Text ID is Referenced
	EmployeeWageTypeIsReferenced	EmployeeWageTypeIsReferenced	Indicator: Wage Type is Referenced
	NmbrOfTimeTicketsIsReferenced	NmbrOfTimeTicketsIsReferenced	Indicator: Number of Time Tickets is Referenced
	EmployeeWageGroupIsReferenced	EmployeeWageGroupIsReferenced	Indicator: Wage Group is Referenced
	EmplSuitabilityIsReferenced	EmplSuitabilityIsReferenced	Indicator: Suitability is Referenced
	WorkCenterSetpTypeIsReferenced	WorkCenterSetpTypeIsReferenced	Indicator: Setup Type Key is Referenced
	OpControlProfileIsReferenced	OpControlProfileIsReferenced	Indicator: Control Profile is Referenced
	NumberOfConfSlipsIsReferenced	NumberOfConfSlipsIsReferenced	Indicator: Number of Confirmation Slips is Referenced
	WorkCenterStdQueueDurnUnit	WorkCenterStdQueueDurnUnit	Unit for the Standard Queue Time
	WorkCenterStandardQueueDurn	WorkCenterStandardQueueDurn	Standard Queue Time
	WorkCenterMinimumQueueDurnUnit	WorkCenterMinimumQueueDurnUnit	Unit for the Minimum Queue Time
	WorkCenterMinimumQueueDuration	WorkCenterMinimumQueueDuration	Minimum Queue Time
	WorkCenterStandardWorkQtyUnit1	WorkCenterStandardWorkQtyUnit1	Standard Work Quantity Unit 1
	WorkCenterStandardWorkQtyUnit2	WorkCenterStandardWorkQtyUnit2	Standard Work Quantity Unit 2
	WorkCenterStandardWorkQtyUnit3	WorkCenterStandardWorkQtyUnit3	Standard Work Quantity Unit 3
	WorkCenterStandardWorkQtyUnit4	WorkCenterStandardWorkQtyUnit4	Standard Work Quantity Unit 4
	WorkCenterStandardWorkQtyUnit5	WorkCenterStandardWorkQtyUnit5	Standard Work Quantity Unit 5
	WorkCenterStandardWorkQtyUnit6	WorkCenterStandardWorkQtyUnit6	Standard Work Quantity Unit 6
	StandardWorkQuantityUnit	StandardWorkQuantityUnit	Unit of Measure of Work
	StandardWorkFormulaParamGroup	StandardWorkFormulaParamGroup	Standard Value Key
	WrkCtrStdValMaintRule1	WrkCtrStdValMaintRule1	Standard Value Maintenance Rule 1
	WrkCtrStdValMaintRule2	WrkCtrStdValMaintRule2	Standard Value Maintenance Rule 2
	WrkCtrStdValMaintRule3	WrkCtrStdValMaintRule3	Standard Value Maintenance Rule 3
	WrkCtrStdValMaintRule4	WrkCtrStdValMaintRule4	Standard Value Maintenance Rule 4
	WrkCtrStdValMaintRule5	WrkCtrStdValMaintRule5	Standard Value Maintenance Rule 5
	WrkCtrStdValMaintRule6	WrkCtrStdValMaintRule6	Standard Value Maintenance Rule 6
	_Plant	_Plant
	_WorkCenterType	_WorkCenterType
	_WorkCenterResponsible	_WorkCenterResponsible
	_WorkCenterCategory	_WorkCenterCategory
	_WorkCenterLocation	_WorkCenterLocation
	_WorkCenterLocationGroup	_WorkCenterLocationGroup
	_WorkCenterUsage	_WorkCenterUsage
	_Text	_Text
	_WorkCenterTextBySemanticKey	_WorkCenterTextBySemanticKey
	_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_WorkCenterBySemanticKey.
-- 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: IPPWRKCNTRBYSEMK

CREATE VIEW I_WorkCenterBySemanticKey AS
SELECT
  Plant,
  WorkCenter,
  WorkCenterInternalID,
  WorkCenterTypeCode,
  WorkCenterIsToBeDeleted,
  WorkCenterIsLocked,
  WorkCenterIsMntndForCosting,
  WorkCenterIsMntndForScheduling,
  NumberOfConfirmationSlips,
  AdvancedPlanningIsSupported,
  LaborTrackingIsRequired,
  WorkCenterCategoryCode,
  WorkCenterLocation,
  WorkCenterLocationGroup,
  WorkCenterUsage,
  WorkCenterResponsible,
  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,
  WrkCtrStdValMaintRule1,
  WrkCtrStdValMaintRule2,
  WrkCtrStdValMaintRule3,
  WrkCtrStdValMaintRule4,
  WrkCtrStdValMaintRule5,
  WrkCtrStdValMaintRule6
FROM I_WorkCenter
LEFT OUTER JOIN I_WorkCenterTextBySemanticKey AS _WorkCenterTextBySemanticKey ON WorkCenter = _WorkCenterTextBySemanticKey.WorkCenter AND Plant = _WorkCenterTextBySemanticKey.Plant  -- association [0..*]
;

Depth:

I_WorkCenterBySemanticKey view

I_WorkCenter view