1. Home
  2. Resources
  3. SAP Tables
  4. OIU_DO_JV - PRA venture extension

SAP Table OIU_DO_JV

PRA venture extension

OIU_DO_JV (PRA venture extension) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIU_DO_JV to other SAP tables.

OIU_DO_JV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
VNAME Joint Venture JV_NAME CHAR 6 0
VNAME_INT_CD Venture Interest Code OIU_VNAME_INT_CD CHAR 2 0
00 Non-interest company
01 100% company operated company
02 Joint venture company operated venture
03 Joint venture outside operated venture
04 Royalty interest venture
VNAME_NM venture name OIU_VNAME_NM CHAR 35 0
SHTXT Description OIU_SHTXT CHAR 35 0
STS_CODE Venture Status OIU_VNAME_STATUS OIU_CM_VNAMST CHAR 2 0
STS_EFF_DT Status Effective Date OIU_STS_EFF_DT DATS 8 0
COUNTRY Country Key LAND1 T005 CHAR 3 0
PRI_GEO_LOC Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC OIU_CM_LXPGL CHAR 2 0
SEC_GEO_LOC Secondary geographic location OIU_SEC_GEO_LOC OIU_CM_LXSGL CHAR 3 0
ACQ_DT Acquired Date OIU_ACQ_DT DATS 8 0
TYPE_CD Venture Usage Type OIU_VNAME_TYPE_CD CHAR 2 0
01 Producing
02 Facility
03 Non-producing
04 Gas plant
05 Undistributed facilities
06 Non-associated override
07 Non-associated royalty
08 Non-associated royalty with distribution
09 Non-equity
OLD_VNAME_NO Old lease ID OIU_OLD_VNAME_NO CHAR 18 0
UNIT_FL Unit venture flag OIU_UNIT_FL CHAR 1 0
X Active
NULL Inactive
DOI_BY_TR_FL DOI by tract flag OIU_DOI_BY_TR_FL CHAR 1 0
X Active
NULL Inactive
DRL_FUND_FL Drill Fund Flag OIU_DRL_FUND_FL CHAR 1 0
X Active
NULL Inactive
ONS_OFS_CD Onshore/Offshore codes OIU_ONS_OFS_CD CHAR 1 0
0 Not applicable
1 Onshore
2 State offshore
3 Federal offshore
ACQ_FROM_KUNNR Party Acquired From OIU_ACQ_FROM_KUNNR KNA1 CHAR 10 0
SLD_TO_KUNNR Party Sold To OIU_SLD_TO_KUNNR KNA1 CHAR 10 0
LEG_DE_CMT_FL Legal description OIU_LEG_DE_CMT_FL CHAR 1 0
X Active
NULL Inactive
FIELD Field ID OIU_FIELDID OIU_PR_FIELD CHAR 10 0
SPACE_ORD_NO Spacing Order Number OIU_SPACE_ORD_NO CHAR 20 0
LPN_NO Land Venture Number OIU_LPN_NO CHAR 9 0
DOI_PRT_FL DOI Print Flag OIU_DOI_PRT_FL CHAR 1 0
X Active
NULL Inactive
OIU_CRUSER Name of Person who Created the Object ERNAM CHAR 12 0
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS DEC 15 0

OIU_DO_JV foreign key relationships

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