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