Table/Structure Field list used by SAP ABAP Program RFEBJP20 (Import Electronic Bank Statement Japan ZENGINKYOU)
SAP ABAP Program 
RFEBJP20 (Import Electronic Bank Statement Japan ZENGINKYOU) is using
-
Class (2)
-
Data Element (1)
-
Table/Structure Field (160)
-
Function Module (7)
-
Message Class (2)
-
Message Number (26)
-
Class Method (1)
-
Program (2)
-
Table (11)
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
BNKA - BANKA | Name of bank | |
| 2 | Table/Structure Field |
BNKA - BANKL | Bank Keys | |
| 3 | Table/Structure Field |
BNKA - BANKS | Bank country key | |
| 4 | Table/Structure Field |
BNKA - BRNCH | Bank Branch | |
| 5 | Table/Structure Field |
FEBEP - BUDAT | Posting date in the document | |
| 6 | Table/Structure Field |
FEBEP - BUTXT | Bank posting text | |
| 7 | Table/Structure Field |
FEBEP - CHECT | Check number | |
| 8 | Table/Structure Field |
FEBEP - EPVOZ | Debit/credit key for line items (for bank purposes) | |
| 9 | Table/Structure Field |
FEBEP - ESNUM | Memo record number (line item number in bank statement) | |
| 10 | Table/Structure Field |
FEBEP - INFO1 | Additional information 1 | |
| 11 | Table/Structure Field |
FEBEP - INFO2 | Additional information 2 | |
| 12 | Table/Structure Field |
FEBEP - INTAG | Interpretation algorithm | |
| 13 | Table/Structure Field |
FEBEP - JPDAT | Date of failed bills of exchange in Japan | |
| 14 | Table/Structure Field |
FEBEP - KUKEY | Short key (surrogate) | |
| 15 | Table/Structure Field |
FEBEP - KWAER | Account Currency Key | |
| 16 | Table/Structure Field |
FEBEP - KWBTR | Amount in account currency | |
| 17 | Table/Structure Field |
FEBEP - PARTN | Business Partner | |
| 18 | Table/Structure Field |
FEBEP - PNOTA | Daybook number | |
| 19 | Table/Structure Field |
FEBEP - SPESF | Fees in foreign currency (not same as account currency) | |
| 20 | Table/Structure Field |
FEBEP - VALUT | Value date of the item to be cleared | |
| 21 | Table/Structure Field |
FEBEP - VGDEF | Posting rule determined using standard value | |
| 22 | Table/Structure Field |
FEBEP - VGEXT | External business transaction | |
| 23 | Table/Structure Field |
FEBEP - VGINT | Posting rule | |
| 24 | Table/Structure Field |
FEBEP - ZUONR | Assignment number | |
| 25 | Table/Structure Field |
FEBKO - ABSND | Sending bank (electronic bank statement) | |
| 26 | Table/Structure Field |
FEBKO - ANWND | Application using bank data storage | |
| 27 | Table/Structure Field |
FEBKO - ANZES | Number of memo records from the bank statement | |
| 28 | Table/Structure Field |
FEBKO - ASTAT | Statement status | |
| 29 | Table/Structure Field |
FEBKO - AZDAT | Statement Date | |
| 30 | Table/Structure Field |
FEBKO - AZIDT | Bank statement identification | |
| 31 | Table/Structure Field |
FEBKO - AZNUM | Statement number | |
| 32 | Table/Structure Field |
FEBKO - BUKRS | Company Code | |
| 33 | Table/Structure Field |
FEBKO - EDATE | Import date into bank data puffer | |
| 34 | Table/Structure Field |
FEBKO - EFART | Input Type | |
| 35 | Table/Structure Field |
FEBKO - EMKEY | Payee Keys | |
| 36 | Table/Structure Field |
FEBKO - ESBTR | Ending balance amount | |
| 37 | Table/Structure Field |
FEBKO - ESVOZ | Closing balance +/- sign | |
| 38 | Table/Structure Field |
FEBKO - ETIME | Import time into bank data buffer | |
| 39 | Table/Structure Field |
FEBKO - EUSER | User who fills the bank data buffer | |
| 40 | Table/Structure Field |
FEBKO - HBKID | Short key for a house bank | |
| 41 | Table/Structure Field |
FEBKO - HKONT | General Ledger Account | |
| 42 | Table/Structure Field |
FEBKO - HKTID | ID for account details | |
| 43 | Table/Structure Field |
FEBKO - KTOIH | Bank account holder | |
| 44 | Table/Structure Field |
FEBKO - KTONR | Bank account number | |
| 45 | Table/Structure Field |
FEBKO - KTOPL | Chart of Accounts | |
| 46 | Table/Structure Field |
FEBKO - KUKEY | Short key (surrogate) | |
| 47 | Table/Structure Field |
FEBKO - SSBTR | Opening balance amount | |
| 48 | Table/Structure Field |
FEBKO - SSVOZ | Starting balance +/- sign | |
| 49 | Table/Structure Field |
FEBKO - SUMHA | Total Credit | |
| 50 | Table/Structure Field |
FEBKO - SUMSO | Total Debit | |
| 51 | Table/Structure Field |
FEBKO - VGTYP | Transaction type | |
| 52 | Table/Structure Field |
FEBKO - WAERS | Currency Key | |
| 53 | Table/Structure Field |
FEBRE - ESNUM | Memo record number (line item number in bank statement) | |
| 54 | Table/Structure Field |
FEBRE - KUKEY | Short key (surrogate) | |
| 55 | Table/Structure Field |
FEBRE - RSNUM | Copied record number | |
| 56 | Table/Structure Field |
FEBRE - VWEZW | Payment Notes | |
| 57 | Table/Structure Field |
FEBVW - ABSND | Sending bank (electronic bank statement) | |
| 58 | Table/Structure Field |
FEBVW - ANWND | Application using bank data storage | |
| 59 | Table/Structure Field |
FEBVW - AZIDT | Bank statement identification | |
| 60 | Table/Structure Field |
FEBVW - BANKA | Name of bank | |
| 61 | Table/Structure Field |
FEBVW - BANKL | Bank key (usually bank number) | |
| 62 | Table/Structure Field |
FJPDAT1_EB - BOKDT | Posting date (YY:Wareki) | |
| 63 | Table/Structure Field |
FJPDAT1_EB - CHKNO | Bill/check number | |
| 64 | Table/Structure Field |
FJPDAT1_EB - CPBBR | Counter party bank branch name | |
| 65 | Table/Structure Field |
FJPDAT1_EB - CPBNA | Counter party bank name | |
| 66 | Table/Structure Field |
FJPDAT1_EB - DECRP | Payment Notes | |
| 67 | Table/Structure Field |
FJPDAT1_EB - DMY21 | Dummy 21 bytes field | |
| 68 | Table/Structure Field |
FJPDAT1_EB - IDCHK | ID for bill/check | |
| 69 | Table/Structure Field |
FJPDAT1_EB - IDPAY | Payment ID (1:incoming, 2:outgoing) | |
| 70 | Table/Structure Field |
FJPDAT1_EB - IDTRA | Transaction ID | |
| 71 | Table/Structure Field |
FJPDAT1_EB - OFFDT | Write off date of securities (YY:Wareki) | |
| 72 | Table/Structure Field |
FJPDAT1_EB - PAYCD | Payer code | |
| 73 | Table/Structure Field |
FJPDAT1_EB - PAYNA | Name or no. (Payment ID - 1:name, 2:payer no.) | |
| 74 | Table/Structure Field |
FJPDAT1_EB - REFNO | Reference number at local bank | |
| 75 | Table/Structure Field |
FJPDAT1_EB - THAMT | Amount from other bank | |
| 76 | Table/Structure Field |
FJPDAT1_EB - TRAMT | Transaction amount | |
| 77 | Table/Structure Field |
FJPDAT1_EB - VALDT | Value date (YY:Wareki) | |
| 78 | Table/Structure Field |
FJPDAT2_EB - BOKDT | Posting date (YY:Wareki) | |
| 79 | Table/Structure Field |
FJPDAT2_EB - CPBBR | Counter party bank branch name | |
| 80 | Table/Structure Field |
FJPDAT2_EB - CPBNA | Counter party bank name | |
| 81 | Table/Structure Field |
FJPDAT2_EB - DMY48 | Dummy 48 bytes field | |
| 82 | Table/Structure Field |
FJPDAT2_EB - PAYCD | Payer code | |
| 83 | Table/Structure Field |
FJPDAT2_EB - PAYNA | Name or no. (Payment ID - 1:name, 2:payer no.) | |
| 84 | Table/Structure Field |
FJPDAT2_EB - RAMT2 | Payment amount (2) (amount > 9999999999) | |
| 85 | Table/Structure Field |
FJPDAT2_EB - REFNO | Reference number at local bank | |
| 86 | Table/Structure Field |
FJPDAT2_EB - REVID | Reverse ID (1: reverse) | |
| 87 | Table/Structure Field |
FJPDAT2_EB - TAMT2 | Amount from other bank (2) | |
| 88 | Table/Structure Field |
FJPDAT2_EB - THAMT | Amount from other bank | |
| 89 | Table/Structure Field |
FJPDAT2_EB - TRAMT | Payment amount (amount <= 9999999999) | |
| 90 | Table/Structure Field |
FJPDAT2_EB - VALDT | Value date (YY:Wareki) | |
| 91 | Table/Structure Field |
FJPHED1_EB - ACTNA | Account name (1 byte Katakana) | |
| 92 | Table/Structure Field |
FJPHED1_EB - ACTNO | Account number at the bank | |
| 93 | Table/Structure Field |
FJPHED1_EB - ACTYP | Account type (1:Futsu, 2:Touza, 4:Chochiku) | |
| 94 | Table/Structure Field |
FJPHED1_EB - BAKCD | House bank code | |
| 95 | Table/Structure Field |
FJPHED1_EB - BOKFR | Posting date from (YY:Wareki) | |
| 96 | Table/Structure Field |
FJPHED1_EB - BOKTO | Posting date to (YY:Wareki) | |
| 97 | Table/Structure Field |
FJPHED1_EB - BRACD | House bank branch code | |
| 98 | Table/Structure Field |
FJPHED1_EB - CAAMT | Opening Balance | |
| 99 | Table/Structure Field |
FJPHED1_EB - CABAL | Opening balance sign (1:Plus, 2:Minus) | |
| 100 | Table/Structure Field |
FJPHED1_EB - CRDAT | Create date (YY:Wareki, MM:Month, DD:Day) | |
| 101 | Table/Structure Field |
FJPHED1_EB - ITMCD | Item code (03:Incoming/outgoing trans.) | |
| 102 | Table/Structure Field |
FJPHED2_EB - ACTNA | Account name (1 byte Katakana) | |
| 103 | Table/Structure Field |
FJPHED2_EB - ACTNO | Account No. at The Bank for Japanese Bank Data | |
| 104 | Table/Structure Field |
FJPHED2_EB - ACTYP | Account type (1:Futsu, 2:Touza, 4:Chochiku) | |
| 105 | Table/Structure Field |
FJPHED2_EB - BAKCD | House bank code | |
| 106 | Table/Structure Field |
FJPHED2_EB - BOKFR | Posting date from (YY:Wareki) | |
| 107 | Table/Structure Field |
FJPHED2_EB - BOKTO | Posting date to (YY:Wareki) | |
| 108 | Table/Structure Field |
FJPHED2_EB - BRACD | House bank branch code | |
| 109 | Table/Structure Field |
FJPHED2_EB - CRDAT | Create date (YY:Wareki, MM:Month, DD:Day) | |
| 110 | Table/Structure Field |
FJPHED2_EB - ITMCD | Item code ('01':Incoming payment transfer) | |
| 111 | Table/Structure Field |
FJPTRL1_EB - CTAMT | Closing balance | |
| 112 | Table/Structure Field |
FJPTRL1_EB - DCFLG | Closing balance sign (+/-) | |
| 113 | Table/Structure Field |
FJPTRL1_EB - ITAMT | Total amount of incoming payment | |
| 114 | Table/Structure Field |
FJPTRL1_EB - NOREC | Number of data records | |
| 115 | Table/Structure Field |
FJPTRL1_EB - OTAMT | Total amount of outgoing payments | |
| 116 | Table/Structure Field |
FJPTRL2_EB - ITAMT | Total amount of incoming payment | |
| 117 | Table/Structure Field |
FJPTRL2_EB - NOICM | Total no. of incoming payment items | |
| 118 | Table/Structure Field |
FJPTRL2_EB - NOREV | Total no. of reversed incoming payments | |
| 119 | Table/Structure Field |
FJPTRL2_EB - RTAMT | Total amount of reversed incoming amount | |
| 120 | Table/Structure Field |
LDERA - LANG | Language ID | |
| 121 | Table/Structure Field |
LDERA - SHERA | Local date: local era (short name) | |
| 122 | Table/Structure Field |
LDERA - STDATE | Local date: Start date | |
| 123 | Table/Structure Field |
RLGRAP - FILENAME | Local file for upload/download | |
| 124 | Table/Structure Field |
SI_T012K - HKONT | General Ledger Account | |
| 125 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 126 | Table/Structure Field |
SYST - DBCNT | ABAP System Field: Edited Database Table Rows | |
| 127 | Table/Structure Field |
SYST - MSGV1 | ABAP System Field: Message Variable | |
| 128 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 129 | Table/Structure Field |
SYST - UNAME | ABAP System Field: Name of Current User | |
| 130 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server | |
| 131 | Table/Structure Field |
T001 - BUKRS | Company Code | |
| 132 | Table/Structure Field |
T001 - KTOPL | Chart of Accounts | |
| 133 | Table/Structure Field |
T001 - LAND1 | Country Key | |
| 134 | Table/Structure Field |
T012 - BANKL | Bank Keys | |
| 135 | Table/Structure Field |
T012 - BUKRS | Company Code | |
| 136 | Table/Structure Field |
T012 - HBKID | Short key for a house bank | |
| 137 | Table/Structure Field |
T012K - BANKN | Bank account number | |
| 138 | Table/Structure Field |
T012K - BKONT | Bank Control Key | |
| 139 | Table/Structure Field |
T012K - BNKN2 | Alternative Bank Acct Number (for Ambiguous Acct Number) | |
| 140 | Table/Structure Field |
T012K - BUKRS | Company Code | |
| 141 | Table/Structure Field |
T012K - HBKID | Short key for a house bank | |
| 142 | Table/Structure Field |
T012K - HKONT | General Ledger Account | |
| 143 | Table/Structure Field |
T012K - HKTID | ID for account details | |
| 144 | Table/Structure Field |
T012K - WAERS | Currency Key | |
| 145 | Table/Structure Field |
T028A - ASALD | Beginning Balance | |
| 146 | Table/Structure Field |
T028A - AZDAT | Statement Date | |
| 147 | Table/Structure Field |
T028A - AZNUM | Statement number | |
| 148 | Table/Structure Field |
T028A - BUKRS | Company Code | |
| 149 | Table/Structure Field |
T028A - ESALD | Closing balance | |
| 150 | Table/Structure Field |
T028A - HKONT | General Ledger Account | |
| 151 | Table/Structure Field |
T028A - JAHR | Bank statement year | |
| 152 | Table/Structure Field |
T028A - VADAT | Processing date | |
| 153 | Table/Structure Field |
T028A - VSTAT | Processing status | |
| 154 | Table/Structure Field |
T028A - WAERS | Currency Key | |
| 155 | Table/Structure Field |
T028B - BANKL | Bank key (usually bank number) | |
| 156 | Table/Structure Field |
T028B - KTONR | Bank account number | |
| 157 | Table/Structure Field |
T028B - VGTYP | Transaction type | |
| 158 | Table/Structure Field |
T028G - VGEXT | External business transaction | |
| 159 | Table/Structure Field |
T028G - VGTYP | Transaction type | |
| 160 | Table/Structure Field |
T028G - VOZPM | +/- sign of the incoming amount |
