- Home
- Resources
- SAP Tables
- OIU_PR_WCDVLH - Well Completion Disposition Volumes Header
SAP Table OIU_PR_WCDVLH
Well Completion Disposition Volumes Header
OIU_PR_WCDVLH (Well Completion Disposition Volumes Header) 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 OIU_PR_WCDVLH to other SAP tables.
Source: OIU_PR_WCDVLH (Well Completion Disposition Volumes Header)
OIU_PR_WCDVLH table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
|
CLNT |
|
3 |
0 |
|
| WCDVLH_NO |
Well Completion Delivery Volume Header Number |
OIU_WCDVLH_NO |
|
CHAR |
|
10 |
0 |
|
| DOC_YEAR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
0 |
|
| 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 |
|
| DN_NO |
Delivery network number |
OIU_DN_NO |
OIU_PR_DN
|
CHAR |
|
20 |
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 |
|
| PRD_DT |
Production date |
OIU_PRD_DT |
|
DATS |
|
8 |
0 |
|
| PRD_MATNR |
Production Material |
OIU_PRD_MATNR |
OIU_CM_MAT_PRCD
|
CHAR |
|
18 |
0 |
|
| MATNR |
Material Number |
MATNR |
OIU_CM_MAT_PRCD
|
CHAR |
|
18 |
0 |
|
| FREQ_CD |
Frequency |
OIU_FREQ_CD |
|
CHAR |
|
1 |
0 |
Possible values
|
| TKBTRY_MP_NO |
Tank battery measurement point number |
OIU_TKBTRY_MP_NO |
OIU_PR_MP
|
CHAR |
|
20 |
0 |
|
| VT_CD |
Volume type code |
OIU_VT_CD |
OIU_PR_VLTYP
|
CHAR |
|
2 |
0 |
|
| VC_CD |
Volume class code |
OIU_VC_CD |
|
CHAR |
|
1 |
0 |
Possible values
| A |
Actual |
| E |
Estimated |
| D |
Designated |
|
| VS_CD |
Volume Source Code |
OIU_VS_CD |
OIU_PR_VLSRC
|
CHAR |
|
1 |
0 |
|
| TRNSP_NO |
Transporter number |
OIU_TRNSP_NO |
KNA1
|
CHAR |
|
10 |
0 |
|
| TRNSP_REF_NO |
Transporter Reference Number |
OIU_TRNSP_REF_NO |
|
CHAR |
|
25 |
0 |
|
| REC_TYPE_CD |
Record type code |
OIU_REC_TYPE_CD |
|
CHAR |
|
4 |
0 |
|
| DAYS_PROD |
Days produced |
OIU_DAYS_PROD |
|
NUMC |
|
2 |
0 |
Possible values
| 00 |
only 0 - 31 days allowed |
|
| PRD_HRS |
Production hours |
OIU_PRD_HRS |
|
NUMC |
|
3 |
0 |
Possible values
| 000 |
only 0-744 hours allowed |
|
| TKT_NO |
Ticket number |
OIU_TKT_NO |
|
CHAR |
|
7 |
0 |
|
| TKT_TIMESTAMP |
Ticket Timestamp (Date) |
OIU_TKT_TIMESTP |
|
DEC |
|
15 |
0 |
|
| ORIG_MP_NO |
Original measurement point number |
OIU_ORIG_MP_NO |
OIU_PR_MP
|
CHAR |
|
20 |
0 |
|
| ORIG_MP_DOC_NO |
Original MP document no |
OIU_ORIG_MP_DOC_NO |
|
CHAR |
|
10 |
0 |
|
| ORIG_MP_DOC_YEAR |
Original document year |
OIU_ORIG_MP_DOC_YEAR |
|
NUMC |
|
4 |
0 |
|
| THEO_U |
Theoretical Unit |
OIU_THEO_U |
T006
|
UNIT |
|
3 |
0 |
|
| THEO |
Theoretical Volume |
OIU_THEO |
|
QUAN |
|
13 |
3 |
|
| CONV_GRP |
Conversion Group (Oil, Natural Gas,..) |
OIB_UMRSL |
OIB01
|
CHAR |
|
4 |
0 |
|
| STD_VOL_U |
Standard volume unit |
OIU_STD_VOL_U |
T006
|
UNIT |
|
3 |
0 |
|
| STD_VOL |
Standard volume |
OIU_STD_VOL |
|
QUAN |
|
13 |
3 |
|
| ENERGY_U |
Energy quantity unit |
OIU_ENERGY_U |
T006
|
UNIT |
|
3 |
0 |
|
| ENERGY |
Energy quantity |
OIU_ENERGY |
|
QUAN |
|
13 |
3 |
|
| HEAT_VAL_U |
Heating Value Unit |
OIU_HEAT_VAL_U |
T006
|
UNIT |
|
3 |
0 |
|
| HEAT_VAL |
Heating value |
OIU_HEAT_VAL |
|
QUAN |
|
13 |
3 |
|
| BASE_DENSITY |
Oil/gas density at standard/base conditions |
OIB_BDICH |
|
FLTP |
|
16 |
16 |
|
| BASE_DENSITY_U |
Unit for densities at standard/base conditions |
OIB_BDNEH |
|
UNIT |
|
3 |
0 |
|
| DENTYP |
Density Type |
OIB_DNTYP |
|
CHAR |
|
1 |
0 |
Possible values
| 1 |
API Gravity, Liquids |
| 2 |
Relative Density (relative to water at standard conditions) |
| 3 |
Density (absolute) |
| 4 |
Relative Density (relative to air at standard conditions) |
|
| MOL_VOLUME |
Gas mol volume |
OIU_MOL_VOLUME |
|
QUAN |
|
13 |
3 |
|
| INVT_DT |
Inventory date |
OIU_INV_DT |
|
DATS |
|
8 |
0 |
|
| XREF_WL_NO |
Cross-Reference Well Number |
OIU_XREF_WL_NO |
OIU_PR_WELL
|
CHAR |
|
15 |
0 |
|
| XREF_WC_NO |
Cross-Reference Wellcompletion Number |
OIU_XREF_WC_NO |
OIU_PR_WC
|
CHAR |
|
5 |
0 |
|
| ORIG_NO |
Original WCDVL No (Well Completion Daily Volume) |
OIU_ORIG_NO |
|
NUMC |
|
12 |
0 |
|
| ORIG_DOC_YEAR |
Fiscal Year |
GJAHR |
|
NUMC |
|
4 |
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 |
|
OIU_PR_WCDVLH foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| OIU_PR_WCDVLH |
CONV_GRP |
OIU_PR_WCDVLH |
CONV_GRP |
OIB01 |
Definition of Conversion Groups |
UMRSL |
| OIU_PR_WCDVLH |
CONV_GRP |
SYST |
MANDT |
OIB01 |
Definition of Conversion Groups |
MANDT |
| OIU_PR_WCDVLH |
DN_NO |
OIU_PR_WCDVLH |
MANDT |
OIU_PR_DN |
Delivery Network |
MANDT |
| OIU_PR_WCDVLH |
DN_NO |
OIU_PR_WCDVLH |
DN_NO |
OIU_PR_DN |
Delivery Network |
DN_NO |
| OIU_PR_WCDVLH |
ENERGY_U |
SYST |
MANDT |
T006 |
Units of Measurement |
MANDT |
| OIU_PR_WCDVLH |
ENERGY_U |
OIU_PR_WCDVLH |
ENERGY_U |
T006 |
Units of Measurement |
MSEHI |
| OIU_PR_WCDVLH |
HEAT_VAL_U |
SYST |
MANDT |
T006 |
Units of Measurement |
MANDT |
| OIU_PR_WCDVLH |
HEAT_VAL_U |
OIU_PR_WCDVLH |
HEAT_VAL_U |
T006 |
Units of Measurement |
MSEHI |
| OIU_PR_WCDVLH |
MATNR |
OIU_PR_WCDVLH |
MATNR |
OIU_CM_MAT_PRCD |
Material and Product Code (processing) Xref |
MATNR |
| OIU_PR_WCDVLH |
MATNR |
OIU_PR_WCDVLH |
MANDT |
OIU_CM_MAT_PRCD |
Material and Product Code (processing) Xref |
MANDT |
| OIU_PR_WCDVLH |
ORIG_MP_NO |
OIU_PR_WCDVLH |
ORIG_MP_NO |
OIU_PR_MP |
PRA Measurement Points |
MP_NO |
| OIU_PR_WCDVLH |
ORIG_MP_NO |
OIU_PR_WCDVLH |
MANDT |
OIU_PR_MP |
PRA Measurement Points |
MANDT |
| OIU_PR_WCDVLH |
PRD_MATNR |
OIU_PR_WCDVLH |
MANDT |
OIU_CM_MAT_PRCD |
Material and Product Code (processing) Xref |
MANDT |
| OIU_PR_WCDVLH |
PRD_MATNR |
OIU_PR_WCDVLH |
PRD_MATNR |
OIU_CM_MAT_PRCD |
Material and Product Code (processing) Xref |
MATNR |
| OIU_PR_WCDVLH |
STD_VOL_U |
SYST |
MANDT |
T006 |
Units of Measurement |
MANDT |
| OIU_PR_WCDVLH |
STD_VOL_U |
OIU_PR_WCDVLH |
STD_VOL_U |
T006 |
Units of Measurement |
MSEHI |
| OIU_PR_WCDVLH |
THEO_U |
SYST |
MANDT |
T006 |
Units of Measurement |
MANDT |
| OIU_PR_WCDVLH |
THEO_U |
OIU_PR_WCDVLH |
THEO_U |
T006 |
Units of Measurement |
MSEHI |
| OIU_PR_WCDVLH |
TKBTRY_MP_NO |
OIU_PR_WCDVLH |
TKBTRY_MP_NO |
OIU_PR_MP |
PRA Measurement Points |
MP_NO |
| OIU_PR_WCDVLH |
TKBTRY_MP_NO |
OIU_PR_WCDVLH |
MANDT |
OIU_PR_MP |
PRA Measurement Points |
MANDT |
| OIU_PR_WCDVLH |
TRNSP_NO |
OIU_PR_WCDVLH |
MANDT |
KNA1 |
General Data in Customer Master |
MANDT |
| OIU_PR_WCDVLH |
TRNSP_NO |
OIU_PR_WCDVLH |
TRNSP_NO |
KNA1 |
General Data in Customer Master |
KUNNR |
| OIU_PR_WCDVLH |
VS_CD |
SYST |
MANDT |
OIU_PR_VLSRC |
VOLUME SOURCE - TBLCM029 |
MANDT |
| OIU_PR_WCDVLH |
VS_CD |
OIU_PR_WCDVLH |
VS_CD |
OIU_PR_VLSRC |
VOLUME SOURCE - TBLCM029 |
VS_CD |
| OIU_PR_WCDVLH |
VT_CD |
OIU_PR_WCDVLH |
VT_CD |
OIU_PR_VLTYP |
Volume Type Table - Tblcm010 |
VL_TYPE_CD |
| OIU_PR_WCDVLH |
WC_NO |
OIU_PR_WCDVLH |
WC_NO |
OIU_PR_WC |
PRA: Well Completion |
WC_NO |
| OIU_PR_WCDVLH |
WC_NO |
OIU_PR_WCDVLH |
WL_NO |
OIU_PR_WC |
PRA: Well Completion |
WL_NO |
| OIU_PR_WCDVLH |
WC_NO |
OIU_PR_WCDVLH |
MANDT |
OIU_PR_WC |
PRA: Well Completion |
MANDT |
| OIU_PR_WCDVLH |
WL_NO |
OIU_PR_WCDVLH |
WL_NO |
OIU_PR_WELL |
PRA: Well |
WL_NO |
| OIU_PR_WCDVLH |
WL_NO |
OIU_PR_WCDVLH |
MANDT |
OIU_PR_WELL |
PRA: Well |
MANDT |
| OIU_PR_WCDVLH |
XREF_WC_NO |
OIU_PR_WCDVLH |
XREF_WC_NO |
OIU_PR_WC |
PRA: Well Completion |
WC_NO |
| OIU_PR_WCDVLH |
XREF_WC_NO |
OIU_PR_WCDVLH |
WL_NO |
OIU_PR_WC |
PRA: Well Completion |
WL_NO |
| OIU_PR_WCDVLH |
XREF_WC_NO |
SYST |
MANDT |
OIU_PR_WC |
PRA: Well Completion |
MANDT |
| OIU_PR_WCDVLH |
XREF_WL_NO |
OIU_PR_WCDVLH |
XREF_WL_NO |
OIU_PR_WELL |
PRA: Well |
WL_NO |
| OIU_PR_WCDVLH |
XREF_WL_NO |
SYST |
MANDT |
OIU_PR_WELL |
PRA: Well |
MANDT |
