SAP ABAP Table J_3RCLRSEL (Vendor/customer open item auto clearing program structure)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-LOC (Application Component) Localization
     ⤷ J3RC (Package) Clearing open items

Basic Data

Table Category	INTTAB	Structure
Structure	J_3RCLRSEL	Table Relationship Diagram
Short Description	Vendor/customer open item auto clearing program structure

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	LINK	☐	CHAR200	CHAR200	CHAR	200	0	Text field length 200
2	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
3	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
5	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
6	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
7	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
8	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
9	UMSKS	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
10	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
11	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
12	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
13	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
14	CLRNG	☐	J_3RCLRNG	WERT7	CURR	13	2	Clearing currency amount
15	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
16	BEDG1	☐	BED1_F123	FDNAME	CHAR	30	0	Criterion 1	*
17	BEDG2	☐	BED2_F123	FDNAME	CHAR	30	0	Criterion 2	*
18	BEDG3	☐	BED3_F123	FDNAME	CHAR	30	0	Criterion 3	*
19	BEDG4	☐	BED4_F123	FDNAME	CHAR	30	0	Criterion 4	*
20	BEDG5	☐	BED5_F123	FDNAME	CHAR	30	0	Criterion 5	*
21	DIFSUMMA	☐	J_3RCLEAR	WERT7	CURR	13	2	Cleared
22	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
23	REBZZ	☐	REBZZ	BUZEI	NUMC	3	0	Line Item in the Relevant Invoice
24	REBZJ	☐	REBZJ	GJAHR	NUMC	4	0	Fiscal Year of the Relevant Invoice (for Credit Memo)
25	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
26	SRTPR	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
27	QUANT	☐	J_3RFCHAR3	J_3RFCHAR3	CHAR	3	0	Iteration quantity
28	NUCLR	☐	J_3RFCLRNUM	J_3RFCLRNUM	CHAR	10	0	Clearing document sequence number
29	USTXT	☐	BKTXT	TEXT25	CHAR	25	0	Document Header Text
30	DE_CR	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
31	CLRPS	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
32	DSBLE	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
33	DSBBT	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
34	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
35	KOART	☐	KOART	KOART	CHAR	1	0	Account type
36	XZAHL	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
37	XZAHR	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
38	XZAHM	☐	XZAHL	XFELD	CHAR	1	0	Indicator: Is Posting Key Used in a Payment Transaction?
39	BILDVAL	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
40	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
41	CLWRS	☐	J_3RCLCUR	WAERS	CUKY	5	0	Clearing currency	*
42	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
43	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
44	KURSR	☐	KURSF	KURSF	DEC	9	5	Exchange rate
45	KURSC	☐	KURSF	KURSF	DEC	9	5	Exchange rate
46	DOCLR	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
47	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
48	NAMEOLD	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
49	FLAG_FILL	☐	CHAR0001	CHAR0001	CHAR	1	0	Individual, User-Defined Character
50	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
51	XPROC	☐	FLAG_X	CHAR1_X	CHAR	1	0	Indicator
52	INTCNUM	☐	J_3RF_INTCNTNUM	ZUONR	CHAR	18	0	Internal Contract Number
53	EXTCNUM	☐	J_3RF_EXTCNTNUM	J_3RF_EXTCNTNUM	CHAR	40	0	External Contract Number	*
54	CNTDATE	☐	J_3RF_CNTDAT	DATUM	DATS	8	0	Contract Date

History

Last changed by/on	SAP	20110901
SAP Release Created in	600