SAP ABAP Table OIUX1_TRN_TAXHL (Tax transaction header 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_TAXHL	Table Relationship Diagram
Short Description	Tax transaction header 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	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	*
3	VNAME	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
4	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
5	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
6	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	*
7	MP_NO	☑	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
8	SALE_DT	☑	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
9	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
10	CT_NO	☑	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	*
11	DN_NO	☑	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	*
12	VL_TYPE_CD	☑	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	*
13	TAXHC_SYSNO	☐	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting
14	DOC_YEAR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
15	DOC_NO	☐	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
16	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
17	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
18	PU_NO	☐	OIU_PU_NO	KUNNR	CHAR	10	0	Purchaser	*
19	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	*
20	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	*
21	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
22	GRV_AM	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
23	PRD_DAYS	☐	OIU_DAYS_PROD	OIU_DAYS_PROD	NUMC	2	0	Days produced
24	REJECT_FLAG	☐	OIUREP_REJECT_FLAG	OIUREP_REJECT_FLAG	CHAR	1	0	Reject flag
25	USERNAME	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
26	TIMESTAMP	☐	OIUX1_TIMESTAMP	OII_TIMEST	NUMC	14	0	Time stamp in Numeric Character
27	.INCLUDE	☐				0	0	Execution Parameters for Tax Reporting
28	RPT_YYYYMM	☐	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
29	RSG	☐	OIUX1_RSG	OIUX1_RSG	CHAR	4	0	Report Submission Group	OIUX1_RPT_SGRP
30	AGENCY	☐	OIUX1_TAX_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting
31	OGIND	☐	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
32	TAXHL_SYSNO	☐	OIUX1_TAXHC_SYSNO	OIUVL_SYS_NO	NUMC	20	0	Tax header sysno for reporting

Foreign Keys

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

History

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