| 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 | RECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESERECN | Allow NULL? |
| 3 | ACTN | Sequential Number of the Change State | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | No | | ESEACTN | Allow NULL? |
| 4 | VALFR | Valid-From Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALFR | Allow NULL? |
| 5 | VALTO | Valid-To Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEVALTO | Allow NULL? |
| 6 | AENNR | Change Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | AENR | ESEAENNR | Allow NULL? |
| 7 | DELFLG | Deletion Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEDELFLG | Allow NULL? |
| 8 | PARKFLG | Data Record Is Inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEPARKFLG | Allow NULL? |
| 9 | CRDAT | Created On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESECRDAT | Allow NULL? |
| 10 | CRNAM | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESECRNAM | Allow NULL? |
| 11 | UPDDAT | Changed On | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ESEUPDDAT | Allow NULL? |
| 12 | UPDNAM | Last Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEUPDNAM | Allow NULL? |
| 13 | SRSID | Source of Data | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | TCG56 | ESESRSID | Allow NULL? |
| 14 | OWNID | Data Provider | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ESEVENDRID | Allow NULL? |
| 15 | RECNROOT | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | * | ESERECN | Allow NULL? |
| 16 | DDPID | Key of Shipping Order Package | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | CVDEDDPID | Allow NULL? |
| 17 | LOGID | Key of log header record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | CVDELOGID | Allow NULL? |
| 18 | OHORDERNO | Job Number of a WWI Job | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESEOHORDER | Allow NULL? |
| 19 | OHORDERCNT | Item counter for WWI job | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ESEORDERCN | Allow NULL? |
| 20 | REPORTRECN | Sequential Number of Data Record | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | ESERECN | Allow NULL? |
| 21 | SRCDOKAR | Document Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DOKAR | Allow NULL? |
| 22 | SRCDOKNR | Document number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | DOKNR | Allow NULL? |
| 23 | SRCDOKVR | Document Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DOKVR | Allow NULL? |
| 24 | SRCDOKTL | Document Part | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DOKTL_D | Allow NULL? |
| 25 | TRGDOKAR | Document Type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | DOKAR | Allow NULL? |
| 26 | TRGDOKNR | Document number | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | * | DOKNR | Allow NULL? |
| 27 | TRGDOKVR | Document Version | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DOKVR | Allow NULL? |
| 28 | TRGDOKTL | Document Part | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | DOKTL_D | Allow NULL? |
| 29 | ADDID | Reference number of application-dependent data | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CVDEADDID | Allow NULL? |
| 30 | GENMODE | Generating mode for report generation | char | 1 | 0 | CHAR | (N' ') | Yes | | ESEGENMODE | Allow NULL? |
| 31 | WWIAPPL1 | WWI-Supported Applications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ESEWWIAPPL | Allow NULL? |
| 32 | WWIAPPL2 | WWI-Supported Applications | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | ESEWWIAPPL | Allow NULL? |
| 33 | GENPC | Key of a WWI Server | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ESEGENPC | Allow NULL? |
| 34 | WWIDEST | WWI destination key | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | ESEWWIDEST | Allow NULL? |
| 35 | PRTYPE | Printer Type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ESEPRTYPE | Allow NULL? |
| 36 | STATUS | Status of a WWI Job | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ESEOHSTAT | Allow NULL? |
| 37 | JOBNAME | Background job name | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | BTCJOB | Allow NULL? |
| 38 | JOBCOUNT | Job ID | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | BTCJOBCNT | Allow NULL? |
| 39 | GENCBFUNC | Function name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | TFDIR | FUNCNAME | Allow NULL? |
| 40 | GENPRIO | Priority of a generation order | char | 1 | 0 | NUMC | (N'0') | Yes | | ESEGENPRIO | Allow NULL? |
| 41 | JOBID | Processing Cycle ID Number | nvarchar | 20 | 0 | NUMC | (N'00000000000000000000') | Yes | | CVDEJOBID | Allow NULL? |
