OIUVL_SCAUDIT

Settlement statement batch | #masterdata | Component: Valuation
Column Name Description
MANDT Client
DOC_NO Val. document number
DOC_YEAR Document year
LINE_ITEM_NO Document Line Item Number
BUKRS FK Company Code
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
SALE_DT Sales Date / Month
WI_OWN_NO FK Working Interest Owner
WI_INT_TYPE_CD FK Participant Interest Type
WI_OWN_ISQ_NO Owner Interest Sequence Number
Column Name Description
💲 Currency Key (GR_VAL_CURR):
ACTL_GR_VAL Actual Gross Value Amount
MKCT_1 Marketing cost amount
MKCT_2 Marketing cost amount
MKCT_3 Marketing cost amount
MKCT_4 Marketing cost amount
MKCT_5 Marketing cost amount
MKCT_6 Marketing cost amount
MKCT_7 Marketing cost amount
MKCT_8 Marketing cost amount
MKCT_9 Marketing cost amount
MKCT_10 Marketing cost amount
MK_RMB_1 Marketing Reimbursement
MK_RMB_2 Marketing Reimbursement
MK_RMB_3 Marketing Reimbursement
MK_RMB_4 Marketing Reimbursement
MK_RMB_5 Marketing Reimbursement
MK_RMB_6 Marketing Reimbursement
MK_RMB_7 Marketing Reimbursement
MK_RMB_8 Marketing Reimbursement
MK_RMB_9 Marketing Reimbursement
MK_RMB_10 Marketing Reimbursement
SVTR_1 Tax or reimbursement amount
SVTR_2 Tax or reimbursement amount
SVTR_3 Tax or reimbursement amount
SVTR_4 Tax or reimbursement amount
SVTR_5 Tax or reimbursement amount
SVTR_6 Tax or reimbursement amount
SVTR_7 Tax or reimbursement amount
SVTR_8 Tax or reimbursement amount
SVTR_9 Tax or reimbursement amount
SEVT_1 Severance tax amount
SEVT_2 Severance tax amount
SEVT_3 Severance tax amount
SEVT_4 Severance tax amount
SEVT_5 Severance tax amount
SEVT_6 Severance tax amount
SEVT_7 Severance tax amount
SEVT_8 Severance tax amount
SEVT_9 Severance tax amount
Column Name Description
📏 Measurement unit (HEAT_VAL_FCT_U):
ACT_HEAT_VAL_FCT Actual Heating Factor
📏 Measurement unit (TOT_GR_VL_U):
ACTL_GR_VL Actual Gross Volume Amount
📏 Measurement unit (WLR_VL_U):
ACTL_WLR_VL Act. Wet-less-Residue Vol. Amount
Column Name Description
SALE_DT Sales Date / Month
SALE_MONTH Sales Month
Column Name Description
TRANSACT_TYPE Transaction Type Show values
SYSTEM_SRCE_CD Valuation Transaction Source Code Show values
TXN_PRCS_CD Transaction Process Code Show values
DOI_SUM_FL Summarize RD to DOI Level Flag Show values
DNTYP Density Type Show values
TAX_CALC_FL Calculate Tax Flag Show values
Column Name Description Domain name
CT_DECM Contract Decimal OIU_PERCENT98
GRV Oil/gas density at standard/base conditions OIU_DICHT
SEVT_TYPE_CD_1 Severance tax type code CHAR2
SEVT_TYPE_CD_2 Severance tax type code CHAR2
SEVT_TYPE_CD_3 Severance tax type code CHAR2
SEVT_TYPE_CD_4 Severance tax type code CHAR2
SEVT_TYPE_CD_5 Severance tax type code CHAR2
SEVT_TYPE_CD_6 Severance tax type code CHAR2
SEVT_TYPE_CD_7 Severance tax type code CHAR2
SEVT_TYPE_CD_8 Severance tax type code CHAR2
SEVT_TYPE_CD_9 Severance tax type code CHAR2
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Company Code
  • OIUVL_SCAUDIT.MANDT == T001.MANDT
  • OIUVL_SCAUDIT.BUKRS == T001.BUKRS
Contract Number
Unit for densities at standard/base conditions
  • OIUVL_SCAUDIT.MANDT == T006.MANDT
  • OIUVL_SCAUDIT.DENSITY_U == T006.MSEHI
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Currency Key
  • OIUVL_SCAUDIT.MANDT == TCURC.MANDT
  • OIUVL_SCAUDIT.GR_VAL_CURR == TCURC.WAERS
Measurement unit
  • OIUVL_SCAUDIT.MANDT == T006.MANDT
  • OIUVL_SCAUDIT.HEAT_VAL_FCT_U == T006.MSEHI
Material Number
Prior Period Adjustment Reason Code
Purchaser
  • OIUVL_SCAUDIT.MANDT == KNA1.MANDT
  • OIUVL_SCAUDIT.PURCH_NO == KNA1.KUNNR
Measurement unit
  • OIUVL_SCAUDIT.MANDT == T006.MANDT
  • OIUVL_SCAUDIT.TOT_GR_VL_U == T006.MSEHI
Volume type code OIUVL_SCAUDIT.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Participant Interest Type OIUVL_SCAUDIT.WI_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Working Interest Owner
  • OIUVL_SCAUDIT.MANDT == KNA1.MANDT
  • OIUVL_SCAUDIT.WI_OWN_NO == KNA1.KUNNR
Measurement unit
  • OIUVL_SCAUDIT.MANDT == T006.MANDT
  • OIUVL_SCAUDIT.WLR_VL_U == T006.MSEHI