C_PRAPndngValnAcctgItmQry

PRA Pending Valuation Acctg Item Query | view: CPVPENDVLAIQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/VL_ACC_DOC, /PRA/VL_ACC_DED, /PRA/VL_ACC_MKT, /PRA/VL_ACC_TAX, T001, TKA02, OIU_CM_PDCD, OIURV_DOC_HDR
Column Name Description
ValuationDocumentYear Document year
ValuationDocumentNumber Val. document number
BookingReversalType Booking/Reversal Indicator Show values
ValnDocAcctgItem VL Document Accounting Line Number
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossAmount Gross value
OwnerGrossAmount Owner Gross Value
OwnerNetAmount Owner Net Value
NetTaxAmount Net Tax Amount
NetTaxReimbmtAmt Net Tax Reimbursement Amount
GrossTaxAmount Gross Tax Amount
GrossTaxReimbmtAmt Gross Tax Reimbursement Amount
OtherDeductionAmount Other deducts amount
NetInternalMarketingAmt Net Marketing Cost - Internal
NetExternalMarketingAmt Net Marketing Cost - External
NetReimbmtMarketingAmt Net Marketing Cost Reimbursement
GrossInternalMarketingAmt Gross Marketing Cost - Internal
GrossExternalMarketingAmt Gross Marketing Cost - External
GrossReimbmtMarketingAmt Gross 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
ItemIsNetZero Net Impact Indicator 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
ValuationDocumentStatus Valuation Document Status Show values
Column Name Description Domain name
MinorProduct Minor Product Code OIU_PD_CD
CompanyCode Company Code BUKRS
FiscalPeriod Fiscal Period OIU_VDM_FIS_PERIOD
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
Master Data Relations Join Conditions
AR MP
  • AR MP
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.ACCTSRBLMEASUREMENTPT == OIU_PR_MP.MP_NO
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
Affiliated Company
  • Client
  • Affiliated Company
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_CM_COMPC.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.AFFILIATEDCOMPANYCODE == OIU_CM_COMPC.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.COUNTRY == T005.LAND1
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == T005.MANDT
Delivery network number
  • Client
  • Delivery network number
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_PR_DN.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.ENERGYUNIT == T006.MSEHI
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == T006.MANDT
Heating Unit Of Measure
  • Client
  • Heating Unit Of Measure
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == T006.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.HEATINGVALUNIT == T006.MSEHI
Material Number
  • Material Number
  • Client
Measurement point number
  • Client
  • Measurement point number
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
Originating Measurement Point Number
  • Client
  • Originating Measurement Point Number
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_PR_MP.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
Participant Interest Type C_PRAPNDNGVALNACCTGITMQRY.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Trading Partner
  • Trading Partner
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.PARTNERCOMPANY == T880.RCOMP
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == T880.MANDT
Contract Number
  • Contract Number
  • Client
PRA owner
  • PRA owner
  • Client
Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
  • Primary geographical location (PRI geo. loc.)
  • C_PRAPNDNGVALNACCTGITMQRY.COUNTRY == OIU_CM_LXPGL.LAND1
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_CM_LXPGL.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.PRIMARYGEOGRLLOCATION == OIU_CM_LXPGL.PRI_GEO_LOC
Adjustment Reason Code
  • Client
  • Adjustment Reason Code
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_CM_PPARSN.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.PRIORPERIODADJUSTMENTREASON == OIU_CM_PPARSN.PPA_RSN_CD
Processing Company Code
  • Processing Company Code
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.PROCESSINGCOMPANYCODE == OIU_CM_COMPC.BUKRS
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_CM_COMPC.MANDT
PBA Number
  • PBA Number
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.PRODUCTBALANCINGAGREEMENT == OIUBL01_PBA.PBA_NO
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIUBL01_PBA.MANDT
Purchaser Number
  • Client
  • Purchaser Number
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == KNA1.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.PURCHASER == KNA1.KUNNR
Related contract number
  • Client
  • Related contract number
Remitter (Customer)
  • Remitter (Customer)
  • Client
  • C_PRAPNDNGVALNACCTGITMQRY.REMITTER == KNA1.KUNNR
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == KNA1.MANDT
Suspense Reason Code
  • Client
  • Suspense Reason Code
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_CM_SUSP.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.SUSPENSEREASON == OIU_CM_SUSP.SUSP_CD
Transporter number
  • Client
  • Transporter number
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == KNA1.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.TRANSPORTER == KNA1.KUNNR
Volume Type Code C_PRAPNDNGVALNACCTGITMQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == T006.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • C_PRAPNDNGVALNACCTGITMQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRAPNDNGVALNACCTGITMQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRAPNDNGVALNACCTGITMQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO