/pra/ofs_V_Sus_Sum

Owner Suspended Summary | view: /PRA/OFS_CDS_SUS | Extraction: Not supported | Component: Ownership
Tables used: /PRA/PP_SUS_SUM
Column Name Description
Column Name Description
💲 Currency Key (waers):
gross_val Gross value
owner_gross_val Owner Gross Value
net_val Owner Net Value
Column Name Description
📏 Base Unit of Measure (vol_uom):
gross_vol Total Gross Volume
net_vol Owner Net Volume
📏 Base Unit of Measure (energy_uom):
gross_energy Gross Energy
owner_energy Owner Energy
Column Name Description
sale_dt Sales Date / Month
Column Name Description
record_type Payment Processing - Record Type Show values
future_pay_fl Payment Processing - Future Pay Flag Show values
Column Name Description Domain name
bal_type Balance Type
own_int_type_seq Owner Interest Type / Sequence
disb_decimal Payment Processing - Disbursement decimal
acct_period Accounting Period /PRA/ACCOUNTING_PERIOD
nri_decimal Net Revenue Interest Percent OIU_PERCENT98
jib_flag Job Interest Billing Indicator OIUH_DO_JIB_OFFS_FL
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Division of interest (DOI)
  • Division of interest (DOI)
  • ?
  • Joint venture
  • Client
  • /PRA/OFS_V_SUS_SUM.DOI_NO == OIU_DO_DI.DOI_NO
  • /PRA/OFS_V_SUS_SUM.[column in domain "BUKRS"] == OIU_DO_DI.BUKRS
  • /PRA/OFS_V_SUS_SUM.VNAME == OIU_DO_DI.VNAME
  • /PRA/OFS_V_SUS_SUM.MANDT == OIU_DO_DI.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • /PRA/OFS_V_SUS_SUM.ENERGY_UOM == T006.MSEHI
  • /PRA/OFS_V_SUS_SUM.MANDT == T006.MANDT
PRA owner
  • Client
  • PRA owner
  • /PRA/OFS_V_SUS_SUM.MANDT == LFA1.MANDT
  • /PRA/OFS_V_SUS_SUM.OWN_NO == LFA1.LIFNR
Full three char. product code (Major and Detail Products) /PRA/OFS_V_SUS_SUM.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
  • /PRA/OFS_V_SUS_SUM.[column in domain "KTOPL"] == SKA1.KTOPL
  • /PRA/OFS_V_SUS_SUM.MANDT == SKA1.MANDT
  • /PRA/OFS_V_SUS_SUM.SAKNR == SKA1.SAKNR
Suspense Reason Code
  • Client
  • Suspense Reason Code
Unit venture
  • Company Code
  • Unit venture
  • Client
  • /PRA/OFS_V_SUS_SUM.BUKRS == OIU_DO_JV.BUKRS
  • /PRA/OFS_V_SUS_SUM.UNIT_VNAME == OIU_DO_JV.VNAME
  • /PRA/OFS_V_SUS_SUM.MANDT == OIU_DO_JV.MANDT
Joint venture
  • ?
  • Joint venture
  • Client
  • /PRA/OFS_V_SUS_SUM.[column in domain "BUKRS"] == OIU_DO_JV.BUKRS
  • /PRA/OFS_V_SUS_SUM.VNAME == OIU_DO_JV.VNAME
  • /PRA/OFS_V_SUS_SUM.MANDT == OIU_DO_JV.MANDT
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • /PRA/OFS_V_SUS_SUM.VOL_UOM == T006.MSEHI
  • /PRA/OFS_V_SUS_SUM.MANDT == T006.MANDT
Currency Key
  • Currency Key
  • Client
  • /PRA/OFS_V_SUS_SUM.WAERS == TCURC.WAERS
  • /PRA/OFS_V_SUS_SUM.MANDT == TCURC.MANDT
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
Well ID number
  • Well ID number
  • Client