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

History

Last changed by/on	SAP	20130529
SAP Release Created in	100_470