| 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 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | No | | BTCJOB | Allow NULL? |
| 3 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | No | | BTCJOBCNT | Allow NULL? |
| 4 | JOBGROUP | Summary of jobs for a group | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCJOBGRP | Allow NULL? |
| 5 | INTREPORT | Name of internal report for batch job | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BTCREP | Allow NULL? |
| 6 | STEPCOUNT | Job step ID number. | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCSTEPCNT | Allow NULL? |
| 7 | SDLSTRTDT | Planned Start Date for Background Job | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCSDATE | Allow NULL? |
| 8 | SDLSTRTTM | Planned start time for background Job | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCSTIME | Allow NULL? |
| 9 | BTCSYSTEM | Target System to Run Background Job | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCTGTSYS | Allow NULL? |
| 10 | SDLDATE | Date of job/step scheduling | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCSDLDATE | Allow NULL? |
| 11 | SDLTIME | Time of a scheduled job/step | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCSDLTIME | Allow NULL? |
| 12 | SDLUNAME | Initiator of job/step scheduling | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCSDLNM | Allow NULL? |
| 13 | LASTCHDATE | Date of last job change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCJCHDATE | Allow NULL? |
| 14 | LASTCHTIME | Time of last job change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCJCHTIME | Allow NULL? |
| 15 | LASTCHNAME | Last job change made by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCJCHNM | Allow NULL? |
| 16 | RELDATE | Release Date for Background Scheduling | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCRELDT | Allow NULL? |
| 17 | RELTIME | Release time of scheduled background job | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCRELTM | Allow NULL? |
| 18 | RELUNAME | User that released scheduled batch job | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCRELNM | Allow NULL? |
| 19 | STRTDATE | Job start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCXDATE | Allow NULL? |
| 20 | STRTTIME | Batch job start time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCXTIME | Allow NULL? |
| 21 | ENDDATE | Job start date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCXDATE | Allow NULL? |
| 22 | ENDTIME | Batch job start time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCXTIME | Allow NULL? |
| 23 | PRDMINS | Duration period (in minutes) for a batch job | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BTCPMIN | Allow NULL? |
| 24 | PRDHOURS | Duration period (in hours) for a batch job | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BTCPHOUR | Allow NULL? |
| 25 | PRDDAYS | Duration (in days) of DBA action | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | BTCPDAY | Allow NULL? |
| 26 | PRDWEEKS | Duration period (in weeks) for a batch job | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BTCPWEEK | Allow NULL? |
| 27 | PRDMONTHS | Duration period (in months) for a batch job | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | BTCPMNTH | Allow NULL? |
| 28 | PERIODIC | Periodic Jobs Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCPFLAG | Allow NULL? |
| 29 | DELANFREP | Job deletion indicator after processing | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCDELFLAG | Allow NULL? |
| 30 | EMERGMODE | Emergency Job operation indicator (content 'X') | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCEFLAG | Allow NULL? |
| 31 | STATUS | State of Background Job | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCSTATUS | Allow NULL? |
| 32 | NEWFLAG | New job ID creation flag | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCNEWFLAG | Allow NULL? |
| 33 | AUTHCKNAM | Background User Name for Authorization Check | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | BTCAUTHNAM | Allow NULL? |
| 34 | AUTHCKMAN | Background client for authorization check | nvarchar | 3 | 0 | CLNT | (N'000') | Yes | * | BTCAUTHMAN | Allow NULL? |
| 35 | SUCCNUM | Number of successor job(s) | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCSNUM | Allow NULL? |
| 36 | PREDNUM | Number of previous jobs | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCPNUM | Allow NULL? |
| 37 | JOBLOG | TemSe object name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | RSTSONAME | Allow NULL? |
| 38 | LASTSTRTDT | Latest Execution Date for a Background Job | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BTCLSDATE | Allow NULL? |
| 39 | LASTSTRTTM | Latest Execution Time for Background Job | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | BTCLSTIME | Allow NULL? |
| 40 | WPNUMBER | Work process number | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCWPNO | Allow NULL? |
| 41 | WPPROCID | Work process ID | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCWPPID | Allow NULL? |
| 42 | EVENTID | Background Processing Event | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCEVENTID | Allow NULL? |
| 43 | EVENTPARM | Background Event Parameters (Such as, Jobname/Jobcount) | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | BTCEVTPARM | Allow NULL? |
| 44 | BTCSYSREAX | Target System to Run Background Job | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCTGTSYS | Allow NULL? |
| 45 | JOBCLASS | Job classification | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCJOBCLAS | Allow NULL? |
| 46 | PRIORITY | Job priority | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCJOBPRIO | Allow NULL? |
| 47 | EVENTCOUNT | Event number | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCEVTCNT | Allow NULL? |
| 48 | CHECKSTAT | Job status check indicator for subsequent job start | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCCKSTAT | Allow NULL? |
| 49 | CALENDARID | Factory Calendar ID for Background Processing | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | BTCCALID | Allow NULL? |
| 50 | PRDBEHAV | Period behavior of jobs on non-workdays | char | 1 | 0 | CHAR | (N' ') | Yes | | BTCPRDBHV | Allow NULL? |
| 51 | EXECSERVER | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 52 | EOMCORRECT | Correction field for calc. job execution (end-of-mth, cal.) | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCEOMCORR | Allow NULL? |
| 53 | CALCORRECT | Correction field for calc. job execution (end-of-mth, cal.) | int | 10 | 0 | INT4 | ((0)) | Yes | | BTCEOMCORR | Allow NULL? |
| 54 | REAXSERVER | Server name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BTCSRVNAME | Allow NULL? |
| 55 | RECLOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LOGSYS | Allow NULL? |
| 56 | RECOBJTYPE | Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SWO_OBJTYP | Allow NULL? |
| 57 | RECOBJKEY | Object key | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | SWO_TYPEID | Allow NULL? |
| 58 | RECDESCRIB | Describe flag | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SWO_DESCRB | Allow NULL? |
| 59 | TGTSRVGRP | Server Group Name Background Processing | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | BPSRVGRPN | Allow NULL? |
