SAP ABAP Table OIUX1_PDCD_XREF (Cross Reference Between State Agency and PRA Material)

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_PDCD_XREF	Table Relationship Diagram
Short Description	Cross Reference Between State Agency and PRA Material

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	T000
2	AGENCY	☑	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
3	OIL_GAS_IND	☑	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
4	VOLUME_TYPE	☑	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
5	MATERIAL	☑	MATNR	MATNR	CHAR	18	0	Material Number	*
6	AGENCY_PROD_CODE	☐	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code	OIUREP_AGY_PDCD

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUX1_PDCD_XREF	AGENCY	OIUREP_ROY_AGY	AGENCY	KEY	1	CN
2	OIUX1_PDCD_XREF	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE	REF
3	OIUX1_PDCD_XREF	MANDT	T000	MANDT	KEY
4	OIUX1_PDCD_XREF	VOLUME_TYPE	OIU_PR_VLTYP	VL_TYPE_CD

History

Last changed by/on	SAP	20070914
SAP Release Created in