P_WorkCenterActivity1

Activity Definition by WorkCenter CostCenter | view: PWRKCNTRACT1 | Extraction: Not supported | Component: Virtual Data Model in PP Master Data

Tables used: TC21, CRHD, CRCO

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (12)
☰ Categorical (7)
Other (13)
🔗 Relations (22)

Column Name	Description
WorkCenterInternalID FK	Object ID of the resource
WorkCenterTypeCode	Object types of the CIM resource	Show values

Column Name	Description

Column Name	Description

Column Name	Description
ValidityStartDate1	Start Date
ValidityEndDate1	End Date
ValidityStartDate2	Start Date
ValidityEndDate2	End Date
ValidityStartDate3	Start Date
ValidityEndDate3	End Date
ValidityStartDate4	Start Date
ValidityEndDate4	End Date
ValidityStartDate5	Start Date
ValidityEndDate5	End Date
ValidityStartDate6	Start Date
ValidityEndDate6	End Date

Column Name	Description
WorkCenterTypeCode	Object types of the CIM resource	Show values
ActivityDescOriginType1	Activity Description Origin Type	Show values
ActivityDescOriginType2	Activity Description Origin Type	Show values
ActivityDescOriginType3	Activity Description Origin Type	Show values
ActivityDescOriginType4	Activity Description Origin Type	Show values
ActivityDescOriginType5	Activity Description Origin Type	Show values
ActivityDescOriginType6	Activity Description Origin Type	Show values

Column Name	Description	Domain name
WorkCenter	Work Center	ARBPL
CostCenterAllocation1	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID1	ID for Alternative Activity Description	CHAR4
CostCenterAllocation2	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID2	ID for Alternative Activity Description	CHAR4
CostCenterAllocation3	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID3	ID for Alternative Activity Description	CHAR4
CostCenterAllocation4	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID4	ID for Alternative Activity Description	CHAR4
CostCenterAllocation5	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID5	ID for Alternative Activity Description	CHAR4
CostCenterAllocation6	Cost Center Allocation	NUM4
CostCenterActivityAltvDescID6	ID for Alternative Activity Description	CHAR4

Master Data Relations	Join Conditions
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Controlling Area Client Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area	`P_WORKCENTERACTIVITY1.MANDT == TKA01.MANDT` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == TKA01.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == TKA01.KOKRS`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Activity Type Client End Date End Date End Date End Date End Date End Date Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Controlling Area Activity Type Activity Type Activity Type Activity Type Activity Type Activity Type	`P_WORKCENTERACTIVITY1.MANDT == CSLA.MANDT` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE1 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE2 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE5 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE6 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE3 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.VALIDITYENDDATE4 == CSLA.DATBI` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA5 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA4 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA1 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA3 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA6 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.CONTROLLINGAREA2 == CSLA.KOKRS` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE5 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE2 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE3 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE4 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE1 == CSLA.LSTAR` `P_WORKCENTERACTIVITY1.COSTCTRACTIVITYTYPE6 == CSLA.LSTAR`
Plant Plant Client	`P_WORKCENTERACTIVITY1.PLANT == T001W.WERKS` `P_WORKCENTERACTIVITY1.MANDT == T001W.MANDT`
Parameter ID Parameter ID Client	`P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM1 == TC20.PARID` `P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT`
Parameter ID Parameter ID Client	`P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM2 == TC20.PARID` `P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT`
Parameter ID Client Parameter ID	`P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT` `P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM3 == TC20.PARID`
Parameter ID Client Parameter ID	`P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT` `P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM4 == TC20.PARID`
Parameter ID Client Parameter ID	`P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT` `P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM5 == TC20.PARID`
Parameter ID Parameter ID Client	`P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAM6 == TC20.PARID` `P_WORKCENTERACTIVITY1.MANDT == TC20.MANDT`
Standard Value Key Client Standard Value Key	`P_WORKCENTERACTIVITY1.MANDT == TC21.MANDT` `P_WORKCENTERACTIVITY1.STANDARDWORKFORMULAPARAMGROUP == TC21.VGWTS`
Work Center Category Client Work Center Category	`P_WORKCENTERACTIVITY1.MANDT == TC30.MANDT` `P_WORKCENTERACTIVITY1.WORKCENTERCATEGORYCODE == TC30.VERWE`
Object ID of the resource Object types of the CIM resource Client Object ID of the resource	`P_WORKCENTERACTIVITY1.WORKCENTERTYPECODE == CRID.OBJTY` `P_WORKCENTERACTIVITY1.MANDT == CRID.MANDT` `P_WORKCENTERACTIVITY1.WORKCENTERINTERNALID == CRID.OBJID`