C_PRAPostedAcctgItmQry

PRA Posted Accounting Item Query | view: CPVPOSTEDAIQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/ACCT_DOC, OIU_CM_PDCD
Column Name Description
CompanyCode FK Company Code
FiscalPeriod FK Fiscal Period
AccountingDocument FK Revenue Accounting Document Number
AccountingDocumentItem Accounting Document Line Number
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossAmount Gross value
OwnerGrossAmount Owner Gross Value
OwnerNetAmount Owner Net Value
NetTaxAmount Line Item Net Tax Amount
NetTaxReimbmtAmt Line Item Net Tax Reimbursement Amount
OtherDeductionAmount Line Other deducts amount
NetInternalMarketingAmt Line Net Marketing Cost - Internal
NetExternalMarketingAmt Line Net Marketing Cost - External
NetReimbmtMarketingAmt Line Net Marketing Cost Reimbursement
Column Name Description
📏 Volume Base Unit of Measure (VolumeUnit):
PressureBaseQty Pressure Base
GrossVolInVolUnit Total Gross Volume
OwnerNetVolInVolUnit Owner Net Volume
GrossVolReducnInVolUnit Gross PVR
OwnrVolReducnInVolUnit Owner PVR
📏 Heating Unit Of Measure (HeatingValUnit):
HeatingValue Heating value
📏 Energy Base Unit Of Measure (EnergyUnit):
GrossEnergyInEnergyUnit Gross Energy
OwnerEnergyInEnergyUnit Owner Energy
GrossEngyReductionInEngyUnit Gross PTR
OwnerEnergyReducnInEnergyUnit Owner PTR
Column Name Description
SalesDate Sales Date / Month
PaymentDate Check Date
CashReceiptDate Cash Receipt Date
Column Name Description
BookingReversalType Booking/Reversal Indicator Show values
MajorProduct Major product code Show values
ItemIsRejected Accounting Document rejection flag Show values
GLAccountType Account Type Show values
AcctDeterminationCategory Account category code Show values
ItemIsSummarizedByProduct PRA Product Code Summarize Indicator Show values
ItemIsWriteOff Accounting Document Writeoff flag Show values
ItemIsCleared Accounting Document Clearing Show values
OwnerPaymentStatus Pay Code Show values
OwnerIsJntIntrstBilgEnabled Joint Interest Billing Offset Flag Show values
PRALegalForm Entity Code Show values
ItemIsReallocated Reallocated flag - results reallocated thru chain-of-title Show values
Column Name Description Domain name
MinorProduct Minor Product Code OIU_PD_CD
GLAccount G/L Account Number SAKNR
JointVenture Joint venture JV_NAME
DivisionOfInterest Division of interest (DOI) OIU_DOI_NO
UnitJointVenture Unit Venture JV_NAME
Product Full three char. product code (Major and Detail Products) OIU_FULL_PD_CD
DocumentItemText PRA Account Documnet Line Item's Description
TaxClassification Tax Class OIU_TAX_CLS
County County Code COUNC
Region Region (State, Province, County) REGIO
GasPlantJointVenture Gas Plant Venture JV_NAME
GasPlantDivisionOfInterest Gasplant DOI No OIU_DOI_NO
PRAContractType Contract Type OIU_CT_TYPE_CD
AccountsReceivableJointVenture AR Venture JV_NAME
AcctsRblDivisionOfInterest AR DOI OIU_DOI_NO
AlternateProperty Remitter Property
AlternateProduct Remitter Product OIU_FULL_PD_CD
PaymentReference Check Number CHCKN
SeveranceTaxType Severance Tax Type OIU_SEVT_TAX_TY
MarketingType Marketing type code OIU_MK_TYPE_CD
ExpenseJointVenture Expense Property number JV_NAME
ExpenseDivisionOfInterest Expense DOI Number OIU_DOI_NO
APIGravityRatio Oil/gas density at standard/base conditions OIU_OIB_DICHT
DisbursementDecimalRatio Disbursement Decimal OIU_PERCENT98
NetRevenueInterestRatio Net Revenue Interest Percent OIU_PERCENT98
OwnerInterestSequence Owner Interest Sequence Number OIU_OWN_ISQ_NO
CalculationBasis Actual / Entitled / Settlement Code CHAR1
JntIntrstBilgPartner JIB Partner KUNNR
TaxBasis Tax Free Code OIU_TAX_FREE_CD
RefValnDocYear Reference VL Document Year GJAHR
RefValnDoc Reference VL Document Number OIU_MP_NO
RefValnDocItem Reference VL Document Accounting Line Item OIU_DOC_LINENR
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
NumberOfItems Number of Items
JntIntrstBilgVenture JIB Venture JV_NAME
JointVentureEquityType Equity type JV_ETYPE
JointVentureEquityGroup Equity group JV_EGROUP
RefFiscalPeriod Fiscal Period OIU_VDM_FIS_PERIOD
RefAccountingDocument Revenue Accounting Trace Document Number /PRA/ACCOUNTING_DOC_NO
RefAccountingDocumentItem Accounting document trace line number NUMC08
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On Timestamp TZNTSTMPS
Master Data Relations Join Conditions
AR MP
  • AR MP
  • Client
  • C_PRAPOSTEDACCTGITMQRY.ACCTSRBLMEASUREMENTPT == OIU_PR_MP.MP_NO
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
Affiliated Company
  • Client
  • Affiliated Company
Company Code
  • Client
  • Company Code
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T001.MANDT
  • C_PRAPOSTEDACCTGITMQRY.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_PRAPOSTEDACCTGITMQRY.COUNTRY == T005.LAND1
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T005.MANDT
Delivery network number
  • Delivery network number
  • Client
  • C_PRAPOSTEDACCTGITMQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_PR_DN.MANDT
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • C_PRAPOSTEDACCTGITMQRY.ENERGYUNIT == T006.MSEHI
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T006.MANDT
Fiscal Period
  • Client
  • Fiscal Period
  • Company Code
Heating Unit Of Measure
  • Client
  • Heating Unit Of Measure
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T006.MANDT
  • C_PRAPOSTEDACCTGITMQRY.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
Measurement point number
  • Client
  • Measurement point number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRAPOSTEDACCTGITMQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Originating Measurement Point Number
  • Client
  • Originating Measurement Point Number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRAPOSTEDACCTGITMQRY.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type C_PRAPOSTEDACCTGITMQRY.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Trading Partner
  • Client
  • Trading Partner
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T880.MANDT
  • C_PRAPOSTEDACCTGITMQRY.PARTNERCOMPANY == T880.RCOMP
Contract Number
  • Client
  • Contract Number
PRA owner
  • Client
  • PRA owner
Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
Adjustment Reason Code
  • Client
  • Adjustment Reason Code
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_CM_PPARSN.MANDT
  • C_PRAPOSTEDACCTGITMQRY.PRIORPERIODADJUSTMENTREASON == OIU_CM_PPARSN.PPA_RSN_CD
Processing Company Code
  • Client
  • Processing Company Code
PBA Number
  • Client
  • PBA Number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIUBL01_PBA.MANDT
  • C_PRAPOSTEDACCTGITMQRY.PRODUCTBALANCINGAGREEMENT == OIUBL01_PBA.PBA_NO
Purchaser Number
  • Client
  • Purchaser Number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == KNA1.MANDT
  • C_PRAPOSTEDACCTGITMQRY.PURCHASER == KNA1.KUNNR
Related contract number
  • Client
  • Related contract number
Remitter (Customer)
  • Client
  • Remitter (Customer)
  • C_PRAPOSTEDACCTGITMQRY.MANDT == KNA1.MANDT
  • C_PRAPOSTEDACCTGITMQRY.REMITTER == KNA1.KUNNR
Suspense Reason Code
  • Client
  • Suspense Reason Code
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_CM_SUSP.MANDT
  • C_PRAPOSTEDACCTGITMQRY.SUSPENSEREASON == OIU_CM_SUSP.SUSP_CD
Transporter number
  • Client
  • Transporter number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == KNA1.MANDT
  • C_PRAPOSTEDACCTGITMQRY.TRANSPORTER == KNA1.KUNNR
Volume Type Code C_PRAPOSTEDACCTGITMQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • C_PRAPOSTEDACCTGITMQRY.MANDT == T006.MANDT
  • C_PRAPOSTEDACCTGITMQRY.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Client
  • Well ID number
Well Completion Number
  • Client
  • Well ID number
  • Well Completion Number
  • C_PRAPOSTEDACCTGITMQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRAPOSTEDACCTGITMQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRAPOSTEDACCTGITMQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO