| 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 | OBJECT | Object Type | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | MASSOBJTYP | Allow NULL? |
| 3 | VARNAME | Variant Name | nvarchar | 10 | 0 | CHAR | (N' ') | No | * | MASSVARNAM | Allow NULL? |
| 4 | SEGNR | Segment counter | nvarchar | 10 | 0 | CHAR | (N' ') | No | | MASSSEGNR | Allow NULL? |
| 5 | VARTEXT | Variant short text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | MASSVARTXT | Allow NULL? |
| 6 | SAPRL | Release of SAP System | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SYSAPRL | Allow NULL? |
| 7 | SEL | Indicator: Save selection fields in variant | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSSELV | Allow NULL? |
| 8 | SELVAL | Save Values of Selection Fields in Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSSVALV | Allow NULL? |
| 9 | SKIPSEL | Skip selection screen | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSSKSEL | Allow NULL? |
| 10 | FIELD | Save Fields to Be Changed in Variant | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSFIELDV | Allow NULL? |
| 11 | FIELDVAL | Indicator: Save values/formulas for fields in variant | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSVALV | Allow NULL? |
| 12 | NEWSEG | Indicator: Save information for creating new segments | char | 1 | 0 | CHAR | (N' ') | Yes | | MASSNEWSEG | Allow NULL? |
| 13 | RELID | Region in IMPORT/EXPORT Data Table | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | INDX_RELID | Allow NULL? |
| 14 | SRTFD | User-defined key in table INDX | nvarchar | 22 | 0 | CHAR | (N' ') | Yes | | INDX_SRTFD | Allow NULL? |
| 15 | LOEKZ | CHAR01 data element for SYST | char | 1 | 0 | CHAR | (N' ') | Yes | | SYCHAR01 | Allow NULL? |
| 16 | SPERR | CHAR01 data element for SYST | char | 1 | 0 | CHAR | (N' ') | Yes | | SYCHAR01 | Allow NULL? |
| 17 | AEDAT | (8-character) Date for SYST | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATS | Allow NULL? |
| 18 | USERA | User name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | USERNAME | Allow NULL? |
| 19 | PGMID | ABAP Program Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | PROGNAME | Allow NULL? |
| 20 | BEGDT | (8-character) Date for SYST | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATS | Allow NULL? |
| 21 | ENDDT | (8-character) Date for SYST | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SYDATS | Allow NULL? |
| 22 | CLUSTR | Length field for user data in EXPORT/IMPORT tables | smallint | 5 | 0 | INT2 | ((0)) | Yes | | INDX_CLSTR | |
| 23 | CLUSTD | Data field for IMPORT/EXPORT database tables | varbinary | 2886 | 0 | LRAW | | Yes | | INDX_CLUST | |