SAP ABAP Table ROIU_PR_WCOLH (Well Completion Contamination Override Header)
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_WCOLH   Table Relationship Diagram
Short Description Well Completion Contamination Override Header    
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 XXDBACTION OIU_DBACTION CHAR1 CHAR 1   0   Database Action Flag  
2 WC_DE OIU_WC_NM OIU_TEXT35 CHAR 35   0   Well completion name  
3 REF_WC_DE OIU_WC_NM OIU_TEXT35 CHAR 35   0   Well completion name  
4 REF_WL_NO OIU_WL_NO_REF OIU_WL_NO CHAR 15   0   Reference well ID number OIU_PR_WELL
5 REF_WC_NO OIU_WC_NO_REF OIU_WC_NO CHAR 5   0   Reference well completion number OIU_PR_WC
6 WL_DE OIU_WL_DE OIU_TEXT35 CHAR 35   0   Well Description  
7 REF_WL_DE OIU_WL_DE OIU_TEXT35 CHAR 35   0   Well Description  
8 REF_WL_SHTX OIU_SHTXT CHAR35 CHAR 35   0   Description  
9 WL_SHTXT OIU_SHTXT CHAR35 CHAR 35   0   Description  
10 REF_EFF_FROM_DT OIU_EFF_FROM_DT_REF DATUM DATS 8   0   Reference effective from date  
11 .INCLUDE       0   0   PRA: Well Completion Offset Lease  
12 MANDT MANDT MANDT CLNT 3   0   Client *
13 WL_NO OIU_WL_NO OIU_WL_NO CHAR 15   0   Well ID number OIU_PR_WELL
14 WC_NO OIU_WC_NO OIU_WC_NO CHAR 5   0   Well Completion Number OIU_PR_WC
15 EFF_FROM_DT OIU_EFF_FROM_DT DATUM DATS 8   0   Effective from date  
16 EFF_TO_DT OIU_EFF_TO_DT DATUM DATS 8   0   Effective To Date  
17 WCOLH_NO OIU_WCOLH_NO OIU_SYS_NO NUMC 12   0   Well Completion Offset Lease Number  
18 .INCLUDE       0   0   Creator and date/time created  
19 OIU_CRUSER ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
20 OIU_TIMESTAMP TZNTSTMPS TZNTSTMPS DEC 15   0   UTC Time Stamp in Short Form (YYYYMMDDhhmmss)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ROIU_PR_WCOLH REF_WC_NO OIU_PR_WC WC_NO KEY 1 CN
2 ROIU_PR_WCOLH REF_WL_NO OIU_PR_WELL WL_NO KEY 1 CN
3 ROIU_PR_WCOLH WC_NO OIU_PR_WC WC_NO KEY 1 CN
4 ROIU_PR_WCOLH WL_NO OIU_PR_WELL WL_NO KEY 1 CN
History
Last changed by/on SAP  20050301 
SAP Release Created in 46C