SAP table OIU_RV_FRML (Valuation Formula Id)
SAP table OIU_RV_FRML has 2 primary key fields being MANDT,FRML_NO.
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
FRML_NO
Formula number
CHAR
8
0
OIU_FRML_NO
FRML_DESC
Formula Description
CHAR
35
0
OIU_FRML_DESC
SHTXT
Description
CHAR
35
0
OIU_SHTXT
VL_TYPE_CD
Volume type code
CHAR
2
0
OIU_PR_VLTYP
OIU_VT_CD
VL_CLS_CD
Volume Class Code
CHAR
1
0
OIU_VL_CLS_CD
LPRD_PRCS_DT
Last Production Process Date
DATS
8
0
OIU_LPRD_PRCS_DT
ENQ_SEL_FLAG
Enq Selection Flag
CHAR
1
0
OIU_ENQ_SEL_FLAG
ACTL_FL
Actual indicator
CHAR
1
0
OIU_ACTL_FL
ENTL_FL
Entitled Flag
CHAR
1
0
OIU_ENTL_FL
SETT_FL
Settlement Flag
CHAR
1
0
OIU_SETT_FL
MAJPD_CD
Major product code
CHAR
1
0
OIU_MAJPD_CD
Possible values
1
Oil
2
Natural Gas
3
Condensate
4
Plant NGLS
5
Water
7
Sulfur
9
Injectants
MATNR
Material Number
CHAR
40
0
OIU_CM_MAT_PRCD
MATNR
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
OIU_RV_FRML foreign key relationships
Table
Field
Check Table
Check Field
0 OIU_RV_FRML
MATNR
OIU_CM_MAT_PRCD
Material and Product Code (processing) Xref
MANDT
1 OIU_RV_FRML
VL_TYPE_CD
OIU_PR_VLTYP
Volume Type Table - Tblcm010
VL_TYPE_CD