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 |
Possible values
|
||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||
| OLD_VNAME_NO | Old lease ID | OIU_OLD_VNAME_NO | CHAR | 18 | 0 | |||||||||||||||||||||
| UNIT_FL | Unit venture flag | OIU_UNIT_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| DOI_BY_TR_FL | DOI by tract flag | OIU_DOI_BY_TR_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| DRL_FUND_FL | Drill Fund Flag | OIU_DRL_FUND_FL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| ONS_OFS_CD | Onshore/Offshore codes | OIU_ONS_OFS_CD | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||
| 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 |
Possible values
|
||||||||||||||||||||
| 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 |
