OIUVL_SCAUDIT - Settlement statement batch

Settlement statement batch information is stored in SAP table OIUVL_SCAUDIT.
It is part of development package OIU_RVVA in software component IS-OIL-PRA-REV-VAL. This development package consists of objects that can be grouped under "PRA Valuation (Revenue)".

Fields for table OIUVL_SCAUDIT

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6
DOC_NO	Val. document number	X	OIURV_DOCNR	CHAR	40
DOC_YEAR	Document year	X	OIU_DOC_YEAR	NUMC	8
LINE_ITEM_NO	Document Line Item Number	X	OIUVL_LINE_ITEM_NO	NUMC	12
BUKRS	Company Code	X	BUKRS	CHAR	8	T001
VNAME	Joint venture	X	JV_NAME	CHAR	12	OIU_DO_JV
DOI_NO	Division of interest (DOI)	X	OIU_DOI_NO	CHAR	10	OIU_DO_DI
SALE_DT	Sales Date / Month	X	OIU_SALE_DT	DATS	16
WI_OWN_NO	Working Interest Owner	X	OIU_WI_OWN_NO	CHAR	20	KNA1
WI_INT_TYPE_CD	Participant Interest Type	X	OIU_PART_INT_TYPE	CHAR	4	OIU_CM_PINTTY
WI_OWN_ISQ_NO	Owner Interest Sequence Number	X	OIU_OWN_ISQ_NO	CHAR	4
TRANSACT_TYPE	Transaction Type		OIUVL_TRANS_TYPE	CHAR	2
SYSTEM_SRCE_CD	Valuation Transaction Source Code		OIU_VL_SRCE_CD	CHAR	4
SALE_MONTH	Sales Month		OIUVL_SALE_MONTH	DATS	16
TXN_PRCS_CD	Transaction Process Code		OIU_TXN_PRCS_CD	CHAR	4
CT_NO	Contract Number		OIU_CT_NO	CHAR	20	OIUCM_CONTRACT
MATNR	Material Number		MATNR	CHAR	80	OIU_CM_MAT_PRCD
VL_TYPE_CD	Volume type code		OIU_VT_CD	CHAR	4	OIU_PR_VLTYP
DOI_SUM_FL	Summarize RD to DOI Level Flag		OIU_DOI_SUM_FL	CHAR	2
PURCH_NO	Purchaser		OIU_PU_NO	CHAR	20	KNA1
CT_DECM	Contract Decimal		OIU_CT_DECM	DEC	5
HEAT_VAL_FCT_U	Measurement unit		OIU_MEAS_U	UNIT	6	T006
ACT_HEAT_VAL_FCT	Actual Heating Factor		OIU_ACT_HEAT_VAL_FCT	QUAN	7
GRV	Oil/gas density at standard/base conditions		OIU_BDICH	FLTP	8
DENSITY_U	Unit for densities at standard/base conditions		OIU_BDNEH	UNIT	6	T006
DNTYP	Density Type		OIU_DNTYP	CHAR	2
TOT_GR_VL_U	Measurement unit		OIU_MEAS_U	UNIT	6	T006
ACTL_GR_VL	Actual Gross Volume Amount		OIU_ACTL_GR_VL_AM	QUAN	7
WLR_VL_U	Measurement unit		OIU_MEAS_U	UNIT	6	T006
ACTL_WLR_VL	Act. Wet-less-Residue Vol. Amount		OIU_ACTL_WLR_VL_AM	QUAN	7
GR_VAL_CURR	Currency Key		WAERS	CUKY	10	TCURC
ACTL_GR_VAL	Actual Gross Value Amount		OIU_ACTL_GR_VAL_AM	CURR	7
MKCT_1	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_2	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_3	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_4	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_5	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_6	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_7	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_8	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_9	Marketing cost amount		OIUVL_MKCT	CURR	8
MKCT_10	Marketing cost amount		OIUVL_MKCT	CURR	8
MK_RMB_1	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_2	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_3	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_4	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_5	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_6	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_7	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_8	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_9	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
MK_RMB_10	Marketing Reimbursement		OIUVL_MK_RMB	CURR	8
TAX_CALC_FL	Calculate Tax Flag		OIU_TAX_CALC_FL	CHAR	2
SEVT_TYPE_CD_1	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_2	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_3	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_4	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_5	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_6	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_7	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_8	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SEVT_TYPE_CD_9	Severance tax type code		OIU_SEVT_TYPE_CD	CHAR	4
SVTR_1	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_2	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_3	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_4	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_5	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_6	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_7	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_8	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SVTR_9	Tax or reimbursement amount		OIUVL_SVTR	CURR	8
SEVT_1	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_2	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_3	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_4	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_5	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_6	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_7	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_8	Severance tax amount		OIUVL_SEVT	CURR	8
SEVT_9	Severance tax amount		OIUVL_SEVT	CURR	8
PPA_RSN_CD	Prior Period Adjustment Reason Code		OIU_PPA_RSN_CD	CHAR	4	OIU_CM_PPARSN
.INCLUDE				OIU_CREATION	0
OIU_CRUSER	Name of Person Responsible for Creating the Object		ERNAM	CHAR	24
OIU_TIMESTAMP	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8