SAP ABAP Table ROIUVL_TTRD (Tier Tax Rates Data)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-VAL (Application Component) Valuation
     ⤷ OIU_RVVA (Package) PRA Valuation (Revenue)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIUVL_TTRD	Table Relationship Diagram
Short Description	Tier Tax Rates Data

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	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
2	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
3	NAME	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
4	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
5	MAJPD_DE	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
6	SALE_DT	☐	OIU_SA_DT	DATS	DATS	8	0	Sales date
7	TAX_CLASS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	OIU_CM_TAXCLS
8	TAX_CLS_DE	☐	OIU_TAX_CLS_DE	OIU_TEXT50	CHAR	50	0	Description
9	LAND1	☐	OIU_COUNTRY	LAND1	CHAR	3	0	Country	T005
10	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
11	PRI_GEO_DESC	☐	OIU_PRI_GEO_DESC	CHAR30	CHAR	30	0	Primary geographical location description
12	BASE_VL_QY	☐	OIUVL_BASE_VL_QY	MENGE	QUAN	13	3	Baseline volume qy
13	BASE_VL_UOM	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
14	.INCLUDE	☐				0	0	Creator and date/time created
15	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
17	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIUVL_TTRD	LAND1	T005	LAND1
2	ROIUVL_TTRD	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
3	ROIUVL_TTRD	TAX_CLASS	OIU_CM_TAXCLS	TAX_CLS		1	CN
4	ROIUVL_TTRD	WC_NO	OIU_PR_WC	WC_NO

History

Last changed by/on	SAP	20110901
SAP Release Created in