I_PRAAcctgDocSmmrySuspense

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