SAP ABAP Table ROIUX1_TAX_ADJ_DYN (Structure for tax adjustments for display)

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_DYN	Table Relationship Diagram
Short Description	Structure for tax adjustments for display

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
29	TAXHC_SYSNO	☐	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting
30	TAX_TYPE	☐	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
31	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
32	TAX_CLS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
33	TIER_TAX_IND	☐	OIUX1_TIER_TAX_IND	OIUX1_TIER_TAX_IND	CHAR	1	0	Tier tax indicator
34	PDIND	☐	OIUX1_PDIND	OIUX1_PDIND	CHAR	1	0	Purchaser/Producer Indicator
35	AFFL_COMP	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
36	SEV_TAX_PAY_FL	☐	OIU_SEVT_PAY_FL	OIU_SEVT_PAY_FL	CHAR	1	0	Tax Severance Tax Calculation Payment Obligations Types
37	SEV_TAX_RPT_FL	☐	OIU_SEVT_RPT_FL	CHAR1	CHAR	1	0	State Severance Tax Reporting Indicators
38	VL_TAX_RAT	☐	OIUVL_VL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Volume tax rate
39	FX_MCD_RAT	☐	OIUVL_FX_MCD_RAT	OIU_PERCENT52	DEC	5	2	Fixed marketing cost deduction rate
40	VAL_TAX_RAT	☐	OIUVL_VAL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Value tax rate
41	TOT_TAX_PC	☐	OIUVL_TOTAL_TAX_PC	OIU_PERCENT98	DEC	9	8	Total tax percentage
42	ACTL_GR_VL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
43	TAX_FREE_05_VL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
44	BLPS_GR_VL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
45	ACTL_TXVL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
46	ACTL_OVRD_TAXVL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
47	ACTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
48	ACTL_WLR_VL_AM	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
49	TAX_FREE_05_WLR	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
50	ACTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
51	ACTL_ENERGY	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
52	ACTL_ENERGY_U	☐	OIU_ACTL_ENERGY_U	MEINS	UNIT	3	0	Actual Energy Unit	*
53	FX_MCD	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
54	ACTL_GR_VAL_AM	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
55	TAX_FREE_05_VAL	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
56	BLPS_GR_VAL	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
57	ACTL_TXVAL	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
58	ACTL_OVRD_TAXVAL	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
59	ACTL_ST_TAX_AM	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
60	ACTL_ST_TAX_RMB	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
61	GR_VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
62	REJECT_FLAG	☐	OIUREP_REJECT_FLAG	OIUREP_REJECT_FLAG	CHAR	1	0	Reject flag
63	USERNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
64	TIMESTAMP	☐	OIUX1_TIMESTAMP	OII_TIMEST	NUMC	14	0	Time stamp in Numeric Character
65	MTA_MKCT_INT	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
66	MTA_MKCT_EXT	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
67	MTA_MCR_EXT	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
68	EXMP_VL	☐	OIUX1_VOL_DYN	MENGE13	QUAN	13	3	Volume
69	STD_VOL_U	☐	OIU_STD_VOL_U	MEINS	UNIT	3	0	Standard volume unit	*
70	EXMP_VAL	☐	OIUX1_VALUE_DYN	WERTV8	CURR	15	2	Value field for display
71	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_DYN	ADJ_TYPE	OIUX1_ADJ_TYP	ADJ_TYPE
2	ROIUX1_TAX_ADJ_DYN	CT_NO	OIUCM_CONTRACT	VBELN
3	ROIUX1_TAX_ADJ_DYN	DOI_NO	OIU_DO_DI	DOI_NO
4	ROIUX1_TAX_ADJ_DYN	MATNR	MARA	MATNR
5	ROIUX1_TAX_ADJ_DYN	MP_NO	OIU_PR_MP	MP_NO
6	ROIUX1_TAX_ADJ_DYN	RSG	OIUX1_RPT_SGRP	RSG
7	ROIUX1_TAX_ADJ_DYN	VL_TYPE_CD	OIU_PR_VLTYP	VL_TYPE_CD
8	ROIUX1_TAX_ADJ_DYN	VNAME	OIU_DO_JV	VNAME
9	ROIUX1_TAX_ADJ_DYN	WC_NO	OIU_PR_WC	WC_NO
10	ROIUX1_TAX_ADJ_DYN	WL_NO	OIU_PR_WELL	WL_NO

History

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