SAP ABAP Table OIUX1_TXCD_XREF (Cross reference between state tax codes and PRA entities)

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_TXCD_XREF	Table Relationship Diagram
Short Description	Cross reference between state tax codes and PRA entities

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	AGENCY	☑	OIUX1_TAX_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
3	OGIND	☑	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
4	AGENCY_PROD_CODE	☑	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code	OIUREP_AGY_PDCD
5	TAX_TYPE	☑	OIU_SEVT_TAX_TY	OIU_SEVT_TAX_TY	CHAR	2	0	Severance Tax Type	*
6	SCHOOL_DIST_CD	☑	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
7	TAX_CLS	☑	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
8	TIER_TAX_IND	☑	OIUX1_TIER_TAX_IND	OIUX1_TIER_TAX_IND	CHAR	1	0	Tier tax indicator
9	AGENCY_TAX_CODE	☐	OIUX1_AGENCY_TAX_CODE	OIUX1_AGENCY_TAX_CODE	CHAR	4	0	Agency defined Tax Code for Reporting	OIUX1_AGY_TXCD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUX1_TXCD_XREF	AGENCY	OIUREP_ROY_AGY	AGENCY		1	CN
2	OIUX1_TXCD_XREF	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE		1	CN
3	OIUX1_TXCD_XREF	AGENCY_TAX_CODE	OIUX1_AGY_TXCD	AGENCY_TAX_CODE

History

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