| 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 | * | MANDT | Allow NULL? |
| 2 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | No | T012K | BUKRS | Allow NULL? |
| 3 | HBKID | Short Key for a House Bank | nvarchar | 5 | 0 | CHAR | (N' ') | No | T012K | HBKID | Allow NULL? |
| 4 | HKTID | ID for account details | nvarchar | 5 | 0 | CHAR | (N' ') | No | T012K | HKTID | Allow NULL? |
| 5 | AZNUM | Statement number | nvarchar | 5 | 0 | NUMC | (N'00000') | No | RFVIBK01A | VVIAZNUM | Allow NULL? |
| 6 | SNUMMC | Consecutive number of C-record in BK01 tape | nvarchar | 2 | 0 | NUMC | (N'00') | No | | VVISNUMMC | Allow NULL? |
| 7 | BANK | Bank data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | VVIBANK | Allow NULL? |
| 8 | KTONR | Account | nvarchar | 24 | 0 | CHAR | (N' ') | No | | VVIKTONR | Allow NULL? |
| 9 | SATZL_1 | Record length | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | VVISATZL | Allow NULL? |
| 10 | SATZA_2 | Record type | char | 1 | 0 | CHAR | (N' ') | Yes | | VVISATZA | Allow NULL? |
| 11 | BANKL_3 | Bank number of dispatching credit institute | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | VVIBANKL | Allow NULL? |
| 12 | BANKL_4 | Bank number of dispatching credit institute | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | VVIBANKL | Allow NULL? |
| 13 | KONTOBV_5 | Bank procedure account number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VVIKONTOBV | Allow NULL? |
| 14 | LEER13_6 | Empty | nvarchar | 13 | 0 | CHAR | (N' ') | Yes | | VVILEER13 | Allow NULL? |
| 15 | TEXTSCHL_7A | Text key part 1: Indicator for transaction | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | VVITEXTSCHLA | Allow NULL? |
| 16 | TEXTSCHL_7B | Text key part 2: Indicator for transaction | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VVITEXTSCHLB | Allow NULL? |
| 17 | LEER_8 | Empty | char | 1 | 0 | CHAR | (N' ') | Yes | | VVILEER1 | Allow NULL? |
| 18 | BETRAG_9 | Amount align right without comma | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | VVIBETRAG | Allow NULL? |
| 19 | BANKLMIETER_10 | Bank number of first paying credit institute (tenant) | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | VVIBANKLMIETER | Allow NULL? |
| 20 | KONTOMIETER_11 | Clearing account number of sold-to party (tenant) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | VVIKONTOMIETER | Allow NULL? |
| 21 | LEER_12 | Empty | nvarchar | 11 | 0 | CHAR | (N' ') | Yes | | VVILEER11 | Allow NULL? |
| 22 | LEER_13 | Empty | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VVILEER3 | Allow NULL? |
| 23 | NAME_EMP_14A | Name of recipient (apartment company) | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | VVINAMEEMP | Allow NULL? |
| 24 | LEER_14B | Empty 8 characters | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | VVILEER8 | Allow NULL? |
| 25 | NAME_AG_15 | Sold-to party (tenant) | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | VVINAMEAG | Allow NULL? |
| 26 | VWZWECK_16 | Purpose | nvarchar | 27 | 0 | CHAR | (N' ') | Yes | | VVIZWECK | Allow NULL? |
| 27 | LEER_17 | Empty | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | VVILEER3 | Allow NULL? |
| 28 | ANZERWEIT | Number of file extensions (00-15) in table RFVIBK01V | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | VVIANZERWEIT | Allow NULL? |
