P_ProdnModOperationWorkCenter
Production Model WorkCenter
P_ProdnModOperationWorkCenter is a Composite CDS View that provides data about "Production Model WorkCenter" in SAP S/4HANA. It reads from 1 data source (I_WorkCenter) and exposes 74 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_WorkCenter | WorkCenter | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Production Model WorkCenter | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| Metadata.ignorePropagatedAnnotations | true | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #S | view | |
| ObjectModel.usageType.dataClass | #MASTER | view |
Fields (74)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | WorkCenterInternalID | I_WorkCenter | WorkCenterInternalID | Work Center |
| KEY | WorkCenterTypeCode | I_WorkCenter | WorkCenterTypeCode | Object Type |
| WorkCenter | I_WorkCenter | WorkCenter | Work Center | |
| Plant | I_WorkCenter | Plant | Valuation Area | |
| SupplyArea | I_WorkCenter | SupplyArea | Supply Area | |
| OperationControlProfile | I_WorkCenter | OperationControlProfile | Control Key | |
| NumberOfTimeTickets | I_WorkCenter | NumberOfTimeTickets | No.TimeTickets | |
| NumberOfConfirmationSlips | I_WorkCenter | NumberOfConfirmationSlips | No. of Conf. Slips | |
| EmployeeWageGroup | I_WorkCenter | EmployeeWageGroup | Wage Group | |
| EmployeeWageType | I_WorkCenter | EmployeeWageType | Wage type | |
| EmployeeSuitability | I_WorkCenter | EmployeeSuitability | ||
| WorkCenterSetupType | I_WorkCenter | WorkCenterSetupType | ||
| ValidityStartDate | I_WorkCenter | ValidityStartDate | Validity Start Date | |
| ValidityEndDate | I_WorkCenter | ValidityEndDate | ValidTo | |
| NmbrOfTimeTicketsIsReferenced | I_WorkCenter | NmbrOfTimeTicketsIsReferenced | No. Time Ticktes Ref | |
| NumberOfConfSlipsIsReferenced | I_WorkCenter | NumberOfConfSlipsIsReferenced | No. Conf. Slips Ref. | |
| EmployeeWageGroupIsReferenced | I_WorkCenter | EmployeeWageGroupIsReferenced | Wage Group Ref. | |
| EmployeeWageTypeIsReferenced | I_WorkCenter | EmployeeWageTypeIsReferenced | Wage Type Ref. | |
| WorkCenterSetpTypeIsReferenced | I_WorkCenter | WorkCenterSetpTypeIsReferenced | Setup Type Ref. | |
| OpControlProfileIsReferenced | I_WorkCenter | OpControlProfileIsReferenced | Control Profile Ref. | |
| EmplSuitabilityIsReferenced | I_WorkCenter | EmplSuitabilityIsReferenced | Suitability Ref. | |
| WorkCenterStdQueueDurnUnit | I_WorkCenter | WorkCenterStdQueueDurnUnit | Std Queue Unit | |
| WorkCenterStandardQueueDurn | I_WorkCenter | WorkCenterStandardQueueDurn | Min. Queue Time | |
| WorkCenterMinimumQueueDurnUnit | I_WorkCenter | WorkCenterMinimumQueueDurnUnit | Std Queue Unit | |
| WorkCenterMinimumQueueDuration | I_WorkCenter | WorkCenterMinimumQueueDuration | Min. Queue Time | |
| CostCenter | CostCtrActType1 | CostCenter | Cost Center | |
| WorkCenterFormulaParam1 | I_WorkCenter | WorkCenterFormulaParam1 | ||
| WorkCenterFormulaParam2 | I_WorkCenter | WorkCenterFormulaParam2 | ||
| WorkCenterFormulaParam3 | I_WorkCenter | WorkCenterFormulaParam3 | ||
| WorkCenterFormulaParam4 | I_WorkCenter | WorkCenterFormulaParam4 | ||
| WorkCenterFormulaParam5 | I_WorkCenter | WorkCenterFormulaParam5 | ||
| WorkCenterFormulaParam6 | I_WorkCenter | WorkCenterFormulaParam6 | ||
| WorkCenterFmlaParamValue1 | I_WorkCenter | WorkCenterFmlaParamValue1 | ||
| WorkCenterFmlaParamValue2 | I_WorkCenter | WorkCenterFmlaParamValue2 | ||
| WorkCenterFmlaParamValue3 | I_WorkCenter | WorkCenterFmlaParamValue3 | ||
| WorkCenterFmlaParamValue4 | I_WorkCenter | WorkCenterFmlaParamValue4 | ||
| WorkCenterFmlaParamValue5 | I_WorkCenter | WorkCenterFmlaParamValue5 | ||
| WorkCenterFmlaParamValue6 | I_WorkCenter | WorkCenterFmlaParamValue6 | ||
| WorkCenterFmlaParamUnit1 | I_WorkCenter | WorkCenterFmlaParamUnit1 | ||
| WorkCenterFmlaParamUnit2 | I_WorkCenter | WorkCenterFmlaParamUnit2 | ||
| WorkCenterFmlaParamUnit3 | I_WorkCenter | WorkCenterFmlaParamUnit3 | ||
| WorkCenterFmlaParamUnit4 | I_WorkCenter | WorkCenterFmlaParamUnit4 | ||
| WorkCenterFmlaParamUnit5 | I_WorkCenter | WorkCenterFmlaParamUnit5 | ||
| WorkCenterFmlaParamUnit6 | I_WorkCenter | WorkCenterFmlaParamUnit6 | ||
| WrkCtrStdValMaintRule1 | I_WorkCenter | WrkCtrStdValMaintRule1 | ||
| WrkCtrStdValMaintRule2 | I_WorkCenter | WrkCtrStdValMaintRule2 | ||
| WrkCtrStdValMaintRule3 | I_WorkCenter | WrkCtrStdValMaintRule3 | ||
| WrkCtrStdValMaintRule4 | I_WorkCenter | WrkCtrStdValMaintRule4 | ||
| WrkCtrStdValMaintRule5 | I_WorkCenter | WrkCtrStdValMaintRule5 | ||
| WrkCtrStdValMaintRule6 | I_WorkCenter | WrkCtrStdValMaintRule6 | ||
| WorkCenterStandardWorkQtyUnit1 | I_WorkCenter | WorkCenterStandardWorkQtyUnit1 | ||
| WorkCenterStandardWorkQtyUnit2 | I_WorkCenter | WorkCenterStandardWorkQtyUnit2 | ||
| WorkCenterStandardWorkQtyUnit3 | I_WorkCenter | WorkCenterStandardWorkQtyUnit3 | ||
| WorkCenterStandardWorkQtyUnit4 | I_WorkCenter | WorkCenterStandardWorkQtyUnit4 | ||
| WorkCenterStandardWorkQtyUnit5 | I_WorkCenter | WorkCenterStandardWorkQtyUnit5 | ||
| WorkCenterStandardWorkQtyUnit6 | I_WorkCenter | WorkCenterStandardWorkQtyUnit6 | ||
| StandardWorkFormulaParamName1 | StdWorkFmlaParam1 | StandardWorkFormulaParamName | ||
| StandardWorkFormulaParamName2 | StdWorkFmlaParam2 | StandardWorkFormulaParamName | ||
| StandardWorkFormulaParamName3 | StdWorkFmlaParam3 | StandardWorkFormulaParamName | ||
| StandardWorkFormulaParamName4 | StdWorkFmlaParam4 | StandardWorkFormulaParamName | ||
| StandardWorkFormulaParamName5 | StdWorkFmlaParam5 | StandardWorkFormulaParamName | ||
| StandardWorkFormulaParamName6 | StdWorkFmlaParam6 | StandardWorkFormulaParamName | ||
| CostCtrActivityType1 | CostCtrActType1 | CostCtrActivityType | Activity Type | |
| CostCtrActyType1IsReferenced | CostCtrActType1 | CostCtrActyTypeIsReferenced | ||
| CostCtrActivityType2 | CostCtrActType2 | CostCtrActivityType | Activity Type | |
| CostCtrActyType2IsReferenced | CostCtrActType2 | CostCtrActyTypeIsReferenced | ||
| CostCtrActivityType3 | CostCtrActType3 | CostCtrActivityType | Activity Type | |
| CostCtrActyType3IsReferenced | CostCtrActType3 | CostCtrActyTypeIsReferenced | ||
| CostCtrActivityType4 | CostCtrActType4 | CostCtrActivityType | Activity Type | |
| CostCtrActyType4IsReferenced | CostCtrActType4 | CostCtrActyTypeIsReferenced | ||
| CostCtrActivityType5 | CostCtrActType5 | CostCtrActivityType | Activity Type | |
| CostCtrActyType5IsReferenced | CostCtrActType5 | CostCtrActyTypeIsReferenced | ||
| CostCtrActivityType6 | CostCtrActType6 | CostCtrActivityType | Activity Type | |
| CostCtrActyType6IsReferenced | CostCtrActType6 | CostCtrActyTypeIsReferenced |
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 P_ProdnModOperationWorkCenter.
-- 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.
CREATE VIEW P_ProdnModOperationWorkCenter AS
SELECT
WorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
WorkCenter.WorkCenterTypeCode AS WorkCenterTypeCode,
WorkCenter.WorkCenter AS WorkCenter,
WorkCenter.Plant AS Plant,
WorkCenter.SupplyArea AS SupplyArea,
WorkCenter.OperationControlProfile AS OperationControlProfile,
WorkCenter.NumberOfTimeTickets AS NumberOfTimeTickets,
WorkCenter.NumberOfConfirmationSlips AS NumberOfConfirmationSlips,
WorkCenter.EmployeeWageGroup AS EmployeeWageGroup,
WorkCenter.EmployeeWageType AS EmployeeWageType,
WorkCenter.EmployeeSuitability AS EmployeeSuitability,
WorkCenter.WorkCenterSetupType AS WorkCenterSetupType,
WorkCenter.ValidityStartDate AS ValidityStartDate,
WorkCenter.ValidityEndDate AS ValidityEndDate,
WorkCenter.NmbrOfTimeTicketsIsReferenced AS NmbrOfTimeTicketsIsReferenced,
WorkCenter.NumberOfConfSlipsIsReferenced AS NumberOfConfSlipsIsReferenced,
WorkCenter.EmployeeWageGroupIsReferenced AS EmployeeWageGroupIsReferenced,
WorkCenter.EmployeeWageTypeIsReferenced AS EmployeeWageTypeIsReferenced,
WorkCenter.WorkCenterSetpTypeIsReferenced AS WorkCenterSetpTypeIsReferenced,
WorkCenter.OpControlProfileIsReferenced AS OpControlProfileIsReferenced,
WorkCenter.EmplSuitabilityIsReferenced AS EmplSuitabilityIsReferenced,
WorkCenter.WorkCenterStdQueueDurnUnit AS WorkCenterStdQueueDurnUnit,
WorkCenter.WorkCenterStandardQueueDurn AS WorkCenterStandardQueueDurn,
WorkCenter.WorkCenterMinimumQueueDurnUnit AS WorkCenterMinimumQueueDurnUnit,
WorkCenter.WorkCenterMinimumQueueDuration AS WorkCenterMinimumQueueDuration,
CostCtrActType1.CostCenter AS CostCenter,
WorkCenter.WorkCenterFormulaParam1 AS WorkCenterFormulaParam1,
WorkCenter.WorkCenterFormulaParam2 AS WorkCenterFormulaParam2,
WorkCenter.WorkCenterFormulaParam3 AS WorkCenterFormulaParam3,
WorkCenter.WorkCenterFormulaParam4 AS WorkCenterFormulaParam4,
WorkCenter.WorkCenterFormulaParam5 AS WorkCenterFormulaParam5,
WorkCenter.WorkCenterFormulaParam6 AS WorkCenterFormulaParam6,
WorkCenter.WorkCenterFmlaParamValue1 AS WorkCenterFmlaParamValue1,
WorkCenter.WorkCenterFmlaParamValue2 AS WorkCenterFmlaParamValue2,
WorkCenter.WorkCenterFmlaParamValue3 AS WorkCenterFmlaParamValue3,
WorkCenter.WorkCenterFmlaParamValue4 AS WorkCenterFmlaParamValue4,
WorkCenter.WorkCenterFmlaParamValue5 AS WorkCenterFmlaParamValue5,
WorkCenter.WorkCenterFmlaParamValue6 AS WorkCenterFmlaParamValue6,
WorkCenter.WorkCenterFmlaParamUnit1 AS WorkCenterFmlaParamUnit1,
WorkCenter.WorkCenterFmlaParamUnit2 AS WorkCenterFmlaParamUnit2,
WorkCenter.WorkCenterFmlaParamUnit3 AS WorkCenterFmlaParamUnit3,
WorkCenter.WorkCenterFmlaParamUnit4 AS WorkCenterFmlaParamUnit4,
WorkCenter.WorkCenterFmlaParamUnit5 AS WorkCenterFmlaParamUnit5,
WorkCenter.WorkCenterFmlaParamUnit6 AS WorkCenterFmlaParamUnit6,
WorkCenter.WrkCtrStdValMaintRule1 AS WrkCtrStdValMaintRule1,
WorkCenter.WrkCtrStdValMaintRule2 AS WrkCtrStdValMaintRule2,
WorkCenter.WrkCtrStdValMaintRule3 AS WrkCtrStdValMaintRule3,
WorkCenter.WrkCtrStdValMaintRule4 AS WrkCtrStdValMaintRule4,
WorkCenter.WrkCtrStdValMaintRule5 AS WrkCtrStdValMaintRule5,
WorkCenter.WrkCtrStdValMaintRule6 AS WrkCtrStdValMaintRule6,
WorkCenter.WorkCenterStandardWorkQtyUnit1 AS WorkCenterStandardWorkQtyUnit1,
WorkCenter.WorkCenterStandardWorkQtyUnit2 AS WorkCenterStandardWorkQtyUnit2,
WorkCenter.WorkCenterStandardWorkQtyUnit3 AS WorkCenterStandardWorkQtyUnit3,
WorkCenter.WorkCenterStandardWorkQtyUnit4 AS WorkCenterStandardWorkQtyUnit4,
WorkCenter.WorkCenterStandardWorkQtyUnit5 AS WorkCenterStandardWorkQtyUnit5,
WorkCenter.WorkCenterStandardWorkQtyUnit6 AS WorkCenterStandardWorkQtyUnit6,
StdWorkFmlaParam1.StandardWorkFormulaParamName AS StandardWorkFormulaParamName1,
StdWorkFmlaParam2.StandardWorkFormulaParamName AS StandardWorkFormulaParamName2,
StdWorkFmlaParam3.StandardWorkFormulaParamName AS StandardWorkFormulaParamName3,
StdWorkFmlaParam4.StandardWorkFormulaParamName AS StandardWorkFormulaParamName4,
StdWorkFmlaParam5.StandardWorkFormulaParamName AS StandardWorkFormulaParamName5,
StdWorkFmlaParam6.StandardWorkFormulaParamName AS StandardWorkFormulaParamName6,
CostCtrActType1.CostCtrActivityType AS CostCtrActivityType1,
CostCtrActType1.CostCtrActyTypeIsReferenced AS CostCtrActyType1IsReferenced,
CostCtrActType2.CostCtrActivityType AS CostCtrActivityType2,
CostCtrActType2.CostCtrActyTypeIsReferenced AS CostCtrActyType2IsReferenced,
CostCtrActType3.CostCtrActivityType AS CostCtrActivityType3,
CostCtrActType3.CostCtrActyTypeIsReferenced AS CostCtrActyType3IsReferenced,
CostCtrActType4.CostCtrActivityType AS CostCtrActivityType4,
CostCtrActType4.CostCtrActyTypeIsReferenced AS CostCtrActyType4IsReferenced,
CostCtrActType5.CostCtrActivityType AS CostCtrActivityType5,
CostCtrActType5.CostCtrActyTypeIsReferenced AS CostCtrActyType5IsReferenced,
CostCtrActType6.CostCtrActivityType AS CostCtrActivityType6,
CostCtrActType6.CostCtrActyTypeIsReferenced AS CostCtrActyType6IsReferenced
FROM I_WorkCenter AS WorkCenter
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- 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
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA