SAP ABAP Table CF002 (Human Resources)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ KC (Package) Cost Accounting Controlling EIS

Basic Data

Table Category	POOL	Pooled table
Pooled table	CF002	Table Relationship Diagram
Short Description	Human Resources

Delivery and Maintenance

Pool/cluster	CFIS
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	RECTY	☑	CFRECTY	RECTY	CHAR	1	0	Record type
3	VERSO	☑	CFVERSO	VERSO	NUMC	2	0	Data area (previously version)	T242V
4	YEARB	☑	CFYEARB	GJAHR	NUMC	4	0	Fiscal Year
5	PERDE	☑	CFPERDE	POPER	NUMC	3	0	Period
6	COMPN	☑	CFCOMPN	CHAR4	CHAR	4	0	Company
7	RFORM	☑	CFRFORM	NUMC03	NUMC	3	0	Legal form (of company)
8	BRNCH	☑	CFBRNCH	NUMC03	NUMC	3	0	Sector of industry (of company)
9	ORGKI	☑	CFORGKI	NUMC08	NUMC	8	0	Internal org.unit
10	ORGKE	☑	CFORGKE	NUMC08	NUMC	8	0	External org.unit
11	CNTRY	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
12	VALTY	☑	CFVALTY	VALTY	CHAR	1	0	Value type	T242W
13	RECNR	☑	CFRECNR	NUM8	NUMC	8	0	CO-BPC record number
14	AEDTM	☐	CFAEDTM	CFDATUM	DATS	8	0	Changed On
15	UNAME	☐	CFUNAME	CHAR12	CHAR	12	0	User name
16	PINTR	☐	CFPINTR	NUMC08	NUMC	8	0	Reference to reports
17	EMPLY	☐	CFEMPLY	CFQUAN8	QUAN	15	3	Employees
18	QEMPL	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
19	WOMNS	☐	CFWOMNS	CFQUAN8	QUAN	15	3	Women
20	QWOMN	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
21	FORGN	☐	CFFORGN	CFQUAN8	QUAN	15	3	Foreigner(s)
22	QFORG	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
23	WORKR	☐	CFWORKR	CFQUAN8	QUAN	15	3	Worker(s)
24	QWORK	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
25	NEDUC	☐	CFNEDUC	CFQUAN8	QUAN	15	3	Uneducated
26	QNEDU	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
27	LEMPL	☐	CFLEMPL	CFQUAN8	QUAN	15	3	Employee with education
28	QLEMP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
29	FEMPL	☐	CFFEMPL	CFQUAN8	QUAN	15	3	Employees with specialist training
30	QFEMP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
31	SEMPL	☐	CFSEMPL	CFQUAN8	QUAN	15	3	Empl.w/degree
32	QSEMP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
33	BTRAI	☐	CFBTRAI	CFQUAN8	QUAN	15	3	Business trainee
34	QBTRA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
35	CTRAI	☐	CFCTRAI	CFQUAN8	QUAN	15	3	Trade trainee
36	QCTRA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
37	DEMPL	☐	CFDEMPL	CFQUAN8	QUAN	15	3	Handicaped places
38	QDEMP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
39	ALIVA	☐	CFALIVA	CFQUAN8	QUAN	15	3	Sum. Age
40	QALIV	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
41	INACQ	☐	CFINACQ	CFQUAN8	QUAN	15	3	Input intern
42	QINAC	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
43	INSEP	☐	CFINSEP	CFQUAN8	QUAN	15	3	Output intern
44	QINSE	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
45	EXACQ	☐	CFEXACQ	CFQUAN8	QUAN	15	3	Input external
46	QEXAC	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
47	EXSEP	☐	CFEXSEP	CFQUAN8	QUAN	15	3	Output extern
48	QEXSE	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
49	SALES	☐	CFSALES	CFCURR8	CURR	15	2	Sales revenue
50	CSALE	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
51	WAGES	☐	CFWAGES	CFCURR8	CURR	15	2	Wages
52	CWAGE	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
53	SALAR	☐	CFSALAR	CFCURR8	CURR	15	2	Wages
54	CSALA	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
55	PERCO	☐	CFPERCO	CFCURR8	CURR	15	2	Personnel costs
56	CPERC	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
57	IPECO	☐	CFIPECO	CFCURR8	CURR	15	2	Personnel costs
58	CIPEC	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
59	DUTHO	☐	CFDUTHO	CFQUAN8	QUAN	15	3	Plan hours
60	QDUTH	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
61	MISHO	☐	CFMISHO	CFQUAN8	QUAN	15	3	Missing hours
62	QMISH	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
63	OVEHO	☐	CFOVEHO	CFQUAN8	QUAN	15	3	Overtime
64	QOVEH	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
65	PREQA	☐	CFPREQA	CFQUAN8	QUAN	15	3	Personnel req.action
66	QPREQ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
67	PREQC	☐	CFPREQC	CFCURR8	CURR	15	2	Pers.req.cost
68	CPREQ	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
69	PMARC	☐	CFPMARC	CFCURR8	CURR	15	2	Personnel marketing costs
70	CPMAR	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
71	UNICO	☐	CFUNICO	CFQUAN8	QUAN	15	3	University contacts
72	QUNIC	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
73	ADVER	☐	CFADVER	CFQUAN8	QUAN	15	3	Display
74	QADVE	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
75	OTHER	☐	CFOTHER	CFQUAN8	QUAN	15	3	Other actions
76	QOTHE	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
77	APPLI	☐	CFAPPLI	CFQUAN8	QUAN	15	3	Application
78	QAPPL	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
79	INVIT	☐	CFINVIT	CFQUAN8	QUAN	15	3	Invitations
80	QINVI	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
81	PRESN	☐	CFPRESN	CFQUAN8	QUAN	15	3	Introduction
82	QPRES	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
83	EDUCC	☐	CFEDUCC	CFCURR8	CURR	15	2	Training costs
84	CEDUC	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
85	ENHAC	☐	CFENHAC	CFCURR8	CURR	15	2	Continuing education costs
86	CENHC	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
87	ENHAP	☐	CFENHAP	CFQUAN8	QUAN	15	3	Education trainee
88	QENHP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
89	ENHAD	☐	CFENHAD	CFQUAN8	QUAN	15	3	Continuing education days
90	QENHD	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*
91	ENHAQ	☐	CFENHAQ	CFQUAN8	QUAN	15	3	Amount education
92	QENHQ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CF002	CEDUC	TCURC	WAERS	REF	C	CN
2	CF002	CENHC	TCURC	WAERS	REF	C	CN
3	CF002	CIPEC	TCURC	WAERS	REF	C	CN
4	CF002	CNTRY	T005	LAND1	KEY	1	CN
5	CF002	CPERC	TCURC	WAERS	REF	C	CN
6	CF002	CPMAR	TCURC	WAERS	REF	C	CN
7	CF002	CPREQ	TCURC	WAERS	REF	C	CN
8	CF002	CSALA	TCURC	WAERS	REF	C	CN
9	CF002	CSALE	TCURC	WAERS	REF	C	CN
10	CF002	CWAGE	TCURC	WAERS	REF	C	CN
11	CF002	MANDT	T000	MANDT	KEY	1	CN
12	CF002	VALTY	T242W	VALTY	KEY	1	CN
13	CF002	VERSO	T242V	VERSO	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in