SAP ABAP Table OIUY3_TX_OPSL (Roy 2.0 TX - OPSL Summary Data for a Run)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y3 (Package) Royalty 2.0 - Texas GLO/TAMU

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUY3_TX_OPSL	Table Relationship Diagram
Short Description	Roy 2.0 TX - OPSL Summary Data for a Run

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	RUN_ID	☑	OIUX3_RUN_ID	NUMC10	NUMC	10	0	Tax Reporting - Run ID
3	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	OIU_CM_COMPC
4	VNAME	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
5	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
6	OWNER_IDENTIFIER	☑	OIUYC_OWNER_IDENTIFIER		CHAR	22	0	Royalty 2.0 - Owner Identifier
7	SALES_DT	☑	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
8	PDCD	☑	OIU_FULL_PD_CD	OIU_FULL_PD_CD	CHAR	3	0	Full three char. product code (Major and Detail Products)	OIUX3_PDCD
9	TRANS_AM	☐	OIUX3_TRANS_AMT	OIUX3_SIGNED_DEC_11_2	DEC	11	2	JE Transaction Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUY3_TX_OPSL	BUKRS	OIU_CM_COMPC	BUKRS	KEY
2	OIUY3_TX_OPSL	DOI_NO	OIU_DO_DI	DOI_NO	KEY
3	OIUY3_TX_OPSL	MANDT	T000	MANDT	KEY
4	OIUY3_TX_OPSL	PDCD	OIUX3_PDCD	PDCD	KEY
5	OIUY3_TX_OPSL	VNAME	OIU_DO_JV	VNAME	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in	617