SAP ABAP Table RE31B (Structure: Transaction EK05)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CA (Application Component) Contract Accounts Receivable and Payable
     ⤷ EE30 (Package) IS-U: Contract Accounts Receivable and Payable

Basic Data

Table Category	INTTAB	Structure
Structure	RE31B	Table Relationship Diagram
Short Description	Structure: Transaction EK05

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	*
2	BLART	☐	BLART_KK	BLART_KK	CHAR	2	0	Document Type	TFK003
3	FKEYS	☐	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger	DFKKSUMC
4	FIKEY	☐	FIKEY_KK	FIKEY_KK	CHAR	12	0	Reconciliation Key for General Ledger	DFKKSUMC
5	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
6	BUDAT	☐	BUDAT_KK	DATUM	DATS	8	0	Posting Date in the Document
7	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
8	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
11	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
12	BVRKO	☐	BVRKO_KK	SAKNR	CHAR	10	0	Bank clearing account	TFK012
13	HKONT	☐	HKONT_KK	SAKNR	CHAR	10	0	General ledger account	TFK012
14	AUGRD	☐	AUGRD_KK	AUGRD_KK	CHAR	2	0	Clearing Reason	TFK001A
15	OPBEL	☐	OPBEL_KK	OPBEL_KK	CHAR	12	0	Number of Contract Accts Rec. & Payable Doc.	*
16	GPART	☐	GPART_KK	BU_PARTNER	CHAR	10	0	Business Partner Number	BUT000
17	VTREF	☐	VTREF_KK	VTREF_KK	CHAR	20	0	Reference Specifications from Contract
18	VKONT	☐	VKONT_KK	VKONT_KK	CHAR	12	0	Contract Account Number	FKKVK
19	BANKL	☐	BANKL	BANKL	CHAR	15	0	Bank number
20	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
21	XBLNS	☐	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
22	XBLNR	☐	XBLNR_KK	XBLNR_KK	CHAR	16	0	Reference document number
23	TXTVW	☐	TXTVW_KK	CHAR80	CHAR	80	0	Note to Payee in Payment
24	KOINH	☐	KOINH_KK	KOINH	CHAR	60	0	Name of Holder of Bank Account/Check Issuer/Cardholder
25	BKONT	☐	BKONT	BKONT	CHAR	2	0	Bank Control Key
26	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
27	XPGRO	☐	XPGRO	XFELD	CHAR	1	0	Post Office Bank Current Account
28	SPART	☐	SPART_KK	SPART	CHAR	2	0	Division	TSPA
29	CHQKZ	☐	CHQKZ_KK	XFELD	CHAR	1	0	Check Payment
30	BETAK	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
31	BETAU	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
32	BETSP	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
33	BETRC	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
34	BETRW	☐	BETRW_KK	WRTV7	CURR	13	2	Amount in Transaction Currency with +/- Sign
35	AZEI1	☐	AZEIL	TEXT79	CHAR	79	0	Line Item Displayed on the Screen
36	XAKON	☐	XAKON_KK	XFELD	CHAR	1	0	Post Payment on Account
37	FAEDN	☐	FAEDN_KK	DATUM	DATS	8	0	Due date for net payment
38	XAUZA	☐	XAUZA_KK	XFELD	CHAR	1	0	Payment
39	XEIZA	☐	XEIZA_KK	XFELD	CHAR	1	0	Incoming Payment
40	NRZAS	☐	NRZAS_KK	NRZAS_KK	CHAR	12	0	Payment Form Number
41	AAUSZ	☐	AAUSZ_KK	XFELD	CHAR	1	0	Pay
42	ALEST	☐	ALEST_KK	XFELD	CHAR	1	0	Stock Savings Plan
43	AAKTO	☐	AAKTO_KK	XFELD	CHAR	1	0	Activity: Pay on Account
44	KEYZ1	☐	KEYZ1_KK	KEYZ1_KK	CHAR	12	0	Payment Lot
45	POST	☐	POST_KK	XFELD	CHAR	1	0	Released item for posting
46	HERKF	☐	HERKF_KK	HERKF_KK	CHAR	2	0	Document Origin Key	*
47	RECPT	☐	E_RECPT	BU_PARTNER	CHAR	10	0	Business Partner That is to Receive the Amount	TE016
48	INTVL	☐	INTVL_KK	INTVL_KK	DEC	3	0	Cash Desk/Cash Journal: Value Date Move on Check Payment
49	HKONA	☐	HKONA_KK	SAKNR	CHAR	10	0	Expense account	SKA1
50	HKONE	☐	HKONE_KK	SAKNR	CHAR	10	0	Revenue Account	SKA1
51	SELT1	☐	SELTX_KK	SELTX_KK	CHAR	1	0	Selection Category	*
52	SELT2	☐	SELTX_KK	SELTX_KK	CHAR	1	0	Selection Category	*
53	SELT3	☐	SELTX_KK	SELTX_KK	CHAR	1	0	Selection Category	*
54	SELW1	☐	SELWC_KK	CHAR35	CHAR	35	0	Field value to be selected
55	SELW2	☐	SELWC_KK	CHAR35	CHAR	35	0	Field value to be selected
56	SELW3	☐	SELWC_KK	CHAR35	CHAR	35	0	Field value to be selected
57	TXT301	☐	TXT30	TEXT30	CHAR	30	0	Text
58	TXT302	☐	TXT30	TEXT30	CHAR	30	0	Text
59	TXT303	☐	TXT30	TEXT30	CHAR	30	0	Text

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RE31B	AUGRD	TFK001A	AUGRD		1	CN
2	RE31B	BANKS	T005	LAND1		1	CN
3	RE31B	BLART	TFK003	BLART		1	CN
4	RE31B	BUKRS	T001	BUKRS		1	CN
5	RE31B	BVRKO	TFK012	BVRKO		1	N
6	RE31B	FIKEY	DFKKSUMC	FIKEY		1	CN
7	RE31B	FKEYS	DFKKSUMC	FIKEY		1	CN
8	RE31B	GPART	BUT000	PARTNER		1	N
9	RE31B	GSBER	TGSB	GSBER		1	CN
10	RE31B	HKONA	SKA1	SAKNR		1	N
11	RE31B	HKONE	SKA1	SAKNR		1	N
12	RE31B	HKONT	TFK012	BVRKO		1	N
13	RE31B	RECPT	TE016	RECPT		1	CN
14	RE31B	SPART	TSPA	SPART		1	CN
15	RE31B	VKONT	FKKVK	VKONT		1	N
16	RE31B	WAERS	TCURC	WAERS		1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in