| 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 | TESTID | PAW identifier | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | | LS_IDENT | Allow NULL? |
| 3 | CLASS | Logical info object class name from Knowledge Warehouse | nvarchar | 10 | 0 | CHAR | (N' ') | No | | LS_CLASS | Allow NULL? |
| 4 | GUID | LOIO unique info object key in Knowledge Warehouse | nvarchar | 32 | 0 | CHAR | (N' ') | No | | LS_GUID | Allow NULL? |
| 5 | PCLASS | Physical info object class in Knowledge Warehouse | nvarchar | 10 | 0 | CHAR | (N' ') | No | | LS_PCLASS | Allow NULL? |
| 6 | PGUID | PHIO unique info object key in Knowledge Warehouse | nvarchar | 32 | 0 | CHAR | (N' ') | No | | LS_PGUID | Allow NULL? |
| 7 | VAR1 | Info object context variant 1: enhancement | nvarchar | 10 | 0 | CHAR | (N' ') | No | | LS_VAR1 | Allow NULL? |
| 8 | VAR2 | Info object context variant 2: release | nvarchar | 12 | 0 | CHAR | (N' ') | No | | LS_VAR2 | Allow NULL? |
| 9 | VAR3 | Info object context variant 3: country | nvarchar | 3 | 0 | CHAR | (N' ') | No | | LS_VAR3 | Allow NULL? |
| 10 | VAR4 | 2-Character SAP Language Code | nvarchar | 2 | 0 | CHAR | (N' ') | No | | LAISO | Allow NULL? |
| 11 | TNAME | PAW - Test Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | LS_TNAME | Allow NULL? |
| 12 | DESCR | PAW - Test Description | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | LS_TDESCR | Allow NULL? |
| 13 | TVERS | PAW test version | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LS_TVERS | Allow NULL? |
| 14 | TARGET | PAW - Targetgroup | nvarchar | 64 | 0 | CHAR | (N' ') | Yes | | LS_TARGET | Allow NULL? |
| 15 | SAVRES | PAW - 'Save Results' Flag - as checkbox ('X' = yes) | char | 1 | 0 | CHAR | (N' ') | Yes | | LS_FLAGSAR | Allow NULL? |
| 16 | TSCENARIO | PAW test scenario | char | 1 | 0 | CHAR | (N' ') | Yes | | LS_SCENA | Allow NULL? |
| 17 | TFORMAT | PAW - Test Format | char | 1 | 0 | CHAR | (N' ') | Yes | | LS_TFORMAT | Allow NULL? |
| 18 | TRDTITLE | PAW - 3rd Party Testtitle | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | LS_3PARTY | Allow NULL? |
| 19 | TRDCONT | LOIO unique info object key in Knowledge Warehouse | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | LS_GUID | Allow NULL? |
| 20 | TRDCLASS | Logical info object class name from Knowledge Warehouse | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | LS_CLASS | Allow NULL? |
| 21 | ALLITEM | Boolean method (PAW) | char | 1 | 0 | NUMC | (N'0') | Yes | | LS_BOOLEAN | Allow NULL? |
| 22 | TIMELIMIT | PAW time limit | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | LS_TLIMIT | Allow NULL? |
| 23 | ITEMNUM | PAW - Number of items in test | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | LS_ITEMNUM | Allow NULL? |
| 24 | DYNITEM | PAW - Dynamic Item Selection | char | 1 | 0 | NUMC | (N'0') | Yes | | LS_DYNITEM | Allow NULL? |
| 25 | STRVISI | PAW - Stucture Visibility | char | 1 | 0 | NUMC | (N'0') | Yes | | LS_STRVISI | Allow NULL? |
| 26 | TFSELECT | PAW - Testform Selection | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | LS_TFSEL | Allow NULL? |
| 27 | ORDRANDOM | PAW - Random Order | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | LS_RANDOM | Allow NULL? |
| 28 | SCORING | PAW - Scoring | char | 1 | 0 | CHAR | (N' ') | Yes | | LS_SCORING | Allow NULL? |
| 29 | CUTOFF | PAW - Cutoff value for testsuccess | decimal | 5 | 2 | DEC | ((0)) | Yes | | LS_CUTOFF | |
| 30 | MAXPT | PAW - Maximal reachable points | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | LS_MAXPT | Allow NULL? |
| 31 | POSTEDIT | PAW - Postedit | char | 1 | 0 | NUMC | (N'0') | Yes | | LS_POSTEDT | Allow NULL? |
| 32 | FBTYPE | Feedback type (PAW) | char | 1 | 0 | NUMC | (N'0') | Yes | | LS_FBTYPE | Allow NULL? |
| 33 | ITEMTREAT | PAW - Itemtreat | char | 1 | 0 | CHAR | (N' ') | Yes | | LS_ITEMTR | Allow NULL? |
