CF005

Personnel Information | #other | Component: Data Collection

🔑 Keys (14)
💰 Amounts (13)
∑ Quantities (49)
📅 Dates (1)
☰ Categorical (1)
Other (2)
🔗 Relations (66)

Column Name	Description
MANDT FK	Client
RECTY	Record type	Show values
VERSO FK	Data area (previously version)
YEARB	Fiscal Year
PERDE	Period
COMPN	Company
EORGE	External organizational unit
IORGE	Organizational unit
KOSTE	Cost center
RFORM	Legal form (of company)
BRNCH	Sector of industry (of company)
LAND1 FK	Country/Region Key
VALTY FK	Value type
RECNR	CO-BPC record number

Column Name	Description
💲 Currency (CUMSAZ):
UMSAZ	Sales revenue
💲 Currency (CDBTRG):
DBTRG	Contribution margin
💲 Currency (CBASBZ):
BASBZ	Basic Pay
💲 Currency (CSOBEZ):
SOBEZ	Planned remuneration
💲 Currency (CISTBZ):
ISTBZ	Actual remuneration
💲 Currency (CEINKO):
EINKO	Employee benefit costs: Direct costs
💲 Currency (CFRWKO):
FRWKO	Voluntary direct costs
💲 Currency (CGEMKO):
GEMKO	Employee benefit costs: Overhead costs
💲 Currency (CAUSKO):
AUSKO	Training costs
💲 Currency (CIWBKO):
IWBKO	Internal further education costs
💲 Currency (CEWBKO):
EWBKO	External further education costs
💲 Currency (CBESKO):
BESKO	Costs of aquisition
💲 Currency (CANWKO):
ANWKO	Recruitment costs

Column Name	Description
📏 Unit (QMITAB):
MITAB	Number of employees
📏 Unit (QARBTR):
ARBTR	Number of hourly-paid workers
📏 Unit (QANGES):
ANGES	Number of salaried employees
📏 Unit (QAZUBI):
AZUBI	Number of trainees
📏 Unit (QTZBES):
TZBES	Number of part-time employees
📏 Unit (QFRAUN):
FRAUN	Number of female employees
📏 Unit (QEXTAB):
EXTAB	External outflow of employees
📏 Unit (QUNTAB):
UNTAB	Number of terminations of contract by employer
📏 Unit (QFRWAB):
FRWAB	Number of terminations of contract by employees
📏 Unit (QEX1AB):
EX1AB	External outflow of employees (1st year)
📏 Unit (QINTAB):
INTAB	Internal outflow of employees
📏 Unit (QEXTZU):
EXTZU	External inflow of employees
📏 Unit (QINTZU):
INTZU	Internal inflow of employees
📏 Unit (QDAUER):
DAUER	Length of time employed
📏 Unit (QALTRS):
ALTRS	Total age
📏 Unit (QSALTR):
SALTR	Age spread
📏 Unit (QALTAR):
ALTAR	Total age of wage earners
📏 Unit (QSALTA):
SALTA	Age spread of wage earners
📏 Unit (QALTAN):
ALTAN	Total age of salary earners
📏 Unit (QSALTN):
SALTN	Age spread of salary earners
📏 Unit (QALTAZ):
ALTAZ	Total age of trainees
📏 Unit (QSALTZ):
SALTZ	Age spread of trainees
📏 Unit (QSOLAZ):
SOLAZ	Planned work time
📏 Unit (QISTAZ):
ISTAZ	Actual working time
📏 Unit (QOVRAZ):
OVRAZ	Overtime
📏 Unit (QFZKRK):
FZKRK	Time absent due to sickness
📏 Unit (QFZURL):
FZURL	Time absent for vacation
📏 Unit (QFZKAZ):
FZKAZ	Time absent due to reduced hours
📏 Unit (QSZBFR):
SZBFR	Planned worktime for employees on a limited contract
📏 Unit (QISTFR):
ISTFR	Actual work time of external personnel
📏 Unit (QSOSBH):
SOSBH	Planned work time for severely handicapped
📏 Unit (QWBLBD):
WBLBD	Further education requirement
📏 Unit (QSWBLB):
SWBLB	Spread of further education requirement
📏 Unit (QEIGRD):
EIGRD	Total degree of aptitude
📏 Unit (QSEIGR):
SEIGR	Spread of aptitude
📏 Unit (QIWGMA):
IWGMA	Number of employees with internal further education
📏 Unit (QEWGMA):
EWGMA	Number of employees with external further education
📏 Unit (QIWBVA):
IWBVA	Number of internal further education events
📏 Unit (QEWBVA):
EWBVA	Number of external further education events
📏 Unit (QIWBTG):
IWBTG	Number of days spent on internal further education
📏 Unit (QEWBTG):
EWBTG	External further education days
📏 Unit (QOFPLS):
OFPLS	Number of vacancies planned
📏 Unit (QPERBD):
PERBD	Workforce requirements
📏 Unit (QBEWRB):
BEWRB	Number of applications
📏 Unit (QSBWRB):
SBWRB	Number of spontaneous applications
📏 Unit (QALTRF):
ALTRF	Age of managers
📏 Unit (QFSTLV):
FSTLV	Number of assistant managers
📏 Unit (QOFNFP):
OFNFP	Vacant management positions
📏 Unit (QFRPOS):
FRPOS	Number of managers

Column Name	Description
AEDTM	Changed On

Column Name	Description
RECTY	Record type	Show values

Column Name	Description	Domain name
UNAME	User name	CHAR12
PINTR	Reference to reports	NUMC08

Master Data Relations	Join Conditions
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CANWKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CAUSKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CBASBZ == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CBESKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CDBTRG == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CEINKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CEWBKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CFRWKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CGEMKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CISTBZ == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CIWBKO == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CSOBEZ == TCURC.WAERS`
Unit	`CF005.MANDT == TCURC.MANDT` `CF005.CUMSAZ == TCURC.WAERS`
Foreign key for country Country/Region Key Client	`CF005.LAND1 == T005.LAND1` `CF005.MANDT == T005.MANDT`
Foreign Key: Client	`CF005.MANDT == T000.MANDT`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QALTAN == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QALTAR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QALTAZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QALTRF == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QALTRS == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QANGES == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QARBTR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QAZUBI == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QBEWRB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QDAUER == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEIGRD == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEWBTG == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEWBVA == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEWGMA == T006.MSEHI`
Unit of measurement	`CF005.MANDT == T006.MANDT` `CF005.QEX1AB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEXTAB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QEXTZU == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFRAUN == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFRPOS == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFRWAB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFSTLV == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFZKAZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFZKRK == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QFZURL == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QINTAB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QINTZU == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QISTAZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QISTFR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QIWBTG == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QIWBVA == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QIWGMA == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QMITAB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QOFNFP == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QOFPLS == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QOVRAZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QPERBD == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSALTA == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSALTN == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSALTR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSALTZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSBWRB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSEIGR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSOLAZ == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSOSBH == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSWBLB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QSZBFR == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QTZBES == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QUNTAB == T006.MSEHI`
Unit	`CF005.MANDT == T006.MANDT` `CF005.QWBLBD == T006.MSEHI`
Value type	`CF005.MANDT == T242W.MANDT` `CF005.VALTY == T242W.VALTY`
Foreign key version Data area (previously version) Client	`CF005.VERSO == T242V.VERSO` `CF005.MANDT == T242V.MANDT`