| 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 | RLDNR | Ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | | RLDNR | Allow NULL? |
| 3 | GCURR | Currency key of the ledger currency | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | GCURR | Allow NULL? |
| 4 | CLASS | Ledger class | char | 1 | 0 | CHAR | (N' ') | No | | LDCLS | Allow NULL? |
| 5 | TYP | Type of ledger (client in which it is to be maintained) | char | 1 | 0 | CHAR | (N' ') | No | | LEDGER_TYP | Allow NULL? |
| 6 | TRCUR | Store transaction currency | char | 1 | 0 | CHAR | (N' ') | No | | TRCUR | Allow NULL? |
| 7 | LCCUR | Store second currency | char | 1 | 0 | CHAR | (N' ') | No | | LCCUR | Allow NULL? |
| 8 | RCCUR | Store third currency | char | 1 | 0 | CHAR | (N' ') | No | | RCCUR | Allow NULL? |
| 9 | OCCUR | Manage fourth currency | char | 1 | 0 | CHAR | (N' ') | Yes | | OCCUR | Allow NULL? |
| 10 | QUANT | Store quantities | char | 1 | 0 | CHAR | (N' ') | No | | QUANT | Allow NULL? |
| 11 | ATQNT | Store additional quantities | char | 1 | 0 | CHAR | (N' ') | No | | ATQNT | Allow NULL? |
| 12 | TAB | Totals Table | nvarchar | 30 | 0 | CHAR | (N' ') | No | * | GLTAB | Allow NULL? |
| 13 | RCOPY | Maintenance by Copying Allowed | char | 1 | 0 | CHAR | (N' ') | No | | RCOPY | Allow NULL? |
| 14 | SHKZ | Maintain debits/credits indicator | char | 1 | 0 | CHAR | (N' ') | No | | SHKZ | Allow NULL? |
| 15 | GLSIP | Write line items | char | 1 | 0 | CHAR | (N' ') | No | | GLSIP | Allow NULL? |
| 16 | VORTRAG | Set up balance carry forward | char | 1 | 0 | CHAR | (N' ') | No | | VORTR | Allow NULL? |
| 17 | DLDNR | Average balance ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | RLDNR1 | Allow NULL? |
| 18 | XDLDNR | Store average in the same ledger | char | 1 | 0 | CHAR | (N' ') | No | | XDLDNR | Allow NULL? |
| 19 | CURT1 | Currency type of the local currency (HSL) | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CURT_HSL | Allow NULL? |
| 20 | CURT2 | Currency type of the group currency (KSL) | nvarchar | 2 | 0 | CHAR | (N' ') | No | | CURT_KSL | Allow NULL? |
| 21 | CURT3 | Currency type of currency 4 | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CURT_OSL | Allow NULL? |
| 22 | V2POST | Delay the ledger update | char | 1 | 0 | CHAR | (N' ') | No | | V2POST | Allow NULL? |
| 23 | LCTYP | Type of consolidation | char | 1 | 0 | CHAR | (N' ') | No | | LC_TYP | Allow NULL? |
| 24 | FIX | Indicator: Standard ledger | char | 1 | 0 | CHAR | (N' ') | No | | G_LD_FIX | Allow NULL? |
| 25 | POST | Postings can be made to ledger | char | 1 | 0 | CHAR | (N' ') | No | | G_POST | Allow NULL? |
| 26 | ROLLUP | Rollup allowed to the ledger | char | 1 | 0 | CHAR | (N' ') | No | | G_ROLLUP | Allow NULL? |
| 27 | DEPLD | Is the ledger an additional ledger? | char | 1 | 0 | CHAR | (N' ') | No | | G_ZUSATZLD | Allow NULL? |
| 28 | APPL | Owner application | nvarchar | 2 | 0 | CHAR | (N' ') | No | * | GLXAPPL | Allow NULL? |
| 29 | SUBAPPL | Subapplication | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | GLXSUBAPPL | Allow NULL? |
| 30 | KOMP | Component | nvarchar | 3 | 0 | CHAR | (N' ') | No | | GLXKOMP | Allow NULL? |
| 31 | GZLEDGER | Indicator: Ledger cannot be reset (delete) | char | 1 | 0 | CHAR | (N' ') | No | | GZLEDGER | Allow NULL? |
| 32 | EXIT | Exit no. (S..: standard exits, U..: user exits) | nvarchar | 3 | 0 | CHAR | (N' ') | No | | EXIT_NR_LD | Allow NULL? |
| 33 | KLDNR | Export ledger | nvarchar | 2 | 0 | CHAR | (N' ') | No | T881 | G_KLDNR | Allow NULL? |
| 34 | LOGSYS | Logical system | nvarchar | 10 | 0 | CHAR | (N' ') | No | TBDLS | LOGSYS | Allow NULL? |
| 35 | VALUTYP | Valuation | char | 1 | 0 | NUMC | (N'0') | No | | G_VALUTYP | Allow NULL? |
| 36 | GCOMPRESS | Summarize data | char | 1 | 0 | CHAR | (N' ') | No | | G_COMPRESS | Allow NULL? |
| 37 | SPLITMETHD | Document Splitting Method | nvarchar | 10 | 0 | CHAR | (N' ') | No | T8G01 | SPLITMETHD | Allow NULL? |
| 38 | DATE_DET_POPER | Date with which the posting period is determined | char | 1 | 0 | NUMC | (N'0') | Yes | | GLX_DATE_FOR_POS | Allow NULL? |
| 39 | GLFLEX | 1-Character Indicator: Type of Ledger | char | 1 | 0 | CHAR | (N' ') | No | | FAGL_TYPE_GLFLEX | Allow NULL? |
| 40 | XLEADING | Indicator: Leading Ledger | char | 1 | 0 | CHAR | (N' ') | No | | FAGL_FLAG_LEADING | Allow NULL? |
| 41 | ORIENT_LEDGER | Reference Ledger for General Ledger Accounting | nvarchar | 2 | 0 | CHAR | (N' ') | No | V_FAGL_T881_DB | FAGL_ORIENTATION_LEDGER | Allow NULL? |
| 42 | AVG_ROLLUP | Indicator: Rollup Ledger for Daily Average Balances | char | 1 | 0 | CHAR | (N' ') | No | | FAGL_TYPE_AVG_ROLLUP | Allow NULL? |
| 43 | XCASH_LEDGER | Cash Ledger Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | FAGL_CASH_LEDGER | Allow NULL? |
