| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | ACTIVITY | FI-SL Business Transaction | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ACTI1 | Allow NULL? |
| 2 | TAB_1 | Table 1 | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABELLE_1 | Allow NULL? |
| 3 | TAB_2 | Table 2 | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABELLE_2 | Allow NULL? |
| 4 | TAB_3 | Table 3 | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABELLE_3 | Allow NULL? |
| 5 | TAB_4 | Table 4 | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABELLE_4 | Allow NULL? |
| 6 | VORGTYP | Activity type for FI-SL activities | char | 1 | 0 | CHAR | (N' ') | No | | VORGTYP | Allow NULL? |
| 7 | SATZTYP | Record Type | char | 1 | 0 | CHAR | (N' ') | No | | RRCTY | Allow NULL? |
| 8 | SHWERT | Activity Transfers Amounts Without +/- Sign | char | 1 | 0 | CHAR | (N' ') | No | | SHWERT | Allow NULL? |
| 9 | BUPER0 | Posting in period zero is allowed | char | 1 | 0 | CHAR | (N' ') | No | | BUPER0 | Allow NULL? |
| 10 | KZKWAER | Activity can transfer a group currency to direct posting | char | 1 | 0 | CHAR | (N' ') | No | | KZKWAER | Allow NULL? |
| 11 | ROLLUP | Posting in rollup ledger is allowed | char | 1 | 0 | CHAR | (N' ') | No | | BU_ROLLUP | Allow NULL? |
| 12 | MZEILE | At least one FI-SL line must be posted per document line? | char | 1 | 0 | CHAR | (N' ') | No | | MZEILE | Allow NULL? |
| 13 | PEROK | Period check already performed in pre-system (open) | char | 1 | 0 | CHAR | (N' ') | No | | PEROK | Allow NULL? |
| 14 | RKBEL | Indicator 'transaction writes CO documents' | char | 1 | 0 | CHAR | (N' ') | No | | RKBEL | Allow NULL? |
| 15 | GFORMAT | Format for FI-SL field movements | nvarchar | 4 | 0 | CHAR | (N' ') | No | T022F | GFORMAT | Allow NULL? |
| 16 | APPL | Owner application | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | GLXAPPL | Allow NULL? |
| 17 | SUBAPPL | Subapplication | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | GLXSUBAPPL | Allow NULL? |
| 18 | KOMP | Component | nvarchar | 3 | 0 | CHAR | (N' ') | No | | GLXKOMP | Allow NULL? |
| 19 | NOTUSED | Activity is not allowed in Special Purpose Ledger | char | 1 | 0 | CHAR | (N' ') | No | | G_NOTGLX | Allow NULL? |
| 20 | ACTGROUP | Activity group | char | 1 | 0 | CHAR | (N' ') | Yes | | G_ACTGROUP | Allow NULL? |
