SAP ABAP Table ROIUX5_OK_MASTER_ALV_0200 (Tax 2.0 - Oklahoma Master Data Screen 0200 ALV Structure)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REP-TAX (Application Component) Tax Reporting
     ⤷ OIU_X5 (Package) Tax 2.0 - Oklahoma Tax

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUX5_OK_MASTER_ALV_0200	Table Relationship Diagram
Short Description	Tax 2.0 - Oklahoma Master Data Screen 0200 ALV Structure

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	Tax 2.0 - Oklahoma Master Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Master Data Key Fields
4	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
5	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
6	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
7	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	OIU_CM_COMPC
8	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
9	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
10	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
11	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
12	.INCLUDE	☐				0	0	Tax 2.0 - Oklahoma Master Data Nonkey Fields
13	PUN	☐	OIUX5_OK_PRODUCTION_UNIT_NO		CHAR	11	0	Tax 2.0 - Oklahoma Production Unit Number	*
14	GAS_CODE	☐	OIUX5_OK_GAS_CODE	OIUX5_OK_GAS_CODE	NUMC	1	0	Tax 2.0 - Oklahoma Gas Code
15	OIL_CLASS	☐	OIUX5_OK_OIL_CLASSIFICATION	OIUX5_OK_OIL_CLASSIFICATION	NUMC	1	0	Tax 2.0 - Oklahoma Oil Classification
16	MULTI_COUNTIES	☐	OIUX5_MULTIPLE_COUNTIES	YESNO	CHAR	1	0	Tax 2.0 - Multiple Counties?
17	COUNTY	☐	OIUX5_OK_COUNTY	OIU_SEC_GEO_LOC	CHAR	3	0	Tax 2.0 - Oklahoma County	OIU_CM_LXSGL
18	NGPA_CD	☐	OIUX5_OK_NGPA_CD	OIUX5_OK_NGPA_CD	CHAR	3	0	Tax 2.0 OKGP - NGPA Code (Tax Incentive Rate Code)
19	.INCLUDE	☐				0	0	Tax Reporting - Last Changed Structure
20	CHANGE_USER	☐	OIUX3_LAST_CHANGED_USER	USNAM	CHAR	12	0	Tax Reporting - Last Changed User
21	CHANGE_DATE	☐	OIUX3_LAST_CHANGED_DATE		DATS	8	0	Tax Reporting - Last Changed Date
22	CHANGE_TIME	☐	OIUX3_LAST_CHANGED_TIME		TIMS	6	0	Tax Reporting - Last Changed Time
23	DROPDOWN_TEXT1	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values
24	DROPDOWN_TEXT2	☐	VAL_TEXT	DDTEXT	CHAR	60	0	Short Text for Fixed Values

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUX5_OK_MASTER_ALV_0200	BUKRS	OIU_CM_COMPC	BUKRS	KEY
2	ROIUX5_OK_MASTER_ALV_0200	COUNTY	OIU_CM_LXSGL	SEC_GEO_LOC	REF
3	ROIUX5_OK_MASTER_ALV_0200	DOI_NO	OIU_DO_DI	DOI_NO	KEY
4	ROIUX5_OK_MASTER_ALV_0200	MANDT	T000	MANDT	KEY
5	ROIUX5_OK_MASTER_ALV_0200	MP_NO	OIU_PR_MP	MP_NO	KEY
6	ROIUX5_OK_MASTER_ALV_0200	VNAME	OIU_DO_JV	VNAME	KEY
7	ROIUX5_OK_MASTER_ALV_0200	WC_NO	OIU_PR_WC	WC_NO	KEY
8	ROIUX5_OK_MASTER_ALV_0200	WL_NO	OIU_PR_WELL	WL_NO	KEY

History

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