CF002 SAP (Human Resources) Pooled Table details
Dictionary Type: Pooled Table
Description: Human Resources
Description: Human Resources
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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
RECTY | Record type | CFRECTY | CHAR | 1 | RECTY | ||||
VERSO | Data area (previously version) | CFVERSO | NUMC | 2 | T242V | VERSO | DBE | ||
YEARB | Fiscal Year | CFYEARB | NUMC | 4 | GJAHR | GJAHR | FSY | ||
PERDE | Period | CFPERDE | NUMC | 3 | POPER | PRD | |||
COMPN | Company | CFCOMPN | CHAR | 4 | CHAR4 | ||||
RFORM | Legal form (of company) | CFRFORM | NUMC | 3 | NUMC03 | ||||
BRNCH | Sector of industry (of company) | CFBRNCH | NUMC | 3 | NUMC03 | ||||
ORGKI | Internal org.unit | CFORGKI | NUMC | 8 | NUMC08 | ||||
ORGKE | External org.unit | CFORGKE | NUMC | 8 | NUMC08 | ||||
CNTRY | Country Key | LAND1 | CHAR | 3 | T005 | LAND1 | LND | ||
VALTY | Value type | CFVALTY | CHAR | 1 | T242W | VALTY | VAT | ||
RECNR | CO-BPC record number | CFRECNR | NUMC | 8 | NUM8 | ||||
AEDTM | Changed On | CFAEDTM | DATS | 8 | CFDATUM | ||||
UNAME | User name | CFUNAME | CHAR | 12 | CHAR12 | ||||
PINTR | Reference to reports | CFPINTR | NUMC | 8 | NUMC08 | ||||
EMPLY | Employees | CFEMPLY | QUAN | 15(3) | CFQUAN8 | ||||
QEMPL | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WOMNS | Women | CFWOMNS | QUAN | 15(3) | CFQUAN8 | ||||
QWOMN | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FORGN | Foreigner(s) | CFFORGN | QUAN | 15(3) | CFQUAN8 | ||||
QFORG | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
WORKR | Worker(s) | CFWORKR | QUAN | 15(3) | CFQUAN8 | ||||
QWORK | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NEDUC | Uneducated | CFNEDUC | QUAN | 15(3) | CFQUAN8 | ||||
QNEDU | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
LEMPL | Employee with education | CFLEMPL | QUAN | 15(3) | CFQUAN8 | ||||
QLEMP | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
FEMPL | Employees with specialist training | CFFEMPL | QUAN | 15(3) | CFQUAN8 | ||||
QFEMP | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SEMPL | Empl.w/degree | CFSEMPL | QUAN | 15(3) | CFQUAN8 | ||||
QSEMP | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BTRAI | Business trainee | CFBTRAI | QUAN | 15(3) | CFQUAN8 | ||||
QBTRA | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CTRAI | Trade trainee | CFCTRAI | QUAN | 15(3) | CFQUAN8 | ||||
QCTRA | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
DEMPL | Handicaped places | CFDEMPL | QUAN | 15(3) | CFQUAN8 | ||||
QDEMP | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ALIVA | Sum. Age | CFALIVA | QUAN | 15(3) | CFQUAN8 | ||||
QALIV | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
INACQ | Input intern | CFINACQ | QUAN | 15(3) | CFQUAN8 | ||||
QINAC | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
INSEP | Output intern | CFINSEP | QUAN | 15(3) | CFQUAN8 | ||||
QINSE | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EXACQ | Input external | CFEXACQ | QUAN | 15(3) | CFQUAN8 | ||||
QEXAC | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EXSEP | Output extern | CFEXSEP | QUAN | 15(3) | CFQUAN8 | ||||
QEXSE | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SALES | Sales revenue | CFSALES | CURR | 15(2) | CFCURR8 | ||||
CSALE | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
WAGES | Wages | CFWAGES | CURR | 15(2) | CFCURR8 | ||||
CWAGE | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
SALAR | Wages | CFSALAR | CURR | 15(2) | CFCURR8 | ||||
CSALA | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
PERCO | Personnel costs | CFPERCO | CURR | 15(2) | CFCURR8 | ||||
CPERC | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
IPECO | Personnel costs | CFIPECO | CURR | 15(2) | CFCURR8 | ||||
CIPEC | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
DUTHO | Plan hours | CFDUTHO | QUAN | 15(3) | CFQUAN8 | ||||
QDUTH | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MISHO | Missing hours | CFMISHO | QUAN | 15(3) | CFQUAN8 | ||||
QMISH | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OVEHO | Overtime | CFOVEHO | QUAN | 15(3) | CFQUAN8 | ||||
QOVEH | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PREQA | Personnel req.action | CFPREQA | QUAN | 15(3) | CFQUAN8 | ||||
QPREQ | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PREQC | Pers.req.cost | CFPREQC | CURR | 15(2) | CFCURR8 | ||||
CPREQ | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
PMARC | Personnel marketing costs | CFPMARC | CURR | 15(2) | CFCURR8 | ||||
CPMAR | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
UNICO | University contacts | CFUNICO | QUAN | 15(3) | CFQUAN8 | ||||
QUNIC | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ADVER | Display | CFADVER | QUAN | 15(3) | CFQUAN8 | ||||
QADVE | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
OTHER | Other actions | CFOTHER | QUAN | 15(3) | CFQUAN8 | ||||
QOTHE | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
APPLI | Application | CFAPPLI | QUAN | 15(3) | CFQUAN8 | ||||
QAPPL | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
INVIT | Invitations | CFINVIT | QUAN | 15(3) | CFQUAN8 | ||||
QINVI | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
PRESN | Introduction | CFPRESN | QUAN | 15(3) | CFQUAN8 | ||||
QPRES | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EDUCC | Training costs | CFEDUCC | CURR | 15(2) | CFCURR8 | ||||
CEDUC | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
ENHAC | Continuing education costs | CFENHAC | CURR | 15(2) | CFCURR8 | ||||
CENHC | Currency | CFCUKY | CUKY | 5 | TCURC | WAERS | |||
ENHAP | Education trainee | CFENHAP | QUAN | 15(3) | CFQUAN8 | ||||
QENHP | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ENHAD | Continuing education days | CFENHAD | QUAN | 15(3) | CFQUAN8 | ||||
QENHD | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ENHAQ | Amount education | CFENHAQ | QUAN | 15(3) | CFQUAN8 | ||||
QENHQ | Unit | CFUNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
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 tableDATA: 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 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