| 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 | ANWND | Application using bank data storage | nvarchar | 4 | 0 | CHAR | (N' ') | No | | ANWND_EBKO | Allow NULL? |
| 3 | ABSND | Sending bank (electronic bank statement) | nvarchar | 50 | 0 | CHAR | (N' ') | No | | ABSND_EB | Allow NULL? |
| 4 | AZIDT | Bank statement identification | nvarchar | 20 | 0 | CHAR | (N' ') | No | | AZIDT_EB | Allow NULL? |
| 5 | EMKEY | Payee Keys | nvarchar | 20 | 0 | CHAR | (N' ') | No | | EMKEY_EB | Allow NULL? |
| 6 | KUKEY | Short key (surrogate) | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | KUKEY_EB | Allow NULL? |
| 7 | ASTAT | Statement status | char | 1 | 0 | CHAR | (N' ') | Yes | | ASTAT_EB | Allow NULL? |
| 8 | DSTAT | Print status | char | 1 | 0 | CHAR | (N' ') | Yes | | DSTAT_EB | Allow NULL? |
| 9 | VB1OK | All postings in area 1 are OK | char | 1 | 0 | CHAR | (N' ') | Yes | | VB1OK_EBKO | Allow NULL? |
| 10 | VB2OK | All postings in area 2 are OK | char | 1 | 0 | CHAR | (N' ') | Yes | | VB2OK_EBKO | Allow NULL? |
| 11 | KIPRE | All items on header record were interpreted | char | 1 | 0 | CHAR | (N' ') | Yes | | KIPRE_EB | Allow NULL? |
| 12 | VFDAT | Data expiry date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | VFDAT_EB | Allow NULL? |
| 13 | GRP01 | Session name for bank postings | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | GRP01_EB | Allow NULL? |
| 14 | XKEP1 | Keep session 1 after processing | char | 1 | 0 | CHAR | (N' ') | Yes | | XKEP1_EB | Allow NULL? |
| 15 | GRP02 | Session name for subledger accounting | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | GRP02_EB | Allow NULL? |
| 16 | XKEP2 | Keep session 2 after processing | char | 1 | 0 | CHAR | (N' ') | Yes | | XKEP2_EB | Allow NULL? |
| 17 | WVDAT | Further processing date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | WVDAT_EB | Allow NULL? |
| 18 | WVTIM | Further processing time | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | WVTIM_EB | Allow NULL? |
| 19 | WVART | Further processing type | char | 1 | 0 | CHAR | (N' ') | Yes | | WVART_EB | Allow NULL? |
| 20 | HKONT | General Ledger Account | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | SKB1 | HKONT | Allow NULL? |
| 21 | KTONR | Bank account number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | BANKN | Allow NULL? |
| 22 | KTOIH | Bank account holder | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | KTOIH_EB | Allow NULL? |
| 23 | KTOSB | Special account name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | KTOSB_EB | Allow NULL? |
| 24 | AZNUM | Statement number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | AZNUM_EB | Allow NULL? |
| 25 | AZSNR | Statement page number | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | AZSNR_EB | Allow NULL? |
| 26 | AZDAT | Statement Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | AZDAT_EB | Allow NULL? |
| 27 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T001 | BUKRS | Allow NULL? |
| 28 | KTOPL | Chart of Accounts | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T004 | KTOPL | Allow NULL? |
| 29 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 30 | SSTYP | Beginning balance type (F=begin balance, M=interim balance) | char | 1 | 0 | CHAR | (N' ') | Yes | | SSTYP_EB | Allow NULL? |
| 31 | SSVOZ | Starting balance +/- sign | char | 1 | 0 | CHAR | (N' ') | Yes | | SSVOZ_EB | Allow NULL? |
| 32 | SSBTR | Opening balance amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | SSBTR_EB | |
| 33 | SUMSO | Total Debit | decimal | 17 | 2 | CURR | ((0)) | Yes | | SUMSO_EB | |
| 34 | SUMHA | Total Credit | decimal | 17 | 2 | CURR | ((0)) | Yes | | SUMHA_EB | |
| 35 | ESTYP | Ending balance type (F=ending balance, M=interim balance) | char | 1 | 0 | CHAR | (N' ') | Yes | | ESTYP_EB | Allow NULL? |
| 36 | ESVOZ | Closing balance +/- sign | char | 1 | 0 | CHAR | (N' ') | Yes | | ESVOZ_EB | Allow NULL? |
| 37 | ESBTR | Ending balance amount | decimal | 17 | 2 | CURR | ((0)) | Yes | | ESBTR_EB | |
| 38 | ESDMB | Ending balance equivalent in local currency | decimal | 17 | 2 | CURR | ((0)) | Yes | | ESDMB_EB | |
| 39 | BLAUF | Life start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BLAUF_EB | Allow NULL? |
| 40 | ELAUF | Life end | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | ELAUF_EB | Allow NULL? |
| 41 | HZINS | Credit interest | decimal | 9 | 3 | DEC | ((0)) | Yes | | HZINS_EB | |
| 42 | TEILN | Customer/vendor EB number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | TEILN_EB | Allow NULL? |
| 43 | BKTOA | Bank account type | nvarchar | 23 | 0 | CHAR | (N' ') | Yes | | BKTOA_EB | Allow NULL? |
| 44 | ANZES | Number of memo records from the bank statement | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | ANZES_EB | Allow NULL? |
| 45 | VGTYP | Transaction type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | VGTYP_EB | Allow NULL? |
| 46 | EFART | Input Type | char | 1 | 0 | CHAR | (N' ') | Yes | | EFART_EB | Allow NULL? |
| 47 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HBKID | Allow NULL? |
| 48 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | HKTID | Allow NULL? |
| 49 | EUSER | User who fills the bank data buffer | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | EUSER_EB | Allow NULL? |
| 50 | EDATE | Import date into bank data puffer | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | EDATE_EB | Allow NULL? |
| 51 | ETIME | Import time into bank data buffer | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | ETIME_EB | Allow NULL? |
| 52 | BKREF | Reference specifications for bank details | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | BKREF | Allow NULL? |
| 53 | XFDIS | X - cash management payment advice notes were created | char | 1 | 0 | CHAR | (N' ') | Yes | | XFDIS_EB | Allow NULL? |
| 54 | DSART | Planning type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | DSART | Allow NULL? |
| 55 | XVERD | Summarize bank statement items | char | 1 | 0 | CHAR | (N' ') | Yes | | FFDISXVERD | Allow NULL? |
| 56 | XBENR | Reference Key | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | AWKEY | Allow NULL? |
| 57 | XBTYP | Reference Transaction | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | AWTYP | Allow NULL? |
| 58 | SEQ_NUMBER | Bank statement sequential number | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SEQ_NUMBER | Allow NULL? |
| 59 | SEQ_STATUS | Sequence status | char | 1 | 0 | CHAR | (N' ') | Yes | | SEQ_STATUS | Allow NULL? |
| 60 | INPUT_FORMAT | Input format | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | INPUT_FORMAT | Allow NULL? |
| 61 | SIBAN | Sender Bank Account: IBAN | nvarchar | 34 | 0 | CHAR | (N' ') | Yes | | SIBAN_EB | Allow NULL? |
