Table/Structure Field list used by SAP ABAP Program J_1BBR30 (Electronic bank account statement: Import layout)
SAP ABAP Program 
J_1BBR30 (Electronic bank account statement: Import layout) is using
-
Data Element (12)
-
Table/Structure Field (197)
-
Function Module (6)
-
Message Class (2)
-
Message Number (12)
-
Program (4)
-
Table (17)
| # | 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 |
BSAK - BELNR | Accounting Document Number | |
| 5 | Table/Structure Field |
BSAK - BUKRS | Company Code | |
| 6 | Table/Structure Field |
BSAK - GJAHR | Fiscal Year | |
| 7 | Table/Structure Field |
BSEC - BELNR | Accounting Document Number | |
| 8 | Table/Structure Field |
BSEC - BUKRS | Company Code | |
| 9 | Table/Structure Field |
BSEC - GJAHR | Fiscal Year | |
| 10 | Table/Structure Field |
BSEC - STCD1 | Tax Number 1 | |
| 11 | Table/Structure Field |
BSEC - STCD2 | Tax Number 2 | |
| 12 | Table/Structure Field |
BSEC - STKZN | Natural Person | |
| 13 | Table/Structure Field |
BSEG - BELNR | Accounting Document Number | |
| 14 | Table/Structure Field |
BSEG - BUKRS | Company Code | |
| 15 | Table/Structure Field |
BSEG - GJAHR | Fiscal Year | |
| 16 | Table/Structure Field |
BSEG - KOART | Account type | |
| 17 | Table/Structure Field |
BSEG - LIFNR | Account Number of Vendor or Creditor | |
| 18 | Table/Structure Field |
BSEG - XCPDD | Indicator: Address and Bank Data Set Individually | |
| 19 | Table/Structure Field |
BSID - ANFBJ | Fiscal Year of the Bill of Exchange Payment Request Document | |
| 20 | Table/Structure Field |
BSID - ANFBN | Document Number of the Bill of Exchange Payment Request | |
| 21 | Table/Structure Field |
BSID - ANFBU | Company Code in Which Bill of Exch.Payment Request Is Posted | |
| 22 | Table/Structure Field |
BSID - BELNR | Accounting Document Number | |
| 23 | Table/Structure Field |
BSID - BUKRS | Company Code | |
| 24 | Table/Structure Field |
BSID - BUZEI | Number of Line Item Within Accounting Document | |
| 25 | Table/Structure Field |
BSID - GJAHR | Fiscal Year | |
| 26 | Table/Structure Field |
BSID - KUNNR | Customer Number | |
| 27 | Table/Structure Field |
BSID - XBLNR | Reference Document Number | |
| 28 | Table/Structure Field |
BSIK - BELNR | Accounting Document Number | |
| 29 | Table/Structure Field |
BSIK - BSTAT | Document Status | |
| 30 | Table/Structure Field |
BSIK - BUKRS | Company Code | |
| 31 | Table/Structure Field |
BSIK - GJAHR | Fiscal Year | |
| 32 | Table/Structure Field |
BSIK - XBLNR | Reference Document Number | |
| 33 | Table/Structure Field |
FEBEP - AVKOA | Payment Advice Account Type | |
| 34 | Table/Structure Field |
FEBEP - BELNR | Accounting Document Number | |
| 35 | Table/Structure Field |
FEBEP - BUDAT | Posting date in the document | |
| 36 | Table/Structure Field |
FEBEP - BVDAT | Posting date at the bank | |
| 37 | Table/Structure Field |
FEBEP - CHECT | Check number | |
| 38 | Table/Structure Field |
FEBEP - EPVOZ | Debit/credit key for line items (for bank purposes) | |
| 39 | Table/Structure Field |
FEBEP - ESNUM | Memo record number (line item number in bank statement) | |
| 40 | Table/Structure Field |
FEBEP - GJAHR | Fiscal Year | |
| 41 | Table/Structure Field |
FEBEP - KFMOD | Account modification | |
| 42 | Table/Structure Field |
FEBEP - KIDNO | Payment Reference | |
| 43 | Table/Structure Field |
FEBEP - KUKEY | Short key (surrogate) | |
| 44 | Table/Structure Field |
FEBEP - KWAER | Account Currency Key | |
| 45 | Table/Structure Field |
FEBEP - KWBTR | Amount in account currency | |
| 46 | Table/Structure Field |
FEBEP - PABLZ | Bank number of partner bank | |
| 47 | Table/Structure Field |
FEBEP - PAKTO | Account number at the partner bank | |
| 48 | Table/Structure Field |
FEBEP - PARTN | Business Partner | |
| 49 | Table/Structure Field |
FEBEP - VALUT | Value date of the item to be cleared | |
| 50 | Table/Structure Field |
FEBEP - VB2BA | 2nd update processed | |
| 51 | Table/Structure Field |
FEBEP - VGEXT | External business transaction | |
| 52 | Table/Structure Field |
FEBEP - XBLNR | Reference Document Number | |
| 53 | Table/Structure Field |
FEBEP - ZUONR | Assignment number | |
| 54 | Table/Structure Field |
FEBKO - ABSND | Sending bank (electronic bank statement) | |
| 55 | Table/Structure Field |
FEBKO - ANWND | Application using bank data storage | |
| 56 | Table/Structure Field |
FEBKO - AZDAT | Statement Date | |
| 57 | Table/Structure Field |
FEBKO - AZIDT | Bank statement identification | |
| 58 | Table/Structure Field |
FEBKO - AZNUM | Statement number | |
| 59 | Table/Structure Field |
FEBKO - BUKRS | Company Code | |
| 60 | Table/Structure Field |
FEBKO - EDATE | Import date into bank data puffer | |
| 61 | Table/Structure Field |
FEBKO - EFART | Input Type | |
| 62 | Table/Structure Field |
FEBKO - EMKEY | Payee Keys | |
| 63 | Table/Structure Field |
FEBKO - ESBTR | Ending balance amount | |
| 64 | Table/Structure Field |
FEBKO - ESVOZ | Closing balance +/- sign | |
| 65 | Table/Structure Field |
FEBKO - ETIME | Import time into bank data buffer | |
| 66 | Table/Structure Field |
FEBKO - EUSER | User who fills the bank data buffer | |
| 67 | Table/Structure Field |
FEBKO - HBKID | Short key for a house bank | |
| 68 | Table/Structure Field |
FEBKO - HKONT | General Ledger Account | |
| 69 | Table/Structure Field |
FEBKO - HKTID | ID for account details | |
| 70 | Table/Structure Field |
FEBKO - KTONR | Bank account number | |
| 71 | Table/Structure Field |
FEBKO - KUKEY | Short key (surrogate) | |
| 72 | Table/Structure Field |
FEBKO - SSBTR | Opening balance amount | |
| 73 | Table/Structure Field |
FEBKO - SSVOZ | Starting balance +/- sign | |
| 74 | Table/Structure Field |
FEBKO - SUMHA | Total Credit | |
| 75 | Table/Structure Field |
FEBKO - SUMSO | Total Debit | |
| 76 | Table/Structure Field |
FEBKO - VGTYP | Transaction type | |
| 77 | Table/Structure Field |
FEBKO - WAERS | Currency Key | |
| 78 | Table/Structure Field |
FEBVW - ABSND | Sending bank (electronic bank statement) | |
| 79 | Table/Structure Field |
FEBVW - ANWND | Application using bank data storage | |
| 80 | Table/Structure Field |
FEBVW - AZIDT | Bank statement identification | |
| 81 | Table/Structure Field |
FEBVW - BANKA | Name of bank | |
| 82 | Table/Structure Field |
FEBVW - BANKL | Bank key (usually bank number) | |
| 83 | Table/Structure Field |
J_1BDMEAA - A02 | Vendor: CPF '1' or CNPJ '' ? | |
| 84 | Table/Structure Field |
J_1BDMEAA - A03 | CPF or CNPJ | |
| 85 | Table/Structure Field |
J_1BDMEAA - A04 | Partner name | |
| 86 | Table/Structure Field |
J_1BDMEAA - A08 | Vendor bank, first three digits | |
| 87 | Table/Structure Field |
J_1BDMEAA - A09 | Vendor bank key w/o control digit | |
| 88 | Table/Structure Field |
J_1BDMEAA - A11 | Vendor account number without w/o contol digit | |
| 89 | Table/Structure Field |
J_1BDMEAA - A13 | Numero Pagato, filled with Bradesco boleto number | |
| 90 | Table/Structure Field |
J_1BDMEAA - A14 | Sufix of numero pagato, retorno | |
| 91 | Table/Structure Field |
J_1BDMEAA - A15 | ano nosso numero, retorno | |
| 92 | Table/Structure Field |
J_1BDMEAA - A16 | Nossu numero, retorno | |
| 93 | Table/Structure Field |
J_1BDMEAA - A17 | Seu numero | |
| 94 | Table/Structure Field |
J_1BDMEAA - A18 | due date | |
| 95 | Table/Structure Field |
J_1BDMEAA - A19 | Emission date of document | |
| 96 | Table/Structure Field |
J_1BDMEAA - A21 | Nominal value | |
| 97 | Table/Structure Field |
J_1BDMEAA - A22 | Amount in Reais | |
| 98 | Table/Structure Field |
J_1BDMEAA - A25 | Document type, 01 = NFF, 02 = Fatura, .... | |
| 99 | Table/Structure Field |
J_1BDMEAA - A28 | Payment form, can be '1,2,3,10,30,31' | |
| 100 | Table/Structure Field |
J_1BDMEAA - A29 | Value date | |
| 101 | Table/Structure Field |
J_1BDMEAA - A31 | Return code, character | |
| 102 | Table/Structure Field |
J_1BDMEAA - A32 | Error codes | |
| 103 | Table/Structure Field |
J_1BDMEAA - A38 | 1 blank | |
| 104 | Table/Structure Field |
J_1BDMEAA - A39 | Additional info | |
| 105 | Table/Structure Field |
J_1BDMEAH - H01 | record type, e.g. '0' for the header | |
| 106 | Table/Structure Field |
J_1BDMEAH - H02 | Company number at bank | |
| 107 | Table/Structure Field |
J_1BDMEAH - H06 | Service type, fixed '20' for the time being | |
| 108 | Table/Structure Field |
J_1BDMEAH - H07 | sending ('1') or receiving ('2') ? | |
| 109 | Table/Structure Field |
J_1BDMEAH - H09 | File Number (Internal or External) | |
| 110 | Table/Structure Field |
J_1BDMEAH - H10 | File creation date | |
| 111 | Table/Structure Field |
J_1BDMEAH - H11 | Time of file generation | |
| 112 | Table/Structure Field |
J_1BDMEAH - H15 | Processing type, not used | |
| 113 | Table/Structure Field |
J_1BDMEAT - T03 | Total of payments | |
| 114 | Table/Structure Field |
J_1BELBYA - A06 | Field is used for identifying open items (year, cust., doc.) | |
| 115 | Table/Structure Field |
J_1BELBYA - A07 | Nosso Numero | |
| 116 | Table/Structure Field |
J_1BELBYA - A08 | 12 blanks | |
| 117 | Table/Structure Field |
J_1BELBYA - A09 | Carteira | |
| 118 | Table/Structure Field |
J_1BELBYA - A13 | Carteira Code | |
| 119 | Table/Structure Field |
J_1BELBYA - A14 | return code from bank | |
| 120 | Table/Structure Field |
J_1BELBYA - A15 | Date when processed at bank | |
| 121 | Table/Structure Field |
J_1BELBYA - A16 | Duplicata Number | |
| 122 | Table/Structure Field |
J_1BELBYA - A19 | Due date | |
| 123 | Table/Structure Field |
J_1BELBYA - A20 | Nominal value in Reais | |
| 124 | Table/Structure Field |
J_1BELBYA - A22 | Agencia Cobradora | |
| 125 | Table/Structure Field |
J_1BELBYA - A23 | Control digit for 'Agencia Cobradora' | |
| 126 | Table/Structure Field |
J_1BELBYA - A25 | Bank charge | |
| 127 | Table/Structure Field |
J_1BELBYA - A28 | Rebate | |
| 128 | Table/Structure Field |
J_1BELBYA - A29 | Discount | |
| 129 | Table/Structure Field |
J_1BELBYA - A30 | Paid amount | |
| 130 | Table/Structure Field |
J_1BELBYA - A31 | Interests + Fees from customer | |
| 131 | Table/Structure Field |
J_1BELBYA - A32B | Present Liquidating credit date | |
| 132 | Table/Structure Field |
J_1BELBYA - A35 | Error code | |
| 133 | Table/Structure Field |
J_1BELBYA - A37 | Record number in file, '000001' for Header | |
| 134 | Table/Structure Field |
J_1BELBYH - H02 | 1 for Remessa and 2 for Retorno | |
| 135 | Table/Structure Field |
J_1BELBYH - H04 | '01' for Itau and Bradesco | |
| 136 | Table/Structure Field |
J_1BELBYH - H06 | Combination of Bank number, bank account and control digit | |
| 137 | Table/Structure Field |
J_1BELBYH - H07 | 8 blanks | |
| 138 | Table/Structure Field |
J_1BELBYH - H08 | Our company name | |
| 139 | Table/Structure Field |
J_1BELBYH - H09 | House bank group code (e.g. 341 for Itau) | |
| 140 | Table/Structure Field |
J_1BELBYH - H11 | File generation date | |
| 141 | Table/Structure Field |
J_1BELBZA - A05 | Carteira, agency and account | |
| 142 | Table/Structure Field |
J_1BELBZA - A06 | Field is used for identifying open items (year, cust., doc.) | |
| 143 | Table/Structure Field |
J_1BELBZA - A08 | Bank duplicata number ('nosso numero'), zero when sending | |
| 144 | Table/Structure Field |
J_1BELBZA - A11 | return code from bank | |
| 145 | Table/Structure Field |
J_1BELBZA - A12 | Date when processed at bank | |
| 146 | Table/Structure Field |
J_1BELBZA - A13 | Duplicata Number | |
| 147 | Table/Structure Field |
J_1BELBZA - A15 | Due date | |
| 148 | Table/Structure Field |
J_1BELBZA - A16 | Nominal value in Reais | |
| 149 | Table/Structure Field |
J_1BELBZA - A18 | (Agencia depositaria) | |
| 150 | Table/Structure Field |
J_1BELBZA - A20 | Bank charge | |
| 151 | Table/Structure Field |
J_1BELBZA - A21 | Bank charge | |
| 152 | Table/Structure Field |
J_1BELBZA - A24 | Rebate | |
| 153 | Table/Structure Field |
J_1BELBZA - A25 | Discount | |
| 154 | Table/Structure Field |
J_1BELBZA - A26 | Paid amount | |
| 155 | Table/Structure Field |
J_1BELBZA - A27 | Interests + Fees from customer | |
| 156 | Table/Structure Field |
J_1BELBZA - A31 | Date when processed at bank | |
| 157 | Table/Structure Field |
J_1BELBZA - A33 | Error codes | |
| 158 | Table/Structure Field |
J_1BELBZA - A35 | Record number in file, '000001' for Header | |
| 159 | Table/Structure Field |
J_1BELBZT - T07 | Total value of items in file | |
| 160 | Table/Structure Field |
J_1BELBZT - T08 | returning file number | |
| 161 | Table/Structure Field |
LFA1 - LIFNR | Account Number of Vendor or Creditor | |
| 162 | Table/Structure Field |
LFA1 - LNRZA | Account Number of the Alternative Payee | |
| 163 | Table/Structure Field |
LFA1 - STCD1 | Tax Number 1 | |
| 164 | Table/Structure Field |
LFA1 - STCD2 | Tax Number 2 | |
| 165 | Table/Structure Field |
LFA1 - STKZN | Natural Person | |
| 166 | Table/Structure Field |
RLGRAP - FILENAME | Local file for upload/download | |
| 167 | Table/Structure Field |
SI_LFA1 - LNRZA | Account Number of the Alternative Payee | |
| 168 | Table/Structure Field |
SI_LFA1 - STCD1 | Tax Number 1 | |
| 169 | Table/Structure Field |
SI_LFA1 - STCD2 | Tax Number 2 | |
| 170 | Table/Structure Field |
SI_LFA1 - STKZN | Natural Person | |
| 171 | Table/Structure Field |
SI_T012K - HKONT | General Ledger Account | |
| 172 | Table/Structure Field |
SYST - DATUM | ABAP System Field: Current Date of Application Server | |
| 173 | Table/Structure Field |
SYST - TABIX | ABAP System Field: Row Index of Internal Tables | |
| 174 | Table/Structure Field |
SYST - UNAME | ABAP System Field: Name of Current User | |
| 175 | Table/Structure Field |
SYST - UZEIT | ABAP System Field: Current Time of Application Server | |
| 176 | Table/Structure Field |
T001 - BUKRS | Company Code | |
| 177 | Table/Structure Field |
T001 - LAND1 | Country Key | |
| 178 | Table/Structure Field |
T012 - BANKL | Bank Keys | |
| 179 | Table/Structure Field |
T012 - BUKRS | Company Code | |
| 180 | Table/Structure Field |
T012 - HBKID | Short key for a house bank | |
| 181 | Table/Structure Field |
T012K - BANKN | Bank account number | |
| 182 | Table/Structure Field |
T012K - BUKRS | Company Code | |
| 183 | Table/Structure Field |
T012K - HBKID | Short key for a house bank | |
| 184 | Table/Structure Field |
T012K - HKONT | General Ledger Account | |
| 185 | Table/Structure Field |
T012K - HKTID | ID for account details | |
| 186 | Table/Structure Field |
T012K - WAERS | Currency Key | |
| 187 | Table/Structure Field |
T028A - AZNUM | Statement number | |
| 188 | Table/Structure Field |
T028A - BUKRS | Company Code | |
| 189 | Table/Structure Field |
T028A - HKONT | General Ledger Account | |
| 190 | Table/Structure Field |
T028A - JAHR | Bank statement year | |
| 191 | Table/Structure Field |
T028B - BANKL | Bank key (usually bank number) | |
| 192 | Table/Structure Field |
T028B - KTONR | Bank account number | |
| 193 | Table/Structure Field |
T028B - VGTYP | Transaction type | |
| 194 | Table/Structure Field |
T045T - BUKRS | Company Code | |
| 195 | Table/Structure Field |
T045T - DTAID | User ID for DME | |
| 196 | Table/Structure Field |
T045T - HBKID | Short key for a house bank | |
| 197 | Table/Structure Field |
T045T - HKTID | ID for account details |
