SAP table OIU_PR_WCDVLH (Well Completion Disposition Volumes Header)

SAP table OIU_PR_WCDVLH has 3 primary key fields being MANDT,WCDVLH_NO,DOC_YEAR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
WCDVLH_NO Well Completion Delivery Volume Header Number CHAR 10 0 OIU_WCDVLH_NO
DOC_YEAR Fiscal Year NUMC 4 0 GJAHR
WL_NO Well ID number CHAR 15 0 OIU_PR_WELL OIU_WL_NO
WC_NO Well Completion Number CHAR 5 0 OIU_PR_WC OIU_WC_NO
DN_NO Delivery network number CHAR 20 0 OIU_PR_DN OIU_DN_NO
EFF_FROM_DT Effective from date DATS 8 0 OIU_EFF_FROM_DT
EFF_TO_DT Effective To Date DATS 8 0 OIU_EFF_TO_DT
PRD_DT Production date DATS 8 0 OIU_PRD_DT
PRD_MATNR Production Material CHAR 40 0 OIU_CM_MAT_PRCD OIU_PRD_MATNR
MATNR Material Number CHAR 40 0 OIU_CM_MAT_PRCD MATNR
FREQ_CD Frequency CHAR 1 0 OIU_FREQ_CD
D Daily
M Monthly
TKBTRY_MP_NO Tank battery measurement point number CHAR 20 0 OIU_PR_MP OIU_TKBTRY_MP_NO
VT_CD Volume type code CHAR 2 0 OIU_PR_VLTYP OIU_VT_CD
VC_CD Volume class code CHAR 1 0 OIU_VC_CD
A Actual
D Designated
E Estimated
VS_CD Volume Source Code CHAR 1 0 OIU_PR_VLSRC OIU_VS_CD
TRNSP_NO Transporter number CHAR 10 0 KNA1 OIU_TRNSP_NO
TRNSP_REF_NO Transporter Reference Number CHAR 25 0 OIU_TRNSP_REF_NO
REC_TYPE_CD Record type code CHAR 4 0 OIU_REC_TYPE_CD
DAYS_PROD Days produced NUMC 2 0 OIU_DAYS_PROD
00 only 0 - 31 days allowed
PRD_HRS Production hours NUMC 3 0 OIU_PRD_HRS
000 only 0-744 hours allowed
TKT_NO Ticket number CHAR 45 0 OIU_TKT_NO
TKT_TIMESTAMP Ticket Timestamp (Date) DEC 15 0 OIU_TKT_TIMESTP
ORIG_MP_NO Original measurement point number CHAR 20 0 OIU_PR_MP OIU_ORIG_MP_NO
ORIG_MP_DOC_NO Original MP document no CHAR 10 0 OIU_ORIG_MP_DOC_NO
ORIG_MP_DOC_YEAR Original document year NUMC 4 0 OIU_ORIG_MP_DOC_YEAR
THEO_U Theoretical Unit UNIT 3 0 T006 OIU_THEO_U
THEO Theoretical Volume QUAN 13 3 OIU_THEO
CONV_GRP Conversion Group (Oil, Natural Gas,..) CHAR 4 0 OIB01 OIB_UMRSL
STD_VOL_U Standard volume unit UNIT 3 0 T006 OIU_STD_VOL_U
STD_VOL Standard volume QUAN 13 3 OIU_STD_VOL
ENERGY_U Energy quantity unit UNIT 3 0 T006 OIU_ENERGY_U
ENERGY Energy quantity QUAN 13 3 OIU_ENERGY
HEAT_VAL_U Heating Value Unit UNIT 3 0 T006 OIU_HEAT_VAL_U
HEAT_VAL Heating value QUAN 13 3 OIU_HEAT_VAL
BASE_DENSITY Oil/gas density at standard/base conditions FLTP 16 16 OIU_BDICH
BASE_DENSITY_U Unit for densities at standard/base conditions UNIT 3 0 * OIU_BDNEH
DENTYP Density Type CHAR 1 0 OIU_DNTYP
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 QUAN 13 3 OIU_MOL_VOLUME
INVT_DT Inventory date DATS 8 0 OIU_INV_DT
XREF_WL_NO Cross-Reference Well Number CHAR 15 0 OIU_PR_WELL OIU_XREF_WL_NO
XREF_WC_NO Cross-Reference Wellcompletion Number CHAR 5 0 OIU_PR_WC OIU_XREF_WC_NO
ORIG_NO Original WCDVL No (Well Completion Daily Volume) NUMC 12 0 OIU_ORIG_NO
ORIG_DOC_YEAR Fiscal Year NUMC 4 0 GJAHR
OIU_CRUSER Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) DEC 15 0 TZNTSTMPS
LD_OIL_WO_RECOV Load Oil Transfer without Recovery CHAR 1 0 OIU_LD_OIL_WO_RECOV
STATUS WC Volume Status Code CHAR 1 0 OIU_WCVL_STS_CD
Successful
D Draft
DRAFT_ME_DOCNR Meas. document number CHAR 10 0 OIU_ME_DOCNR
DRAFT_ME_DOCYR Meas. document year NUMC 4 0 OIU_ME_DOCYR

OIU_PR_WCDVLH foreign key relationships

Table Field Check Table Check Field
0 OIU_PR_WCDVLH DN_NO OIU_PR_DN Delivery Network MANDT
0 OIU_PR_WCDVLH DN_NO OIU_PR_DN Delivery Network DN_NO
1 OIU_PR_WCDVLH ENERGY_U T006 Units of Measurement MANDT
1 OIU_PR_WCDVLH ENERGY_U T006 Units of Measurement MSEHI
0 OIU_PR_WCDVLH HEAT_VAL_U T006 Units of Measurement MANDT
1 OIU_PR_WCDVLH MATNR OIU_CM_MAT_PRCD Material and Product Code (processing) Xref MANDT
0 OIU_PR_WCDVLH ORIG_MP_NO OIU_PR_MP PRA Measurement Points MANDT
0 OIU_PR_WCDVLH ORIG_MP_NO OIU_PR_MP PRA Measurement Points MP_NO
1 OIU_PR_WCDVLH PRD_MATNR OIU_CM_MAT_PRCD Material and Product Code (processing) Xref MANDT
0 OIU_PR_WCDVLH STD_VOL_U T006 Units of Measurement MANDT
0 OIU_PR_WCDVLH STD_VOL_U T006 Units of Measurement MSEHI
1 OIU_PR_WCDVLH THEO_U T006 Units of Measurement MANDT
1 OIU_PR_WCDVLH THEO_U T006 Units of Measurement MSEHI
0 OIU_PR_WCDVLH TKBTRY_MP_NO OIU_PR_MP PRA Measurement Points MANDT
0 OIU_PR_WCDVLH TKBTRY_MP_NO OIU_PR_MP PRA Measurement Points MP_NO
1 OIU_PR_WCDVLH TRNSP_NO KNA1 General Data in Customer Master MANDT
1 OIU_PR_WCDVLH TRNSP_NO KNA1 General Data in Customer Master KUNNR
0 OIU_PR_WCDVLH VS_CD OIU_PR_VLSRC VOLUME SOURCE - TBLCM029 MANDT
0 OIU_PR_WCDVLH VS_CD OIU_PR_VLSRC VOLUME SOURCE - TBLCM029 VS_CD
1 OIU_PR_WCDVLH VT_CD OIU_PR_VLTYP Volume Type Table - Tblcm010 VL_TYPE_CD
0 OIU_PR_WCDVLH WC_NO OIU_PR_WC PRA: Well Completion MANDT
0 OIU_PR_WCDVLH WC_NO OIU_PR_WC PRA: Well Completion WC_NO
1 OIU_PR_WCDVLH WL_NO OIU_PR_WELL PRA: Well MANDT
1 OIU_PR_WCDVLH WL_NO OIU_PR_WELL PRA: Well WL_NO
0 OIU_PR_WCDVLH XREF_WC_NO OIU_PR_WC PRA: Well Completion MANDT
0 OIU_PR_WCDVLH XREF_WC_NO OIU_PR_WC PRA: Well Completion WC_NO
1 OIU_PR_WCDVLH XREF_WL_NO OIU_PR_WELL PRA: Well MANDT
1 OIU_PR_WCDVLH XREF_WL_NO OIU_PR_WELL PRA: Well WL_NO