SAP ABAP Table T8JV (Joint Venture)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ GJVC (Package) Joint venture objects with original in ALR

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T8JV	Table Relationship Diagram
Short Description	Joint Venture

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	VNAME	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture
4	PAYTERMS	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
5	BMETHOD	☐	JV_BMETHOD	JV_BMETHOD	CHAR	4	0	Billing Method	T8J0C
6	VTYPE	☐	JV_VTYPE	JV_VTYPE	CHAR	1	0	Venture Type
7	OPERATOR	☐	JV_OPERAT	KUNNR	CHAR	10	0	Operator for Non-Operated Venture	KNA1
8	TAXCODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
9	VCLASS	☐	JV_VCLASS	JV_VCLASS	CHAR	2	0	Venture class	T8JT
10	ITD	☐	JV_ITD	JV_BILLING_PYI	CHAR	1	0	Inception to Date
11	CRUSER	☐	JV_CRUSER	UNAME	CHAR	12	0	User who Created
12	CRTIME	☐	JV_CRTIME	ZEITE	CHAR	8	0	Time Created
13	CRDATE	☐	JV_CRDATE	DATUM	DATS	8	0	Date Created
14	CHUSER	☐	JV_CHUSER	UNAME	CHAR	12	0	User who Last Changed
15	CHTIME	☐	JV_CHTIME	ZEITE	CHAR	8	0	Time Last Changed
16	CHDATE	☐	JV_CHDATE	DATUM	DATS	8	0	Date Last Changed
17	.INCLU--AP	☐				0	0	Extension for 3.0 Upgrade
18	BFORMAT	☐	JV_BFORM	JV_BFORM	CHAR	4	0	JV Billing Format	T8J0R
19	JOA	☐	JV_JOA	JV_JOA	CHAR	6	0	Joint Operating Agreement	T8JU
20	VACTIVE	☐	JV_PROCESS	XFELD	CHAR	1	0	Block Joint Venture for Cutback and Billing
21	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
22	OUTPAYTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
23	OUTTAXCODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
24	TXJCD2	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
25	NBFORMAT	☐	JV_NBFORM	JV_NBFORM	CHAR	4	0	Joint Venture Non-billing Form	T8J3A
26	BFREQ	☐	JV_BFRQ	JV_BFRQ	NUMC	1	0	JV Billing Frequency
27	OVRDF	☐	JV_DFPAY	DEC3_2	DEC	5	2	% Drilling Payroll Burden in U.S.
28	OVRND	☐	JV_NDPAY	DEC3_2	DEC	5	2	Non-Drilling % to Apply for U.S. Payroll Burden Clearing
29	PCOCOSTC	☐	JV_PCOCC	KOSTL	CHAR	10	0	Cost Centre for posting PCO expense	CSKS
30	PCOPROJK	☐	JV_PCOWBS	PS_POSNR	NUMC	8	0	Parent Company Overhead Expense WBS Element	PRPS
31	PCOORDNR	☐	JV_PCOORD	AUFNR	CHAR	12	0	Parent Company Overhead Expense Order	AUFK
32	KOSTL	☐	JV_VKOSTL	KOSTL	CHAR	10	0	Substitute Cost Centre	CSKS
33	FUNDGROUP	☐	JV_FUNDGP	JV_FUNDGP	CHAR	6	0	JV Funding group	T8JM
34	CHECKFC	☐	JV_CHECKFC	XFELD	CHAR	1	0	Check Funding Currencies
35	PROPERTY	☐	JV_PROPERT	JV_CONTRAC	CHAR	24	0	JV Property ID
36	BILLTHRES	☐	JV_BILL_THRESH	WERT7	CURR	13	2	Billing threshold (debit)
37	BILLTHRESC	☐	JV_BILL_THRESH_C	WERT7	CURR	13	2	Billing threshold (credit)
38	BILLTHRESA	☐	JV_BILL_THRESH_ACTIVE	XFELD	CHAR	1	0	Billing threshold active
39	PSCHEM	☐	JV_PSCHEM	JV_PSCHEM	CHAR	4	0	Payment term schema	T8JPTS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T8JV	BFORMAT	T8J0R	BILLFORMAT
2	T8JV	BMETHOD	T8J0C	BMETHOD	REF	1	CN
3	T8JV	BUKRS	T001	BUKRS	KEY	1	CN
4	T8JV	FUNDGROUP	T8JM	FUNDGROUP	REF	C	CN
5	T8JV	JOA	T8JU	JOA	REF	1	CN
6	T8JV	KOSTL	CSKS	KOSTL	REF	C	CN
7	T8JV	MANDT	T000	MANDT	KEY	1	CN
8	T8JV	NBFORMAT	T8J3A	NBFORM	REF	C	CN
9	T8JV	OPERATOR	KNA1	KUNNR	REF	C	CN
10	T8JV	OUTTAXCODE	T007A	MWSKZ	REF	C	CN
11	T8JV	PCOCOSTC	CSKS	KOSTL
12	T8JV	PCOORDNR	AUFK	AUFNR	REF	1	CN
13	T8JV	PCOPROJK	PRPS	PSPNR	REF	1	CN
14	T8JV	PSCHEM	T8JPTS	PSCHEM		1	CN
15	T8JV	TAXCODE	T007A	MWSKZ	REF	C	CN
16	T8JV	TXJCD	TTXJ	TXJCD	REF	C	CN
17	T8JV	TXJCD2	TTXJ	TXJCD	REF	C	CN
18	T8JV	VCLASS	T8JT	VCLASS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in