| 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 | KBID | Internal Number of SCE Knowledge Base | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | KBID | Allow NULL? |
| 3 | DSINT | Internal counter for objects in an SCE knowledge base | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SCEID | Allow NULL? |
| 4 | GRINT | Internal counter for objects in an SCE knowledge base | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | SCEID | Allow NULL? |
| 5 | COUNTER | 2-byte integer | smallint | 5 | 0 | INT2 | ((0)) | No | | SCEINT2 | |
| 6 | COMP | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | No | | SCEBOOLEAN | Allow NULL? |
| 7 | S_SALES | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | SCEBOOLEAN | Allow NULL? |
| 8 | S_ENGINEERING | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | SCEBOOLEAN | Allow NULL? |
| 9 | S_P_SALES | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | SCEBOOLEAN | Allow NULL? |
| 10 | S_P_PURCHASE | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | SCEBOOLEAN | Allow NULL? |
| 11 | S_P_ENGINEER | Boolean (T = true, F = false, blank = unknown) | char | 1 | 0 | CHAR | (N' ') | Yes | | SCEBOOLEAN | Allow NULL? |