SAP ABAP Table ROIUX1_TRN_TAX (Structure for both header and detail)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX1_TRN_TAX	Table Relationship Diagram
Short Description	Structure for both header and detail

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	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
2	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
3	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
4	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
5	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	*
6	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
7	SALE_DT	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
9	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	*
10	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	*
11	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	*
12	TAXHC_SYSNO	☐	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting
13	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
14	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
15	PU_NO	☐	OIU_PU_NO	KUNNR	CHAR	10	0	Purchaser	*
16	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	*
17	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	*
18	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
19	GRV_AM	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
20	DOC_YEAR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
21	DOC_NO	☐	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
22	TAX_TYPE	☐	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
23	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
24	TAX_CLS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
25	TIER_TAX_IND	☐	OIUX1_TIER_TAX_IND	OIUX1_TIER_TAX_IND	CHAR	1	0	Tier tax indicator
26	PDIND	☐	OIUX1_PDIND	OIUX1_PDIND	CHAR	1	0	Purchaser/Producer Indicator
27	AFFL_COMP	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
28	SEV_TAX_PAY_FL	☐	OIU_SEVT_PAY_FL	OIU_SEVT_PAY_FL	CHAR	1	0	Tax Severance Tax Calculation Payment Obligations Types
29	SEV_TAX_RPT_FL	☐	OIU_SEVT_RPT_FL	CHAR1	CHAR	1	0	State Severance Tax Reporting Indicators
30	VL_TAX_RAT	☐	OIUVL_VL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Volume tax rate
31	FX_MCD_RAT	☐	OIUVL_FX_MCD_RAT	OIU_PERCENT52	DEC	5	2	Fixed marketing cost deduction rate
32	VAL_TAX_RAT	☐	OIUVL_VAL_TAX_RAT	OIUVL_PERCENT76	DEC	7	6	Value tax rate
33	TOT_TAX_PC	☐	OIUVL_TOTAL_TAX_PC	OIU_PERCENT98	DEC	9	8	Total tax percentage
34	ACTL_GR_VL	☐	OIU_ACTL_GR_VL_AM	MENGE	QUAN	13	3	Actual Gross Volume Amount
35	TAX_FREE_05_VL	☐	OIUVL_TAX_FREE_VL	MENGE	QUAN	13	3	Tax free 05 volume
36	BLPS_GR_VL	☐	OIUVL_BLPS_GR_VL	MENGE	QUAN	13	3	Before lease plant split gross volume
37	ACTL_TXVL	☐	OIUVL_ACTL_TXVL	MENGE	QUAN	13	3	Actual taxable volume
38	ACTL_OVRD_TAXVL	☐	OIUVL_ACTL_OVRD_TAX_VL	MENGE	QUAN	13	3	Actual override taxable volume
39	ACTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
40	ACTL_WLR_VL_AM	☐	OIU_ACTL_WLR_VL_AM	MENGE	QUAN	13	3	Act. Wet-less-Residue Vol. Amount
41	TAX_FREE_05_WLR	☐	OIUVL_TAX_FREE_WLR	MENGE	QUAN	13	3	Tax free 05 wet-less-residue
42	ACTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
43	ACTL_ENERGY	☐	OIU_ACTL_ENERGY	MENGE	QUAN	13	3	Actual Energy
44	ACTL_ENERGY_U	☐	OIU_ACTL_ENERGY_U	MEINS	UNIT	3	0	Actual Energy Unit	*
45	FX_MCD	☐	OIUVL_FX_MCD	WERT8	CURR	15	2	Fixed marketing cost deduction
46	ACTL_GR_VAL_AM	☐	OIU_ACTL_GR_VAL_AM	WERT7	CURR	13	2	Actual Gross Value Amount
47	TAX_FREE_05_VAL	☐	OIUVL_TAX_FREE_VAL	WERT8	CURR	15	2	Tax free 05 value
48	BLPS_GR_VAL	☐	OIUVL_BLPS_GR_VAL	WERT8	CURR	15	2	Before lease plant split gross value
49	ST_TAX_PROC_ALLW	☐	OIUVL_ST_TAX_PROC_ALLOW	WERT8	CURR	15	2	State tax processing allowance
50	ACTL_TXVAL	☐	OIUVL_ACTL_TXVAL	WERT8	CURR	15	2	Actual taxable value
51	ACTL_OVRD_TAXVAL	☐	OIUVL_ACTL_OVRD_TAX_VAL	WERT8	CURR	15	2	Actual override taxable value
52	ACTL_ST_TAX_AM	☐	OIUVL_ACTL_ST_TAX_AM	WERT8	CURR	15	2	Actual state tax amount
53	ACTL_ST_TAX_RMB	☐	OIUVL_ACTL_ST_TAX_REIMB	WERT8	CURR	15	2	Actual state tax reimbursement
54	GR_VAL_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
55	REJECT_FLAG	☐	OIUREP_REJECT_FLAG	OIUREP_REJECT_FLAG	CHAR	1	0	Reject flag
56	USERNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
57	TIMESTAMP	☐	OIUX1_TIMESTAMP	OII_TIMEST	NUMC	14	0	Time stamp in Numeric Character

History

Last changed by/on	SAP	20070914
SAP Release Created in