/pra/ofs_V_Owner_Check_Dtl

Owner Check Details | view: /PRA/OFS_CDS_CQD | Extraction: Not supported | Component: Ownership
Tables used: /PRA/PP_CHK_DTL, /PRA/PP_CHK_HDR, T001, LFA1, OIU_CM_PPARSN_TX, OIU_DO_DI, OIU_PR_WC, T8JVT
Column Name Description
run_id FK Proc 2.0 - Run ID
check_no Check number
own_no FK PRA owner
vname FK Joint venture
doi_no FK Division of interest (DOI)
wl_no FK Well ID number
wc_no FK Well Completion Number
own_int_type_seq Owner Interest Type / Sequence
sale_dt Sales Date / Month
pd_cd FK Full three char. product code (Major and Detail Products)
disb_decimal Payment Processing - Disbursement decimal
saknr FK G/L Account Number
record_type Payment Processing - Record Type Show values
Column Name Description
💲 Currency Key (waers):
gross_val Gross value
owner_gross_val Owner Gross Value
net_val Owner Net Value
gross_tot_mkt Gross marketing costs
gross_tot_taxes Gross Tax
owner_tot_mkt Total owner marketing cost
owner_tot_taxes Owner tax
owner_tot_other Total Owner Other Deducts
grs_less_tax_mkt Gross value less deductions
price Price
Column Name Description
📏 Volume Unit (vol_uom):
gross_vol Total Gross Volume
net_vol Owner Net Volume
📏 Energy Unit of Measure (energy_uom):
gross_energy Gross Energy
owner_energy Owner Energy
📏 Base Unit of Measure (heat_val_uom):
heat_val Heating value
Column Name Description
sale_dt Sales Date / Month
check_dt Check Date
status_dt Status Date
Column Name Description
record_type Payment Processing - Record Type Show values
payment_type Payment Type Show values
check_status Payment Processing - Check Status Show values
dtl_rej_fl Payment Processing - Detail Reject Flag Show values
Column Name Description Domain name
own_nm Owner Name NAME
owner Owner
check_status_nm Check Status Description DDTEXT
doi_nm Division of Interest Name OIU_TEXT30
venture_doi Venture/DOI
wc_nm Well completion name OIU_TEXT35_CONV
well Well
acct_period Accounting Period /PRA/ACCOUNTING_PERIOD
nri_decimal Net Revenue Interest Percent OIU_PERCENT98
unit_vname_nm Joint Venture Description JVA_TEXT35
unit_venture Unit Venture Description TEXT35
ppa_rsn_cd_nm Prior Period Adjustment Reason Description OIU_TEXT50
ppa_reason Prior Period Adjustment Reason
jva_name JIB Venture JV_NAME
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Division of interest (DOI)
  • Company Code
  • Joint venture
  • Division of interest (DOI)
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.BUKRS == OIU_DO_DI.BUKRS
  • /PRA/OFS_V_OWNER_CHECK_DTL.VNAME == OIU_DO_DI.VNAME
  • /PRA/OFS_V_OWNER_CHECK_DTL.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == OIU_DO_DI.MANDT
Payment Processing - Detail Level Reject Code
  • Payment Processing - Detail Level Reject Code
  • Client
Energy Unit of Measure
  • Energy Unit of Measure
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.ENERGY_UOM == T006.MSEHI
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == T006.MANDT
Payment Processing - High Level Reject Code
  • Client
  • Payment Processing - High Level Reject Code
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.HEAT_VAL_UOM == T006.MSEHI
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == T006.MANDT
PRA owner
  • PRA owner
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.OWN_NO == LFA1.LIFNR
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == LFA1.MANDT
Full three char. product code (Major and Detail Products) /PRA/OFS_V_OWNER_CHECK_DTL.PD_CD == OIUX3_PDCD.PDCD
Prior Period Adjustment Reason Code
  • Prior Period Adjustment Reason Code
  • Client
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • /PRA/OFS_V_OWNER_CHECK_DTL.[column in domain "KTOPL"] == SKA1.KTOPL
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == SKA1.MANDT
  • /PRA/OFS_V_OWNER_CHECK_DTL.SAKNR == SKA1.SAKNR
Unit venture
  • Company Code
  • Unit venture
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.BUKRS == OIU_DO_JV.BUKRS
  • /PRA/OFS_V_OWNER_CHECK_DTL.UNIT_VNAME == OIU_DO_JV.VNAME
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == OIU_DO_JV.MANDT
Joint venture
  • Company Code
  • Joint venture
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.BUKRS == T8JV.BUKRS
  • /PRA/OFS_V_OWNER_CHECK_DTL.VNAME == T8JV.VNAME
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == T8JV.MANDT
Volume Unit
  • Volume Unit
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.VOL_UOM == T006.MSEHI
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.WAERS == TCURC.WAERS
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == TCURC.MANDT
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • /PRA/OFS_V_OWNER_CHECK_DTL.WC_NO == OIU_PR_WC.WC_NO
  • /PRA/OFS_V_OWNER_CHECK_DTL.WL_NO == OIU_PR_WC.WL_NO
  • /PRA/OFS_V_OWNER_CHECK_DTL.MANDT == OIU_PR_WC.MANDT
Well ID number
  • Well ID number
  • Client