JVB26 - JV Billing Extract: Supplemental Detail - Expenditure Detail

JV Billing Extract: Supplemental Detail - Expenditure Detail information is stored in SAP table JVB26.
It is part of development package GJVA_BILLING in software component CA-JVA-JVA. This development package consists of objects that can be grouped under "Billing functionality for Joint Venture Accounting".

Fields for table JVB26

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
RCLNT	Client	X	MANDT	CLNT	6
ID	16 byte UUID in 36 chars according to RFC4122	X	SYSUUID_C36	CHAR	72	JVB00
RBUKRS	Company Code	X	BUKRS	CHAR	8
RYEAR	General Ledger Fiscal Year	X	GJAHR_POS	NUMC	8
POPER	Posting period	X	POPER	NUMC	6
SDS	Supplemental detail set for JV billing	X	JV_SDS	CHAR	8
RCNTR	Cost Center	X	KOSTL	CHAR	20
PS_PSP_PNR	Work Breakdown Structure Element (WBS Element)	X	PS_PSP_PNR	NUMC	16
RORDNR	Order Number	X	AUFNR	CHAR	24
VPTNR	Partner account number	X	JV_PART	CHAR	20	KNA1
BELNR	Document Number of an Accounting Document	X	BELNR_D	CHAR	20
DOCLN	Six-Character Posting Item for Ledger	X	DOCLN6	CHAR	12
EGRUP	Equity group	X	JV_EGROUP	CHAR	6	T8JF
VNAME	Joint venture	X	JV_NAME	CHAR	12	T8JV
FUNDING_CURRENCY	Currency Key	X	WAERS	CUKY	10
RACCT	Account Number	X	RACCT	CHAR	20	SKA1
ETYPE	Equity type		JV_ETYPE	CHAR	6
NPLNR	Network Number for Account Assignment		NPLNR	CHAR	24
NPLNR_VORGN	Network activity		NPVRG	CHAR	8
PRODPER	Production Month (Date to find period and year)		JV_PRODPER	DATS	16
JVACTIVITY	JVA Activity (Joint Venture Accounting)		JV_ACTIVITY	CHAR	4
EBELN	Purchasing Document Number		EBELN	CHAR	20
EBELP	Item Number of Purchasing Document		EBELP	NUMC	10
AWTYP	Reference procedure		AWTYP	CHAR	10
AWORG	Reference Organizational Units		AWORG	CHAR	20
JIBCL	JIB/JIBE Class		JV_JIBCL	CHAR	6	T8J6A
JIBSA	JIB/JIBE Subclass A		JV_JIBSA	CHAR	10	T8J6C
JIBSB	JV Subclass B		JV_JIBSB	CHAR	48	T8J6E
CEIND	Indicator: Capital		JV_CEIND	CHAR	2
PROJ_SUP	JV Project		JV_PROJ	NUMC	16
BILLCODE	JV Billing code		JV_BILLCO	CHAR	6
MATNR	Material Number		MATNR	CHAR	80
BLART	Document Type		BLART	CHAR	4
PROJ_SDS	JV Project		JV_PROJ	NUMC	16
ORDER_SDS	Order Number		AUFNR	CHAR	24
ACCT_SDS	Account Number		RACCT	CHAR	20
RECIND_SDS	Recovery Indicator		JV_RECIND	CHAR	4
RCNTR_SDS	Cost Center		KOSTL	CHAR	20
AWREF	Reference document number		AWREF	CHAR	20
MSL	Quantity		QUAN1_12	QUAN	12
RUNIT	Base Unit of Measure		MEINS	UNIT	6
TANGIND	JV Tangible/Intangible Indicator		JV_TANGI	CHAR	2
AFEIND	JV AFE Indicator		JV_AFEIND	CHAR	2
AFENUM	AFE (authorization for expenditure)		JV_AFENUM	CHAR	44
FCURR	Value field 12(23) characters with 2 decimal places		WERTV12	CURR	12
RWCUR	Transaction Currency		FINS_CURRW	CUKY	10
WSL	Amount in Company Code Currency		FINS_VHCUR12	CURR	12
RHCUR	Company Code Currency		FINS_CURRH	CUKY	10
HSL	Amount in Company Code Currency		FINS_VHCUR12	CURR	12
RKCUR	Global Currency		FINS_CURRK	CUKY	10
KSL	Amount in Global Currency		FINS_VKCUR12	CURR	12
ROCUR	Freely Defined Currency 1		FINS_CURR1	CUKY	10
OSL	Amount in Freely Defined Currency 1		FINS_VOCUR12	CURR	12
RVCUR	Freely Defined Currency 2		FINS_CURR2	CUKY	10
VSL	Amount in Freely Defined Currency 2		FINS_VVCUR12	CURR	12
RBCUR	Freely Defined Currency 3		FINS_CURR3	CUKY	10
BSL	Amount in Freely Defined Currency 3		FINS_VBCUR12	CURR	12
RCCUR	Freely Defined Currency 4		FINS_CURR4	CUKY	10
CSL	Amount in Freely Defined Currency 4		FINS_VCCUR12	CURR	12
RDCUR	Freely Defined Currency 5		FINS_CURR5	CUKY	10
DSL	Amount in Freely Defined Currency 5		FINS_VDCUR12	CURR	12
RECUR	Freely Defined Currency 6		FINS_CURR6	CUKY	10
ESL	Amount in Freely Defined Currency 6		FINS_VECUR12	CURR	12
RFCUR	Freely Defined Currency 7		FINS_CURR7	CUKY	10
FSL	Amount in Freely Defined Currency 7		FINS_VFCUR12	CURR	12
RGCUR	Freely Defined Currency 8		FINS_CURR8	CUKY	10
GSL	Amount in Freely Defined Currency 8		FINS_VGCUR12	CURR	12