C_PRASmmryFedPyblQry

PRA Summary Federal Payable Query | view: CPVSUMFEDPBLQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/FP_PAY_SUM, /PRA/ACCT_COA
Column Name Description
Column Name Description
GrossAmount Gross value
OwnerGrossAmount Owner Gross Value
OwnerNetAmount Owner Net Value
Column Name Description
📏 Volume Unit (VolumeUnit):
GrossVolInVolUnit Total Gross Volume
OwnerNetVolInVolUnit Owner Net Volume
📏 Energy Unit (EnergyUnit):
GrossEnergyInEnergyUnit Gross Energy
OwnerEnergyInEnergyUnit Owner Energy
Column Name Description
SalesDate Sales Date / Month
Column Name Description
ProcessingException ONRR-2014 - Disposition Code Show values
Column Name Description Domain name
DeliveryNetwork Delivery network number OIU_DN_NO
ExceptionReason ONRR-2014 - Reason Code
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_PRASMMRYFEDPYBLQRY.COSTCENTER == CSKS.KOSTL
  • C_PRASMMRYFEDPYBLQRY.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_PRASMMRYFEDPYBLQRY.[column in domain "DATBI"] == CSKS.DATBI
  • C_PRASMMRYFEDPYBLQRY.MANDT == CSKS.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Joint venture
  • Company Code
  • Client
  • C_PRASMMRYFEDPYBLQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRASMMRYFEDPYBLQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRASMMRYFEDPYBLQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRASMMRYFEDPYBLQRY.MANDT == OIU_DO_DI.MANDT
Energy Unit
  • Client
  • Energy Unit
  • C_PRASMMRYFEDPYBLQRY.MANDT == T006.MANDT
  • C_PRASMMRYFEDPYBLQRY.ENERGYUNIT == T006.MSEHI
G/L Account Number
  • G/L Account Number
  • Company Code
  • Client
  • C_PRASMMRYFEDPYBLQRY.GLACCOUNT == SKB1.SAKNR
  • C_PRASMMRYFEDPYBLQRY.COMPANYCODE == SKB1.BUKRS
  • C_PRASMMRYFEDPYBLQRY.MANDT == SKB1.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • C_PRASMMRYFEDPYBLQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRASMMRYFEDPYBLQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRASMMRYFEDPYBLQRY.MANDT == OIU_DO_JV.MANDT
Contract Number
  • Contract Number
  • Client
PRA owner
  • PRA owner
  • Client
  • C_PRASMMRYFEDPYBLQRY.PRAOWNER == LFA1.LIFNR
  • C_PRASMMRYFEDPYBLQRY.MANDT == LFA1.MANDT
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
Full three char. product code (Major and Detail Products) C_PRASMMRYFEDPYBLQRY.PRODUCT == OIUX3_PDCD.PDCD
Volume Type Code C_PRASMMRYFEDPYBLQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Unit
  • Client
  • Volume Unit
  • C_PRASMMRYFEDPYBLQRY.MANDT == T006.MANDT
  • C_PRASMMRYFEDPYBLQRY.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Well Completion Number
  • Client
  • Well ID number
  • C_PRASMMRYFEDPYBLQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRASMMRYFEDPYBLQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRASMMRYFEDPYBLQRY.WELL == OIU_PR_WC.WL_NO