C_PRASmmryOwnrPyblQry

PRA Summary Owner Payable Query | view: CPVSUMOWNPBLQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/PP_PAY_SUM, /PRA/ACCT_COA
Column Name Description
PRAOwner FK PRA owner
OwnerInterestType Participant Interest Type
OwnerInterestSequence Owner Interest Sequence Number
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
Well FK Well ID number
WellCompletion FK Well Completion Number
SalesDate Sales Date / Month
Product FK Full three char. product code (Major and Detail Products)
DisbursementDecimalRatio Payment Processing - Disbursement decimal
GLAccount FK G/L Account Number
RecordType Payment Processing - Record Type Show values
CompanyCodeCurrency FK Currency Key
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
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
RecordType Payment Processing - Record Type Show values
CalculationBasis Actual, Entitlement, Settlement Codes Show values
PaymentCycle Payment Processing - Future Pay Flag Show values
Column Name Description Domain name
OwnerIsJntIntrstBilgEnabled Job Interest Billing Indicator OIUH_DO_JIB_OFFS_FL
FiscalPeriod Fiscal Period OIU_VDM_FIS_PERIOD
NetRevenueInterestRatio Net Revenue Interest Percent OIU_PERCENT98
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • C_PRASMMRYOWNRPYBLQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PRASMMRYOWNRPYBLQRY.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_PRASMMRYOWNRPYBLQRY.COUNTRY == T005.LAND1
  • C_PRASMMRYOWNRPYBLQRY.MANDT == T005.MANDT
County Code
  • County Code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_PRASMMRYOWNRPYBLQRY.COUNTY == T005E.COUNC
  • C_PRASMMRYOWNRPYBLQRY.COUNTRY == T005E.LAND1
  • C_PRASMMRYOWNRPYBLQRY.MANDT == T005E.MANDT
  • C_PRASMMRYOWNRPYBLQRY.REGION == T005E.REGIO
Delivery network number
  • Delivery network number
  • Client
  • C_PRASMMRYOWNRPYBLQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRASMMRYOWNRPYBLQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Joint venture
  • Client
  • ?
  • C_PRASMMRYOWNRPYBLQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRASMMRYOWNRPYBLQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRASMMRYOWNRPYBLQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRASMMRYOWNRPYBLQRY.[column in domain "BUKRS"] == OIU_DO_DI.BUKRS
Energy Unit
  • Energy Unit
  • Client
  • C_PRASMMRYOWNRPYBLQRY.ENERGYUNIT == T006.MSEHI
  • C_PRASMMRYOWNRPYBLQRY.MANDT == T006.MANDT
G/L Account Number
  • Client
  • ?
  • G/L Account Number
  • C_PRASMMRYOWNRPYBLQRY.MANDT == SKA1.MANDT
  • C_PRASMMRYOWNRPYBLQRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PRASMMRYOWNRPYBLQRY.GLACCOUNT == SKA1.SAKNR
Joint venture
  • Joint venture
  • Client
  • ?
  • C_PRASMMRYOWNRPYBLQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRASMMRYOWNRPYBLQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRASMMRYOWNRPYBLQRY.[column in domain "BUKRS"] == OIU_DO_JV.BUKRS
PRA owner
  • Client
  • PRA owner
  • C_PRASMMRYOWNRPYBLQRY.MANDT == LFA1.MANDT
  • C_PRASMMRYOWNRPYBLQRY.PRAOWNER == LFA1.LIFNR
Prior Period Adjustment Reason Code
  • Prior Period Adjustment Reason Code
  • Client
Full three char. product code (Major and Detail Products) C_PRASMMRYOWNRPYBLQRY.PRODUCT == OIUX3_PDCD.PDCD
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_PRASMMRYOWNRPYBLQRY.COUNTRY == T005S.LAND1
  • C_PRASMMRYOWNRPYBLQRY.MANDT == T005S.MANDT
  • C_PRASMMRYOWNRPYBLQRY.REGION == T005S.BLAND
Suspense Reason Code
  • Client
  • Suspense Reason Code
Unit venture
  • Unit venture
  • Company Code
  • Client
  • C_PRASMMRYOWNRPYBLQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRASMMRYOWNRPYBLQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRASMMRYOWNRPYBLQRY.MANDT == OIU_DO_JV.MANDT
Volume Unit
  • Volume Unit
  • Client
  • C_PRASMMRYOWNRPYBLQRY.VOLUMEUNIT == T006.MSEHI
  • C_PRASMMRYOWNRPYBLQRY.MANDT == T006.MANDT
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • C_PRASMMRYOWNRPYBLQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRASMMRYOWNRPYBLQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRASMMRYOWNRPYBLQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO