I_ValnDocAcctgItem

Valuation Document Accounting Item | view: IPVVLDOCACCTDOC | TRAN | Extraction: Full only | Component: Production and Revenue Accounting
Tables used: /PRA/VL_ACC_DOC, OIU_CM_PDCD
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
Column Name Description
📏 Heating Unit Of Measure (HeatingValUnit):
PressureBaseQty Pressure Base
HeatingValue Heating value
GrossVolReducnInVolUnit Gross PVR
OwnrVolReducnInVolUnit Owner PVR
📏 Volume Base Unit of Measure (VolumeUnit):
GrossVolInVolUnit Total Gross Volume
OwnerNetVolInVolUnit Owner Net Volume
📏 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
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
Master Data Relations Join Conditions
AR MP
  • AR MP
  • Client
  • I_VALNDOCACCTGITEM.ACCTSRBLMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_VALNDOCACCTGITEM.MANDT == OIU_PR_MP.MANDT
Affiliated Company
  • Affiliated Company
  • Client
Country/Region Key
  • Client
  • Country/Region Key
  • I_VALNDOCACCTGITEM.MANDT == T005.MANDT
  • I_VALNDOCACCTGITEM.COUNTRY == T005.LAND1
Delivery network number
  • Client
  • Delivery network number
  • I_VALNDOCACCTGITEM.MANDT == OIU_PR_DN.MANDT
  • I_VALNDOCACCTGITEM.DELIVERYNETWORK == OIU_PR_DN.DN_NO
Energy Base Unit Of Measure
  • Client
  • Energy Base Unit Of Measure
  • I_VALNDOCACCTGITEM.MANDT == T006.MANDT
  • I_VALNDOCACCTGITEM.ENERGYUNIT == T006.MSEHI
Heating Unit Of Measure
  • Heating Unit Of Measure
  • Client
  • I_VALNDOCACCTGITEM.HEATINGVALUNIT == T006.MSEHI
  • I_VALNDOCACCTGITEM.MANDT == T006.MANDT
Material Number
  • Material Number
  • Client
Measurement point number
  • Measurement point number
  • Client
  • I_VALNDOCACCTGITEM.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • I_VALNDOCACCTGITEM.MANDT == OIU_PR_MP.MANDT
Originating Measurement Point Number
  • Originating Measurement Point Number
  • Client
  • I_VALNDOCACCTGITEM.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_VALNDOCACCTGITEM.MANDT == OIU_PR_MP.MANDT
Participant Interest Type I_VALNDOCACCTGITEM.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Trading Partner
  • Client
  • Trading Partner
  • I_VALNDOCACCTGITEM.MANDT == T880.MANDT
  • I_VALNDOCACCTGITEM.PARTNERCOMPANY == T880.RCOMP
Contract Number
  • Client
  • Contract Number
PRA owner
  • Client
  • PRA owner
Primary geographical location (PRI geo. loc.)
  • Client
  • Country/Region Key
  • Primary geographical location (PRI geo. loc.)
Adjustment Reason Code
  • Adjustment Reason Code
  • Client
Processing Company Code
  • Client
  • Processing Company Code
PBA Number
  • Client
  • PBA Number
  • I_VALNDOCACCTGITEM.MANDT == OIUBL01_PBA.MANDT
  • I_VALNDOCACCTGITEM.PRODUCTBALANCINGAGREEMENT == OIUBL01_PBA.PBA_NO
Purchaser Number
  • Client
  • Purchaser Number
  • I_VALNDOCACCTGITEM.MANDT == KNA1.MANDT
  • I_VALNDOCACCTGITEM.PURCHASER == KNA1.KUNNR
Related contract number
  • Client
  • Related contract number
Remitter (Customer)
  • Client
  • Remitter (Customer)
  • I_VALNDOCACCTGITEM.MANDT == KNA1.MANDT
  • I_VALNDOCACCTGITEM.REMITTER == KNA1.KUNNR
Suspense Reason Code
  • Client
  • Suspense Reason Code
Transporter number
  • Client
  • Transporter number
  • I_VALNDOCACCTGITEM.MANDT == KNA1.MANDT
  • I_VALNDOCACCTGITEM.TRANSPORTER == KNA1.KUNNR
Volume Type Code I_VALNDOCACCTGITEM.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Client
  • Volume Base Unit of Measure
  • I_VALNDOCACCTGITEM.MANDT == T006.MANDT
  • I_VALNDOCACCTGITEM.VOLUMEUNIT == T006.MSEHI
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • I_VALNDOCACCTGITEM.WELL == OIU_PR_WC.WL_NO
  • I_VALNDOCACCTGITEM.MANDT == OIU_PR_WC.MANDT
  • I_VALNDOCACCTGITEM.WELLCOMPLETION == OIU_PR_WC.WC_NO