SAP ABAP Table U_12398 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_12398	Table Relationship Diagram
Short Description	Generated Table for View

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	KUKEY	☑	KUKEY_EB	KUKEY_EB	NUMC	8	0	Short key (surrogate)
3	ESNUM	☑	ESNUM_EB	NUM5	NUMC	5	0	Memo record number (line item number in bank statement)
4	EPERL	☐	EPERL_EB	CHAR1	CHAR	1	0	Line item completed
5	VB1OK	☐	VB1OK_EB	CHAR1	CHAR	1	0	Update 1 OK
6	VB2BA	☐	VB2BA_EB	CHAR1	CHAR	1	0	2nd update processed
7	VB2OK	☐	VB2OK_EB	CHAR1	CHAR	1	0	2nd update OK
8	PIPRE	☐	PIPRE_EB	CHAR1	CHAR	1	0	Line items were interpreted
9	GRPNR	☐	GRPNR_EB	CHAR2	CHAR	2	0	Bundle number for grouping line items
10	ESTAT	☐	ESTAT_EB	CHAR4	CHAR	4	0	Error status
11	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
13	BVDAT	☐	BVDAT_EB	DATE_EB	DATS	8	0	Posting date at the bank
14	BUDAT	☐	BUDAT_EB	DATE_EB	DATS	8	0	Posting date in the document
15	VALUT	☐	VALUT_EB	DATE_EB	DATS	8	0	Value date of the item to be cleared
16	BUTIM	☐	BUTIM_EB	TIME6	CHAR	6	0	Value date time
17	VOZEI	☐	VOZEI_EB	CHAR2	CHAR	2	0	do not use-> now EPVOZ_EP signs (C,RC,D,RD)
18	KWAER	☐	KWAER_EB	WAERS	CUKY	5	0	Account Currency Key
19	KWBTR	☐	KWBTR_EB	WRTV7	CURR	13	2	Amount in account currency
20	SPESK	☐	SPESK_EB	WERT7	CURR	13	2	Fees in account currency
21	FWAER	☐	FWAER_EB	WAERS	CUKY	5	0	Foreign currency key (unequal to account currency)	TCURC
22	FWBTR	☐	FWBTR_EB	WRTV7	CURR	13	2	Foreign currency amount (different from account cuurency)
23	SPESF	☐	SPESF_EB	WERT7	CURR	13	2	Fees in foreign currency (not same as account currency)
24	VORGC	☐	VORGC_EB	CHAR3	CHAR	3	0	Business transaction code
25	TEXTS	☐	TEXTS_EB	CHAR4	CHAR	4	0	Text key
26	VGEXT	☐	VGEXT_EB	VGEXT_EB	CHAR	27	0	External business transaction
27	VGMAN	☐	VGMAN_EB	VGMAN_EB	CHAR	4	0	Transaction
28	VGINT	☐	VGINT_EB	VGINT_EB	CHAR	4	0	Posting rule	T028D
29	KFMOD	☐	KFMOD_EB	KFMOD_EB	CHAR	10	0	Account modification
30	VGSAP	☐	VGSAP_EB	CHAR4	CHAR	4	0	SAP bank transaction
31	BUTXT	☐	BUTXT_EB	CHAR50	CHAR	50	0	Bank posting text
32	ANZSP	☐	ANZSP_EB	NUM5	NUMC	5	0	Number of collective items
33	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
34	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
35	PABKS	☐	PABKS_EB	LAND1	CHAR	3	0	Country key of partner bank	T005
36	PABLZ	☐	PABLZ_EB	BANKK	CHAR	15	0	Bank number of partner bank
37	PASWI	☐	PASWI_EB	SWIFT	CHAR	11	0	SWIFT code of partner bank
38	PAKTO	☐	PAKTO_EB	BANKN	CHAR	18	0	Account number at the partner bank
39	PARTN	☐	PARTN_EB	CHAR55	CHAR	55	0	Business Partner
40	BUSAB	☐	BUSAB_EB	CHAR2	CHAR	2	0	Accounting Clerk
41	KOSTL	☐	KOSTL_EB	CHAR10	CHAR	10	0	Cost center
42	GSBER	☐	GSBER_EB	CHAR4	CHAR	4	0	Business area
43	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center
44	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
45	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
46	PNOTA	☐	PNOTA_EB	CHAR10	CHAR	10	0	Daybook number
47	CHECT	☐	CHECT	CHCKN	CHAR	13	0	Check number
48	STAVV	☐	STAVV_EB	CHAR2	CHAR	2	0	Financial Assets Management status
49	TXTVV	☐	TXTVV_EB	CHAR40	CHAR	40	0	Financial Assets Management Information Field
50	EPVOZ	☐	EPVOZ_EB	CHAR1	CHAR	1	0	Debit/credit key for line items (for bank purposes)
51	INFO1	☐	INFO1_EB	CHAR30	CHAR	30	0	Additional information 1
52	INFO2	☐	INFO2_EB	CHAR30	CHAR	30	0	Additional information 2
53	AVSID	☐	AVSID	AVSID	CHAR	16	0	Payment Advice Number
54	INTAG	☐	INTAG_EB	INTAG_EB	NUMC	3	0	Interpretation algorithm
55	NBBLN	☐	NBBLN_EB	BELNR	CHAR	10	0	Subledger document number
56	AKBLN	☐	AKBLN_EB	BELNR	CHAR	10	0	Payment on account document number
57	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer
58	AVKOA	☐	KOART_AV	KOART_AV	CHAR	1	0	Payment Advice Account Type
59	AVKON	☐	KTONR_AV	KTONR	CHAR	10	0	Account Number
60	BATCH	☐	BATCH_EB	CHAR3	CHAR	3	0	Batch number (bundle number)
61	KURSF	☐	KURSF_EB	KURSF	DEC	9	5	Exchange rate (different from local currency)
62	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
63	JPDAT	☐	JPDAT_EB	DATE_EB	DATS	8	0	Date of failed bills of exchange in Japan
64	POSAG	☐	POSAG_EB	CHAR3	CHAR	3	0	Posting algorithm (lockbox only)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_12398	FWAER	TCURC	WAERS	REF	1	CN
2	U_12398	MANDT	T000	MANDT	KEY	1	CN
3	U_12398	PABKS	T005	LAND1	REF	1	CN
4	U_12398	VGINT	T028D	VGINT

History

Last changed by/on	SAP	20130529
SAP Release Created in