SAP ABAP Table ROIUX1_TAX_ADJ (Structure for tax adjustments)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X1 (Package) PRA Tax Reporting - Tax Reporting Framework

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX1_TAX_ADJ	Table Relationship Diagram
Short Description	Structure for tax adjustments

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	.INCLUDE	☐				0	0	Execution Parameters for Tax Reporting
2	RPT_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	RSG	☐	OIUX1_RSG	OIUX1_RSG	CHAR	4	0	Report Submission Group	OIUX1_RPT_SGRP
4	AGENCY	☐	OIUX1_TAX_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
5	OGIND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
8	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
9	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
10	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
11	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
12	SALES_YYYYMM	☐	OIUREP_SALES_YYYYMM	OIUREP_SALES_YYYYMM	NUMC	6	0	Sales YYYYMM
13	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
14	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIUCM_CONTRACT
15	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
16	ADJ_TYPE	☐	OIUX1_ADJ_TYPE	OIUX1_ADJ_TYPE	CHAR	2	0	Adjustment type for Tax reporting	OIUX1_ADJ_TYP
17	DOC_YEAR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
18	DOC_NO	☐	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
19	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
20	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	*
21	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
22	PU_NO	☐	OIU_PU_NO	KUNNR	CHAR	10	0	Purchaser	*
23	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	*
24	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	*
25	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
26	GRV_AM	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
27	PRD_DAYS	☐	OIU_DAYS_PROD	OIU_DAYS_PROD	NUMC	2	0	Days produced
28	.INCLUDE	☐				0	0	Tax transaction detail for reporting
29	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
30	TAXHC_SYSNO	☐	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting
31	TAX_TYPE	☐	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
32	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
33	TAX_CLS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
34	TIER_TAX_IND	☐	OIUX1_TIER_TAX_IND	OIUX1_TIER_TAX_IND	CHAR	1	0	Tier tax indicator
35	PDIND	☐	OIUX1_PDIND	OIUX1_PDIND	CHAR	1	0	Purchaser/Producer Indicator
36	AFFL_COMP	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
37	SEV_TAX_PAY_FL	☐	OIU_SEVT_PAY_FL	OIU_SEVT_PAY_FL	CHAR	1	0	Tax Severance Tax Calculation Payment Obligations Types
38	SEV_TAX_RPT_FL	☐	OIU_SEVT_RPT_FL	CHAR1	CHAR	1	0	State Severance Tax Reporting Indicators
39	VL_TAX_RAT	☐	OIUVL_VL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Volume tax rate
40	FX_MCD_RAT	☐	OIUVL_FX_MCD_RAT	OIU_PERCENT52	DEC	5	2	Fixed marketing cost deduction rate
41	VAL_TAX_RAT	☐	OIUVL_VAL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Value tax rate
42	TOT_TAX_PC	☐	OIUVL_TOTAL_TAX_PC	OIU_PERCENT98	DEC	9	8	Total tax percentage
43	ACTL_GR_VL	☐	OIU_ACTL_GR_VL_AM	MENGE	QUAN	13	3	Actual Gross Volume Amount
44	TAX_FREE_05_VL	☐	OIUVL_TAX_FREE_VL	MENGE	QUAN	13	3	Tax free 05 volume
45	BLPS_GR_VL	☐	OIUVL_BLPS_GR_VL	MENGE	QUAN	13	3	Before lease plant split gross volume
46	ACTL_TXVL	☐	OIUVL_ACTL_TXVL	MENGE	QUAN	13	3	Actual taxable volume
47	ACTL_OVRD_TAXVL	☐	OIUVL_ACTL_OVRD_TAX_VL	MENGE	QUAN	13	3	Actual override taxable volume
48	ACTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
49	ACTL_WLR_VL_AM	☐	OIU_ACTL_WLR_VL_AM	MENGE	QUAN	13	3	Act. Wet-less-Residue Vol. Amount
50	TAX_FREE_05_WLR	☐	OIUVL_TAX_FREE_WLR	MENGE	QUAN	13	3	Tax free 05 wet-less-residue
51	ACTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
52	ACTL_ENERGY	☐	OIU_ACTL_ENERGY	MENGE	QUAN	13	3	Actual Energy
53	ACTL_ENERGY_U	☐	OIU_ACTL_ENERGY_U	MEINS	UNIT	3	0	Actual Energy Unit	*
54	FX_MCD	☐	OIUVL_FX_MCD	WERT8	CURR	15	2	Fixed marketing cost deduction
55	ACTL_GR_VAL_AM	☐	OIU_ACTL_GR_VAL_AM	WERT7	CURR	13	2	Actual Gross Value Amount
56	TAX_FREE_05_VAL	☐	OIUVL_TAX_FREE_VAL	WERT8	CURR	15	2	Tax free 05 value
57	BLPS_GR_VAL	☐	OIUVL_BLPS_GR_VAL	WERT8	CURR	15	2	Before lease plant split gross value
58	ST_TAX_PROC_ALLW	☐	OIUVL_ST_TAX_PROC_ALLOW	WERT8	CURR	15	2	State tax processing allowance
59	ACTL_TXVAL	☐	OIUVL_ACTL_TXVAL	WERT8	CURR	15	2	Actual taxable value
60	ACTL_OVRD_TAXVAL	☐	OIUVL_ACTL_OVRD_TAX_VAL	WERT8	CURR	15	2	Actual override taxable value
61	ACTL_ST_TAX_AM	☐	OIUVL_ACTL_ST_TAX_AM	WERT8	CURR	15	2	Actual state tax amount
62	ACTL_ST_TAX_RMB	☐	OIUVL_ACTL_ST_TAX_REIMB	WERT8	CURR	15	2	Actual state tax reimbursement
63	GR_VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
64	REJECT_FLAG	☐	OIUREP_REJECT_FLAG	OIUREP_REJECT_FLAG	CHAR	1	0	Reject flag
65	USERNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
66	TIMESTAMP	☐	OIUX1_TIMESTAMP	OII_TIMEST	NUMC	14	0	Time stamp in Numeric Character
67	MTA_MKCT_INT	☐	OIUVL_ACTL_MKCT_INT	WERT8	CURR	15	2	Actual marketing cost internal
68	MTA_MKCT_EXT	☐	OIUVL_ACTL_MKCT_EXT	WERT8	CURR	15	2	Actual marketing cost external
69	MTA_MCR_EXT	☐	OIUVL_ACTL_MCR_EXT	WERT8	CURR	15	2	Actual marketing cost reimbursement external
70	EXMP_VL	☐	OIUVL_EXMP_VL	MENGE	QUAN	13	3	Exempt volume
71	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	*
72	EXMP_VAL	☐	OIUVL_EXMP_VAL	WERT8	CURR	15	2	Exempt value
73	CURRENCY	☐	OIUREP_CURRENCY	WAERS	CUKY	5	0	Currency	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUX1_TAX_ADJ	ADJ_TYPE	OIUX1_ADJ_TYP	ADJ_TYPE
2	ROIUX1_TAX_ADJ	CT_NO	OIUCM_CONTRACT	VBELN
3	ROIUX1_TAX_ADJ	DOI_NO	OIU_DO_DI	DOI_NO
4	ROIUX1_TAX_ADJ	MATNR	MARA	MATNR
5	ROIUX1_TAX_ADJ	MP_NO	OIU_PR_MP	MP_NO
6	ROIUX1_TAX_ADJ	RSG	OIUX1_RPT_SGRP	RSG
7	ROIUX1_TAX_ADJ	VL_TYPE_CD	OIU_PR_VLTYP	VL_TYPE_CD
8	ROIUX1_TAX_ADJ	VNAME	OIU_DO_JV	VNAME
9	ROIUX1_TAX_ADJ	WC_NO	OIU_PR_WC	WC_NO
10	ROIUX1_TAX_ADJ	WL_NO	OIU_PR_WELL	WL_NO

History

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