SAP ABAP Table ROIU_DO_DI (Base DOI Maintenance Structure)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)
⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)
Basic Data
Table Category | INTTAB | Structure |
Structure | ROIU_DO_DI | Table Relationship Diagram |
Short Description | Base DOI Maintenance Structure |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | Base Venture/DOI Relationship | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
4 | VNAME | JV_NAME | JV_NAME | CHAR | 6 | 0 | Joint venture | OIU_DO_JV | |
5 | DOI_NO | OIU_DOI_NO | OIU_DOI_NO | CHAR | 5 | 0 | Division of interest (DOI) | * | |
6 | DOI_NM | OIU_DOI_NM | OIU_TEXT30 | CHAR | 30 | 0 | Division of Interest Name | ||
7 | SHTXT | OIU_SHTXT | CHAR35 | CHAR | 35 | 0 | Description | ||
8 | COMB_PD_CD | OIU_COMB_PD_CD | OIU_COMB_PD_CD | CHAR | 3 | 0 | Combined product code | OIUCM_COMB_PD_CD | |
9 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
10 | PRI_GEO_LOC | OIU_PRI_GEO_LOC | OIU_PRI_GEO_LOC | CHAR | 2 | 0 | Primary geographical location (PRI geo. loc.) | OIU_CM_LXPGL | |
11 | SEC_GEO_LOC | OIU_SEC_GEO_LOC | OIU_SEC_GEO_LOC | CHAR | 3 | 0 | Secondary geographic location | OIU_CM_LXSGL | |
12 | DI_LEG_DE_CMT_FL | OIU_DI_LEG_DE_CMT_FL | OIU_X_FLAG | CHAR | 1 | 0 | Legal Description Flag | ||
13 | PERM_TMPRY_CD | OIU_PERM_TMPRY_CD | OIU_PERM_TMPRY_CD | CHAR | 1 | 0 | Permanent/Temporary Code | ||
14 | START_DATE | OIU_START_DT | DATUM | DATS | 8 | 0 | Start date | ||
15 | EXPIRATION_DATE | OIU_END_DT | DATUM | DATS | 8 | 0 | End Date | ||
16 | DOI_APPR_CD | OIU_DOI_APPR_CD | OIU_X_FLAG | CHAR | 1 | 0 | DOI Approval Code | ||
17 | CHECKED_OUT_FL | OIU_CHECKED_OUT_FL | OIU_X_FLAG | CHAR | 1 | 0 | Checked out flag | ||
18 | PPN_PROCESS_DT | OIUOW_PPN_PROCESS_DT | DATUM | DATS | 8 | 0 | PPN process date | ||
19 | PPN_PROCESS_FL | OIUOW_PPN_PROCESS_FL | OIU_X_FLAG | CHAR | 1 | 0 | PPN Process Flag | ||
20 | OWN_TRANSFER_FL | OIUOW_TRANSFER_FL | OIU_X_FLAG | CHAR | 1 | 0 | Transfer Flag | ||
21 | OWN_CHANGE_FL | OIUOW_CHANGE_FL | OIU_X_FLAG | CHAR | 1 | 0 | Owner Change Flag | ||
22 | CHECK_OUT_DATE | OIUOW_CHECK_OUT_DT | TZNTSTMPS | DEC | 15 | 0 | Check Out Date | ||
23 | CHECK_IN_DATE | OIUOW_CHECK_IN_DT | TZNTSTMPS | DEC | 15 | 0 | Check In Date | ||
24 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
25 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
26 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
27 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
28 | CPCD_DESC | OIU_CPCD_DESC | OIU_TEXT30 | CHAR | 30 | 0 | Combined Product Code Description | ||
29 | LANDX | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
30 | PRI_GEO_DE | OIU_PRI_GEO_DESC | CHAR30 | CHAR | 30 | 0 | Primary geographical location description | ||
31 | SEC_GEO_DE | OIU_SEC_GEO_DESC | CHAR30 | CHAR | 30 | 0 | Secondary Geographical Location Description | ||
32 | GENR_DO_FL | OIU_GENR_DO_FL | OIU_X_FLAG | CHAR | 1 | 0 | Generated Division Order Flag | ||
33 | DO_EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
34 | PRINT_USER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
35 | LAB_ONLY_FL | OIU_LAB_ONLY_FL | OIU_X_FLAG | CHAR | 1 | 0 | Labels Only Flag | ||
36 | COPIES_NO | CO_COPIES | NUMC2 | NUMC | 2 | 0 | Number of printouts | ||
37 | XXDBACTION | OIU_DBACTION | CHAR1 | CHAR | 1 | 0 | Database Action Flag | ||
38 | REF_BUKRS | BUKRS_REF | BUKRS | CHAR | 4 | 0 | Reference company code | T001 | |
39 | REF_BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
40 | REF_VNAME | OIU_JV_NAME_REF | JV_NAME | CHAR | 6 | 0 | Reference Joint Venture | OIU_DO_JV | |
41 | REF_DOI_NO | OIU_DOI_NO_REF | OIU_DOI_NO | CHAR | 5 | 0 | Reference Division of Interest Number | OIU_DO_DI | |
42 | REF_DOI_NM | OIU_DOI_NM | OIU_TEXT30 | CHAR | 30 | 0 | Division of Interest Name |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIU_DO_DI | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | ROIU_DO_DI | COMB_PD_CD | OIUCM_COMB_PD_CD | COMB_PD_CD | REF | ||
3 | ROIU_DO_DI | LAND1 | T005 | LAND1 | KEY | 1 | CN |
4 | ROIU_DO_DI | PRI_GEO_LOC | OIU_CM_LXPGL | PRI_GEO_LOC | KEY | 1 | CN |
5 | ROIU_DO_DI | REF_BUKRS | T001 | BUKRS | 1 | CN | |
6 | ROIU_DO_DI | REF_DOI_NO | OIU_DO_DI | DOI_NO | 1 | CN | |
7 | ROIU_DO_DI | REF_VNAME | OIU_DO_JV | VNAME | 1 | CN | |
8 | ROIU_DO_DI | SEC_GEO_LOC | OIU_CM_LXSGL | SEC_GEO_LOC | KEY | 1 | CN |
9 | ROIU_DO_DI | VNAME | OIU_DO_JV | VNAME | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 46C |