SAP ABAP Table T8JVEXTR (Billing extract reporting)

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ CA-JVA (Application Component) Joint Venture und Production Sharing Accounting
     ⤷ GJV2 (Package) Joint Venture Development

Basic Data

Table Category	INTTAB	Structure
Structure	T8JVEXTR	Table Relationship Diagram
Short Description	Billing extract reporting

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	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	RJVNAM	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
3	REGROU	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
4	REP_YEAR	☐	JV_REPYEAR	GJAHR	NUMC	4	0	Reporting year
5	REP_PERIOD	☐	JV_REPPER	MONAT	NUMC	2	0	Reporting period
6	XTYPE	☐	JV_XTYPE	JV_XTYPE	CHAR	2	0	Extract type
7	.INCLUDE	☐				0	0	JV Expenditure Detail Rpt.
8	FUNDCURR	☐	JV_FUNDCUR	WAERS	CUKY	5	0	Funding currency	TCURC
9	FYEAR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
10	PERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
11	CEIND	☐	JV_CEIND	XFELD	CHAR	1	0	Indicator: Capital
12	JIBCL	☐	JV_JIBCL	JV_JIBCL	CHAR	3	0	JIB/JIBE Class	T8J6A
13	JIBSA	☐	JV_JIBSA	JV_JIBSA	CHAR	5	0	JIB/JIBE Subclass A	T8J6C
14	JIBSB	☐	JV_JIBSB	JV_JIBSB	CHAR	24	0	JV Subclass B	T8J6E
15	BILLCODE	☐	JV_BILLCO	CHAR3	CHAR	3	0	JV Billing code
16	CCENTRE	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
17	PROJECT	☐	JV_PROJ	PS_POSNR	NUMC	8	0	JV Project	PRPS
18	ORDER	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
19	NPLNR	☐	NPLNR	AUFNR	CHAR	12	0	Network Number for Account Assignment	*
20	AUFPL	☐	AUFPL_CH	AUFPL	NUMC	10	0	Task List Number for Operations in Order
21	APLZL	☐	APLZL_CH	CO_APLZL	NUMC	8	0	General Counter for Order	*
22	SDS_CO	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
23	ORSDS_CO	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
24	KOSTL_SDS	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
25	PROJ_SDS	☐	JV_PROJ	PS_POSNR	NUMC	8	0	JV Project	*
26	ORDER_SDS	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
27	ACCOUNT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	SKA1
28	SDS_ACC	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
29	ORSDS_ACC	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
30	ACC_SDS	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
31	SDS_RI	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
32	ORSDS_RI	☐	JV_SDS	JV_SDS	CHAR	4	0	Supplemental detail set for JV billing	*
33	RI_SDS	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
34	TANGIND	☐	JV_TANGI	JV_TANGI	CHAR	1	0	JV Tangible/Intangible Indicator
35	AFEIND	☐	JV_AFEIND	XFELD	CHAR	1	0	JV AFE Indicator
36	AFENUM	☐	JV_AFENUM	J_OBJNREXT	CHAR	22	0	AFE (authorization for expenditure)
37	PARTN	☐	JV_PART	KUNNR	CHAR	10	0	Partner account number	KNA1
38	PROJ_SUP	☐	JV_PROJ	PS_POSNR	NUMC	8	0	JV Project	*
39	PRODPER	☐	JVA_PROD_MONTH	BUPER	ACCP	6	0	Produktionsmonat
40	LOCALCURR	☐	LCURR	WAERS	CUKY	5	0	Currency key of the local currency	TCURC
41	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*
42	KSL1_CUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
43	HSL2_CUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
44	KSL2_CUR	☐	RTCUR	WAERS	CUKY	5	0	Currency Key	*
45	FCMAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
46	FYDAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
47	FIDAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
48	LCMAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
49	LYDAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
50	LIDAMT	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
51	KSL1_PTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
52	KSL1_YTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
53	KSL1_ITD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
54	HSL2_PTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
55	HSL2_YTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
56	HSL2_ITD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
57	KSL2_PTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
58	KSL2_YTD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount
59	KSL2_ITD	☐	JV_PER_AMT	WERTV9	CURR	17	2	Joint Venture Period Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T8JVEXTR	ACCOUNT	SKA1	SAKNR
2	T8JVEXTR	CCENTRE	CSKS	KOSTL
3	T8JVEXTR	FUNDCURR	TCURC	WAERS
4	T8JVEXTR	JIBCL	T8J6A	CLASS
5	T8JVEXTR	JIBSA	T8J6C	SUBCLASS
6	T8JVEXTR	JIBSB	T8J6E	JIBSB
7	T8JVEXTR	LOCALCURR	TCURC	WAERS
8	T8JVEXTR	ORDER	AUFK	AUFNR
9	T8JVEXTR	PARTN	KNA1	KUNNR
10	T8JVEXTR	PROJECT	PRPS	PSPNR
11	T8JVEXTR	RBUKRS	T001	BUKRS
12	T8JVEXTR	REGROU	T8JF	EGRUP
13	T8JVEXTR	RJVNAM	T8JV	VNAME

History

Last changed by/on	SAP	20050219
SAP Release Created in