| 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 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T001 | BUKRS | Allow NULL? |
| 3 | SAKNR | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | SKA1 | SAKNR | Allow NULL? |
| 4 | BEGRU | Authorization Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BRGRU | Allow NULL? |
| 5 | BUSAB | Accounting clerk | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T001S | BUSAB | Allow NULL? |
| 6 | DATLZ | Date of the last interest calculation run | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DATLZ | Allow NULL? |
| 7 | ERDAT | Date on which the Record Was Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ERDAT_RF | Allow NULL? |
| 8 | ERNAM | Name of Person who Created the Object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ERNAM_RF | Allow NULL? |
| 9 | FDGRV | Planning group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | T035 | FDGRV | Allow NULL? |
| 10 | FDLEV | Planning level | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T036 | FDLEV | Allow NULL? |
| 11 | FIPLS | Financial Budget Item | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | FIPLS | Allow NULL? |
| 12 | FSTAG | Field status group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T004F | FSTAG | Allow NULL? |
| 13 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012 | HBKID | Allow NULL? |
| 14 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | T012K | HKTID | Allow NULL? |
| 15 | KDFSL | Key for Exchange Rate Differences in Foreign Currency Accts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T030S | KDFSL | Allow NULL? |
| 16 | MITKZ | Account is reconciliation account | char | 1 | 0 | CHAR | (N' ') | Yes | | MITKZ | Allow NULL? |
| 17 | MWSKZ | Tax Category in Account Master Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SMWSK | Allow NULL? |
| 18 | STEXT | G/L account additional text | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | STEXT_SKB1 | Allow NULL? |
| 19 | VZSKZ | Interest calculation indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T056 | VZSKZ | Allow NULL? |
| 20 | WAERS | Account currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS_SKB1 | Allow NULL? |
| 21 | WMETH | Indicator: account managed in external system | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | WMETH | Allow NULL? |
| 22 | XGKON | Cash receipt account / cash disbursement account | char | 1 | 0 | CHAR | (N' ') | Yes | | XGKON | Allow NULL? |
| 23 | XINTB | Indicator: Is account only posted to automatically? | char | 1 | 0 | CHAR | (N' ') | Yes | | XINTB | Allow NULL? |
| 24 | XKRES | Indicator: Can Line Items Be Displayed by Account? | char | 1 | 0 | CHAR | (N' ') | Yes | | XKRES | Allow NULL? |
| 25 | XLOEB | Indicator: Account marked for deletion? | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV | Allow NULL? |
| 26 | XNKON | Indicator: Supplement for automatic postings ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XNKON | Allow NULL? |
| 27 | XOPVW | Indicator: Open Item Management? | char | 1 | 0 | CHAR | (N' ') | Yes | | XOPVW | Allow NULL? |
| 28 | XSPEB | Indicator: Is Account Blocked for Posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEB | Allow NULL? |
| 29 | ZINDT | Key date of the last interest calculation | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DZINDT | Allow NULL? |
| 30 | ZINRT | Interest calculation frequency in months | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | DZINRT | Allow NULL? |
| 31 | ZUAWA | Key for sorting according to assignment numbers | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TZUN | DZUAWA | Allow NULL? |
| 32 | ALTKT | Alternative account number in company code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | ALTKT_SKB1 | Allow NULL? |
| 33 | XMITK | Indicator: Reconcil.acct ready for input at time of posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | XMITK | Allow NULL? |
| 34 | RECID | Recovery Indicator | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T8JJ | JV_RECIND | Allow NULL? |
| 35 | FIPOS | Commitment Item | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | * | FIPOS | Allow NULL? |
| 36 | XMWNO | Indicator: Tax code is not a required field | char | 1 | 0 | CHAR | (N' ') | Yes | | XMWNO | Allow NULL? |
| 37 | XSALH | Indicator: Only Manage Balances in Local Currency | char | 1 | 0 | CHAR | (N' ') | Yes | | XSALH | Allow NULL? |
| 38 | BEWGP | Valuation Group | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | BEWGP | Allow NULL? |
| 39 | INFKY | Inflation Key | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | J_1AINFSKS | J_1AIFSKS | Allow NULL? |
| 40 | TOGRU | Tolerance Group for G/L Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T043S | TOGRU_S | Allow NULL? |
| 41 | XLGCLR | Clearing Specific to Ledger Groups | char | 1 | 0 | CHAR | (N' ') | Yes | | XLGCLR | Allow NULL? |
| 42 | MCAKEY | MCA Key | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | GLE_MCA_TMCAKEY | GLE_DTE_MCA_MCAKEY | Allow NULL? |
