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
⤷ 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 |