/pra/ofs_V_Owner_Fp_Bal

Owner Federal Payables Summary | view: /PRA/OFS_CDS_OFP | Extraction: Not supported | Component: Ownership
Tables used: /PRA/FP_PAY_SUM, /PRA/BP_VEND_MD, LFA1, /PRA/FP_SRC, OIU_CM_PPARSN_TX, OIU_DO_DI, OIU_PR_WC
Column Name Description
bal_type Federal Payable Balance Type
sale_dt Sales Date / Month
bukrs FK Company Code
vname FK Joint venture
doi_no FK Division of interest (DOI)
wl_no FK Well ID number
wc_no FK Well Completion Number
vbeln FK Contract Number
vl_type_cd FK Volume Type Code
pd_cd FK Full three char. product code (Major and Detail Products)
own_no FK PRA owner
saknr FK G/L Account Number
kostl FK Cost Center
Column Name Description
💲 Currency Key (waers):
gross_val Gross value
owner_gross_val Owner Gross Value
net_val Owner Net Value
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
Column Name Description
sale_dt Sales Date / Month
Column Name Description
disp_cd ONRR-2014 - Disposition Code Show values
Column Name Description Domain name
own_nm Owner Name NAME
owner Owner
doi_nm Division of Interest Name OIU_TEXT30
venture_doi Venture/DOI
wc_nm Well completion name OIU_TEXT35_CONV
well Well
ppa_rsn_cd_nm Prior Period Adjustment Reason Description OIU_TEXT50
ppa_reason Prior Period Adjustment Reason
disp_cd_nm Disposition Reason Code Description DDTEXT
disp_rsn_cd ONRR-2014 - Reason Code
disp_rsn_nm Reason Code Description TEXT30
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
Division of interest (DOI)
  • Client
  • Division of interest (DOI)
  • Joint venture
  • Company Code
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == OIU_DO_DI.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/OFS_V_OWNER_FP_BAL.VNAME == OIU_DO_DI.VNAME
  • /PRA/OFS_V_OWNER_FP_BAL.BUKRS == OIU_DO_DI.BUKRS
Energy Unit of Measure
  • Client
  • Energy Unit of Measure
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == T006.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.ENERGY_UOM == T006.MSEHI
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == CSKS.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.[column in domain "KOKRS"] == CSKS.KOKRS
  • /PRA/OFS_V_OWNER_FP_BAL.[column in domain "DATBI"] == CSKS.DATBI
  • /PRA/OFS_V_OWNER_FP_BAL.KOSTL == CSKS.KOSTL
PRA owner
  • Client
  • PRA owner
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == LFA1.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) /PRA/OFS_V_OWNER_FP_BAL.PD_CD == OIUX3_PDCD.PDCD
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
G/L Account Number
  • Client
  • G/L Account Number
  • Company Code
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == SKB1.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.SAKNR == SKB1.SAKNR
  • /PRA/OFS_V_OWNER_FP_BAL.BUKRS == SKB1.BUKRS
Contract Number
  • Client
  • Contract Number
Volume Type Code /PRA/OFS_V_OWNER_FP_BAL.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Client
  • Joint venture
  • Company Code
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == OIU_DO_JV.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.VNAME == OIU_DO_JV.VNAME
  • /PRA/OFS_V_OWNER_FP_BAL.BUKRS == OIU_DO_JV.BUKRS
Volume Unit
  • Client
  • Volume Unit
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == T006.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.VOL_UOM == T006.MSEHI
Currency Key
  • Client
  • Currency Key
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == TCURC.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.WAERS == TCURC.WAERS
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • /PRA/OFS_V_OWNER_FP_BAL.MANDT == OIU_PR_WC.MANDT
  • /PRA/OFS_V_OWNER_FP_BAL.WL_NO == OIU_PR_WC.WL_NO
  • /PRA/OFS_V_OWNER_FP_BAL.WC_NO == OIU_PR_WC.WC_NO
Well ID number
  • Client
  • Well ID number