SAP ABAP Table ROIURV_TAX_COMM (Tax communication)

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_TAX_COMM	Table Relationship Diagram
Short Description	Tax communication

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	VOL_UNIT	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
2	VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
3	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
4	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
5	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
6	MP_TYPE_CD	☐	OIU_MP_TYPE_CD	OIU_MP_TYPE_CD	CHAR	2	0	Measurement point type code	OIU_PR_MPTYP
7	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
8	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code	OIU_CM_PDCD
9	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
10	IOTR_FL	☐	OIU_IOTR_FL	OIU_X_FLAG	CHAR	1	0	Price includes Tax Reimbursement.
11	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
12	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
13	WI_OWN_NO	☐	OIU_WI_OWN_NO	KUNNR	CHAR	10	0	Working Interest Owner	KNA1
14	WI_INT_TYP_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
15	WI_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
16	NI_OWN_NO	☐	OIU_NI_OWN_NO	LIFNR	CHAR	10	0	Net Interest Owner	*
17	NI_INT_TYP_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
18	NI_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
19	SALE_DT	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
20	SYSTEM_SRCE_CD	☐	OIU_VL_SRCE_CD	OIU_VL_SRCE_CD	CHAR	2	0	Valuation Transaction Source Code
21	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
22	VL_GAS_PRICE	☐	OIUVL_VL_GAS_PRICE	OIUVL_AMOUNT16_8	CURR	16	8	Volume gas price
23	TOT_GRI_PC	☐	OIU_TOT_GRI_PC	OIU_PERCENT98	DEC	9	8	Total Gross Interest %
24	TOT_NRI_PC	☐	OIU_TOT_NRI_PC	OIU_PERCENT98	DEC	9	8	Total Net Revenue Interest Percentage
25	TOTAL_PART_INT	☐	OIUVL_TOTAL_PART_INT	OIU_PERCENT98	DEC	9	8	Total participation interest
26	ADJ_CT_DECM	☐	OIU_CT_DECM	OIU_PERCENT98	DEC	9	8	Contract Decimal
27	RMB_SCDWN_PC	☐	OIUVL_RMB_SCDWN_PC	OIU_PERCENT52	DEC	5	2	Reimbursement scaledown percentage
28	SALE_DT_TO	☐	OIU_SA_DT_TO	DATUM	DATS	8	0	Sales To-Date
29	SALE_DT_FROM	☐	OIU_SA_DT_FROM	DATUM	DATS	8	0	Sales From-Date
30	ONS_OFFS_CD	☐	OIU_ONS_OFS_CD	OIU_ONS_OFS_CD	CHAR	1	0	Onshore/Offshore codes
31	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	OIU_CM_SCHDCD
32	TAX_CLASS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
33	PRD_DAYS	☐	OIU_DAYS_PROD	OIU_DAYS_PROD	NUMC	2	0	Days produced
34	KS_ADP_VAL	☐	OIUVL_KS_ADP_VAL	MENGE	QUAN	13	3	Kansas average daily production value
35	PC_RET_LSE	☐	OIU_PCT_RET_LSE	OIU_PERCENT74	DEC	7	4	Percent Returned to Lease
36	CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	*
37	GRV	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
38	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
39	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	OIU_CM_LXSGL
40	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
41	ENTY_CD	☐	OIU_ENTY_CD	OIU_ENTITY_CD	CHAR	2	0	Entity Code
42	OWN_ENTL_FL	☐	OIUVL_OWN_ENTL_FL	OIU_FLAG	CHAR	1	0	Owner entitled flag
43	EXEMPT_OWN_FL	☐	OIUVL_EXEMPT_OWN_FL	OIU_FLAG	CHAR	1	0	Exempt owner flag
44	TIER_TAX_DECM	☐	OIUVL_TIER_TAX_DECM	OIU_PERCENT74	DEC	7	4	Tier tax decimal
45	ACTL_ENTL_SETT	☐	OIUVL_ACTL_ENTL_SETT	OIU_FLAG	CHAR	1	0	Actual/entitled/settlement indicator
46	MKTG_FREE_FL	☐	OIUVL_MKTG_FREE_FL	OIU_FLAG	CHAR	1	0	Marketing free flag
47	ONE_PC_GAS_RMB_FL	☐	OIUVL_ONE_PC_GAS_RMB_FL	OIUVL_ONE_PC_GAS_RMB_FL	CHAR	1	0	One percent tax reimbursement
48	VOL_RATE_MIN	☐	OIUVL_VOL_RATE_MIN	OIU_PERCENT76	DEC	7	6	Volume Rate Minimum
49	VOL_RATE_MAX	☐	OIUVL_VOL_RATE_MAX	OIU_PERCENT76	DEC	7	6	Volume Rate Maximum
50	VAL_RATE_MIN	☐	OIUVL_VAL_RATE_MIN	OIU_PERCENT76	DEC	7	6	Valuation Rate Minimum
51	VAL_RATE_MAX	☐	OIUVL_VAL_RATE_MAX	OIU_PERCENT76	DEC	7	6	Valuation Rate Maximum
52	TRNSP_CALC_COST_PER_BBL	☐	OIUVL_TRNSP_CALC_COST_PER_BBL	WERT8	CURR	15	2	Transportation calculation cost per barrel
53	TRNSP_CALC_COST_25C_BBL	☐	OIUVL_TRNSP_CALC_COST_25C_BBL	WERT8	CURR	15	2	Override tax value
54	CT_PRC_CD	☐	OIUVL_CT_PRC_CD	OIUVL_CT_PRC_CD	CHAR	2	0	Contract price code
55	RMB_TAX_RAT	☐	OIUVL_RMB_TAX_RAT	OIU_PERCENT76	DEC	7	6	Reimbursement tax rate
56	RPA_ALLW_FL	☐	OIUVL_RPA_ALLW_FL	OIUVL_RPA_ALLW_FL	CHAR	1	0	Royalty processing allowance allowed
57	PRC_INCL_TAX_FL	☐	OIUVL_PRC_INCL_TAX_FL	OIUVL_PRC_INCL_TAX_FL	CHAR	1	0	Indicator if state allows the price to include tax option
58	GR_UP_RMB_FL	☐	OIUVL_GR_UP_RMB_FL	OIU_FLAG	CHAR	1	0	Gross up reimbursement amount
59	CALC_TAX_FL	☐	OIU_TAX_CALC_FL	OIU_X_FLAG	CHAR	1	0	Calculate Tax Flag
60	ENTL_GR_VL	☐	OIU_ENTL_GR_VL_AM	MENGE	QUAN	13	3	Entitled Gross Volume Amount
61	ENTL_GR_VAL	☐	OIU_ENTL_GR_VAL_AM	WERT7	CURR	13	2	Entitled Gross Value Amount
62	PRCS_EXMP_FL	☐	OIUVL_PRCS_EXMP_FL	OIU_FLAG	CHAR	1	0	Process tax-free amounts
63	SEVT_TAX_TY	☐	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
64	SEV_TAX_PAY_FL	☐	OIU_SEVT_PAY_FL	OIU_SEVT_PAY_FL	CHAR	1	0	Tax Severance Tax Calculation Payment Obligations Types
65	VL_TAX_RAT	☐	OIUVL_VL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Volume tax rate
66	VAL_TAX_RAT	☐	OIUVL_VAL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Value tax rate
67	TAX_FREE_05_PC	☐	OIUVL_TAX_FREE_05_PC	OIU_PERCENT98	DEC	9	8	Tax free 05 percentage
68	ACTL_OVRD_TAX_VL	☐	OIUVL_OVRD_TAX_VL	MENGE	QUAN	13	3	Override tax volume
69	ACTL_OVRD_TAX_VAL	☐	OIUVL_OVRD_TAX_VAL	WERT8	CURR	15	2	Override tax value
70	ENTL_OVRD_TAX_VL	☐	OIUVL_ENTL_OVRD_TAX_VL	MENGE	QUAN	13	3	Entitled override taxable volume
71	ENTL_OVRD_TAX_VAL	☐	OIUVL_ENTL_OVRD_TAX_VAL	WERT8	CURR	15	2	Entitled override taxable value
72	FX_MCD_RAT	☐	OIUVL_FX_MCD_RAT	OIU_PERCENT52	DEC	5	2	Fixed marketing cost deduction rate
73	FX_MCD	☐	OIU_FIX_MKT_DED	OIU_SIGNED_CURR_11_2	CURR	11	2	Fixed Marketing Deduct
74	TAX_RMB_PC	☐	OIUVL_TAX_RMB_PC	OIU_PERCENT52	DEC	5	2	Tax reimbursement percentage
75	ST_TAX_PC	☐	OIUVL_ST_TAX_PC	OIUVL_PERCENT139	DEC	13	9	State tax percentage
76	TOTAL_EXMP_VL	☐	OIUVL_TOTAL_EXMPT_VL	MENGE	QUAN	13	3	Total exempt volume
77	TOTAL_EXMP_VAL	☐	OIUVL_TOTAL_EXMPT_VAL	WERT8	CURR	15	2	Total exempt value
78	LVL_CD	☐	OIU_LVL_CD	OIU_LVL_CD	NUMC	2	0	Level Code
79	FRML_ACTL_FL	☐	OIU_ACTL_FL	OIU_X_FLAG	CHAR	1	0	Actual indicator
80	FRML_ENTL_FL	☐	OIU_ENTL_FL	OIU_X_FLAG	CHAR	1	0	Entitled Flag
81	FRML_SETT_FL	☐	OIU_SETT_FL	OIU_X_FLAG	CHAR	1	0	Settlement Flag
82	RM_FEE_FL	☐	OIU_RM_FEE_FL	OIU_X_FLAG	CHAR	1	0	CO2 Removal Fee Flag
83	WL_BASE_VOL_PC	☐	OIUVL_WL_BASE_VL_PC	OIUVL_PERCENT109	DEC	10	9	Well base volume percentage
84	TXN_TYPE	☐	OIUVL_TXN_TYPE	OIUVL_TXN_TYPE	CHAR	1	0	Transaction type
85	GR_VL	☐	OIUVL_GR_VL	MENGE	QUAN	13	3	Gross volume
86	GR_VAL	☐	OIUVL_GR_VAL	WERT8	CURR	15	2	Gross value
87	WLR_VL	☐	OIUVL_WLR_VL	MENGE	QUAN	13	3	Wet-less-residue volume
88	TAX_FREE_05_VL	☐	OIUVL_TAX_FREE_VL	MENGE	QUAN	13	3	Tax free 05 volume
89	TAX_FREE_05_VAL	☐	OIUVL_TAX_FREE_VAL	WERT8	CURR	15	2	Tax free 05 value
90	TAX_FREE_05_WLR	☐	OIUVL_TAX_FREE_WLR	MENGE	QUAN	13	3	Tax free 05 wet-less-residue
91	TOTAL_TAX_PC	☐	OIUVL_TOTAL_TAX_PC	OIU_PERCENT98	DEC	9	8	Total tax percentage
92	TOTAL_TAX_EXIN	☐	OIUVL_TOTAL_TAX_EXIN_PC	OIU_PERCENT98	DEC	9	8	Total tax exempt interest
93	TOT_TAX_REIMB_PC	☐	OIUVL_TOL_TAX_REIMB_PC	OIU_PERCENT98	DEC	9	8	Total tax reimbursement percentage
94	ST_TAX_ALLOW	☐	OIUVL_TAX_ALLOWANCE	OIU_PERCENT98	DEC	9	8	Tax allowance
95	BLPS_GR_VL	☐	OIUVL_BLPS_GR_VL	MENGE	QUAN	13	3	Before lease plant split gross volume
96	BLPS_GR_VAL	☐	OIUVL_BLPS_GR_VAL	WERT8	CURR	15	2	Before lease plant split gross value
97	GR_ST_TAX	☐	OIUVL_GR_ST_TAX	WERT8	CURR	15	2	Gross state tax
98	ST_TAX	☐	OIUVL_ST_TAX	WERT8	CURR	15	2	State tax
99	TXVL	☐	OIUVL_TXVL	MENGE	QUAN	13	3	Taxable volume
100	TXVAL	☐	OIUVL_TXVAL	WERT8	CURR	15	2	Taxable value
101	ST_TAX_REIMB	☐	OIUVL_ST_TAX_REIMB	WERT8	CURR	15	2	State Tax reimbursement amount
102	ST_TAX_PROC_ALLOW	☐	OIUVL_ST_TAX_PROC_ALLOW	WERT8	CURR	15	2	State tax processing allowance
103	PRC_LIM_AM	☐	OIUVL_PRC_LIM_AM	WERT7	CURR	13	2	Price Limit
104	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	*
105	KS_TAX_CLS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
106	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIUCM_CONTRACT
107	INCL_TAX_FREE_05	☐	OIUVL_INCL_TAX_FREE_05	OIU_FLAG	CHAR	1	0	Include Tax Free 05 in taxable value/volume summarization
108	TCD_VT_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
109	FREQ_CD	☐	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
110	ACT_VOL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
111	ENT_VOL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
112	ACT_VAL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
113	ENT_VAL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
114	SET_VOL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
115	SET_VAL_OVR	☐	OIU_OVERRIDE_FL		CHAR	1	0	Override flag
116	SETT_OVRD_TAX_VL	☐	OIUVL_ENTL_OVRD_TAX_VL	MENGE	QUAN	13	3	Entitled override taxable volume
117	SETT_OVRD_TAX_VAL	☐	OIUVL_ENTL_OVRD_TAX_VAL	WERT8	CURR	15	2	Entitled override taxable value

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIURV_TAX_COMM	BUKRS	T001	BUKRS		1	CN
2	ROIURV_TAX_COMM	CT_NO	OIUCM_CONTRACT	VBELN		1	CN
3	ROIURV_TAX_COMM	DOI_NO	OIU_DO_DI	DOI_NO		1	CN
4	ROIURV_TAX_COMM	MAJPD_CD	OIU_CM_PDCD	MAJPD_CD
5	ROIURV_TAX_COMM	MATNR	OIU_CM_MAT_PRCD	MATNR		1	CN
6	ROIURV_TAX_COMM	MP_NO	OIU_PR_MP	MP_NO		1	CN
7	ROIURV_TAX_COMM	MP_TYPE_CD	OIU_PR_MPTYP	MP_TYPE_CD
8	ROIURV_TAX_COMM	NI_INT_TYP_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD		1	N
9	ROIURV_TAX_COMM	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
10	ROIURV_TAX_COMM	SCHOOL_DIST_CD	OIU_CM_SCHDCD	SCHOOL_DIST_CD		1	CN
11	ROIURV_TAX_COMM	SEC_GEO_LOC	OIU_CM_LXSGL	SEC_GEO_LOC		1	CN
12	ROIURV_TAX_COMM	TCD_VT_CD	OIU_PR_VLTYP	VL_TYPE_CD
13	ROIURV_TAX_COMM	VAL_CURR	TCURC	WAERS		1	CN
14	ROIURV_TAX_COMM	VL_TYPE_CD	OIU_PR_VLTYP	VL_TYPE_CD
15	ROIURV_TAX_COMM	VNAME	OIU_DO_JV	VNAME		1	CN
16	ROIURV_TAX_COMM	VOL_UNIT	T006	MSEHI		1	CN
17	ROIURV_TAX_COMM	WC_NO	OIU_PR_WC	WC_NO		1	CN
18	ROIURV_TAX_COMM	WI_INT_TYP_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD		1	N
19	ROIURV_TAX_COMM	WI_OWN_NO	KNA1	KUNNR		1	CN
20	ROIURV_TAX_COMM	WL_NO	OIU_PR_WELL	WL_NO		1	CN

History

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