| 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 | * | MANDT | Allow NULL? |
| 2 | JOBNO | Job Identification: GUID - 32 Characters | nvarchar | 32 | 0 | CHAR | (N' ') | No | | EMG_JOBNO | Allow NULL? |
| 3 | STEPNO | Number of Job Steps in Import Job | nvarchar | 3 | 0 | NUMC | (N'000') | No | | EMG_STEPNO | Allow NULL? |
| 4 | FIRMA | Company (Client) for Migration | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TEMFIRMA | EMG_FIRMA | Allow NULL? |
| 5 | OBJECT | Migration Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | EMG_OBJECT | Allow NULL? |
| 6 | DIR | Path for Migration | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | EMG_PFAD | Allow NULL? |
| 7 | FILE | File Name for Migration | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | EMG_FILE | Allow NULL? |
| 8 | ERRDIR | Path for Migration | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | EMG_PFAD | Allow NULL? |
| 9 | ERRFILE | Name of error file | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | EMG_EFILE | Allow NULL? |
| 10 | CODEPAGE | Code Page of Legacy System | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | * | EMG_SCP | Allow NULL? |
| 11 | PROG | Program name within a step (e.g. report) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BTCPROG | Allow NULL? |
| 12 | VARI | Name of variant within a step | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | BTCVARIANT | Allow NULL? |
| 13 | SERVER | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 14 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 15 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
| 16 | NCOMM | Commit interval of migration | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | EMG_NCOMM | Allow NULL? |
| 17 | JOBGROUP | Job group | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | EMG_JOBGROUP | Allow NULL? |
| 18 | TOPGROUP | Superior Job Group | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | EMG_TOPGROUP | Allow NULL? |
| 19 | STOP | Job Cancelation | char | 1 | 0 | CHAR | (N' ') | Yes | | EMG_STOP | Allow NULL? |
| 20 | STATUS | Status of Migration Import Run | char | 1 | 0 | CHAR | (N' ') | Yes | | EMG_JOBSTATUS | Allow NULL? |
| 21 | JOBTYPE | Job category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | EMG_JOBTYPE | Allow NULL? |
| 22 | S_DATE | Starting date for migration | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EMG_S_DATE | Allow NULL? |
| 23 | RESTART | Migration run in restart mode | char | 1 | 0 | CHAR | (N' ') | Yes | | EMG_KNZ_RESTART | Allow NULL? |
| 24 | SPLIT | Migration: File Was Split | char | 1 | 0 | CHAR | (N' ') | Yes | | EMG_SPLIT | Allow NULL? |
