CF002 SAP (Human Resources) Pooled Table details

Dictionary Type: Pooled Table
Description: Human Resources




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




Pooled Table field list including key, data, relationships and ABAP select examples

CF002 is a standard SAP Pooled Table which is used to store Human Resources data and is available within R/3 SAP systems depending on the version and release level.

The CF002 table consists of various fields, each holding specific information or linking keys about Human Resources data available in SAP. These include RECTY (Record type), VERSO (Data area (previously version)), YEARB (Fiscal Year), PERDE (Period).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified


SAP CF002 pooled 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
RECTYRecord type CFRECTYCHAR1RECTY
VERSOData area (previously version) CFVERSONUMC2T242VVERSODBE
YEARBFiscal Year CFYEARBNUMC4GJAHRGJAHRFSY
PERDEPeriod CFPERDENUMC3POPERPRD
COMPNCompany CFCOMPNCHAR4CHAR4
RFORMLegal form (of company) CFRFORMNUMC3NUMC03
BRNCHSector of industry (of company) CFBRNCHNUMC3NUMC03
ORGKIInternal org.unit CFORGKINUMC8NUMC08
ORGKEExternal org.unit CFORGKENUMC8NUMC08
CNTRYCountry Key LAND1CHAR3T005LAND1LND
VALTYValue type CFVALTYCHAR1T242WVALTYVAT
RECNRCO-BPC record number CFRECNRNUMC8NUM8
AEDTMChanged On CFAEDTMDATS8CFDATUM
UNAMEUser name CFUNAMECHAR12CHAR12
PINTRReference to reports CFPINTRNUMC8NUMC08
EMPLYEmployees CFEMPLYQUAN15(3) CFQUAN8
QEMPLUnit CFUNITUNIT3Assigned to domainCUNITMEINS
WOMNSWomen CFWOMNSQUAN15(3) CFQUAN8
QWOMNUnit CFUNITUNIT3Assigned to domainCUNITMEINS
FORGNForeigner(s) CFFORGNQUAN15(3) CFQUAN8
QFORGUnit CFUNITUNIT3Assigned to domainCUNITMEINS
WORKRWorker(s) CFWORKRQUAN15(3) CFQUAN8
QWORKUnit CFUNITUNIT3Assigned to domainCUNITMEINS
NEDUCUneducated CFNEDUCQUAN15(3) CFQUAN8
QNEDUUnit CFUNITUNIT3Assigned to domainCUNITMEINS
LEMPLEmployee with education CFLEMPLQUAN15(3) CFQUAN8
QLEMPUnit CFUNITUNIT3Assigned to domainCUNITMEINS
FEMPLEmployees with specialist training CFFEMPLQUAN15(3) CFQUAN8
QFEMPUnit CFUNITUNIT3Assigned to domainCUNITMEINS
SEMPLEmpl.w/degree CFSEMPLQUAN15(3) CFQUAN8
QSEMPUnit CFUNITUNIT3Assigned to domainCUNITMEINS
BTRAIBusiness trainee CFBTRAIQUAN15(3) CFQUAN8
QBTRAUnit CFUNITUNIT3Assigned to domainCUNITMEINS
CTRAITrade trainee CFCTRAIQUAN15(3) CFQUAN8
QCTRAUnit CFUNITUNIT3Assigned to domainCUNITMEINS
DEMPLHandicaped places CFDEMPLQUAN15(3) CFQUAN8
QDEMPUnit CFUNITUNIT3Assigned to domainCUNITMEINS
ALIVASum. Age CFALIVAQUAN15(3) CFQUAN8
QALIVUnit CFUNITUNIT3Assigned to domainCUNITMEINS
INACQInput intern CFINACQQUAN15(3) CFQUAN8
QINACUnit CFUNITUNIT3Assigned to domainCUNITMEINS
INSEPOutput intern CFINSEPQUAN15(3) CFQUAN8
QINSEUnit CFUNITUNIT3Assigned to domainCUNITMEINS
EXACQInput external CFEXACQQUAN15(3) CFQUAN8
QEXACUnit CFUNITUNIT3Assigned to domainCUNITMEINS
EXSEPOutput extern CFEXSEPQUAN15(3) CFQUAN8
QEXSEUnit CFUNITUNIT3Assigned to domainCUNITMEINS
SALESSales revenue CFSALESCURR15(2) CFCURR8
CSALECurrency CFCUKYCUKY5TCURCWAERS
WAGESWages CFWAGESCURR15(2) CFCURR8
CWAGECurrency CFCUKYCUKY5TCURCWAERS
SALARWages CFSALARCURR15(2) CFCURR8
CSALACurrency CFCUKYCUKY5TCURCWAERS
PERCOPersonnel costs CFPERCOCURR15(2) CFCURR8
CPERCCurrency CFCUKYCUKY5TCURCWAERS
IPECOPersonnel costs CFIPECOCURR15(2) CFCURR8
CIPECCurrency CFCUKYCUKY5TCURCWAERS
DUTHOPlan hours CFDUTHOQUAN15(3) CFQUAN8
QDUTHUnit CFUNITUNIT3Assigned to domainCUNITMEINS
MISHOMissing hours CFMISHOQUAN15(3) CFQUAN8
QMISHUnit CFUNITUNIT3Assigned to domainCUNITMEINS
OVEHOOvertime CFOVEHOQUAN15(3) CFQUAN8
QOVEHUnit CFUNITUNIT3Assigned to domainCUNITMEINS
PREQAPersonnel req.action CFPREQAQUAN15(3) CFQUAN8
QPREQUnit CFUNITUNIT3Assigned to domainCUNITMEINS
PREQCPers.req.cost CFPREQCCURR15(2) CFCURR8
CPREQCurrency CFCUKYCUKY5TCURCWAERS
PMARCPersonnel marketing costs CFPMARCCURR15(2) CFCURR8
CPMARCurrency CFCUKYCUKY5TCURCWAERS
UNICOUniversity contacts CFUNICOQUAN15(3) CFQUAN8
QUNICUnit CFUNITUNIT3Assigned to domainCUNITMEINS
ADVERDisplay CFADVERQUAN15(3) CFQUAN8
QADVEUnit CFUNITUNIT3Assigned to domainCUNITMEINS
OTHEROther actions CFOTHERQUAN15(3) CFQUAN8
QOTHEUnit CFUNITUNIT3Assigned to domainCUNITMEINS
APPLIApplication CFAPPLIQUAN15(3) CFQUAN8
QAPPLUnit CFUNITUNIT3Assigned to domainCUNITMEINS
INVITInvitations CFINVITQUAN15(3) CFQUAN8
QINVIUnit CFUNITUNIT3Assigned to domainCUNITMEINS
PRESNIntroduction CFPRESNQUAN15(3) CFQUAN8
QPRESUnit CFUNITUNIT3Assigned to domainCUNITMEINS
EDUCCTraining costs CFEDUCCCURR15(2) CFCURR8
CEDUCCurrency CFCUKYCUKY5TCURCWAERS
ENHACContinuing education costs CFENHACCURR15(2) CFCURR8
CENHCCurrency CFCUKYCUKY5TCURCWAERS
ENHAPEducation trainee CFENHAPQUAN15(3) CFQUAN8
QENHPUnit CFUNITUNIT3Assigned to domainCUNITMEINS
ENHADContinuing education days CFENHADQUAN15(3) CFQUAN8
QENHDUnit CFUNITUNIT3Assigned to domainCUNITMEINS
ENHAQAmount education CFENHAQQUAN15(3) CFQUAN8
QENHQUnit CFUNITUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



How do I retrieve data from SAP table CF002 using ABAP code

The following ABAP code Example will allow you to do a basic selection on CF002 to SELECT all data from the table
DATA: WA_CF002 TYPE CF002.

SELECT SINGLE *
FROM CF002
INTO CORRESPONDING FIELDS OF WA_CF002
WHERE...

How to access SAP table CF002

Within an ECC or HANA version of SAP you can also view further information about CF002 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!