| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | VERSIO | Version | nvarchar | 3 | 0 | CHAR | (N' ') | No | TKCVS | CFVERSION | Allow NULL? |
| 3 | PLACTI | Plan/Act. indicator (EC-EIS/EC-BP) | char | 1 | 0 | CHAR | (N' ') | No | | CFPLACT | Allow NULL? |
| 4 | YEARB | Fiscal Year | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CFYEARB | Allow NULL? |
| 5 | PERDE | Period | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CFPERDE | Allow NULL? |
| 6 | VERSO | Data area (previously version) | nvarchar | 2 | 0 | NUMC | (N'00') | No | T242V | CFVERSO | Allow NULL? |
| 7 | COMPN | Company | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CFCOMPN | Allow NULL? |
| 8 | EORGE | External organizational unit | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CFEORGE | Allow NULL? |
| 9 | IORGE | Organizational unit | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CFIORGE | Allow NULL? |
| 10 | KOSTE | Cost center | nvarchar | 14 | 0 | CHAR | (N' ') | No | | CFKOSTE | Allow NULL? |
| 11 | RFORM | Legal form (of company) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CFRFORM | Allow NULL? |
| 12 | BRNCH | Sector of industry (of company) | nvarchar | 3 | 0 | NUMC | (N'000') | No | | CFBRNCH | Allow NULL? |
| 13 | LAND1 | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | No | T005 | LAND1 | Allow NULL? |
| 14 | VALTY | Value type | char | 1 | 0 | CHAR | (N' ') | No | T242W | CFVALTY | Allow NULL? |
| 15 | RECNR | CO-BPC record number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | CFRECNR | Allow NULL? |
| 16 | AEDTM | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CFAEDTM | Allow NULL? |
| 17 | UNAME | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CFUNAME | Allow NULL? |
| 18 | VERSO_WAERS | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | RKCG_CUKY | Allow NULL? |
| 19 | MITAB | Number of employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFMITAB | |
| 20 | QMITAB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 21 | ARBTR | Number of hourly-paid workers | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFARBTR | |
| 22 | QARBTR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 23 | ANGES | Number of salaried employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFANGES | |
| 24 | QANGES | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 25 | AZUBI | Number of trainees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFAZUBI | |
| 26 | QAZUBI | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 27 | TZBES | Number of part-time employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFTZBES | |
| 28 | QTZBES | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 29 | FRAUN | Number of female employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFRAUN | |
| 30 | QFRAUN | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 31 | EXTAB | External outflow of employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEXTAB | |
| 32 | QEXTAB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 33 | UNTAB | Number of terminations of contract by employer | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFUNTAB | |
| 34 | QUNTAB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 35 | FRWAB | Number of terminations of contract by employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFRWAB | |
| 36 | QFRWAB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 37 | EX1AB | External outflow of employees (1st year) | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEX1AB | |
| 38 | QEX1AB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 39 | INTAB | Internal outflow of employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFINTAB | |
| 40 | QINTAB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 41 | EXTZU | External inflow of employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEXTZU | |
| 42 | QEXTZU | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 43 | INTZU | Internal inflow of employees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFINTZU | |
| 44 | QINTZU | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 45 | DAUER | Length of time employed | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFDAUER | |
| 46 | QDAUER | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 47 | ALTRS | Total age | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFALTRS | |
| 48 | QALTRS | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 49 | SALTR | Age spread | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSALTR | |
| 50 | QSALTR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 51 | ALTAR | Total age of wage earners | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFALTAR | |
| 52 | QALTAR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 53 | SALTA | Age spread of wage earners | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSALTA | |
| 54 | QSALTA | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 55 | ALTAN | Total age of salary earners | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFALTAN | |
| 56 | QALTAN | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 57 | SALTN | Age spread of salary earners | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSALTN | |
| 58 | QSALTN | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 59 | ALTAZ | Total age of trainees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFALTAZ | |
| 60 | QALTAZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 61 | SALTZ | Age spread of trainees | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSALTZ | |
| 62 | QSALTZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 63 | SOLAZ | Planned work time | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSOLAZ | |
| 64 | QSOLAZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 65 | ISTAZ | Actual working time | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFISTAZ | |
| 66 | QISTAZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 67 | OVRAZ | Overtime | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFOVRAZ | |
| 68 | QOVRAZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 69 | FZKRK | Time absent due to sickness | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFZKRK | |
| 70 | QFZKRK | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 71 | FZURL | Time absent for vacation | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFZURL | |
| 72 | QFZURL | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 73 | FZKAZ | Time absent due to reduced hours | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFZKAZ | |
| 74 | QFZKAZ | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 75 | SZBFR | Planned worktime for employees on a limited contract | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSZBFR | |
| 76 | QSZBFR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 77 | ISTFR | Actual work time of external personnel | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFISTFR | |
| 78 | QISTFR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 79 | SOSBH | Planned work time for severely handicapped | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSOSBH | |
| 80 | QSOSBH | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 81 | UMSAZ | Sales revenue | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFUMSAZ | |
| 82 | DBTRG | Contribution margin | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFDBTRG | |
| 83 | BASBZ | Basic Pay | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFBASBZ | |
| 84 | SOBEZ | Planned remuneration | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFSOBEZ | |
| 85 | ISTBZ | Actual remuneration | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFISTBZ | |
| 86 | EINKO | Employee benefit costs: Direct costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFEINKO | |
| 87 | FRWKO | Voluntary direct costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFFRWKO | |
| 88 | GEMKO | Employee benefit costs: Overhead costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFGEMKO | |
| 89 | AUSKO | Training costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFAUSKO | |
| 90 | WBLBD | Further education requirement | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFWBLBD | |
| 91 | QWBLBD | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 92 | SWBLB | Spread of further education requirement | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSWBLB | |
| 93 | QSWBLB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 94 | EIGRD | Total degree of aptitude | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEIGRD | |
| 95 | QEIGRD | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 96 | SEIGR | Spread of aptitude | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSEIGR | |
| 97 | QSEIGR | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 98 | IWGMA | Number of employees with internal further education | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFIWGMA | |
| 99 | QIWGMA | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 100 | EWGMA | Number of employees with external further education | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEWGMA | |
| 101 | QEWGMA | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 102 | IWBVA | Number of internal further education events | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFIWBVA | |
| 103 | QIWBVA | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 104 | EWBVA | Number of external further education events | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEWBVA | |
| 105 | QEWBVA | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 106 | IWBTG | Number of days spent on internal further education | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFIWBTG | |
| 107 | QIWBTG | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 108 | EWBTG | External further education days | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFEWBTG | |
| 109 | QEWBTG | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 110 | IWBKO | Internal further education costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFIWBKO | |
| 111 | EWBKO | External further education costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFEWBKO | |
| 112 | OFPLS | Number of vacancies planned | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFOFPLS | |
| 113 | QOFPLS | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 114 | PERBD | Workforce requirements | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFPERBD | |
| 115 | QPERBD | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 116 | BEWRB | Number of applications | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFBEWRB | |
| 117 | QBEWRB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 118 | SBWRB | Number of spontaneous applications | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFSBWRB | |
| 119 | QSBWRB | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 120 | BESKO | Costs of aquisition | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFBESKO | |
| 121 | ANWKO | Recruitment costs | decimal | 15 | 2 | CURR | ((0)) | Yes | | CFANWKO | |
| 122 | ALTRF | Age of managers | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFALTRF | |
| 123 | QALTRF | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 124 | FSTLV | Number of assistant managers | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFSTLV | |
| 125 | QFSTLV | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 126 | OFNFP | Vacant management positions | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFOFNFP | |
| 127 | QOFNFP | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
| 128 | FRPOS | Number of managers | decimal | 15 | 3 | QUAN | ((0)) | Yes | | CFFRPOS | |
| 129 | QFRPOS | Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | RKCG_UNIT | Allow NULL? |
