I_WellCompletion

Well Completion | view: IPVWELLCOMPLTN | ATTR | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: OIU_PR_WC
Column Name Description
Well FK Well ID number
WellCompletion Well Completion Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WellCompletionLatitude Latitude number Show values
WellCompltnLatitudeDirection Latitude direction code Show values
WellCompletionLongitude Longitude Show values
WellCompltnLongitudeDirection Longitude Direction Code Show values
CoalBedMethaneRptgIsEnabled Coal Bed Methane Indicator Show values
Column Name Description Domain name
WellCompletionName Well completion name OIU_TEXT35
APIWellCompletionNumber API well completion number OIU_API_WC_NO
AlternateWellCompletionKey Alternate WC Key CHAR40
WellCompletionHier Well Completion Hierarchy Group CHAR15
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
Master Data Relations | to Other Relations ↓ Join Conditions
Country
  • Client
  • Country/Region Key
  • I_WELLCOMPLETION.MANDT == T005.MANDT
  • I_WELLCOMPLETION.COUNTRY == T005.LAND1
Development Program
  • Client
  • Development program number
Field
  • Client
  • Field ID
Platform Number
  • Client
  • Platform number
  • I_WELLCOMPLETION.MANDT == OIU_PR_PF.MANDT
  • I_WELLCOMPLETION.OFFSHOREPLATFORM == OIU_PR_PF.PF_NO
Primary geographical location (PRI geo. loc.)
  • Client
  • Primary geographical location (PRI geo. loc.)
  • Country/Region Key
Reservoir
  • Reservoir ID
  • Client
Zone
  • Reservoir ID
  • Client
  • Reservoir zone
Secondary geographic location
  • Client
  • Primary geographical location (PRI geo. loc.)
  • Secondary geographic location
  • Country/Region Key
Well
  • Client
  • Well ID number
Purpose
  • Well purpose code
  • Client
Other Relations | to Master Data Relations ↑ Join Conditions
org1
  • Client
  • Org. Level 1 - Company
  • I_WELLCOMPLETION.MANDT == OIUH_CM_OR1.MANDT
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT == OIUH_CM_OR1.OR1_OR_LVL_1_NO
org2
  • Client
  • Second-highest organization level number ( Company Code)
  • Org. Level 1 - Company
  • I_WELLCOMPLETION.MANDT == OIUH_CM_OR2.MANDT
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT2 == OIUH_CM_OR2.OR2_OR_LVL_2_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT == OIUH_CM_OR2.OR2_OR_LVL_1_NO
org3
  • Client
  • Second-highest organization level number ( Company Code)
  • Org. Level 1 - Company
  • Third-highest organization level number ( Company Code)
  • I_WELLCOMPLETION.MANDT == OIUH_CM_OR3.MANDT
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT2 == OIUH_CM_OR3.OR3_OR_LVL_2_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT == OIUH_CM_OR3.OR3_OR_LVL_1_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT3 == OIUH_CM_OR3.OR3_OR_LVL_3_NO
Org4
  • Client
  • Second-highest organization level number ( Company Code)
  • Org. Level 1 - Company
  • Third-highest organization level number ( Company Code)
  • Fourth-highest organization level number ( Company Code)
  • I_WELLCOMPLETION.MANDT == OIUH_CM_OR4.MANDT
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT2 == OIUH_CM_OR4.OR4_OR_LVL_2_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT == OIUH_CM_OR4.OR4_OR_LVL_1_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT3 == OIUH_CM_OR4.OR4_OR_LVL_3_NO
  • I_WELLCOMPLETION.ORGANIZATIONALUNIT4 == OIUH_CM_OR4.OR4_OR_LVL_4_NO