I_PRAAcctgDocSmmryFedPybl

PRA Acctg Document Summary Federal Pybl | view: IPVSMMRYFEDPYBL | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/FP_PAY_SUM, /PRA/ACCT_COA
Column Name Description
SalesDate Sales Date / Month
CompanyCode FK Company Code
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
Well FK Well ID number
WellCompletion FK Well Completion Number
PRAContract FK Contract Number
VolumeType FK Volume Type Code
Product FK Full three char. product code (Major and Detail Products)
PRAOwner FK PRA owner
GLAccount FK G/L Account Number
CostCenter FK Cost Center
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
GLAccountType Account Type Show values
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
  • Client
  • Company Code
Currency Key
  • Client
  • Currency Key
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == TCURC.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.COMPANYCODECURRENCY == TCURC.WAERS
Cost Center
  • Client
  • ?
  • ?
  • Cost Center
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == CSKS.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.[column in domain "KOKRS"] == CSKS.KOKRS
  • I_PRAACCTGDOCSMMRYFEDPYBL.[column in domain "DATBI"] == CSKS.DATBI
  • I_PRAACCTGDOCSMMRYFEDPYBL.COSTCENTER == CSKS.KOSTL
Division of interest (DOI)
  • Client
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == OIU_DO_DI.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.JOINTVENTURE == OIU_DO_DI.VNAME
  • I_PRAACCTGDOCSMMRYFEDPYBL.COMPANYCODE == OIU_DO_DI.BUKRS
  • I_PRAACCTGDOCSMMRYFEDPYBL.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
Energy Unit
  • Energy Unit
  • Client
  • I_PRAACCTGDOCSMMRYFEDPYBL.ENERGYUNIT == T006.MSEHI
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == T006.MANDT
G/L Account Number
  • Client
  • G/L Account Number
  • Company Code
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == SKB1.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.GLACCOUNT == SKB1.SAKNR
  • I_PRAACCTGDOCSMMRYFEDPYBL.COMPANYCODE == SKB1.BUKRS
Joint venture
  • Client
  • Joint venture
  • Company Code
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == OIU_DO_JV.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.JOINTVENTURE == OIU_DO_JV.VNAME
  • I_PRAACCTGDOCSMMRYFEDPYBL.COMPANYCODE == OIU_DO_JV.BUKRS
Contract Number
  • Client
  • Contract Number
PRA owner
  • Client
  • PRA owner
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == LFA1.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.PRAOWNER == LFA1.LIFNR
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == OIU_CM_PPARSN.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.PRIORPERIODADJUSTMENTREASON == OIU_CM_PPARSN.PPA_RSN_CD
Full three char. product code (Major and Detail Products) I_PRAACCTGDOCSMMRYFEDPYBL.PRODUCT == OIUX3_PDCD.PDCD
Volume Type Code I_PRAACCTGDOCSMMRYFEDPYBL.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Unit
  • Client
  • Volume Unit
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == T006.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well Completion Number
  • Well ID number
  • I_PRAACCTGDOCSMMRYFEDPYBL.MANDT == OIU_PR_WC.MANDT
  • I_PRAACCTGDOCSMMRYFEDPYBL.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRAACCTGDOCSMMRYFEDPYBL.WELL == OIU_PR_WC.WL_NO