TCYMPP SAP (Customizing Settings for Workforce Planning) Table details
Description: Customizing Settings for Workforce Planning
Table field list including key, data, relationships and ABAP select examples
TCYMPP is a standard SAP Table which is used to store Customizing Settings for Workforce Planning data and is available within R/3 SAP systems depending on the version and release level.
The TCYMPP table consists of various fields, each holding specific information or linking keys about Customizing Settings for Workforce Planning data available in SAP. These include MPPPRO_ID (Profile for work force planning), PEAVAICAP (Display working time for personnel resource), PEOVRLOAD (Display total load for a personnel resource), ALLOCWRK (Display distributed/undistributed work).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: E - Control table, SAP and customer have separate key areasDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
Text table = TCYMPPT
SAP TCYMPP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MPPPRO_ID | Profile for work force planning | CY_MPPPRO | CHAR | 10 | CY_MPPPRO | CY# | |||
PEAVAICAP | Display working time for personnel resource | CY_PEAVCA | CHAR | 1 | KREUZ | ||||
PEOVRLOAD | Display total load for a personnel resource | CY_PEOVLD | CHAR | 1 | KREUZ | ||||
ALLOCWRK | Display distributed/undistributed work | CY_ALCWRK | CHAR | 1 | KREUZ | ||||
PERTYPE | Unit in which the duration of a period is specified | CY_DAPER | CHAR | 1 | CY_DAPER | ||||
MIXED_PERIODS | Mixed period types | CY_MIXED_PERIODS | CHAR | 1 | KREUZ | ||||
PLNGTIMT | Type of entry planning period | CY_PLATIMT | CHAR | 1 | CY_ZAPER | ||||
PLNGDATF | Start date for planning period | CY_PLADATF | CHAR | 10 | CHAR10 | ||||
PLNGDATT | Finish date for planning period | CY_PLADATT | CHAR | 10 | CHAR10 | ||||
DSTRBWRK | Distribute work to first/last day of the period | CY_DSTRBW | CHAR | 1 | KREUZ | ||||
OUTPUTLEN | Width of planning periods | CY_OUTLEN | NUMC | 6 | |||||
SHOW_NETWORK | Display network | CY_SHOW_NETWORK | CHAR | 1 | KREUZ | ||||
FISCAL_YEAR_VAR | Fiscal Year Variant | PERIV | CHAR | 2 | T009 | PERIV | |||
CALENDAR_ID | Factory Calendar | WFCID | CHAR | 2 | TFACD | WFCID | FCI | ||
PERSONS | Allow selection of other personel resources for assignments | CY_PERSONS | CHAR | 1 | KREUZ | ||||
P_LE_PERCENT | Load on personnel resource in % | CY_PERCENT | DEC | 5(2) | PRZ32 | ||||
P_LE_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
P_GT_PERCENT | Load on personnel resource in % | CY_PERCENT | DEC | 5(2) | PRZ32 | ||||
P_GT_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
P_GT_LE_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
P_COLOUR_1 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ | ||||
P_COLOUR_2 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ | ||||
P_COLOUR_3 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ | ||||
A_LE_PERCENT | Percentage of the activity work that has been distributed | CY_A_PERCENT | DEC | 5(2) | PRZ32 | ||||
A_LE_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
A_GT_PERCENT | Percentage of the activity work that has been distributed | CY_A_PERCENT | DEC | 5(2) | PRZ32 | ||||
A_GT_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
A_GT_LE_COLOUR | Light color for reporting | CY_COLOUR | NUMC | 1 | CY_COLOUR | ||||
A_COLOUR_1 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ | ||||
A_COLOUR_2 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ | ||||
A_COLOUR_3 | Display traffic light | CY_DISPLAY_COLOUR | CHAR | 1 | KREUZ |
Key field | Non-key field |
How do I retrieve data from SAP table TCYMPP using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCYMPP to SELECT all data from the tableDATA: WA_TCYMPP TYPE TCYMPP.
SELECT SINGLE *
FROM TCYMPP
INTO CORRESPONDING FIELDS OF WA_TCYMPP
WHERE...
How to access SAP table TCYMPP
Within an ECC or HANA version of SAP you can also view further information about TCYMPP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects