SAP ABAP Table OIUX1_TRN_TAXDL (Tax transaction detail for reporting)

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	TRANSP	Transparent table
Transparent table	OIUX1_TRN_TAXDL	Table Relationship Diagram
Short Description	Tax transaction detail for reporting

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	TAXHC_SYSNO	☑	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting
3	TAX_TYPE	☑	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
4	SCHOOL_DIST_CD	☑	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
5	TAX_CLS	☑	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
6	TIER_TAX_IND	☑	OIUX1_TIER_TAX_IND	OIUX1_TIER_TAX_IND	CHAR	1	0	Tier tax indicator
7	PDIND	☑	OIUX1_PDIND	OIUX1_PDIND	CHAR	1	0	Purchaser/Producer Indicator
8	AFFL_COMP	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
9	SEV_TAX_PAY_FL	☐	OIU_SEVT_PAY_FL	OIU_SEVT_PAY_FL	CHAR	1	0	Tax Severance Tax Calculation Payment Obligations Types
10	ACTL_GR_VL	☐	OIU_ACTL_GR_VL_AM	MENGE	QUAN	13	3	Actual Gross Volume Amount
11	TAX_FREE_05_VL	☐	OIUVL_TAX_FREE_VL	MENGE	QUAN	13	3	Tax free 05 volume
12	BLPS_GR_VL	☐	OIUVL_BLPS_GR_VL	MENGE	QUAN	13	3	Before lease plant split gross volume
13	ACTL_TXVL	☐	OIUVL_ACTL_TXVL	MENGE	QUAN	13	3	Actual taxable volume
14	ACTL_OVRD_TAXVL	☐	OIUVL_ACTL_OVRD_TAX_VL	MENGE	QUAN	13	3	Actual override taxable volume
15	ACTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
16	ACTL_WLR_VL_AM	☐	OIU_ACTL_WLR_VL_AM	MENGE	QUAN	13	3	Act. Wet-less-Residue Vol. Amount
17	TAX_FREE_05_WLR	☐	OIUVL_TAX_FREE_WLR	MENGE	QUAN	13	3	Tax free 05 wet-less-residue
18	ACTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
19	ACTL_ENERGY	☐	OIU_ACTL_ENERGY	MENGE	QUAN	13	3	Actual Energy
20	ACTL_ENERGY_U	☐	OIU_ACTL_ENERGY_U	MEINS	UNIT	3	0	Actual Energy Unit	*
21	FX_MCD	☐	OIUVL_FX_MCD	WERT8	CURR	15	2	Fixed marketing cost deduction
22	ACTL_GR_VAL_AM	☐	OIU_ACTL_GR_VAL_AM	WERT7	CURR	13	2	Actual Gross Value Amount
23	TAX_FREE_05_VAL	☐	OIUVL_TAX_FREE_VAL	WERT8	CURR	15	2	Tax free 05 value
24	BLPS_GR_VAL	☐	OIUVL_BLPS_GR_VAL	WERT8	CURR	15	2	Before lease plant split gross value
25	ST_TAX_PROC_ALLW	☐	OIUVL_ST_TAX_PROC_ALLOW	WERT8	CURR	15	2	State tax processing allowance
26	ACTL_TXVAL	☐	OIUVL_ACTL_TXVAL	WERT8	CURR	15	2	Actual taxable value
27	ACTL_OVRD_TAXVAL	☐	OIUVL_ACTL_OVRD_TAX_VAL	WERT8	CURR	15	2	Actual override taxable value
28	ACTL_ST_TAX_AM	☐	OIUVL_ACTL_ST_TAX_AM	WERT8	CURR	15	2	Actual state tax amount
29	ACTL_ST_TAX_RMB	☐	OIUVL_ACTL_ST_TAX_REIMB	WERT8	CURR	15	2	Actual state tax reimbursement
30	GR_VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
31	.INCLUDE	☐				0	0	Execution Parameters for Tax Reporting
32	RPT_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
33	RSG	☐	OIUX1_RSG	OIUX1_RSG	CHAR	4	0	Report Submission Group	OIUX1_RPT_SGRP
34	AGENCY	☐	OIUX1_TAX_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
35	OGIND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
36	USERNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
37	TIMESTAMP	☐	OIUX1_TIMESTAMP	OII_TIMEST	NUMC	14	0	Time stamp in Numeric Character

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUX1_TRN_TAXDL	RSG	OIUX1_RPT_SGRP	RSG

History

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