SAP ABAP Table ROIU_PR_WCDT (Maintenance Structure: OIU_PR_WCDT)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	INTTAB	Structure
Structure	ROIU_PR_WCDT	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_PR_WCDT

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	PRA: Well Completion Downtime
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
4	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
5	EFF_FROM_TS	☐	OIU_EFF_FROM_TS	TZNTSTMPS	DEC	15	0	Effective from timestamp
6	STRM_TYPE_CD	☐	OIU_STRM_TYPE_CD	OIU_STRM_TYPE_CD	CHAR	1	0	Stream type code	OIU_PR_STRMT
7	EFF_TO_TS	☐	OIU_EFF_TO_TS	TZNTSTMPS	DEC	15	0	Effective to timestamp
8	WCDT_NO	☐	OIU_WCDT_NO	OIU_SYS_NO	NUMC	12	0	Well Completion Downtime Number
9	COND_CD	☐	OIU_COND_CD	OIU_COND_CD	CHAR	1	0	Condition Code
10	HOUR_FL	☐	OIU_HOUR_FL	OIU_X_FLAG	CHAR	1	0	Hour flag
11	HRS	☐	OIU_HRS	OIU_HRS	DEC	5	2	Number of Hours
12	.INCLUDE	☐				0	0	Creator and date/time created
13	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
14	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
15	WC_NM	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
16	STRM_TYPE_DE	☐	OIU_STRM_TYPE_DE	OIU_TEXT50	CHAR	50	0	Stream Type Description
17	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
18	EFF_FROM_TM	☐	OIU_EFF_FROM_TM	TIME	TIMS	6	0	Effective From Time
19	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
20	EFF_TO_TM	☐	OIU_EFF_TO_TM	TIME	TIMS	6	0	Effective To Time
21	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
22	REF_WL_NO	☐	OIU_WL_NO_REF	OIU_WL_NO	CHAR	15	0	Reference well ID number	OIU_PR_WELL
23	REF_WC_NO	☐	OIU_WC_NO_REF	OIU_WC_NO	CHAR	5	0	Reference well completion number	OIU_PR_WC
24	REF_WC_NM	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
25	REF_STRM_TYPE_CD	☐	OIU_STRM_TYPE_CD_REF	OIU_STRM_TYPE_CD	CHAR	1	0	Reference stream type code	OIU_PR_STRMT
26	REF_STRM_TYPE_DE	☐	OIU_STRM_TYPE_DE	OIU_TEXT50	CHAR	50	0	Stream Type Description
27	REF_EFF_FROM_DT	☐	OIU_EFF_FROM_DT_REF	DATUM	DATS	8	0	Reference effective from date
28	REF_EFF_FROM_TM	☐	OIU_EFF_FROM_TM_REF	TIME	TIMS	6	0	Reference Effective From Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_PR_WCDT	REF_STRM_TYPE_CD	OIU_PR_STRMT	STRM_TYPE_CD
2	ROIU_PR_WCDT	REF_WC_NO	OIU_PR_WC	WC_NO		1	CN
3	ROIU_PR_WCDT	REF_WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN
4	ROIU_PR_WCDT	STRM_TYPE_CD	OIU_PR_STRMT	STRM_TYPE_CD
5	ROIU_PR_WCDT	WC_NO	OIU_PR_WC	WC_NO	REF	1	CN
6	ROIU_PR_WCDT	WL_NO	OIU_PR_WELL	WL_NO	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C