/pra/ofs_V_Owner_Doi

Owner Division of Interest | view: /PRA/OFS_CDS_DOI | Extraction: Not supported | Component: Ownership
Column Name Description
bukrs FK Company Code
vname FK Joint venture
doi_no FK Division of interest (DOI)
own_no FK PRA owner
own_int_type_cd FK Participant Interest Type
own_isq_no Owner Interest Sequence Number
eff_from_dt Effective from date
Column Name Description
Column Name Description
Column Name Description
eff_from_dt Effective from date
sts_eff_dt Status Effective Date
eff_to_dt Effective To Date
Column Name Description
vname_int_cd Venture Interest Code Show values
type_cd Venture Usage Type Show values
unit_fl Unit venture flag Show values
doi_by_tr_fl DOI by tract flag Show values
jib_offs_fl Joint Interest Billing Offset Flag Show values
pay_cd Pay Code Show values
entl_cd Entitlement Code Show values
enty_cd Entity Code Show values
lse_use_pmt_cd Pay on Lease Use Fuel Show values
Column Name Description Domain name
vname_nm Venture Name OIU_TEXT35
old_vname_no Old lease ID OBJNR
field_nm Field Name OIU_TEXT35
space_ord_no Spacing Order Number CHAR20
lpn_no Land Venture Number OIU_LPN_NO
sts_code_nm Venture Status Description OIU_TEXT50
venture_status Venture Status
type_cd_nm Venture Usage Type Description DDTEXT
venture_usage Venture Usage Type
doi_nm Division of Interest Name OIU_TEXT30
venture_doi Venture/DOI
comb_pd_cd_nm Combined Product Code Description TEXT50
comb_pd Combined Product Code
pri_geo_desc Primary geographical location description CHAR30
prim_loc Primary Location
sec_geo_desc Secondary Geographical Location Description CHAR30
sec_loc Secondardy Location
doi_status_de DOI Status Text OIU_TEXT50
own_nm Owner Name NAME
owner Owner
nri_pc Net Revenue Interest Percent OIU_PERCENT98
susp_cd_nm Suspense Reason Description OIU_TEXT40
susp_reason Suspense Reason
pay_cd_nm Pay Code Description DDTEXT
pay_code Pay Code
enty_cd_nm Entity Type Description DDTEXT
entity_code Entity Type
jib_partn_nm JIB Partner Name NAME
jib_partner JIB Partner
pp_kunnr_nm Production Payment Owner Name NAME
pp_owner Production Payment Owner
tax_free_de Tax Free Code Description CHAR50
lse_use_tx Lease Use Fuel Name DDTEXT
Master Data Relations Join Conditions
Company code
  • Client
  • Company Code
  • /PRA/OFS_V_OWNER_DOI.MANDT == T001.MANDT
  • /PRA/OFS_V_OWNER_DOI.BUKRS == T001.BUKRS
Combined product code
  • Combined product code
  • Client
Division Of Interest
  • Division of interest (DOI)
  • Client
  • Company Code
  • Joint venture
  • /PRA/OFS_V_OWNER_DOI.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/OFS_V_OWNER_DOI.MANDT == OIU_DO_DI.MANDT
  • /PRA/OFS_V_OWNER_DOI.BUKRS == OIU_DO_DI.BUKRS
  • /PRA/OFS_V_OWNER_DOI.VNAME == OIU_DO_DI.VNAME
Field
  • Field ID
  • Client
Customer/Partner
  • Client
  • JIB Partner
  • /PRA/OFS_V_OWNER_DOI.MANDT == KNA1.MANDT
  • /PRA/OFS_V_OWNER_DOI.JIB_PARTN == KNA1.KUNNR
Country/Region Key
  • Country/Region Key
  • Client
  • /PRA/OFS_V_OWNER_DOI.LAND1 == T005.LAND1
  • /PRA/OFS_V_OWNER_DOI.MANDT == T005.MANDT
Participant Interest Type /PRA/OFS_V_OWNER_DOI.OWN_INT_TYPE_CD == OIU_CM_PINTTY.OWN_INT_TYPE_CD
PRA owner
  • Client
  • PRA owner
  • /PRA/OFS_V_OWNER_DOI.MANDT == LFA1.MANDT
  • /PRA/OFS_V_OWNER_DOI.OWN_NO == LFA1.LIFNR
DOI Status
  • Client
  • DOI Status
PP KUNNR
  • Client
  • Production Payment Owner
  • /PRA/OFS_V_OWNER_DOI.MANDT == OIUOW_PP.MANDT
  • /PRA/OFS_V_OWNER_DOI.PP_KUNNR == OIUOW_PP.OWN_NO
Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
Secondary geographic location
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
  • Secondary geographic location
E&P Venture Status
  • Client
  • Venture Status
Suspense Code
  • Suspense Reason Code
  • Client
Tax Free Code /PRA/OFS_V_OWNER_DOI.TAX_FREE_CD == OIU_CM_TFC.TAX_FREE_CD
Venture
  • Client
  • Company Code
  • Joint venture
  • /PRA/OFS_V_OWNER_DOI.MANDT == OIU_DO_JV.MANDT
  • /PRA/OFS_V_OWNER_DOI.BUKRS == OIU_DO_JV.BUKRS
  • /PRA/OFS_V_OWNER_DOI.VNAME == OIU_DO_JV.VNAME