SAP ABAP Table ROIU_WC_DATED (Well Completion Dated Maintenance Structure (OIU_PR_WCVD))
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_WC_DATED | Table Relationship Diagram |
Short Description | Well Completion Dated Maintenance Structure (OIU_PR_WCVD) |
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 | WL_NO | OIU_WL_NO | OIU_WL_NO | CHAR | 15 | 0 | Well ID number | OIU_PR_WELL | |
2 | WC_NO | OIU_WC_NO | OIU_WC_NO | CHAR | 5 | 0 | Well Completion Number | OIU_PR_WC | |
3 | WC_NAME | OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
4 | WC_SHTXT | OIU_SHTXT | CHAR35 | CHAR | 35 | 0 | Description | ||
5 | EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
6 | EFF_TO_DT | OIU_EFF_TO_DT | DATUM | DATS | 8 | 0 | Effective To Date | ||
7 | NEXT_EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
8 | NEXT_EFF_TO_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
9 | PREV_EFF_FROM_DT | OIU_EFF_FROM_DT | DATUM | DATS | 8 | 0 | Effective from date | ||
10 | REF_WL_NO | OIU_WL_NO_REF | OIU_WL_NO | CHAR | 15 | 0 | Reference well ID number | OIU_PR_WELL | |
11 | REF_WC_NO | OIU_WC_NO_REF | OIU_WC_NO | CHAR | 5 | 0 | Reference well completion number | OIU_PR_WC | |
12 | REF_WC_NAME | OIU_WC_NM | OIU_TEXT35 | CHAR | 35 | 0 | Well completion name | ||
13 | REF_EFF_FROM_DT | OIU_EFF_FROM_DT_REF | DATUM | DATS | 8 | 0 | Reference effective from date | ||
14 | PSPNR | PS_POSNR | PS_POSNR | NUMC | 8 | 0 | WBS Element | PRPS | |
15 | AL_FL | OIU_AL_ALLW_FL | OIU_X_FLAG | CHAR | 1 | 0 | Allocation allowed flag | ||
16 | HVCLS | OIB_HVCLS | OIB_HVCLS | CHAR | 2 | 0 | Heating value class (calorific value class) | ||
17 | CRUD_TYPE_CD | OIU_CRUD_TYPE_CD | OIU_CRUD_TYPE_CD | CHAR | 2 | 0 | Crude type code | OIU_PR_CRTYP | |
18 | OP_FL | OIU_OPERATOR_FL | OIU_X_FLAG | CHAR | 1 | 0 | Operated flag | ||
19 | CONTN_FL | OIU_CYC_CONTN_FL | OIU_X_FLAG | CHAR | 1 | 0 | Continuous Flag | ||
20 | WL_COUNT | OIU_WL_COUNT | OIU_WL_COUNT | INT4 | 10 | 0 | Well count | ||
21 | PRD_MTH_CD | OIU_PRD_MTH_CD | OIU_PRD_MTH_CD | CHAR | 2 | 0 | Producing method code | OIU_PR_PMCD | |
22 | EXT_LOSS_PC | OIU_EXT_LOSS_PC | OIU_PERCENT52 | DEC | 5 | 2 | Ext. Loss Percentage | ||
23 | WL_CLASS_CD | OIU_WL_CLASS_CD | OIU_WL_CLASS_CD | CHAR | 2 | 0 | Well class code | OIU_PR_WLCLS | |
24 | CRTYP_DE | OIU_CRTYP_DE | OIU_TEXT35 | CHAR | 35 | 0 | Crude type description | ||
25 | PRD_MTH_DE | OIU_PRD_MTH_DE | OIU_TEXT50 | CHAR | 50 | 0 | Producing Method Description | ||
26 | WL_CLASS_DE | OIU_WL_CLASS_DE | OIU_TEXT50 | CHAR | 50 | 0 | Well Class Description | ||
27 | STATUS_CD | OIU_WC_STATUS_CD | OIU_WC_STATUS_CD | CHAR | 2 | 0 | Well completion status code | OIU_PR_WC_STS | |
28 | STATUS_DE | OIU_STATUS_DE | OIU_TEXT35 | CHAR | 35 | 0 | Status description | ||
29 | OPERATOR | OIU_OPERATOR | KUNNR | CHAR | 10 | 0 | Operator | KNA1 | |
30 | OPERATOR_DE | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
31 | MCOD1 | MCDD1 | CHAR25 | CHAR | 25 | 0 | Search term for matchcode search | ||
32 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
33 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
34 | COST_CENTER | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | CSKS | |
35 | COST_CENTER_DE | KLTXT | TEXT40 | CHAR | 40 | 0 | Description | ||
36 | KOSTL_KTEXT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
37 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
38 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
39 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | ||
40 | XXDBACTION | TTDBACTION | TTDBACTION | CHAR | 1 | 0 | Time Interval Handler (CO): Identifier for database activity |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIU_WC_DATED | BUKRS | T001 | BUKRS | KEY | 1 | CN |
2 | ROIU_WC_DATED | COST_CENTER | CSKS | KOSTL | KEY | 1 | CN |
3 | ROIU_WC_DATED | CRUD_TYPE_CD | OIU_PR_CRTYP | CRTYP_CD | KEY | 1 | CN |
4 | ROIU_WC_DATED | OPERATOR | KNA1 | KUNNR | KEY | 1 | CN |
5 | ROIU_WC_DATED | PRD_MTH_CD | OIU_PR_PMCD | PRD_MTH_CD | KEY | 1 | CN |
6 | ROIU_WC_DATED | PSPNR | PRPS | PSPNR | KEY | 1 | C |
7 | ROIU_WC_DATED | REF_WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
8 | ROIU_WC_DATED | REF_WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
9 | ROIU_WC_DATED | STATUS_CD | OIU_PR_WC_STS | STATUS_CD | |||
10 | ROIU_WC_DATED | WC_NO | OIU_PR_WC | WC_NO | KEY | 1 | CN |
11 | ROIU_WC_DATED | WL_CLASS_CD | OIU_PR_WLCLS | WL_CLASS_CD | |||
12 | ROIU_WC_DATED | WL_NO | OIU_PR_WELL | WL_NO | KEY | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |