SAP ABAP Table ROIUVL_TCWC (Tax Class - Well Completion)

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_TCWC	Table Relationship Diagram
Short Description	Tax Class - Well Completion

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	OIU_PR_WELL
2	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
3	WC_NM	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
4	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
5	MP_DE	☐	OIU_MP_DE	OIU_TEXT35	CHAR	35	0	Measurement point description
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
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	DOI_NM	☐	OIU_DOI_NM	OIU_TEXT30	CHAR	30	0	Division of Interest Name
11	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
12	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
13	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
14	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	OIU_CM_SCHDCD
15	TAX_CLASS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	OIU_CM_TAXCLS
16	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	OIU_CM_LXPGL
17	LAND	☐	OIU_COUNTRY	LAND1	CHAR	3	0	Country	T005
18	PRI_GEO_DESC	☐	OIU_PRI_GEO_DESC	CHAR30	CHAR	30	0	Primary geographical location description
19	MAJPD_DE	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
20	TAX_CLS_DE	☐	OIU_TAX_CLS_DE	OIU_TEXT50	CHAR	50	0	Description
21	SCHOOL_DIST_DE	☐	OIU_SCHOOL_DIST_DE	OIU_TEXT50	CHAR	50	0	School district text
22	.INCLUDE	☐				0	0	Creator and date/time created
23	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
24	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25	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_TCWC	BUKRS	T001	BUKRS
2	ROIUVL_TCWC	DOI_NO	OIU_DO_DI	DOI_NO
3	ROIUVL_TCWC	LAND	T005	LAND1		1	CN
4	ROIUVL_TCWC	MP_NO	OIU_PR_MP	MP_NO
5	ROIUVL_TCWC	PRI_GEO_LOC	OIU_CM_LXPGL	PRI_GEO_LOC		1	CN
6	ROIUVL_TCWC	SCHOOL_DIST_CD	OIU_CM_SCHDCD	SCHOOL_DIST_CD		1	CN
7	ROIUVL_TCWC	TAX_CLASS	OIU_CM_TAXCLS	TAX_CLS		1	CN
8	ROIUVL_TCWC	VNAME	OIU_DO_JV	VNAME
9	ROIUVL_TCWC	WC_NO	OIU_PR_WC	WC_NO
10	ROIUVL_TCWC	WL_NO	OIU_PR_WELL	WL_NO

History

Last changed by/on	SAP	20110901
SAP Release Created in