SAP ABAP Table CF005 (Personnel Information)

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	TRANSP	Transparent table
Transparent table	CF005	Table Relationship Diagram
Short Description	Personnel Information

Delivery and Maintenance

Pool/cluster
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	EORGE	☑	CFEORGE	NUMC08	NUMC	8	0	External organizational unit
8	IORGE	☑	CFIORGE	NUMC08	NUMC	8	0	Organizational unit
9	KOSTE	☑	CFKOSTE	CHAR14	CHAR	14	0	Cost center
10	RFORM	☑	CFRFORM	NUMC03	NUMC	3	0	Legal form (of company)
11	BRNCH	☑	CFBRNCH	NUMC03	NUMC	3	0	Sector of industry (of company)
12	LAND1	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	VALTY	☑	CFVALTY	VALTY	CHAR	1	0	Value type	T242W
14	RECNR	☑	CFRECNR	NUM8	NUMC	8	0	CO-BPC record number
15	AEDTM	☐	CFAEDTM	CFDATUM	DATS	8	0	Changed On
16	UNAME	☐	CFUNAME	CHAR12	CHAR	12	0	User name
17	PINTR	☐	CFPINTR	NUMC08	NUMC	8	0	Reference to reports
18	MITAB	☐	CFMITAB	CFQUAN8	QUAN	15	3	Number of employees
19	QMITAB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
20	ARBTR	☐	CFARBTR	CFQUAN8	QUAN	15	3	Number of hourly-paid workers
21	QARBTR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
22	ANGES	☐	CFANGES	CFQUAN8	QUAN	15	3	Number of salaried employees
23	QANGES	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
24	AZUBI	☐	CFAZUBI	CFQUAN8	QUAN	15	3	Number of trainees
25	QAZUBI	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
26	TZBES	☐	CFTZBES	CFQUAN8	QUAN	15	3	Number of part-time employees
27	QTZBES	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
28	FRAUN	☐	CFFRAUN	CFQUAN8	QUAN	15	3	Number of female employees
29	QFRAUN	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
30	EXTAB	☐	CFEXTAB	CFQUAN8	QUAN	15	3	External outflow of employees
31	QEXTAB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
32	UNTAB	☐	CFUNTAB	CFQUAN8	QUAN	15	3	Number of terminations of contract by employer
33	QUNTAB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
34	FRWAB	☐	CFFRWAB	CFQUAN8	QUAN	15	3	Number of terminations of contract by employees
35	QFRWAB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
36	EX1AB	☐	CFEX1AB	CFQUAN8	QUAN	15	3	External outflow of employees (1st year)
37	QEX1AB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
38	INTAB	☐	CFINTAB	CFQUAN8	QUAN	15	3	Internal outflow of employees
39	QINTAB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
40	EXTZU	☐	CFEXTZU	CFQUAN8	QUAN	15	3	External inflow of employees
41	QEXTZU	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
42	INTZU	☐	CFINTZU	CFQUAN8	QUAN	15	3	Internal inflow of employees
43	QINTZU	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
44	DAUER	☐	CFDAUER	CFQUAN8	QUAN	15	3	Length of time employed
45	QDAUER	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
46	ALTRS	☐	CFALTRS	CFQUAN8	QUAN	15	3	Total age
47	QALTRS	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
48	SALTR	☐	CFSALTR	CFQUAN8	QUAN	15	3	Age spread
49	QSALTR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
50	ALTAR	☐	CFALTAR	CFQUAN8	QUAN	15	3	Total age of wage earners
51	QALTAR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
52	SALTA	☐	CFSALTA	CFQUAN8	QUAN	15	3	Age spread of wage earners
53	QSALTA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
54	ALTAN	☐	CFALTAN	CFQUAN8	QUAN	15	3	Total age of salary earners
55	QALTAN	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
56	SALTN	☐	CFSALTN	CFQUAN8	QUAN	15	3	Age spread of salary earners
57	QSALTN	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
58	ALTAZ	☐	CFALTAZ	CFQUAN8	QUAN	15	3	Total age of trainees
59	QALTAZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
60	SALTZ	☐	CFSALTZ	CFQUAN8	QUAN	15	3	Age spread of trainees
61	QSALTZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
62	SOLAZ	☐	CFSOLAZ	CFQUAN8	QUAN	15	3	Planned work time
63	QSOLAZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
64	ISTAZ	☐	CFISTAZ	CFQUAN8	QUAN	15	3	Actual working time
65	QISTAZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
66	OVRAZ	☐	CFOVRAZ	CFQUAN8	QUAN	15	3	Overtime
67	QOVRAZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
68	FZKRK	☐	CFFZKRK	CFQUAN8	QUAN	15	3	Time absent due to sickness
69	QFZKRK	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
70	FZURL	☐	CFFZURL	CFQUAN8	QUAN	15	3	Time absent for vacation
71	QFZURL	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
72	FZKAZ	☐	CFFZKAZ	CFQUAN8	QUAN	15	3	Time absent due to reduced hours
73	QFZKAZ	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
74	SZBFR	☐	CFSZBFR	CFQUAN8	QUAN	15	3	Planned worktime for employees on a limited contract
75	QSZBFR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
76	ISTFR	☐	CFISTFR	CFQUAN8	QUAN	15	3	Actual work time of external personnel
77	QISTFR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
78	SOSBH	☐	CFSOSBH	CFQUAN8	QUAN	15	3	Planned work time for severely handicapped
79	QSOSBH	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
80	UMSAZ	☐	CFUMSAZ	CFCURR8	CURR	15	2	Sales revenue
81	CUMSAZ	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
82	DBTRG	☐	CFDBTRG	CFCURR8	CURR	15	2	Contribution margin
83	CDBTRG	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
84	BASBZ	☐	CFBASBZ	CFCURR8	CURR	15	2	Basic Pay
85	CBASBZ	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
86	SOBEZ	☐	CFSOBEZ	CFCURR8	CURR	15	2	Planned remuneration
87	CSOBEZ	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
88	ISTBZ	☐	CFISTBZ	CFCURR8	CURR	15	2	Actual remuneration
89	CISTBZ	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
90	EINKO	☐	CFEINKO	CFCURR8	CURR	15	2	Employee benefit costs: Direct costs
91	CEINKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
92	FRWKO	☐	CFFRWKO	CFCURR8	CURR	15	2	Voluntary direct costs
93	CFRWKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
94	GEMKO	☐	CFGEMKO	CFCURR8	CURR	15	2	Employee benefit costs: Overhead costs
95	CGEMKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
96	AUSKO	☐	CFAUSKO	CFCURR8	CURR	15	2	Training costs
97	CAUSKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
98	WBLBD	☐	CFWBLBD	CFQUAN8	QUAN	15	3	Further education requirement
99	QWBLBD	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
100	SWBLB	☐	CFSWBLB	CFQUAN8	QUAN	15	3	Spread of further education requirement
101	QSWBLB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
102	EIGRD	☐	CFEIGRD	CFQUAN8	QUAN	15	3	Total degree of aptitude
103	QEIGRD	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
104	SEIGR	☐	CFSEIGR	CFQUAN8	QUAN	15	3	Spread of aptitude
105	QSEIGR	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
106	IWGMA	☐	CFIWGMA	CFQUAN8	QUAN	15	3	Number of employees with internal further education
107	QIWGMA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
108	EWGMA	☐	CFEWGMA	CFQUAN8	QUAN	15	3	Number of employees with external further education
109	QEWGMA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
110	IWBVA	☐	CFIWBVA	CFQUAN8	QUAN	15	3	Number of internal further education events
111	QIWBVA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
112	EWBVA	☐	CFEWBVA	CFQUAN8	QUAN	15	3	Number of external further education events
113	QEWBVA	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
114	IWBTG	☐	CFIWBTG	CFQUAN8	QUAN	15	3	Number of days spent on internal further education
115	QIWBTG	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
116	EWBTG	☐	CFEWBTG	CFQUAN8	QUAN	15	3	External further education days
117	QEWBTG	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
118	IWBKO	☐	CFIWBKO	CFCURR8	CURR	15	2	Internal further education costs
119	CIWBKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
120	EWBKO	☐	CFEWBKO	CFCURR8	CURR	15	2	External further education costs
121	CEWBKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
122	OFPLS	☐	CFOFPLS	CFQUAN8	QUAN	15	3	Number of vacancies planned
123	QOFPLS	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
124	PERBD	☐	CFPERBD	CFQUAN8	QUAN	15	3	Workforce requirements
125	QPERBD	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
126	BEWRB	☐	CFBEWRB	CFQUAN8	QUAN	15	3	Number of applications
127	QBEWRB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
128	SBWRB	☐	CFSBWRB	CFQUAN8	QUAN	15	3	Number of spontaneous applications
129	QSBWRB	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
130	BESKO	☐	CFBESKO	CFCURR8	CURR	15	2	Costs of aquisition
131	CBESKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
132	ANWKO	☐	CFANWKO	CFCURR8	CURR	15	2	Recruitment costs
133	CANWKO	☐	CFCUKY	WAERS	CUKY	5	0	Currency	TCURC
134	ALTRF	☐	CFALTRF	CFQUAN8	QUAN	15	3	Age of managers
135	QALTRF	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
136	FSTLV	☐	CFFSTLV	CFQUAN8	QUAN	15	3	Number of assistant managers
137	QFSTLV	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
138	OFNFP	☐	CFOFNFP	CFQUAN8	QUAN	15	3	Vacant management positions
139	QOFNFP	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006
140	FRPOS	☐	CFFRPOS	CFQUAN8	QUAN	15	3	Number of managers
141	QFRPOS	☐	CFUNIT	MEINS	UNIT	3	0	Unit	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CF005	CANWKO	TCURC	WAERS	REF	C	CN
2	CF005	CAUSKO	TCURC	WAERS	REF	C	CN
3	CF005	CBASBZ	TCURC	WAERS	REF	C	CN
4	CF005	CBESKO	TCURC	WAERS	REF	C	CN
5	CF005	CDBTRG	TCURC	WAERS	REF	C	CN
6	CF005	CEINKO	TCURC	WAERS	REF	C	CN
7	CF005	CEWBKO	TCURC	WAERS	REF	C	CN
8	CF005	CFRWKO	TCURC	WAERS	REF	C	CN
9	CF005	CGEMKO	TCURC	WAERS	REF	C	CN
10	CF005	CISTBZ	TCURC	WAERS	REF	C	CN
11	CF005	CIWBKO	TCURC	WAERS	REF	C	CN
12	CF005	CSOBEZ	TCURC	WAERS	REF	C	CN
13	CF005	CUMSAZ	TCURC	WAERS	REF	C	CN
14	CF005	LAND1	T005	LAND1	KEY	1	CN
15	CF005	MANDT	T000	MANDT	KEY	1	CN
16	CF005	QALTAN	T006	MSEHI	REF	C	CN
17	CF005	QALTAR	T006	MSEHI	REF	C	CN
18	CF005	QALTAZ	T006	MSEHI	REF	C	CN
19	CF005	QALTRF	T006	MSEHI	REF	C	CN
20	CF005	QALTRS	T006	MSEHI	REF	C	CN
21	CF005	QANGES	T006	MSEHI	REF	C	CN
22	CF005	QARBTR	T006	MSEHI	REF	C	CN
23	CF005	QAZUBI	T006	MSEHI	REF	C	CN
24	CF005	QBEWRB	T006	MSEHI	REF	C	CN
25	CF005	QDAUER	T006	MSEHI	REF	C	CN
26	CF005	QEIGRD	T006	MSEHI	REF	C	CN
27	CF005	QEWBTG	T006	MSEHI	REF	C	CN
28	CF005	QEWBVA	T006	MSEHI	REF	C	CN
29	CF005	QEWGMA	T006	MSEHI	REF	C	CN
30	CF005	QEX1AB	T006	MSEHI	REF	C	CN
31	CF005	QEXTAB	T006	MSEHI	REF	C	CN
32	CF005	QEXTZU	T006	MSEHI	REF	C	CN
33	CF005	QFRAUN	T006	MSEHI	REF	C	CN
34	CF005	QFRPOS	T006	MSEHI	REF	C	CN
35	CF005	QFRWAB	T006	MSEHI	REF	C	CN
36	CF005	QFSTLV	T006	MSEHI	REF	C	CN
37	CF005	QFZKAZ	T006	MSEHI	REF	C	CN
38	CF005	QFZKRK	T006	MSEHI	REF	C	CN
39	CF005	QFZURL	T006	MSEHI	REF	C	CN
40	CF005	QINTAB	T006	MSEHI	REF	C	CN
41	CF005	QINTZU	T006	MSEHI	REF	C	CN
42	CF005	QISTAZ	T006	MSEHI	REF	C	CN
43	CF005	QISTFR	T006	MSEHI	REF	C	CN
44	CF005	QIWBTG	T006	MSEHI	REF	C	CN
45	CF005	QIWBVA	T006	MSEHI	REF	C	CN
46	CF005	QIWGMA	T006	MSEHI	REF	C	CN
47	CF005	QMITAB	T006	MSEHI	REF	C	CN
48	CF005	QOFNFP	T006	MSEHI	REF	C	CN
49	CF005	QOFPLS	T006	MSEHI	REF	C	CN
50	CF005	QOVRAZ	T006	MSEHI	REF	C	CN
51	CF005	QPERBD	T006	MSEHI	REF	C	CN
52	CF005	QSALTA	T006	MSEHI	REF	C	CN
53	CF005	QSALTN	T006	MSEHI	REF	C	CN
54	CF005	QSALTR	T006	MSEHI	REF	C	CN
55	CF005	QSALTZ	T006	MSEHI	REF	C	CN
56	CF005	QSBWRB	T006	MSEHI	REF	C	CN
57	CF005	QSEIGR	T006	MSEHI	REF	C	CN
58	CF005	QSOLAZ	T006	MSEHI	REF	C	CN
59	CF005	QSOSBH	T006	MSEHI	REF	C	CN
60	CF005	QSWBLB	T006	MSEHI	REF	C	CN
61	CF005	QSZBFR	T006	MSEHI	REF	C	CN
62	CF005	QTZBES	T006	MSEHI	REF	C	CN
63	CF005	QUNTAB	T006	MSEHI	REF	C	CN
64	CF005	QWBLBD	T006	MSEHI	REF	C	CN
65	CF005	VALTY	T242W	VALTY	KEY	1	CN
66	CF005	VERSO	T242V	VERSO	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in