P_WorkCenterActivity1

DDL: P_WORKCENTERACTIVITY1 SQL: PWRKCNTRACT1 Type: view_entity COMPOSITE
59 Fields 2 Data Sources

P_WorkCenterActivity1 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_StandardWorkFmlaParamGroup, I_WorkCenter) and exposes 59 fields with key fields WorkCenterInternalID, WorkCenterTypeCode.

Data Sources (2)

SourceAliasJoin Type
I_StandardWorkFmlaParamGroup tc21 inner
I_WorkCenter wrkctr from

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY WorkCenterInternalID I_WorkCenter WorkCenterInternalID Work Center
KEY WorkCenterTypeCode I_WorkCenter WorkCenterTypeCode Object Type
WorkCenterCategoryCode I_WorkCenter WorkCenterCategoryCode Work Center Category
WorkCenter I_WorkCenter WorkCenter Work Center
Plant I_WorkCenter Plant Valuation Area
StandardWorkFormulaParamGroup I_WorkCenter StandardWorkFormulaParamGroup Std Value Key
StandardWorkFormulaParam1 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam1 Parameter
StandardWorkFormulaParam2 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam2 Parameter
StandardWorkFormulaParam3 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam3 Parameter
StandardWorkFormulaParam4 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam4 Parameter
StandardWorkFormulaParam5 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam5 Parameter
StandardWorkFormulaParam6 I_StandardWorkFmlaParamGroup StandardWorkFormulaParam6 Parameter
CostCenterAllocation1 costctr1 CostCenterAllocation
ControllingArea1 costctr1 ControllingArea Controlling Area
CostCtrActivityType1 costctr1 CostCtrActivityType Activity Type
ActivityDescOriginType1 costctr1 ActivityDescOriginType
CostCenterActivityAltvDescID1 costctr1 CostCenterActivityAltvDescID
ValidityStartDate1 costctr1 ValidityStartDate Validity Start Date
ValidityEndDate1 costctr1 ValidityEndDate ValidTo
CostCenterAllocation2 costctr2 CostCenterAllocation
ControllingArea2 costctr2 ControllingArea Controlling Area
CostCtrActivityType2 costctr2 CostCtrActivityType Activity Type
ActivityDescOriginType2 costctr2 ActivityDescOriginType
CostCenterActivityAltvDescID2 costctr2 CostCenterActivityAltvDescID
ValidityStartDate2 costctr2 ValidityStartDate Validity Start Date
ValidityEndDate2 costctr2 ValidityEndDate ValidTo
CostCenterAllocation3 costctr3 CostCenterAllocation
ControllingArea3 costctr3 ControllingArea Controlling Area
CostCtrActivityType3 costctr3 CostCtrActivityType Activity Type
ActivityDescOriginType3 costctr3 ActivityDescOriginType
CostCenterActivityAltvDescID3 costctr3 CostCenterActivityAltvDescID
ValidityStartDate3 costctr3 ValidityStartDate Validity Start Date
ValidityEndDate3 costctr3 ValidityEndDate ValidTo
CostCenterAllocation4 costctr4 CostCenterAllocation
ControllingArea4 costctr4 ControllingArea Controlling Area
CostCtrActivityType4 costctr4 CostCtrActivityType Activity Type
ActivityDescOriginType4 costctr4 ActivityDescOriginType
CostCenterActivityAltvDescID4 costctr4 CostCenterActivityAltvDescID
ValidityStartDate4 costctr4 ValidityStartDate Validity Start Date
ValidityEndDate4 costctr4 ValidityEndDate ValidTo
CostCenterAllocation5 costctr5 CostCenterAllocation
ControllingArea5 costctr5 ControllingArea Controlling Area
CostCtrActivityType5 costctr5 CostCtrActivityType Activity Type
ActivityDescOriginType5 costctr5 ActivityDescOriginType
CostCenterActivityAltvDescID5 costctr5 CostCenterActivityAltvDescID
ValidityStartDate5 costctr5 ValidityStartDate Validity Start Date
ValidityEndDate5 costctr5 ValidityEndDate ValidTo
CostCenterAllocation6 costctr6 CostCenterAllocation
ControllingArea6 costctr6 ControllingArea Controlling Area
CostCtrActivityType6 costctr6 CostCtrActivityType Activity Type
ActivityDescOriginType6 costctr6 ActivityDescOriginType
CostCenterActivityAltvDescID6 costctr6 CostCenterActivityAltvDescID
ValidityStartDate6 costctr6 ValidityStartDate Validity Start Date
ValidityEndDate6 costctr6 ValidityEndDate ValidTo
_WorkCenter I_WorkCenter _WorkCenter
_WorkCenterType I_WorkCenter _WorkCenterType
_WorkCenterCategory I_WorkCenter _WorkCenterCategory
_Plant I_WorkCenter _Plant
_StandardWorkFmlaParamGroup I_WorkCenter _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 P_WorkCenterActivity1.
-- 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: PWRKCNTRACT1

CREATE VIEW P_WorkCenterActivity1 AS
SELECT
  wrkctr.WorkCenterInternalID AS WorkCenterInternalID,
  wrkctr.WorkCenterTypeCode AS WorkCenterTypeCode,
  wrkctr.WorkCenterCategoryCode AS WorkCenterCategoryCode,
  wrkctr.WorkCenter AS WorkCenter,
  wrkctr.Plant AS Plant,
  wrkctr.StandardWorkFormulaParamGroup AS StandardWorkFormulaParamGroup,
  tc21.StandardWorkFormulaParam1 AS StandardWorkFormulaParam1,
  tc21.StandardWorkFormulaParam2 AS StandardWorkFormulaParam2,
  tc21.StandardWorkFormulaParam3 AS StandardWorkFormulaParam3,
  tc21.StandardWorkFormulaParam4 AS StandardWorkFormulaParam4,
  tc21.StandardWorkFormulaParam5 AS StandardWorkFormulaParam5,
  tc21.StandardWorkFormulaParam6 AS StandardWorkFormulaParam6,
  costctr1.CostCenterAllocation AS CostCenterAllocation1,
  costctr1.ControllingArea AS ControllingArea1,
  costctr1.CostCtrActivityType AS CostCtrActivityType1,
  costctr1.ActivityDescOriginType AS ActivityDescOriginType1,
  costctr1.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID1,
  costctr1.ValidityStartDate AS ValidityStartDate1,
  costctr1.ValidityEndDate AS ValidityEndDate1,
  costctr2.CostCenterAllocation AS CostCenterAllocation2,
  costctr2.ControllingArea AS ControllingArea2,
  costctr2.CostCtrActivityType AS CostCtrActivityType2,
  costctr2.ActivityDescOriginType AS ActivityDescOriginType2,
  costctr2.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID2,
  costctr2.ValidityStartDate AS ValidityStartDate2,
  costctr2.ValidityEndDate AS ValidityEndDate2,
  costctr3.CostCenterAllocation AS CostCenterAllocation3,
  costctr3.ControllingArea AS ControllingArea3,
  costctr3.CostCtrActivityType AS CostCtrActivityType3,
  costctr3.ActivityDescOriginType AS ActivityDescOriginType3,
  costctr3.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID3,
  costctr3.ValidityStartDate AS ValidityStartDate3,
  costctr3.ValidityEndDate AS ValidityEndDate3,
  costctr4.CostCenterAllocation AS CostCenterAllocation4,
  costctr4.ControllingArea AS ControllingArea4,
  costctr4.CostCtrActivityType AS CostCtrActivityType4,
  costctr4.ActivityDescOriginType AS ActivityDescOriginType4,
  costctr4.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID4,
  costctr4.ValidityStartDate AS ValidityStartDate4,
  costctr4.ValidityEndDate AS ValidityEndDate4,
  costctr5.CostCenterAllocation AS CostCenterAllocation5,
  costctr5.ControllingArea AS ControllingArea5,
  costctr5.CostCtrActivityType AS CostCtrActivityType5,
  costctr5.ActivityDescOriginType AS ActivityDescOriginType5,
  costctr5.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID5,
  costctr5.ValidityStartDate AS ValidityStartDate5,
  costctr5.ValidityEndDate AS ValidityEndDate5,
  costctr6.CostCenterAllocation AS CostCenterAllocation6,
  costctr6.ControllingArea AS ControllingArea6,
  costctr6.CostCtrActivityType AS CostCtrActivityType6,
  costctr6.ActivityDescOriginType AS ActivityDescOriginType6,
  costctr6.CostCenterActivityAltvDescID AS CostCenterActivityAltvDescID6,
  costctr6.ValidityStartDate AS ValidityStartDate6,
  costctr6.ValidityEndDate AS ValidityEndDate6,
  wrkctr._WorkCenter AS _WorkCenter,
  wrkctr._WorkCenterType AS _WorkCenterType,
  wrkctr._WorkCenterCategory AS _WorkCenterCategory,
  wrkctr._Plant AS _Plant,
  wrkctr._StandardWorkFmlaParamGroup AS _StandardWorkFmlaParamGroup
FROM I_WorkCenter AS wrkctr
INNER JOIN I_StandardWorkFmlaParamGroup AS tc21 ON /* join condition not captured in parsed metadata */
;

Learn More