| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | KEY1 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | NUMC10 | Allow NULL? |
| 3 | KEY2 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | NUMC10 | Allow NULL? |
| 4 | KEY3 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | NUMC10 | Allow NULL? |
| 5 | REL_KEY1 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | NUMC10 | Allow NULL? |
| 6 | REL_DATA1 | Boolean | char | 1 | 0 | CHAR | (N' ') | Yes | | SCOL_BOOLEAN | Allow NULL? |
| 7 | REL_DATA2 | Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATUM | Allow NULL? |
| 8 | REL_DATA3 | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 9 | REL_DATA4 | Natural Number | int | 10 | 0 | INT4 | ((0)) | Yes | | INT4 | Allow NULL? |
| 10 | REL_DATA5 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NUMC10 | Allow NULL? |
| 11 | REL_DATA6 | Numeric Character Field, Length 10 | nvarchar | 10 | 0 | NUMC | (N'0000000000') | Yes | | NUMC10 | Allow NULL? |
| 12 | REL_DATA7 | Character Field Length = 10 | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CHAR10 | Allow NULL? |
| 13 | REL_DATA8 | 30 Characters | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CHAR30 | Allow NULL? |
| 14 | REL_DATA9 | Character field, length 32 | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CHAR32 | Allow NULL? |