TCYMPP SAP (Customizing Settings for Workforce Planning) Table details

Dictionary Type: Table
Description: Customizing Settings for Workforce Planning




ABAP Code to SELECT data from TCYMPP
Related tables to TCYMPP
Access table TCYMPP




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 areas
Display/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
MANDTClient MANDTCLNT3T000MANDT
MPPPRO_IDProfile for work force planning CY_MPPPROCHAR10CY_MPPPROCY#
PEAVAICAPDisplay working time for personnel resource CY_PEAVCACHAR1KREUZ
PEOVRLOADDisplay total load for a personnel resource CY_PEOVLDCHAR1KREUZ
ALLOCWRKDisplay distributed/undistributed work CY_ALCWRKCHAR1KREUZ
PERTYPEUnit in which the duration of a period is specified CY_DAPERCHAR1CY_DAPER
MIXED_PERIODSMixed period types CY_MIXED_PERIODSCHAR1KREUZ
PLNGTIMTType of entry planning period CY_PLATIMTCHAR1CY_ZAPER
PLNGDATFStart date for planning period CY_PLADATFCHAR10CHAR10
PLNGDATTFinish date for planning period CY_PLADATTCHAR10CHAR10
DSTRBWRKDistribute work to first/last day of the period CY_DSTRBWCHAR1KREUZ
OUTPUTLENWidth of planning periods CY_OUTLENNUMC6
SHOW_NETWORKDisplay network CY_SHOW_NETWORKCHAR1KREUZ
FISCAL_YEAR_VARFiscal Year Variant PERIVCHAR2T009PERIV
CALENDAR_IDFactory Calendar WFCIDCHAR2TFACDWFCIDFCI
PERSONSAllow selection of other personel resources for assignments CY_PERSONSCHAR1KREUZ
P_LE_PERCENTLoad on personnel resource in % CY_PERCENTDEC5(2) PRZ32
P_LE_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
P_GT_PERCENTLoad on personnel resource in % CY_PERCENTDEC5(2) PRZ32
P_GT_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
P_GT_LE_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
P_COLOUR_1Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ
P_COLOUR_2Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ
P_COLOUR_3Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ
A_LE_PERCENTPercentage of the activity work that has been distributed CY_A_PERCENTDEC5(2) PRZ32
A_LE_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
A_GT_PERCENTPercentage of the activity work that has been distributed CY_A_PERCENTDEC5(2) PRZ32
A_GT_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
A_GT_LE_COLOURLight color for reporting CY_COLOURNUMC1CY_COLOUR
A_COLOUR_1Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ
A_COLOUR_2Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ
A_COLOUR_3Display traffic light CY_DISPLAY_COLOURCHAR1KREUZ

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!