SAP ABAP Table T8JVTCL (JV structure for clearing)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ CA-JVA (Application Component) Joint Venture und Production Sharing Accounting
     ⤷ GJVB (Package) Joint venture billing

Basic Data

Table Category	INTTAB	Structure
Structure	T8JVTCL	Table Relationship Diagram
Short Description	JV structure for clearing

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	CLDOCNR	☐	DOCNR	BELNR	CHAR	10	0	Doc. Number
2	CLDOCLN	☐	JV_DOCLN	BUZEI	NUMC	3	0	Line Item in Joint Venture Document
3	RYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	RTCUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
5	DRCRK	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
6	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	RJVNAM	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
8	REGROU	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
9	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
10	RKOKRS	☐	KOKRS	CACCD	CHAR	4	0	Controlling Area	*
11	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
12	RORDNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
13	RPROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
14	RPRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
15	RRECIN	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
16	RPARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	*
17	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
18	AUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
19	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
20	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
21	QSSKZ	☐	QSSKZ	QSSKZ	CHAR	2	0	Withholding Tax Code	*
22	TSL	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
23	HSL	☐	VTCUR9	WERTV9	CURR	17	2	Value in Transaction Currency
24	KSL	☐	VGCUR9	WERTV9	CURR	17	2	Value in group currency
25	MSL	☐	QUAN1	MENG8	QUAN	15	3	Quantity
26	SKNTO	☐	SKNTO	WERT7	CURR	13	2	Cash discount amount in local currency
27	SKNT2	☐	SKNT2	WERT7	CURR	13	2	Cash Discount Amount in Second Local Currency
28	SKNT3	☐	SKNT3	WERT7	CURR	13	2	Cash Discount Amount in Third Local Currency
29	WSKTO	☐	WSKTO	WERT7	CURR	13	2	Cash Discount Amount in Document Currency
30	REBZT	☐	REBZT	REBZT	CHAR	1	0	Follow-On Document Type
31	PART_NR	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
32	RES_NR	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
33	DIFHW	☐	DIFHW	WERT7	CURR	13	2	Amount Difference in Local Currency
34	DIFH2	☐	DIFH2	WERT7	CURR	13	2	Amount Difference in Second Local Currency
35	DIFH3	☐	DIFH3	WERT7	CURR	13	2	Amount Difference in Third Local Currency
36	DIFFW	☐	DIFFW	WRTV7	CURR	13	2	Amount Difference in Foreign Currency
37	ORECID	☐	JV_ORECID	JV_RECIND	CHAR	2	0	Original Recovery Indicator	*
38	REFDOCNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
39	REFRYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
40	REFDOCLN	☐	JV_REFDLN	NUMC5	NUMC	5	0	Line Item in Joint Venture Reference Doc
41	REFACTIV	☐	GLVOR	CHAR4	CHAR	4	0	Business Transaction
42	REFFIDLN	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
43	SGTXT	☐	SGTXT	TEXT50	CHAR	50	0	Item Text
44	BILID	☐	JV_BILIND	JV_BILIND	CHAR	2	0	Payroll Type	*
45	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
46	BILLM	☐	JV_BILLM	DATUM	DATS	8	0	Billing Month
47	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month
48	UMSKZ	☐	UMSKZ	UMSKZ	CHAR	1	0	Special G/L Indicator	*
49	KOART	☐	KOART	KOART	CHAR	1	0	Account type
50	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
51	SAKNR	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
52	PARGB	☐	PARGB	GSBER	CHAR	4	0	Trading partner's business area	*
53	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
54	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
55	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
56	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
57	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
58	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
59	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
60	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	*
61	VBUND	☐	VBUND	RCOMP	CHAR	6	0	Company ID	*
62	CURT1	☐	CURT1	CURTP	CHAR	2	0	Currency type of the first local currency
63	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
64	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
65	CURT4	☐	CURT4	CURTP	CHAR	2	0	Currency type of the fourth local currency
66	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
67	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
68	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
69	HWAE4	☐	HWAE4	WAERS	CUKY	5	0	Currency key of the fourth local currency	*
70	DMBE2	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
71	DMBE3	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
72	DMBE4	☐	VLCUR9	WERTV9	CURR	17	2	Value in local currency
73	PSWSL	☐	PSWSL	WAERS	CUKY	5	0	Update Currency for General Ledger Transaction Figures	*
74	PSWBT	☐	PSWBT	WERT7	CURR	13	2	Amount for Updating in General Ledger
75	BDIFF	☐	BDIFF	WRTV7	CURR	13	2	Valuation Difference
76	BDIF2	☐	BDIF2	WRTV7	CURR	13	2	Valuation Difference for the Second Local Currency
77	BDIF3	☐	BDIF3	WRTV7	CURR	13	2	Valuation Difference for the Third Local Currency
78	JVA_RDIFF	☐	RDIFF	WRTV7	CURR	13	2	Exchange Rate Gain/Loss Realized
79	JVA_RDIF2	☐	RDIF2	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Second Local Currency
80	JVA_RDIF3	☐	RDIF3	WRTV7	CURR	13	2	Exchange Rate Difference Realized for Third Local Currency
81	XREF1	☐	XREF1	CHAR12	CHAR	12	0	Business partner reference key
82	XREF2	☐	XREF2	CHAR12	CHAR	12	0	Business partner reference key
83	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
84	AGZEI	☐	JV_AGZEI		NUMC	5	0	Clearing Item
85	AGZEI_STAT	☐	JV_AGZEI		NUMC	5	0	Clearing Item
86	UMSKS_STAT	☐	UMSKS	UMSKS	CHAR	1	0	Special G/L Transaction Type
87	CBCUSTOMER	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
88	CBVENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
89	CBPAYTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key

History

Last changed by/on	SAP	20130529
SAP Release Created in