SAP table OIUCM_T8JV (PRA Joint Venture Master Data)

SAP table OIUCM_T8JV has 3 primary key fields being MANDT,BUKRS,VNAME.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
BUKRS Company Code CHAR 4 0 OIUCM_T8JZ BUKRS
VNAME Joint venture CHAR 6 0 JV_NAME
PAYTERMS Terms of payment key CHAR 4 0 DZTERM
BMETHOD Billing Method CHAR 4 0 T8J0C JV_BMETHOD
VTYPE Venture Type CHAR 1 0 JV_VTYPE
1 Operated venture
2 Non-operated venture
3 Non-operated venture for on-billing
4 Operated venture (with tax)
5 Corporate venture
OPERATOR Operator for Non-Operated Venture CHAR 10 0 KNA1 JV_OPERAT
TAXCODE Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
VCLASS Venture Class CHAR 2 0 T8JT JV_VCLASS
ITD Inception to Date CHAR 1 0 JV_ITD
CRUSER User who Created CHAR 12 0 JV_CRUSER
CRTIME Time Created CHAR 8 0 JV_CRTIME
CRDATE Date Created DATS 8 0 JV_CRDATE
CHUSER User who Last Changed CHAR 12 0 JV_CHUSER
CHTIME Time Last Changed CHAR 8 0 JV_CHTIME
CHDATE Date Last Changed DATS 8 0 JV_CHDATE
VACTIVE Block Joint Venture for Cutback and Billing CHAR 1 0 JV_PROCESS

OIUCM_T8JV foreign key relationships

Table Field Check Table Check Field
0 OIUCM_T8JV BMETHOD T8J0C Billing Methods MANDT
0 OIUCM_T8JV BMETHOD T8J0C Billing Methods BUKRS
0 OIUCM_T8JV BMETHOD T8J0C Billing Methods BMETHOD
1 OIUCM_T8JV BUKRS OIUCM_T8JZ PRA JVA Companies MANDT
1 OIUCM_T8JV BUKRS OIUCM_T8JZ PRA JVA Companies BUKRS
0 OIUCM_T8JV MANDT T000 Clients MANDT
1 OIUCM_T8JV OPERATOR KNA1 General Data in Customer Master MANDT
1 OIUCM_T8JV OPERATOR KNA1 General Data in Customer Master KUNNR
0 OIUCM_T8JV TAXCODE T007A Tax Keys KALSM
0 OIUCM_T8JV TAXCODE T007A Tax Keys MWSKZ
1 OIUCM_T8JV VCLASS T8JT Venture Class MANDT
1 OIUCM_T8JV VCLASS T8JT Venture Class BUKRS