1. Home
  2. Resources
  3. SAP Tables
  4. OIU_DO_DI - Base Venture/DOI Relationship

SAP Table OIU_DO_DI

Base Venture/DOI Relationship

OIU_DO_DI (Base Venture/DOI Relationship) 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_DI to other SAP tables.

OIU_DO_DI 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 OIU_DO_JV CHAR 6 0
DOI_NO Division of interest (DOI) OIU_DOI_NO CHAR 5 0
DOI_NM Division of Interest Name OIU_DOI_NM CHAR 30 0
SHTXT Description OIU_SHTXT CHAR 35 0
COMB_PD_CD Combined product code OIU_COMB_PD_CD OIUCM_COMB_PD_CD CHAR 3 0
LAND1 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
DI_LEG_DE_CMT_FL Legal Description Flag OIU_DI_LEG_DE_CMT_FL CHAR 1 0
X Active
NULL Inactive
PERM_TMPRY_CD Permanent/Temporary Code OIU_PERM_TMPRY_CD CHAR 1 0
T Temporary
P Permanent
START_DATE Start date OIU_START_DT DATS 8 0
EXPIRATION_DATE End Date OIU_END_DT DATS 8 0
DOI_APPR_CD DOI Approval Code OIU_DOI_APPR_CD CHAR 1 0
X Active
NULL Inactive
CHECKED_OUT_FL Checked out flag OIU_CHECKED_OUT_FL CHAR 1 0
X Active
NULL Inactive
PPN_PROCESS_DT PPN process date OIUOW_PPN_PROCESS_DT DATS 8 0
PPN_PROCESS_FL PPN Process Flag OIUOW_PPN_PROCESS_FL CHAR 1 0
X Active
NULL Inactive
OWN_TRANSFER_FL Transfer Flag OIUOW_TRANSFER_FL CHAR 1 0
X Active
NULL Inactive
OWN_CHANGE_FL Owner Change Flag OIUOW_CHANGE_FL CHAR 1 0
X Active
NULL Inactive
CHECK_OUT_DATE Check Out Date OIUOW_CHECK_OUT_DT DEC 15 0
CHECK_IN_DATE Check In Date OIUOW_CHECK_IN_DT DEC 15 0
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_DI foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIU_DO_DI BUKRS OIU_DO_DI MANDT T001 Company Codes MANDT
OIU_DO_DI BUKRS OIU_DO_DI BUKRS T001 Company Codes BUKRS
OIU_DO_DI COMB_PD_CD OIU_DO_DI MANDT OIUCM_COMB_PD_CD Combined Product Code MANDT
OIU_DO_DI COMB_PD_CD OIU_DO_DI COMB_PD_CD OIUCM_COMB_PD_CD Combined Product Code COMB_PD_CD
OIU_DO_DI LAND1 OIU_DO_DI LAND1 T005 Countries LAND1
OIU_DO_DI LAND1 OIU_DO_DI MANDT T005 Countries MANDT
OIU_DO_DI PRI_GEO_LOC OIU_DO_DI PRI_GEO_LOC OIU_CM_LXPGL Country and Primary Geo. Location Xref PRI_GEO_LOC
OIU_DO_DI PRI_GEO_LOC OIU_DO_DI MANDT OIU_CM_LXPGL Country and Primary Geo. Location Xref MANDT
OIU_DO_DI PRI_GEO_LOC OIU_DO_DI LAND1 OIU_CM_LXPGL Country and Primary Geo. Location Xref LAND1
OIU_DO_DI SEC_GEO_LOC OIU_DO_DI MANDT OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio MANDT
OIU_DO_DI SEC_GEO_LOC OIU_DO_DI LAND1 OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio LAND1
OIU_DO_DI SEC_GEO_LOC OIU_DO_DI PRI_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio PRI_GEO_LOC
OIU_DO_DI SEC_GEO_LOC OIU_DO_DI SEC_GEO_LOC OIU_CM_LXSGL Cross Reference Between Country and Secondary Geo. Locatio SEC_GEO_LOC
OIU_DO_DI VNAME OIU_DO_DI BUKRS OIU_DO_JV PRA venture extension BUKRS
OIU_DO_DI VNAME OIU_DO_DI VNAME OIU_DO_JV PRA venture extension VNAME
OIU_DO_DI VNAME OIU_DO_DI MANDT OIU_DO_JV PRA venture extension MANDT