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