SAP ABAP Table ROIURV_SCTXNS1 (Settlement statement/CI transaction)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
     ⤷ OIU_RVDC (Package) PRA Valuation (Document Concept)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIURV_SCTXNS1	Table Relationship Diagram
Short Description	Settlement statement/CI transaction

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SCTXNS_NO	☐	OIUVL_SCTXNS_NO	OIU_SYS_NO	NUMC	12	0	Document number for the transaction
2	DOC_NO	☐	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
3	DOC_YEAR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
4	DOC_DT	☐	OIUVL_DOC_DT	OIUVL_DOC_DT	DATS	8	0	Document date
5	TXN_TYPE	☐	OIUVL_TXN_TYPE	OIUVL_TXN_TYPE	CHAR	1	0	Transaction type
6	SETT_REF_NO	☐	OIUVL_SETT_REF_NO	CHAR18	CHAR	18	0	Settlement statement identification number
7	DOC_REF_NO	☐	OIUVL_DOC_REF_NO	OIUVL_DOC_REF_NO	CHAR	10	0	Related Document
8	PU_NO	☐	OIU_PU_NO	KUNNR	CHAR	10	0	Purchaser	KNA1
9	LINE_ITEM_NO	☐	OIU_LIN_NO	NUMC5	NUMC	5	0	Line Number
10	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	OIU_CM_PPARSN
11	REJ_RSN_CD	☐	OIU_REJ_RSN_CD	OIU_REJ_RSN_CD	CHAR	3	0	Rejection Reason Code	OIU_CM_REJCD
12	VL_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
13	SETT_MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
14	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
15	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code	OIU_CM_PDCD
16	SETT_BUKRS	☐	OIUVL_SETT_BUKRS	BUKRS	CHAR	4	0	Settlement Company Code	*
17	SETT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
18	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
19	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
20	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
21	COST_CENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
22	LVL_CD	☐	OIU_LVL_CD	OIU_LVL_CD	NUMC	2	0	Level Code
23	WI_OWN_NO	☐	OIU_WI_OWN_NO	KUNNR	CHAR	10	0	Working Interest Owner	KNA1
24	WI_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
25	WI_OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
26	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIUCM_CONTRACT
27	CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	OIU_CM_CTTYP
28	FREQ_CD	☐	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
29	SALE_DT	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
30	UNIT_BUKRS	☐	OIUVL_UNIT_BUKRS	BUKRS	CHAR	4	0	Unit Company Code	*
31	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
32	DOI_SUM_FL	☐	OIU_DOI_SUM_FL	OIU_X_FLAG	CHAR	1	0	Summarize RD to DOI Level Flag
33	TXN_PRCS_CD	☐	OIU_TXN_PRCS_CD	OIU_TXN_PRCS_CD	CHAR	2	0	Transaction Process Code
34	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
35	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
36	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
37	ONS_OFFS_CD	☐	OIU_ONS_OFS_CD	OIU_ONS_OFS_CD	CHAR	1	0	Onshore/Offshore codes
38	SYSTEM_SRCE_CD	☐	OIU_VL_SRCE_CD	OIU_VL_SRCE_CD	CHAR	2	0	Valuation Transaction Source Code
39	VNAME_TYPE_CD	☐	OIU_VNAME_TYPE_CD	OIU_PR_TYPE_CD	CHAR	2	0	Venture Usage Type
40	THEO_CND_TAX_FL	☐	OIU_THEO_CND_TAX_FL	OIU_X_FLAG	CHAR	1	0	Theoretical Condensate Tax Calculation Flag
41	TOT_GRI_PC	☐	OIU_TOT_GRI_PC	OIU_PERCENT98	DEC	9	8	Total Gross Interest %
42	CT_DECM	☐	OIU_CT_DECM	OIU_PERCENT98	DEC	9	8	Contract Decimal
43	REL_CT_DECM	☐	OIU_REL_CT_DECM	OIU_PERCENT98	DEC	9	8	Relative Contract Decimal
44	TOT_MKT_GRP_GRI	☐	OIU_TOT_MKT_GRP_GRI	OIU_PERCENT98	DEC	9	8	Total Market Groups GRI
45	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
46	TOT_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	T006
47	ACTL_GR_VL	☐	OIU_ACTL_GR_VL_AM	MENGE	QUAN	13	3	Actual Gross Volume Amount
48	ENERGY_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	T006
49	ACTL_ENERGY	☐	OIU_ACTL_ENERGY	MENGE	QUAN	13	3	Actual Energy
50	GRV	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
51	DENSITY_U	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
52	DNTYP	☐	OIB_DNTYP	OIB_DNTYP	CHAR	1	0	Density Type
53	HEAT_VAL_FCT_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	T006
54	ACT_HEAT_VAL_FCT	☐	OIU_ACT_HEAT_VAL_FCT	MENGE	QUAN	13	3	Actual Heating Factor
55	WLR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	T006
56	ACTL_WLR_VL	☐	OIU_ACTL_WLR_VL_AM	MENGE	QUAN	13	3	Act. Wet-less-Residue Vol. Amount
57	GR_VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
58	ACTL_GR_VAL	☐	OIU_ACTL_GR_VAL_AM	WERT7	CURR	13	2	Actual Gross Value Amount
59	TAX_CALC_FL	☐	OIU_TAX_CALC_FL	OIU_X_FLAG	CHAR	1	0	Calculate Tax Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIURV_SCTXNS1	BUKRS	T001	BUKRS		1	CN
2	ROIURV_SCTXNS1	CT_NO	OIUCM_CONTRACT	VBELN		1	CN
3	ROIURV_SCTXNS1	CT_TYPE_CD	OIU_CM_CTTYP	CT_TYPE_CD
4	ROIURV_SCTXNS1	DENSITY_U	T006	MSEHI		1	CN
5	ROIURV_SCTXNS1	DOI_NO	OIU_DO_DI	DOI_NO		1	CN
6	ROIURV_SCTXNS1	ENERGY_U	T006	MSEHI		1	CN
7	ROIURV_SCTXNS1	GR_VAL_CURR	TCURC	WAERS		1	CN
8	ROIURV_SCTXNS1	HEAT_VAL_FCT_U	T006	MSEHI		1	CN
9	ROIURV_SCTXNS1	LAND1	T005	LAND1		1	CN
10	ROIURV_SCTXNS1	MAJPD_CD	OIU_CM_PDCD	MAJPD_CD
11	ROIURV_SCTXNS1	MATNR	OIU_CM_MAT_PRCD	MATNR		1	CN
12	ROIURV_SCTXNS1	PPA_RSN_CD	OIU_CM_PPARSN	PPA_RSN_CD		1	CN
13	ROIURV_SCTXNS1	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
14	ROIURV_SCTXNS1	PU_NO	KNA1	KUNNR		1	CN
15	ROIURV_SCTXNS1	REJ_RSN_CD	OIU_CM_REJCD	REJ_RSN_CD
16	ROIURV_SCTXNS1	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC		1	CN
17	ROIURV_SCTXNS1	SETT_MATNR	OIU_CM_MAT_PRCD	MATNR		1	CN
18	ROIURV_SCTXNS1	SETT_VNAME	OIU_DO_JV	VNAME		1	CN
19	ROIURV_SCTXNS1	TOT_GR_VL_U	T006	MSEHI		1	CN
20	ROIURV_SCTXNS1	UNIT_VNAME	OIU_DO_JV	VNAME		1	CN
21	ROIURV_SCTXNS1	VL_TYPE_CD	OIU_PR_VLTYP	VL_TYPE_CD
22	ROIURV_SCTXNS1	VNAME	OIU_DO_JV	VNAME		1	CN
23	ROIURV_SCTXNS1	WI_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD		1	N
24	ROIURV_SCTXNS1	WI_OWN_NO	KNA1	KUNNR		1	CN
25	ROIURV_SCTXNS1	WLR_VL_U	T006	MSEHI		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C