SAP ABAP Table OIUREP_CODE_XREF (Reg Reporting Product/Volume Type to Report Code Cross Ref)

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_CODE_XREF	Table Relationship Diagram
Short Description	Reg Reporting Product/Volume Type to Report Code Cross Ref

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Key for regulatory reporting tables
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	AGENCY	☑	OIUREP_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_REPORTS
4	REP_NAME	☑	OIU_REP_REPNAME	PROGNAME	CHAR	40	0	Regulatory Report Name	OIUREP_REPORTS
5	.INCLUDE	☑				0	0	Structure for OIUREP_CODE_XREF table key
6	OVERRIDE_GRP	☑	OIUREP_OVERRIDE_GRP		CHAR	5	0	Override Group
7	MAJPD_CD	☑	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code	*
8	VT_CD	☑	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	OIU_PR_VLTYP
9	PD_CD	☑	OIU_PD_CD	OIU_PD_CD	CHAR	2	0	Minor Product Code	OIU_CM_PDCD
10	TRNSP_METH_CD	☑	OIU_TRNSP_METH_CD	OIU_MTH_CD	CHAR	1	0	Transporter Method Code	OIU_PR_TRMTH
11	NEG_IND	☑	OIUREP_POS_NEG_IND	OIUREP_POS_NEG_IND	CHAR	1	0	Negative Value Indicator
12	RPT_COL_PRI	☐	OIUREP_FIELDNAME1	FDNAME	CHAR	30	0	Reg. Reporting - Fieldname 1	OIUREP_CODE_RPTC
13	CODE_VAL_PRI	☐	OIUREP_CODE_VAL_PRI	CHAR30	CHAR	30	0	Re. Reporting - Value of primary field	OIUREP_CODE_VALS
14	RPT_COL_SEC	☐	OIUREP_FIELDNAME2	FDNAME	CHAR	30	0	Reg. Reporting - Fieldname 2	OIUREP_CODE_RPTC
15	CODE_VAL_SEC	☐	OIUREP_CODE_VAL_SEC	CHAR30	CHAR	30	0	Re. Reporting - Value of secondary field	OIUREP_CODE_VALS
16	RPT_COLUMN	☐	FIELDNAME	FDNAME	CHAR	30	0	Field Name	OIUREP_CODE_RPTC
17	TEXT_ID	☐	TDID	TDID	CHAR	4	0	Text ID	OIUREP_TEXT_STDH
18	TEXT	☐	FLDTX	CHAR60	CHAR	60	0	Field text
19	INV_IND	☐	OIUREP_INVENTORY	OIUREP_INVENTORY	CHAR	2	0	Inventory Indicator
20	RPT_COL_3RD	☐	OIUREP_FIELDNAME3	FDNAME	CHAR	30	0	Reg. Reporting - Fieldname 3	OIUREP_CODE_RPTC
21	CODE_VAL_3RD	☐	OIUREP_CODE_VAL_3RD	CHAR30	CHAR	30	0	Re. Reporting - Value of 3rd field	OIUREP_CODE_VALS

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_CODE_XREF	AGENCY	OIUREP_REPORTS	AGENCY
2	OIUREP_CODE_XREF	CODE_VAL_3RD	OIUREP_CODE_VALS	RPT_COLUMN
3	OIUREP_CODE_XREF	CODE_VAL_PRI	OIUREP_CODE_VALS	RPT_COLUMN
4	OIUREP_CODE_XREF	CODE_VAL_SEC	OIUREP_CODE_VALS	RPT_COLUMN	KEY
5	OIUREP_CODE_XREF	MANDT	T000	MANDT
6	OIUREP_CODE_XREF	PD_CD	OIU_CM_PDCD	PD_CD
7	OIUREP_CODE_XREF	REP_NAME	OIUREP_REPORTS	REP_NAME
8	OIUREP_CODE_XREF	RPT_COLUMN	OIUREP_CODE_RPTC	RPT_COLUMN
9	OIUREP_CODE_XREF	RPT_COL_3RD	OIUREP_CODE_RPTC	RPT_COLUMN
10	OIUREP_CODE_XREF	RPT_COL_PRI	OIUREP_CODE_RPTC	RPT_COLUMN
11	OIUREP_CODE_XREF	RPT_COL_SEC	OIUREP_CODE_RPTC	RPT_COLUMN
12	OIUREP_CODE_XREF	TEXT_ID	OIUREP_TEXT_STDH	REP_NAME
13	OIUREP_CODE_XREF	TRNSP_METH_CD	OIU_PR_TRMTH	MTH_CD
14	OIUREP_CODE_XREF	VT_CD	OIU_PR_VLTYP	VL_TYPE_CD

History

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