SAP table OIU_DO_JV (PRA venture extension)

SAP table OIU_DO_JV 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 MANDT
BUKRS Company Code CHAR 4 0 T001 BUKRS
VNAME Joint venture CHAR 6 0 JV_NAME
VNAME_INT_CD Venture Interest Code CHAR 2 0 OIU_VNAME_INT_CD
VNAME_NM Venture Name CHAR 35 0 OIU_VNAME_NM
SHTXT Description CHAR 35 0 OIU_SHTXT
STS_CODE Venture Status CHAR 2 0 OIU_CM_VNAMST OIU_VNAME_STATUS
STS_EFF_DT Status Effective Date DATS 8 0 OIU_STS_EFF_DT
COUNTRY Country/Region Key CHAR 3 0 T005 LAND1
PRI_GEO_LOC Primary geographical location (PRI geo. loc.) CHAR 2 0 OIU_CM_LXPGL OIU_PRI_GEO_LOC
SEC_GEO_LOC Secondary geographic location CHAR 3 0 OIU_CM_LXSGL OIU_SEC_GEO_LOC
ACQ_DT Acquired Date DATS 8 0 OIU_ACQ_DT
TYPE_CD Venture Usage Type CHAR 2 0 OIU_VNAME_TYPE_CD
OLD_VNAME_NO Old lease ID CHAR 18 0 OIU_OLD_VNAME_NO
UNIT_FL Unit venture flag CHAR 1 0 OIU_UNIT_FL
DOI_BY_TR_FL DOI by tract flag CHAR 1 0 OIU_DOI_BY_TR_FL
DRL_FUND_FL Drill Fund Flag CHAR 1 0 OIU_DRL_FUND_FL
ONS_OFS_CD Onshore/Offshore codes CHAR 1 0 OIU_ONS_OFS_CD
0 Not applicable
1 Onshore
2 State offshore
3 Federal offshore
ACQ_FROM_KUNNR Party Acquired From CHAR 10 0 KNA1 OIU_ACQ_FROM_KUNNR
SLD_TO_KUNNR Party Sold To CHAR 10 0 KNA1 OIU_SLD_TO_KUNNR
LEG_DE_CMT_FL Legal description CHAR 1 0 OIU_LEG_DE_CMT_FL
FIELD Field ID CHAR 10 0 OIU_PR_FIELD OIU_FIELDID
SPACE_ORD_NO Spacing Order Number CHAR 20 0 OIU_SPACE_ORD_NO
LPN_NO Land Venture Number CHAR 9 0 OIU_LPN_NO
DOI_PRT_FL DOI Print Flag CHAR 1 0 OIU_DOI_PRT_FL
OIU_CRUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS

OIU_DO_JV foreign key relationships

Table Field Check Table Check Field
0 OIU_DO_JV ACQ_FROM_KUNNR KNA1 General Data in Customer Master MANDT
0 OIU_DO_JV ACQ_FROM_KUNNR KNA1 General Data in Customer Master KUNNR
1 OIU_DO_JV BUKRS T001 Company Codes BUKRS
0 OIU_DO_JV COUNTRY T005 Countries MANDT
0 OIU_DO_JV COUNTRY T005 Countries LAND1
1 OIU_DO_JV FIELD OIU_PR_FIELD Field MANDT
0 OIU_DO_JV PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref MANDT
0 OIU_DO_JV PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref LAND1
0 OIU_DO_JV PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref PRI_GEO_LOC
1 OIU_DO_JV SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio MANDT
1 OIU_DO_JV SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio LAND1
1 OIU_DO_JV SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio PRI_GEO_LOC
0 OIU_DO_JV SLD_TO_KUNNR KNA1 General Data in Customer Master MANDT
0 OIU_DO_JV SLD_TO_KUNNR KNA1 General Data in Customer Master KUNNR
1 OIU_DO_JV STS_CODE OIU_CM_VNAMST PRA Venture Status Code table - (TBLRV047) MANDT
1 OIU_DO_JV STS_CODE OIU_CM_VNAMST PRA Venture Status Code table - (TBLRV047) VNAME_STATUS