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

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_REP (Package) Production, Tax & Royalty Reporting

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUREP_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	AGENCY_PROD_CODE	☑	OIUREP_AGENCY_PDCD	OIUREP_AGENCY_PDCD	CHAR	3	0	Agency defined product code	OIUREP_AGY_PDCD
5	PRODUCT_CODE	☑	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
6	NO_GAS	☐	OIUX1_NO_GAS	FLAG	CHAR	1	0	Not report in Gas report

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_PDCD_XREF	AGENCY	OIUREP_ROY_AGY	AGENCY	KEY	1	CN
2	OIUREP_PDCD_XREF	AGENCY_PROD_CODE	OIUREP_AGY_PDCD	AGENCY_PROD_CODE	KEY	1	CN
3	OIUREP_PDCD_XREF	MANDT	T000	MANDT	KEY
4	OIUREP_PDCD_XREF	PRODUCT_CODE	OIU_CM_MAT_PRCD	MATNR	KEY

History

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