SAP ABAP Table ROIUY6_DISP_WY_VARIANCE_RPDTD (Royalty 2.0 - Display Wyoming Report Detail Variance)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
     ⤷ OIU_Y6 (Package) Royalty 2.0 - WY

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUY6_DISP_WY_VARIANCE_RPDTD	Table Relationship Diagram
Short Description	Royalty 2.0 - Display Wyoming Report Detail Variance

Delivery and Maintenance

Pool/cluster
Delivery Class
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	.INCLUDE	☐				0	0	Royalty 2.0 - WY - Report Details
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Royalty 2.0 - Wyoming - Report Detail Key
4	RUN_ID	☐	OIUX3_RUN_ID	NUMC10	NUMC	10	0	Tax Reporting - Run ID
5	PAYER_CODE	☐	OIUY6_WY_PAYER_CODE	OIUY6_WY_COMPANY_ID	NUMC	4	0	Royalty 2.0 - Wyoming - Payer Code
6	SALES_MONTH	☐	OIUY6_WY_SALES_MONTH		NUMC	6	0	Royalty 2.0 - Wyoming - Sales Month (MMCCYY)
7	STATE_LEASE_NO	☐	OIUY6_WY_STATE_LEASE_NO		CHAR	15	0	Royalty 2.0 - Wyoming - State Lease Number
8	UNIQUE_ID	☐	OIUY6_WY_UNIQUE_IDENTIFIER		CHAR	20	0	Royalty 2.0 - Wyoming - PSA
9	WY_PDCD	☐	OIUY6_WY_PRODUCT_CODE	OIUY6_WY_PRODUCT_CODE	NUMC	3	0	Royalty 2.0 - Wyoming - Product Code
10	.INCLUDE	☐				0	0	Royalty 2.0 - Wyoming - Report Detail Non-Key
11	UOM	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	T006
12	GROSS_VOL	☐	OIUX3_GROSS_VOLUME	OIUX3_SIGNED_DEC_11_2	DEC	11	2	Gross Volume
13	GROSS_VAL	☐	OIUX3_GROSS_VALUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Gross Value
14	PROCESSING	☐	OIUY6_WY_PROCESSING_COSTS	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - Processing Costs
15	TRANSPORTATION	☐	OIUY6_WY_TRANSPORTATION_COSTS	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - Transportation Costs
16	NET_SALES_VALUE	☐	OIUY6_WY_NET_SALES_VALUE	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - Net Sales Value
17	TRACT_ALLOC_LSE	☐	OIUY6_WY_TRACT_ALLOC_TO_LEASE	OIU_PERCENT98	DEC	9	8	Royalty 2.0 - Wyoming - Tract Allocation to Lease
18	ROYALTY_RATE	☐	OIUY6_WY_ROYALTY_RATE	OIU_PERCENT98	DEC	9	8	Royalty 2.0 - Wyoming - Royalty Rate
19	STATE_ROYALTY	☐	OIUY6_WY_STATE_ROYALTY	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - State Royalty
20	OPERATED_FL	☐	OIUY6_OPERATED_FLAG	YESNO	CHAR	1	0	Royalty 2.0 - WY - Operated Flag
21	TRANS_QUANTITY	☐	OIUY6_WY_TRANS_QUANTITY	OIUY6_WY_TRANS_QUANTITY	DEC	21	10	Roy 2.0 WY - Trans Quantity (High Precision)
22	ORIGINAL_REPORT	☐	OIUY6_WY_ORIGINAL_REPORT	YESNO	CHAR	1	0	Royalty 2.0 - WY - Original Report
23	.INCLUDE	☐				0	0	Creator and date/time created
24	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
25	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
26	2ND_STATE_ROY_AM	☐	OIUY6_WY_STATE_ROYALTY	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - State Royalty
27	VAR_STATE_ROY_AM	☐	OIUY6_WY_STATE_ROYALTY	OIUX3_SIGNED_CURR_11_2	CURR	11	2	Royalty 2.0 - WY - State Royalty
28	PERCENT	☐	INT2	INT2	INT2	5	0	2 byte integer (signed)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUY6_DISP_WY_VARIANCE_RPDTD	MANDT	T000	MANDT	KEY
2	ROIUY6_DISP_WY_VARIANCE_RPDTD	UOM	T006	MSEHI	REF

History

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