SAP ABAP Table ROIU_PR_WC_MP_RMAT (Maintenance Structure: OIU_PR_WCRMAT and OIU_PR_MPRMAT)
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)
⤷
⤷
Basic Data
| Table Category | INTTAB | Structure |
| Structure | ROIU_PR_WC_MP_RMAT |
|
| Short Description | Maintenance Structure: OIU_PR_WCRMAT and OIU_PR_MPRMAT |
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 | |
0 | 0 | Well Completion Reproduced Materials | |||||
| 2 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 3 | |
OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
| 4 | |
OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
| 5 | |
OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
| 6 | |
OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
| 7 | |
OIU_FRM_PC | OIU_PERCENT52 | DEC | 5 | 2 | Formation percent | ||
| 8 | |
OIU_RPRD_MATNR | MATNR | CHAR | 18 | 0 | Reprod. Material | OIU_CM_MAT_PRCD | |
| 9 | |
0 | 0 | Creator and date/time created | |||||
| 10 | |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 11 | |
TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
| 12 | |
OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
| 13 | |
OIU_MP_NO | OIU_MP_NO | CHAR | 20 | 0 | Measurement point number | OIU_PR_MP | |
| 14 | |
OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
| 15 | |
MAKTX | TEXT40 | CHAR | 40 | 0 | Material description | ||
| 16 | |
OIU_WL_NO_REF | OIU_WL_NO | CHAR | 15 | 0 | Reference well ID number | OIU_PR_WELL | |
| 17 | |
OIU_WC_NO_REF | OIU_WC_NO | CHAR | 5 | 0 | Reference well completion number | OIU_PR_WC | |
| 18 | |
OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
| 19 | |
OIU_MP_NO_REF | OIU_MP_NO | CHAR | 20 | 0 | Reference measurement point number | OIU_PR_MP | |
| 20 | |
OIU_MP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Measurement point description | ||
| 21 | |
OIU_EFF_FROM_DT_REF | DATUM | DATS | 8 | 0 | Reference effective from date | ||
| 22 | |
OIU_DBACTION | CHAR1 | CHAR | 1 | 0 | Database Action Flag |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | ROIU_PR_WC_MP_RMAT | MANDT | |
|
KEY | 1 | CN |
| 2 | ROIU_PR_WC_MP_RMAT | MP_NO | |
|
KEY | 1 | CN |
| 3 | ROIU_PR_WC_MP_RMAT | REF_MP_NO | |
|
KEY | 1 | CN |
| 4 | ROIU_PR_WC_MP_RMAT | REF_WC_NO | |
|
1 | CN | |
| 5 | ROIU_PR_WC_MP_RMAT | REF_WL_NO | |
|
KEY | 1 | CN |
| 6 | ROIU_PR_WC_MP_RMAT | RPRD_MATNR | |
|
KEY | 1 | CN |
| 7 | ROIU_PR_WC_MP_RMAT | WC_NO | |
|
KEY | 1 | CN |
| 8 | ROIU_PR_WC_MP_RMAT | WL_NO | |
|
KEY | 1 | CN |
History
| Last changed by/on | SAP | 20050301 |
| SAP Release Created in | 46C |