SAP ABAP View U_12300 (Bank statement)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷
FIN-FSCM-CLM-CM (Application Component) Cash Management
⤷
U111 (Package) Cash Management
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | U_12300 | |
| Short Description | Bank statement | |
| Root table | FEBKO | Electronic Bank Statement Header Records |
| Entity Type | DM02L |
| Short text | Bank statement |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | FEBKO |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | ANWND | EQ | '0001' | 0 | 0 | |||||
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | ANWND | ANWND_EBKO | Application using bank data storage | |||||
| 3 | ABSND | ABSND_EB | Sending bank (electronic bank statement) | |||||
| 4 | AZIDT | AZIDT_EB | Bank statement identification | |||||
| 5 | EMKEY | EMKEY_EB | Payee Keys | |||||
| 6 | KUKEY | KUKEY_EB | Short key (surrogate) | |||||
| 7 | ASTAT | ASTAT_EB | Statement status | |||||
| 8 | DSTAT | DSTAT_EB | Print status | |||||
| 9 | VB1OK | VB1OK_EBKO | All postings in area 1 are OK | |||||
| 10 | VB2OK | VB2OK_EBKO | All postings in area 2 are OK | |||||
| 11 | KIPRE | KIPRE_EB | All items on header record were interpreted | |||||
| 12 | VFDAT | VFDAT_EB | Data expiry date | |||||
| 13 | GRP01 | GRP01_EB | Session name for bank postings | |||||
| 14 | XKEP1 | XKEP1_EB | Keep session 1 after processing | |||||
| 15 | GRP02 | GRP02_EB | Session name for subledger accounting | |||||
| 16 | XKEP2 | XKEP2_EB | Keep session 2 after processing | |||||
| 17 | WVDAT | WVDAT_EB | Further processing date | |||||
| 18 | WVTIM | WVTIM_EB | Further processing time | |||||
| 19 | WVART | WVART_EB | Further processing type | |||||
| 20 | HKONT | HKONT | General Ledger Account | |||||
| 21 | KTONR | BANKN | Bank account number | |||||
| 22 | KTOIH | KTOIH_EB | Bank account holder | |||||
| 23 | KTOSB | KTOSB_EB | Special account name | |||||
| 24 | AZNUM | AZNUM_EB | Statement number | |||||
| 25 | AZSNR | AZSNR_EB | Statement page number | |||||
| 26 | AZDAT | AZDAT_EB | Statement Date | |||||
| 27 | BUKRS | BUKRS | Company Code | |||||
| 28 | KTOPL | KTOPL | Chart of Accounts | |||||
| 29 | WAERS | WAERS | Currency Key | |||||
| 30 | SSTYP | SSTYP_EB | Beginning balance type (F=begin balance, M=interim balance) | |||||
| 31 | SSVOZ | SSVOZ_EB | Starting balance +/- sign | |||||
| 32 | SSBTR | SSBTR_EB | Opening balance amount | |||||
| 33 | SUMSO | SUMSO_EB | Total Debit | |||||
| 34 | SUMHA | SUMHA_EB | Total Credit | |||||
| 35 | ESTYP | ESTYP_EB | Ending balance type (F=ending balance, M=interim balance) | |||||
| 36 | ESVOZ | ESVOZ_EB | Closing balance +/- sign | |||||
| 37 | ESBTR | ESBTR_EB | Ending balance amount | |||||
| 38 | ESDMB | ESDMB_EB | Ending balance equivalent in local currency | |||||
| 39 | BLAUF | BLAUF_EB | Life start | |||||
| 40 | ELAUF | ELAUF_EB | Life end | |||||
| 41 | HZINS | HZINS_EB | Credit interest | |||||
| 42 | TEILN | TEILN_EB | Customer/vendor EB number | |||||
| 43 | BKTOA | BKTOA_EB | Bank account type | |||||
| 44 | ANZES | ANZES_EB | Number of memo records from the bank statement | |||||
| 45 | VGTYP | VGTYP_EB | Transaction type | |||||
| 46 | EFART | EFART_EB | Input Type | |||||
| 47 | HBKID | HBKID | Short key for a house bank | |||||
| 48 | HKTID | HKTID | ID for account details | |||||
| 49 | EUSER | EUSER_EB | User who fills the bank data buffer | |||||
| 50 | EDATE | EDATE_EB | Import date into bank data puffer | |||||
| 51 | ETIME | ETIME_EB | Import time into bank data buffer | |||||
| 52 | BKREF | BKREF | Reference specifications for bank details | |||||
| 53 | XFDIS | XFDIS_EB | X - cash management payment advice notes were created | |||||
| 54 | DSART | DSART | Planning type | |||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20040315 |
| SAP Release Created in |