SAP ABAP Table OIUY1_GEN_CD_VAL (Maintain Code with Effective Dated)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y1 (Package) PRA Royalty Reporting - Migration To New Framework

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUY1_GEN_CD_VAL	Table Relationship Diagram
Short Description	Maintain Code with Effective Dated

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	OIUY1_CAT_CD
3	CATEGORY	☑	OIUY1_CAT	CHAR2	CHAR	2	0	ID to represent the Category	OIUY1_CAT_CD
4	CODE	☑	OIUY1_CD	CHAR20	CHAR	20	0	Input code for the category
5	SEQ_NO	☑	OIU_SEQ_NO	OIU_SEQ_NO	NUMC	3	0	Sequence number
6	EFF_FROM_DT	☑	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
7	CODE_VAL	☐	OIUY1_CODE_VALUE	CHAR60	CHAR	60	0	Description for code values
8	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUY1_GEN_CD_VAL	AGENCY	OIUY1_CAT_CD	AGENCY	KEY
2	OIUY1_GEN_CD_VAL	CATEGORY	OIUY1_CAT_CD	CATEGORY	KEY
3	OIUY1_GEN_CD_VAL	MANDT	T000	MANDT	KEY

History

Last changed by/on	SAP	20050224
SAP Release Created in	600