| 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 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | No | T004 | KTOPL | Allow NULL? |
| 3 | SAKNR | G/L Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | No | | SAKNR | Allow NULL? |
| 4 | XBILK | Indicator: Account is a balance sheet account? | char | 1 | 0 | CHAR | (N' ') | Yes | | XBILK | Allow NULL? |
| 5 | SAKAN | G/L account number, significant length | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SAKAN | Allow NULL? |
| 6 | BILKT | Group Account Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKA1 | BILKT | 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 | GVTYP | P&L statement account type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | GVTYP | Allow NULL? |
| 10 | KTOKS | G/L Account Group | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T077S | KTOKS | Allow NULL? |
| 11 | MUSTR | Number of the sample account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKM1 | MUSTR | Allow NULL? |
| 12 | VBUND | Company ID of trading partner | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | T880 | RASSC | Allow NULL? |
| 13 | XLOEV | Indicator: Account marked for deletion? | char | 1 | 0 | CHAR | (N' ') | Yes | | XLOEV | Allow NULL? |
| 14 | XSPEA | Indicator: account is blocked for creation ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEA | Allow NULL? |
| 15 | XSPEB | Indicator: Is Account Blocked for Posting? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEB | Allow NULL? |
| 16 | XSPEP | Indicator: account blocked for planning ? | char | 1 | 0 | CHAR | (N' ') | Yes | | XSPEP | Allow NULL? |
| 17 | MCOD1 | Search Term for Using Matchcode | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | MCODF | Allow NULL? |
| 18 | FUNC_AREA | Functional Area | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | TFKB | FKBER | Allow NULL? |
