OIU_DO_DP SAP (DOI Accounting Information) Table details
Dictionary Type: Table
Description: DOI Accounting Information
Description: DOI Accounting Information
Table field list including key, data, relationships and ABAP select examples
OIU_DO_DP is a standard SAP Table which is used to store DOI Accounting Information data and is available within R/3 SAP systems depending on the version and release level.
The OIU_DO_DP table consists of various fields, each holding specific information or linking keys about DOI Accounting Information data available in SAP. These include BUKRS (Company Code), VNAME (Joint Venture), DOI_NO (Division of interest (DOI)), MAJPD_CD (Major product code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIU_DO_DP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
VNAME | Joint Venture | JV_NAME | CHAR | 6 | OIU_DO_JV | ALPHA | JV_NAME | JVV | |
DOI_NO | Division of interest (DOI) | OIU_DOI_NO | CHAR | 5 | OIU_DO_DI | ALPHA | OIU_DOI_NO | OIU_DOI | H_OIU_DO_DI |
MAJPD_CD | Major product code | OIU_MAJPD_CD | CHAR | 1 | OIU_MAJPD_CD | OIU_MAJPD | |||
EFF_FROM_DT | Effective from date | OIU_EFF_FROM_DT | DATS | 8 | DATUM | OIU_EFD | |||
PLT_COND_FL | Plant Condensate Material FLag | OIU_PLT_COND_FL | CHAR | 1 | OIU_X_FLAG | ||||
SCUBBER_OIL_FL | Scrubber Oil Material FLag | OIU_SCRUBBER_OIL_FL | CHAR | 1 | OIU_X_FLAG | ||||
EFF_TO_DT | Effective To Date | OIU_EFF_TO_DT | DATS | 8 | DATUM | OIU_ETD | |||
DP_NO | DOI Accounting Information Number | OIU_DP_NO | NUMC | 12 | OIU_SYS_NO | ||||
ENTL_CD | Entitlement Code | OIU_ENTL_CD | CHAR | 1 | OIU_ENTL_CD | ||||
MP_NO | Measurement point number | OIU_MP_NO | CHAR | 20 | OIU_PR_MP | ALPHA | OIU_MP_NO | OIU_MP | H_OIU_PR_MP |
BLN_ROY_FL | Blanchard Royalty Flag | OIU_BLN_ROY_FL | CHAR | 1 | OIU_X_FLAG | ||||
REV_RCPT_LAG | Revenue Receipt Lag Month | OIU_REV_RCPT_LAG | NUMC | 2 | NUMC2 | ||||
REV_PRCS_CD | Revenue Process Code | OIU_REV_PRCS_CD | CHAR | 2 | OIU_REV_PRCS_CD | ||||
NRTF_CD | Normal Recording Time Frame Code | OIU_NRTF_CD | CHAR | 1 | OIU_NRTF_CD | ||||
REC_PYMT_CD | Record Payment/ Check Write Code | OIU_REC_PYMT_CD | CHAR | 1 | OIU_REC_PYMT_CD | ||||
IGNR_PYMT_FL | Ignore Payment/Pay Next Check Write Flag | OIU_IGNR_PYMT_FL | CHAR | 1 | OIU_X_FLAG | ||||
TAX_RMB_GRNT_CD | Tax Reimbursement at Gross or Net Code | OIU_TAX_RMB_GRNT_CD | CHAR | 1 | OIU_TAX_RMB_GRNT_CD | ||||
TAX_GRNT_CD | Tax Gross or Net Code | OIU_TAX_GRNT_CD | CHAR | 1 | OIU_TAX_GRNT_CD | ||||
SSC_FL | Sliding Scale Indicator Flag | OIU_SSC_FL | CHAR | 1 | OIU_X_FLAG | ||||
CUR_HIST_CD | Pay on Current/Historical Ownership (Allocate to Owners) | OIU_CUR_HIST_CD | CHAR | 1 | OIU_CUR_HIST_CD | ||||
ACCT_ENT_FL | Accounting Entry Override Flag | OIU_ACCT_ENT_FL | CHAR | 1 | OIU_X_FLAG | ||||
DOI_SUM_FL | Summarize RD to DOI Level Flag | OIU_DOI_SUM_FL | CHAR | 1 | OIU_X_FLAG | ||||
OVRD_OWN_CD | Override Owner code | OIU_OVRD_OWN_CD | CHAR | 2 | CHAR2 | ||||
THEO_CND_TAX_FL | Theoretical Condensate Tax Calculation Flag | OIU_THEO_CND_TAX_FL | CHAR | 1 | OIU_X_FLAG | ||||
WI_PAY_OVRD_FL | Working Interest Payment Override Flag | OIU_WI_PAY_OVRD_FL | CHAR | 1 | OIU_X_FLAG | ||||
KOSTL | PRA Cost Center | OIUCM_KOSTL | CHAR | 10 | ALPHA | OIUCM_KOSTL | H_OIUCM_KOSTN | ||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS |
Key field | Non-key field |
How do I retrieve data from SAP table OIU_DO_DP using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIU_DO_DP to SELECT all data from the tableDATA: WA_OIU_DO_DP TYPE OIU_DO_DP.
SELECT SINGLE *
FROM OIU_DO_DP
INTO CORRESPONDING FIELDS OF WA_OIU_DO_DP
WHERE...
How to access SAP table OIU_DO_DP
Within an ECC or HANA version of SAP you can also view further information about OIU_DO_DP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects