SAP ABAP Table U_12300 (Generated Table for View U_12300)
Basic Data
Table Category | VIEW | General view structure |
General view structure | U_12300 | Table Relationship Diagram |
Short Description | Generated Table for View U_12300 |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ANWND | ANWND_EBKO | ANWND_EBKO | CHAR | 4 | 0 | Application using bank data storage | ||
3 | ABSND | ABSND_EB | CHAR50 | CHAR | 50 | 0 | Sending bank (electronic bank statement) | ||
4 | AZIDT | AZIDT_EB | CHAR20 | CHAR | 20 | 0 | Bank statement identification | ||
5 | EMKEY | EMKEY_EB | CHAR20 | CHAR | 20 | 0 | Payee Keys | ||
6 | KUKEY | KUKEY_EB | KUKEY_EB | NUMC | 8 | 0 | Short key (surrogate) | ||
7 | ASTAT | ASTAT_EB | CHAR1 | CHAR | 1 | 0 | Statement status | ||
8 | DSTAT | DSTAT_EB | CHAR1 | CHAR | 1 | 0 | Print status | ||
9 | VB1OK | VB1OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 1 are OK | ||
10 | VB2OK | VB2OK_EBKO | CHAR1 | CHAR | 1 | 0 | All postings in area 2 are OK | ||
11 | KIPRE | KIPRE_EB | CHAR1 | CHAR | 1 | 0 | All items on header record were interpreted | ||
12 | VFDAT | VFDAT_EB | DATUM | DATS | 8 | 0 | Data expiry date | ||
13 | GRP01 | GRP01_EB | CHAR12 | CHAR | 12 | 0 | Session name for bank postings | ||
14 | XKEP1 | XKEP1_EB | CHAR1 | CHAR | 1 | 0 | Keep session 1 after processing | ||
15 | GRP02 | GRP02_EB | CHAR12 | CHAR | 12 | 0 | Session name for subledger accounting | ||
16 | XKEP2 | XKEP2_EB | CHAR1 | CHAR | 1 | 0 | Keep session 2 after processing | ||
17 | WVDAT | WVDAT_EB | DATUM | DATS | 8 | 0 | Further processing date | ||
18 | WVTIM | WVTIM_EB | TIMES | TIMS | 6 | 0 | Further processing time | ||
19 | WVART | WVART_EB | CHAR1 | CHAR | 1 | 0 | Further processing type | ||
20 | HKONT | HKONT | SAKNR | CHAR | 10 | 0 | General Ledger Account | SKB1 | |
21 | KTONR | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
22 | KTOIH | KTOIH_EB | CHAR35 | CHAR | 35 | 0 | Bank account holder | ||
23 | KTOSB | KTOSB_EB | CHAR35 | CHAR | 35 | 0 | Special account name | ||
24 | AZNUM | AZNUM_EB | NUM5 | NUMC | 5 | 0 | Statement number | ||
25 | AZSNR | AZSNR_EB | NUM3 | NUMC | 3 | 0 | Statement page number | ||
26 | AZDAT | AZDAT_EB | DATE_EB | DATS | 8 | 0 | Statement Date | ||
27 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
28 | KTOPL | KTOPL | KTOPL | CHAR | 4 | 0 | Chart of Accounts | T004 | |
29 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
30 | SSTYP | SSTYP_EB | CHAR1 | CHAR | 1 | 0 | Beginning balance type (F=begin balance, M=interim balance) | ||
31 | SSVOZ | SSVOZ_EB | CHAR1 | CHAR | 1 | 0 | Starting balance +/- sign | ||
32 | SSBTR | SSBTR_EB | WERT9 | CURR | 17 | 2 | Opening balance amount | ||
33 | SUMSO | SUMSO_EB | WERT9 | CURR | 17 | 2 | Total Debit | ||
34 | SUMHA | SUMHA_EB | WERT9 | CURR | 17 | 2 | Total Credit | ||
35 | ESTYP | ESTYP_EB | CHAR1 | CHAR | 1 | 0 | Ending balance type (F=ending balance, M=interim balance) | ||
36 | ESVOZ | ESVOZ_EB | CHAR1 | CHAR | 1 | 0 | Closing balance +/- sign | ||
37 | ESBTR | ESBTR_EB | WERT9 | CURR | 17 | 2 | Ending balance amount | ||
38 | ESDMB | ESDMB_EB | WERT9 | CURR | 17 | 2 | Ending balance equivalent in local currency | ||
39 | BLAUF | BLAUF_EB | DATUM | DATS | 8 | 0 | Life start | ||
40 | ELAUF | ELAUF_EB | DATUM | DATS | 8 | 0 | Life end | ||
41 | HZINS | HZINS_EB | HZINS_EB | DEC | 9 | 3 | Credit interest | ||
42 | TEILN | TEILN_EB | CHAR20 | CHAR | 20 | 0 | Customer/vendor EB number | ||
43 | BKTOA | BKTOA_EB | CHAR23 | CHAR | 23 | 0 | Bank account type | ||
44 | ANZES | ANZES_EB | NUM5 | NUMC | 5 | 0 | Number of memo records from the bank statement | ||
45 | VGTYP | VGTYP_EB | VGTYP_EB | CHAR | 8 | 0 | Transaction type | ||
46 | EFART | EFART_EB | CHAR1 | CHAR | 1 | 0 | Input Type | ||
47 | HBKID | HBKID | HBKID | CHAR | 5 | 0 | Short key for a house bank | ||
48 | HKTID | HKTID | HKTID | CHAR | 5 | 0 | ID for account details | ||
49 | EUSER | EUSER_EB | CHAR12 | CHAR | 12 | 0 | User who fills the bank data buffer | ||
50 | EDATE | EDATE_EB | DATUM | DATS | 8 | 0 | Import date into bank data puffer | ||
51 | ETIME | ETIME_EB | UZEIT | TIMS | 6 | 0 | Import time into bank data buffer | ||
52 | BKREF | BKREF | CHAR20 | CHAR | 20 | 0 | Reference specifications for bank details | ||
53 | XFDIS | XFDIS_EB | XFELD | CHAR | 1 | 0 | X - cash management payment advice notes were created | ||
54 | DSART | DSART | DSART | CHAR | 2 | 0 | Planning type |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | U_12300 | BUKRS | T001 | BUKRS | REF | 1 | CN |
2 | U_12300 | HKONT | SKB1 | SAKNR | REF | 1 | CN |
3 | U_12300 | KTOPL | T004 | KTOPL | REF | 1 | CN |
4 | U_12300 | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | U_12300 | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20040315 |
SAP Release Created in |