SAP Table ROIU_WC_DATED
Well Completion Dated Maintenance Structure (OIU_PR_WCVD)
ROIU_WC_DATED (Well Completion Dated Maintenance Structure (OIU_PR_WCVD)) 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 ROIU_WC_DATED to other SAP tables.
ROIU_WC_DATED table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
WL_NO
Well ID number
|
OIU_WL_NO | OIU_PR_WELL |
CHAR
|
15 | 0 | |||||||||||
|
WC_NO
Well Completion Number
|
OIU_WC_NO | OIU_PR_WC |
CHAR
|
5 | 0 | |||||||||||
|
WC_NAME
Well completion name
|
OIU_WC_NM |
CHAR
|
35 | 0 | ||||||||||||
|
WC_SHTXT
Description
|
OIU_SHTXT |
CHAR
|
35 | 0 | ||||||||||||
|
EFF_FROM_DT
Effective from date
|
OIU_EFF_FROM_DT |
DATS
|
8 | 0 | ||||||||||||
|
EFF_TO_DT
Effective To Date
|
OIU_EFF_TO_DT |
DATS
|
8 | 0 | ||||||||||||
|
NEXT_EFF_FROM_DT
Effective from date
|
OIU_EFF_FROM_DT |
DATS
|
8 | 0 | ||||||||||||
|
NEXT_EFF_TO_DT
Effective from date
|
OIU_EFF_FROM_DT |
DATS
|
8 | 0 | ||||||||||||
|
PREV_EFF_FROM_DT
Effective from date
|
OIU_EFF_FROM_DT |
DATS
|
8 | 0 | ||||||||||||
|
REF_WL_NO
Reference well ID number
|
OIU_WL_NO_REF | OIU_PR_WELL |
CHAR
|
15 | 0 | |||||||||||
|
REF_WC_NO
Reference well completion number
|
OIU_WC_NO_REF | OIU_PR_WC |
CHAR
|
5 | 0 | |||||||||||
|
REF_WC_NAME
Well completion name
|
OIU_WC_NM |
CHAR
|
35 | 0 | ||||||||||||
|
REF_EFF_FROM_DT
Reference effective from date
|
OIU_EFF_FROM_DT_REF |
DATS
|
8 | 0 | ||||||||||||
|
PSPNR
WBS Element
|
PS_POSNR | PRPS |
NUMC
|
8 | 0 | |||||||||||
|
AL_FL
Allocation allowed flag
|
OIU_AL_ALLW_FL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
HVCLS
Heating value class (calorific value class)
|
OIB_HVCLS |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
CRUD_TYPE_CD
Crude type code
|
OIU_CRUD_TYPE_CD | OIU_PR_CRTYP |
CHAR
|
2 | 0 | |||||||||||
|
OP_FL
Operated flag
|
OIU_OPERATOR_FL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
CONTN_FL
Continuous Flag
|
OIU_CYC_CONTN_FL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
WL_COUNT
Well count
|
OIU_WL_COUNT |
INT4
|
10 | 0 | ||||||||||||
|
PRD_MTH_CD
Producing method code
|
OIU_PRD_MTH_CD | OIU_PR_PMCD |
CHAR
|
2 | 0 | |||||||||||
|
EXT_LOSS_PC
Ext. Loss Percentage
|
OIU_EXT_LOSS_PC |
DEC
|
5 | 2 | ||||||||||||
|
WL_CLASS_CD
Well class code
|
OIU_WL_CLASS_CD | OIU_PR_WLCLS |
CHAR
|
2 | 0 | |||||||||||
|
CRTYP_DE
Crude type description
|
OIU_CRTYP_DE |
CHAR
|
35 | 0 | ||||||||||||
|
PRD_MTH_DE
Producing Method Description
|
OIU_PRD_MTH_DE |
CHAR
|
50 | 0 | ||||||||||||
|
WL_CLASS_DE
Well Class Description
|
OIU_WL_CLASS_DE |
CHAR
|
50 | 0 | ||||||||||||
|
STATUS_CD
Well completion status code
|
OIU_WC_STATUS_CD | OIU_PR_WC_STS |
CHAR
|
2 | 0 | |||||||||||
|
STATUS_DE
Status description
|
OIU_STATUS_DE |
CHAR
|
35 | 0 | ||||||||||||
|
OPERATOR
Operator
|
OIU_OPERATOR | KNA1 |
CHAR
|
10 | 0 | |||||||||||
|
OPERATOR_DE
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||||||
|
MCOD1
Search term for matchcode search
|
MCDD1 |
CHAR
|
25 | 0 | ||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||
|
BUTXT
Name of Company Code or Company
|
BUTXT |
CHAR
|
25 | 0 | ||||||||||||
|
COST_CENTER
Cost Center
|
KOSTL | CSKS |
CHAR
|
10 | 0 | |||||||||||
|
COST_CENTER_DE
Description
|
KLTXT |
CHAR
|
40 | 0 | ||||||||||||
|
KOSTL_KTEXT
General Name
|
KTEXT |
CHAR
|
20 | 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 | ||||||||||||
|
XXDBACTION
Time Interval Handler (CO): Identifier for database activity
|
TTDBACTION |
CHAR
|
1 | 0 | ||||||||||||
ROIU_WC_DATED foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ROIU_WC_DATED | BUKRS | SY | MANDT |
T001
Company Codes
|
MANDT |
| ROIU_WC_DATED | BUKRS | ROIU_WC_DATED | BUKRS |
T001
Company Codes
|
BUKRS |
| ROIU_WC_DATED | COST_CENTER | SY | MANDT |
CSKS
Cost Center Master Data
|
MANDT |
| ROIU_WC_DATED | COST_CENTER | * |
CSKS
Cost Center Master Data
|
KOKRS | |
| ROIU_WC_DATED | COST_CENTER | ROIU_WC_DATED | COST_CENTER |
CSKS
Cost Center Master Data
|
KOSTL |
| ROIU_WC_DATED | COST_CENTER | * |
CSKS
Cost Center Master Data
|
DATBI | |
| ROIU_WC_DATED | CRUD_TYPE_CD | SY | MANDT |
OIU_PR_CRTYP
CRUDE TYPES - TBLCM015
|
MANDT |
| ROIU_WC_DATED | CRUD_TYPE_CD | ROIU_WC_DATED | CRUD_TYPE_CD |
OIU_PR_CRTYP
CRUDE TYPES - TBLCM015
|
CRTYP_CD |
| ROIU_WC_DATED | OPERATOR | SY | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| ROIU_WC_DATED | OPERATOR | ROIU_WC_DATED | OPERATOR |
KNA1
General Data in Customer Master
|
KUNNR |
| ROIU_WC_DATED | PRD_MTH_CD | SY | MANDT |
OIU_PR_PMCD
Well Category/Producing Method Codes Table - Tblcm013
|
MANDT |
| ROIU_WC_DATED | PRD_MTH_CD | ROIU_WC_DATED | PRD_MTH_CD |
OIU_PR_PMCD
Well Category/Producing Method Codes Table - Tblcm013
|
PRD_MTH_CD |
| ROIU_WC_DATED | PSPNR | SY | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| ROIU_WC_DATED | PSPNR | ROIU_WC_DATED | PSPNR |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| ROIU_WC_DATED | REF_WC_NO | ROIU_WC_DATED | REF_WL_NO |
OIU_PR_WC
PRA: Well Completion
|
WL_NO |
| ROIU_WC_DATED | REF_WC_NO | ROIU_WC_DATED | REF_WC_NO |
OIU_PR_WC
PRA: Well Completion
|
WC_NO |
| ROIU_WC_DATED | REF_WC_NO | SY | MANDT |
OIU_PR_WC
PRA: Well Completion
|
MANDT |
| ROIU_WC_DATED | REF_WL_NO | SY | MANDT |
OIU_PR_WELL
PRA: Well
|
MANDT |
| ROIU_WC_DATED | REF_WL_NO | ROIU_WC_DATED | REF_WL_NO |
OIU_PR_WELL
PRA: Well
|
WL_NO |
| ROIU_WC_DATED | STATUS_CD | SY | MANDT |
OIU_PR_WC_STS
Well completion status
|
MANDT |
| ROIU_WC_DATED | STATUS_CD | ROIU_WC_DATED | STATUS_CD |
OIU_PR_WC_STS
Well completion status
|
STATUS_CD |
| ROIU_WC_DATED | WC_NO | SY | MANDT |
OIU_PR_WC
PRA: Well Completion
|
MANDT |
| ROIU_WC_DATED | WC_NO | ROIU_WC_DATED | WL_NO |
OIU_PR_WC
PRA: Well Completion
|
WL_NO |
| ROIU_WC_DATED | WC_NO | ROIU_WC_DATED | WC_NO |
OIU_PR_WC
PRA: Well Completion
|
WC_NO |
| ROIU_WC_DATED | WL_CLASS_CD | ROIU_WC_DATED | WL_CLASS_CD |
OIU_PR_WLCLS
Well Class Table - Tblpr014
|
WL_CLASS_CD |
| ROIU_WC_DATED | WL_NO | SY | MANDT |
OIU_PR_WELL
PRA: Well
|
MANDT |
| ROIU_WC_DATED | WL_NO | ROIU_WC_DATED | WL_NO |
OIU_PR_WELL
PRA: Well
|
WL_NO |