SAP ABAP Table T8JVB60 (JV Non-op Billing Screen Structure)

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	T8JVB60	Table Relationship Diagram
Short Description	JV Non-op Billing Screen 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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
2	PARTN	☐	JV_OPERATOR	JV_PARTN	CHAR	10	0	JV Operator	T8JO
3	KURSF	☐	KURSF	KURSF	DEC	9	5	Exchange rate
4	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
5	BKTXT	☐	JV_BKTXT	JV_TEXT25	CHAR	25	0	Billing header text
6	WWERT	☐	WWERT_D	DATUM	DATS	8	0	Translation date
7	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
8	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
9	BANK_TYPE	☐	JV_BANK_TYPE	BVTYP	CHAR	4	0	JV Business Partner's Bank type
10	VNAME	☐	JV_VENTURE	JV_NAME	CHAR	6	0	Joint Venture	T8JV
11	FUNDCUR	☐	JV_FUNDCUR	WAERS	CUKY	5	0	Funding currency	T8JC2
12	FCVAL	☐	JV_FCVAL	WERTV9	CURR	17	2	Funding Currency Amount
13	LCVAL	☐	JV_LCVAL	WERTV9	CURR	17	2	Local Currency Amount
14	NOBNO	☐	JV_NONOP_BILL_NO	JV_NONOP_BILL_NO	CHAR	10	0	JV Non-Operated Billing Number	T8J4G
15	NGTEXT	☐	JV_NGTEXT	JV_NGTEXT	CHAR	5	0	JV Net or Gross Indicator Text
16	NBTEXT	☐	JV_NOP_BILL_TEXT	TEXT35	CHAR	35	0	JV Non-Operated Bill Description
17	VTEXT	☐	JV_LTEXT	JV_TEXT35	CHAR	35	0	Joint Venture Text
18	NBNET	☐	JV_NBNET	XFELD	CHAR	1	0	Net Input Only
19	NAME1	☐	NAME1	TEXT30	CHAR	30	0	Name
20	LTEXT	☐	JV_DATA_ENTRY_TEXT	JV_TEXT43	CHAR	43	0	Line Text for Data Entry
21	UNAME	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
22	SDATE	☐	DATUM	DATUM	DATS	8	0	Date
23	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
24	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
25	TOTAMT	☐	JV_TOTAMT	WERTV7	CURR	13	2	Total Amount
26	TOTTAX	☐	JV_TOTTAX	WERTV7	CURR	13	2	Total Tax
27	TAXAMTF	☐	JV_TAXAMTF	WERTV7	CURR	13	2	Tax invoice amount
28	TAMNTF	☐	JV_TAMNTF	WERTV7	CURR	13	2	JV tax amount in funding currency for header information
29	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	T8JF
30	EGTXT	☐	JV_EGTXT	TEXT35	CHAR	35	0	JV Equity Group Name
31	PROJN	☐	JV_PROJECT	PS_POSNR	NUMC	8	0	Internal project item number	PRPS
32	HKONT	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	SKA1
33	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
34	PAYMETHOD	☐	DZLSCH	ZLSCH	CHAR	1	0	Payment method	T042Z
35	PAYTERMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
36	NOPSHARE	☐	JV_NOSHARE	JV_SHARE	DEC	9	6	Non-Operated Share
37	POSTFCVAL	☐	JV_FCPVAL	WERTV7	CURR	13	2	non-op billing actual funding currency posting amount
38	POSTUCVAL	☐	JV_UCPVAL	WERTV7	CURR	13	2	non-op billing actual user currency posting amount
39	POSTUCVAL_FC	☐	JV_UCPVAL_FC	WERTV7	CURR	13	2	non-op actual user currency posting amount in funding curr.
40	USERCUR	☐	JV_USERCUR	WAERS	CUKY	5	0	User Currency	TCURC
41	FUC_RATE	☐	JV_FUCRATE	KURSF	DEC	9	5	Exchange rate of user currency to funding currency
42	ASSET	☐	JV_ASSET	XFELD	CHAR	1	0	JV Asset Line Indicator
43	ASSETRN	☐	JV_ASSETRN	BWASL	CHAR	3	0	JV Asset Transaction Type	TABW
44	ASSETCD	☐	JV_ASSETCD	NUM1	NUMC	1	0	Asset Transaction Code
45	INVNTRY	☐	JV_INVNTRY	XFELD	CHAR	1	0	JV Inventory Line Indicator
46	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
47	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
48	VYEAR	☐	VYEAR	GJAHR	NUMC	4	0	Acquisition year of the asset (manually changeable)
49	VMNTH	☐	VMNTH	POPER	NUMC	3	0	Asset Accounting: Acquis. month (in depreciation area)
50	VALUE_DATE	☐	JV_VALUE_DATE	DATUM	DATS	8	0	Asset Value Date
51	ASSET_CLASS	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	*
52	ANLHTXT	☐	JV_ASSET_DESCRIPTION	TEXT50	CHAR	50	0	Asset Description
53	ASSETAMT	☐	JV_ASSETVL	WERTV7	CURR	13	2	Non-Operated Billing Asset line amount
54	ACQUSITION	☐	ACQUSITION	WERTV7	CURR	13	2	Acquisition Value
55	DETAIL_SUM	☐	JV_DETAIL_SUM	WERTV7	CURR	13	2	Sum of total itemized amounts in funding currency
56	LOCAL_DETAIL_SUM	☐	JV_LOCAL_DETAIL_SUM	WERTV7	CURR	13	2	Sum of total itemized amounts in local currency
57	LOCLCUR	☐	JV_LOCLCUR	WAERS	CUKY	5	0	Local currency	*
58	TRX_AMOUNT	☐	JV_AMOUNT	WERTV7	CURR	13	2	JV General Billing Amount in transaction currency
59	LOCAL_TRX_AMOUNT	☐	JV_LOCAL_AMOUNT	WERTV7	CURR	13	2	JV General Billing Amount in local currency
60	BUDGET	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
61	U_FUNDCUR_FACTOR	☐	JV_FUNDCUR_FACTOR_FOR_USERCUR	DEC9	DEC	9	0	Funding currency factor for user currency exchange rate
62	U_USERCUR_FACTOR	☐	JV_USERCUR_FACTOR_FOR_USERCUR	DEC9	DEC	9	0	User currency factor for user currency exchange rate
63	F_LOCALCUR_FACTOR	☐	JV_LOCALCUR_FACTOR_FOR_FUNDCUR	DEC9	DEC	9	0	Local currency factor for funding currency exchange rate
64	F_FUNDCUR_FACTOR	☐	JV_FUNDCUR_FACTOR_FOR_FUNDCUR	DEC9	DEC	9	0	Funding currency factor for funding currency exchange rate
65	FLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag
66	POM	☐	JV_POM	DATUM	DATS	8	0	Processing operational month

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T8JVB60	ASSETRN	TABW	BWASL		C	CN
2	T8JVB60	AUFNR	AUFK	AUFNR
3	T8JVB60	BUKRS	T001	BUKRS
4	T8JVB60	EGRUP	T8JF	EGRUP
5	T8JVB60	FUNDCUR	T8JC2	FUNDCUR	REF	1	CN
6	T8JVB60	HKONT	SKA1	SAKNR
7	T8JVB60	KOSTL	CSKS	KOSTL
8	T8JVB60	LAND1	T005	LAND1
9	T8JVB60	NOBNO	T8J4G	NOBNO
10	T8JVB60	PARTN	T8JO	PARTN
11	T8JVB60	PAYMETHOD	T042Z	ZLSCH
12	T8JVB60	PROJN	PRPS	PSPNR
13	T8JVB60	USERCUR	TCURC	WAERS	REF	1	CN
14	T8JVB60	VNAME	T8JV	VNAME

History

Last changed by/on	SAP	20130529
SAP Release Created in