| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CATID | Index category identification | nvarchar | 32 | 0 | CHAR | (N' ') | No | SRETIDCAT | SRET_CATID | Allow NULL? |
| 2 | LANGU | Language Key Acc. SAP Norm (1 character) | char | 1 | 0 | CHAR | (N' ') | No | | SRET_LANGU | Allow NULL? |
| 3 | LAISO | 2-Character SAP Language Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | LAISO | Allow NULL? |
| 4 | NUMDOC | Planned No. of Documents for a Language | nvarchar | 12 | 0 | NUMC | (N'000000000000') | Yes | | SRET_NUDOC | Allow NULL? |
| 5 | AVGDOCSIZ | Average Document Size in KB | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SRET_AVGDS | Allow NULL? |
| 6 | IDXCOUNT | Counter for indexed/de-indexed documents | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SRET_IDCNT | Allow NULL? |
| 7 | CREA_USER | User who created the language for a category | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SRET_CRELA | Allow NULL? |
| 8 | CRTIME | Language creation time (date - time) acc. to UTC | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SRET_CRLTI | Allow NULL? |
| 9 | CHNG_USER | Language last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SRET_CHGLA | Allow NULL? |
| 10 | CHTIME | Last time of change date - time (UTC) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SRET_CHLTI | Allow NULL? |
| 11 | TTIME | Transport (time stamp) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SRET_TTIME | Allow NULL? |
| 12 | TFLAG | Transport flag (import flag) | char | 1 | 0 | CHAR | (N' ') | Yes | | SRET_TFLAG | Allow NULL? |
| 13 | PYINS | Indicates whether a physical index is to be imported | char | 1 | 0 | CHAR | (N' ') | Yes | | SRET_PYINS | Allow NULL? |
| 14 | INDEXDEL | Indicates that the Index is To Be Deleted | char | 1 | 0 | CHAR | (N' ') | Yes | | SRET_IDXDE | Allow NULL? |
| 15 | HASINDEX | Indicates Whether a Physical Index Exists | char | 1 | 0 | CHAR | (N' ') | Yes | | SRET_HASIX | Allow NULL? |
| 16 | TRORDER | Transport request | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | SRET_TRORD | Allow NULL? |
| 17 | CTIME | Time stamp of export for checking against index | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SRET_CTIME | Allow NULL? |
| 18 | ITIME | Time stamp for export of physical index | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SRET_ITIME | Allow NULL? |
| 19 | IMPORT | Indicates whether the index was imported | char | 1 | 0 | CHAR | (N' ') | Yes | | SRET_IMPFL | Allow NULL? |
