SAP ABAP Table J_3RCOPSDK (Open Item Data for Clearing Transactions G/L)

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_3RCOPSDK	Table Relationship Diagram
Short Description	Open Item Data for Clearing Transactions G/L

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	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
5	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
6	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
7	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
8	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
9	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
10	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
11	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
12	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
13	ZFBDT	☐	J_3RCDZFBDT	DATUM	DATS	8	0	Base date for calculation of term of payment
14	ZUONR	☐	J_3RCDZUONR	ZUONR	CHAR	18	0	Assignment number
15	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
16	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
17	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
18	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
19	VERZG	☐	VERZG	WRTV3	DEC	5	0	Calculated Days in Arrears
20	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
21	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
22	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
23	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
24	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
25	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
26	CCBTC	☐	CCBTC	CCBTC	CHAR	10	0	Payment cards: Settlement run
27	XREF3	☐	XREF3	CHAR20	CHAR	20	0	Reference key for line item
28	BUPLA	☐	J_3RCBUPLA	CHAR4	CHAR	4	0	Business place
29	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
30	FILKD	☐	FILKD	MAXKK	CHAR	10	0	Account Number of the Branch
31	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
32	ZTERM	☐	J_3RCDZTERM	ZTERM	CHAR	4	0	Terms of payment key
33	ZBD1T	☐	J_3RCDZBD1T	ZBDXT	DEC	3	0	Cash discount days 1
34	ZBD2T	☐	J_3RCDZBD2T	ZBDXT	DEC	3	0	Cash discount days 2
35	ZBD3T	☐	J_3RCDZBD3T	ZBDXT	DEC	3	0	Net Payment Terms Period
36	ZBD1P	☐	J_3RCDZBD1P	PRZ23	DEC	5	3	Cash Discount Percentage 1
37	ZBD2P	☐	J_3RCDZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
38	ZBFIX	☐	J_3RCDZBFIX	ZBFIX	CHAR	1	0	Fixed Payment Terms
39	REBZG	☐	REBZG	BELNR	CHAR	10	0	Number of the Invoice the Transaction Belongs to
40	SAMNR	☐	SAMNR	SAMNR	NUMC	8	0	Invoice List Number
41	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
42	ANLN2	☐	ANLN2_4	ANLN2_4	CHAR	4	0	New asset subnumber, 4 characters
43	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
44	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
45	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
46	AUFPL	☐	CO_AUFPL	AUFPL	NUMC	10	0	Routing number of operations in the order
47	ANFBN	☐	ANFBN	BELNR	CHAR	10	0	Document Number of the Bill of Exchange Payment Request
48	KONKO	☐	KONKO	MAXKK	CHAR	10	0	Open item account number
49	TOLER	☐	TOLER_043G	TOLER_043G	NUMC	2	0	Grace Days
50	ZLSPR	☐	J_3RCDZLSPR	ZAHLS	CHAR	1	0	Payment Block Key	*
51	MANSP	☐	MANSP	MANSP	CHAR	1	0	Dunning block	*
52	MANST	☐	MAHNS_D	MAHNS	NUMC	1	0	Dunning Level
53	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
54	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
55	RSTGR	☐	RSTGR	RSTGR	CHAR	3	0	Reason Code for Payments	*
56	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
57	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
58	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
59	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
60	TOGRU	☐	TOGRU	TOGRU	CHAR	4	0	Tolerance group for the business partner/G/L account	*
61	VBEL2	☐	VBELN_VA	VBELN	CHAR	10	0	Sales Document	*
62	NETDT	☐	NETDT	DATUM	DATS	8	0	Due Date for Net Payment
63	EMPFB	☐	EMPFB	MAXKK	CHAR	10	0	Payee/Payer
64	KIDNO	☐	KIDNO	CHAR30	CHAR	30	0	Payment Reference
65	ZLSCH	☐	J_3RCDZLSCH	ZLSCH	CHAR	1	0	Payment method	*
66	UZAWE	☐	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	*
67	SECCO	☐	J_3RCSECCO	CHAR4	CHAR	4	0	Section code
68	PYCUR	☐	J_3RCPYCUR	WAERS	CUKY	5	0	Currency for Automatic Payment	*
69	PYAMT	☐	J_3RCPYAMT	WERT7	CURR	13	2	Amount in Payment Currency
70	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement
71	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*

History

Last changed by/on	SAP	20130529
SAP Release Created in	500