C_PRASmmrySuspenseQry

PRA Summary Suspense Query | view: CPVSUMSUSPENSEQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/PP_SUS_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
  • Client
  • Currency Key
  • C_PRASMMRYSUSPENSEQRY.MANDT == TCURC.MANDT
  • C_PRASMMRYSUSPENSEQRY.COMPANYCODECURRENCY == TCURC.WAERS
Country/Region Key
  • Country/Region Key
  • Client
  • C_PRASMMRYSUSPENSEQRY.COUNTRY == T005.LAND1
  • C_PRASMMRYSUSPENSEQRY.MANDT == T005.MANDT
County Code
  • Country/Region Key
  • Region (State, Province, County)
  • County Code
  • Client
  • C_PRASMMRYSUSPENSEQRY.COUNTRY == T005E.LAND1
  • C_PRASMMRYSUSPENSEQRY.REGION == T005E.REGIO
  • C_PRASMMRYSUSPENSEQRY.COUNTY == T005E.COUNC
  • C_PRASMMRYSUSPENSEQRY.MANDT == T005E.MANDT
Delivery network number
  • Delivery network number
  • Client
  • C_PRASMMRYSUSPENSEQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRASMMRYSUSPENSEQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Division of interest (DOI)
  • Joint venture
  • ?
  • Client
  • C_PRASMMRYSUSPENSEQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRASMMRYSUSPENSEQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRASMMRYSUSPENSEQRY.[column in domain "BUKRS"] == OIU_DO_DI.BUKRS
  • C_PRASMMRYSUSPENSEQRY.MANDT == OIU_DO_DI.MANDT
Energy Unit
  • Energy Unit
  • Client
  • C_PRASMMRYSUSPENSEQRY.ENERGYUNIT == T006.MSEHI
  • C_PRASMMRYSUSPENSEQRY.MANDT == T006.MANDT
G/L Account Number
  • ?
  • Client
  • G/L Account Number
  • C_PRASMMRYSUSPENSEQRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PRASMMRYSUSPENSEQRY.MANDT == SKA1.MANDT
  • C_PRASMMRYSUSPENSEQRY.GLACCOUNT == SKA1.SAKNR
Joint venture
  • Joint venture
  • ?
  • Client
  • C_PRASMMRYSUSPENSEQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRASMMRYSUSPENSEQRY.[column in domain "BUKRS"] == OIU_DO_JV.BUKRS
  • C_PRASMMRYSUSPENSEQRY.MANDT == OIU_DO_JV.MANDT
PRA owner
  • PRA owner
  • Client
  • C_PRASMMRYSUSPENSEQRY.PRAOWNER == LFA1.LIFNR
  • C_PRASMMRYSUSPENSEQRY.MANDT == LFA1.MANDT
Prior Period Adjustment Reason Code
  • Prior Period Adjustment Reason Code
  • Client
Full three char. product code (Major and Detail Products) C_PRASMMRYSUSPENSEQRY.PRODUCT == OIUX3_PDCD.PDCD
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • C_PRASMMRYSUSPENSEQRY.COUNTRY == T005S.LAND1
  • C_PRASMMRYSUSPENSEQRY.REGION == T005S.BLAND
  • C_PRASMMRYSUSPENSEQRY.MANDT == T005S.MANDT
Suspense Reason Code
  • Client
  • Suspense Reason Code
Unit venture
  • Unit venture
  • Company Code
  • Client
  • C_PRASMMRYSUSPENSEQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRASMMRYSUSPENSEQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRASMMRYSUSPENSEQRY.MANDT == OIU_DO_JV.MANDT
Volume Unit
  • Volume Unit
  • Client
  • C_PRASMMRYSUSPENSEQRY.VOLUMEUNIT == T006.MSEHI
  • C_PRASMMRYSUSPENSEQRY.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Well Completion Number
  • Client
  • C_PRASMMRYSUSPENSEQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRASMMRYSUSPENSEQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRASMMRYSUSPENSEQRY.MANDT == OIU_PR_WC.MANDT