| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | TAB | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | TABNAME | Allow NULL? |
| 2 | TTYPE | Table type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | TTYPE | Allow NULL? |
| 3 | FLDGR | Max. number of period data fields in FI-SL record | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FLDGR | Allow NULL? |
| 4 | TRCUR | Store transaction currency | char | 1 | 0 | CHAR | (N' ') | Yes | | TRCUR | Allow NULL? |
| 5 | LCCUR | Store second currency | char | 1 | 0 | CHAR | (N' ') | Yes | | LCCUR | Allow NULL? |
| 6 | RCCUR | Store third currency | char | 1 | 0 | CHAR | (N' ') | Yes | | RCCUR | Allow NULL? |
| 7 | OCCUR | Manage fourth currency | char | 1 | 0 | CHAR | (N' ') | Yes | | OCCUR | Allow NULL? |
| 8 | QUANT | Store quantities | char | 1 | 0 | CHAR | (N' ') | Yes | | QUANT | Allow NULL? |
| 9 | ATQNT | Store additional quantities | char | 1 | 0 | CHAR | (N' ') | Yes | | ATQNT | Allow NULL? |
| 10 | COMPTAB | Indicator for global table | char | 1 | 0 | CHAR | (N' ') | Yes | | RCOMP_TAB | Allow NULL? |
| 11 | NTABLE | Correspondence table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | NTABLE | Allow NULL? |
| 12 | PSITABLE | Plan line item table with blocked periods | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | PSITABLE | Allow NULL? |
| 13 | OBJTABLE | Object table for FI-SL tables | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | OBJTABLE_D | Allow NULL? |
| 14 | ENQOBJECT | Name of lock object | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | ENQOBJECT | Allow NULL? |
| 15 | OBJTABLE2 | Object table for fields without sender-receiver relationship | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | OBJTABLE2 | Allow NULL? |
| 16 | OBJTABLE3 | Third object table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | OBJTABLE3 | Allow NULL? |
| 17 | OBJTABLE4 | Fourth object table | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | OBJTABLE4 | Allow NULL? |
| 18 | PROGROUP | Program group (A: fixed tables, 1,2,3: user-defined tables) | char | 1 | 0 | CHAR | (N' ') | Yes | | PROGROUP | Allow NULL? |
| 19 | APPL | Owner application | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | GLXAPPL | Allow NULL? |
| 20 | SUBAPPL | Subapplication | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | GLXSUBAPPL | Allow NULL? |
| 21 | KOMP | Component | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | GLXKOMP | Allow NULL? |
| 22 | INACTIVE | Indicator defining whether table is inactive | char | 1 | 0 | CHAR | (N' ') | Yes | | INACTIVE | Allow NULL? |
| 23 | OBJCHECK | Is the object table to be validated? | char | 1 | 0 | CHAR | (N' ') | Yes | | G_OBJCHECK | Allow NULL? |
| 24 | SAPRL | SAP Release for which the table was installed | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | G_SAPRL | Allow NULL? |
| 25 | RNTABLE | Rollup actual line item table with single periods | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RNTABLE | Allow NULL? |
| 26 | RPSITABLE | Rollup plan line item table with blocked periods | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | RPSITABLE | Allow NULL? |
| 27 | GFISTABLE | SFIS communication structure | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | GFISTABLE | Allow NULL? |
| 28 | SCREEN | Screen number for summary record display | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | G_DYNNR | Allow NULL? |
| 29 | USE_OF_VIEW | Use of views | char | 1 | 0 | CHAR | (N' ') | Yes | | G_USE_OF_VIEW | Allow NULL? |
| 30 | DIM_ORGUNIT | FI-SL: Field name for organizational unit | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | G_DIM_ORGUNIT | Allow NULL? |
| 31 | DIM_ACCOUNT | FI-SL: Field name for the account | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | G_DIM_ACCOUNT | Allow NULL? |
| 32 | PHYS_TAB | Table Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | TABNAME | Allow NULL? |
| 33 | GLFLEX | Indicator: Used for New General Ledger | char | 1 | 0 | CHAR | (N' ') | No | | FAGL_FLAG_GLFLEX | Allow NULL? |
| 34 | WRITE_SI_FOR_BCF | Indicator: Balance Carryforward Writes Line Items | char | 1 | 0 | CHAR | (N' ') | Yes | | WRITE_SI_FOR_BCF | Allow NULL? |
| 35 | COMMIT_LEVEL | 30 Characters | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CHAR30 | Allow NULL? |
