I_PRAAcctgDocDetail

PRA Accounting Document Detail | view: IPVACCTGDOCDTL | TRAN | Extraction: Full only | 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
NetTaxAmount Line Item Net Tax Amount
NetTaxReimbmtAmt Line Item Net Tax Reimbursement Amount
NetInternalMarketingAmt Line Net Marketing Cost - Internal
NetExternalMarketingAmt Line Net Marketing Cost - External
NetReimbmtMarketingAmt Line Net Marketing Cost Reimbursement
OtherDeductionAmount Line Other deducts amount
OwnerNetAmount Owner Net Value
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
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
BookingReversalType Booking/Reversal Indicator 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
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
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
LastChangedByUser Changed By XUBNAME
ChangedDateTime Changed On Timestamp TZNTSTMPS
NumberOfItems Number of Items
Master Data Relations Join Conditions
AR MP
  • AR MP
  • Client
  • I_PRAACCTGDOCDETAIL.ACCTSRBLMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIU_PR_MP.MANDT
Affiliated Company
  • Affiliated Company
  • Client
Company Code
  • Company Code
  • Client
  • I_PRAACCTGDOCDETAIL.COMPANYCODE == T001.BUKRS
  • I_PRAACCTGDOCDETAIL.MANDT == T001.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • I_PRAACCTGDOCDETAIL.COUNTRY == T005.LAND1
  • I_PRAACCTGDOCDETAIL.MANDT == T005.MANDT
Delivery network number
  • Delivery network number
  • Client
  • I_PRAACCTGDOCDETAIL.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIU_PR_DN.MANDT
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • I_PRAACCTGDOCDETAIL.ENERGYUNIT == T006.MSEHI
  • I_PRAACCTGDOCDETAIL.MANDT == T006.MANDT
Fiscal Period
  • Fiscal Period
  • Company Code
  • Client
Heating Unit Of Measure
  • Heating Unit Of Measure
  • Client
  • I_PRAACCTGDOCDETAIL.HEATINGVALUNIT == T006.MSEHI
  • I_PRAACCTGDOCDETAIL.MANDT == T006.MANDT
Material Number
  • Client
  • Material Number
Measurement point number
  • Measurement point number
  • Client
  • I_PRAACCTGDOCDETAIL.MEASUREMENTPOINT == OIU_PR_MP.MP_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIU_PR_MP.MANDT
Originating Measurement Point Number
  • Originating Measurement Point Number
  • Client
  • I_PRAACCTGDOCDETAIL.ORIGINATINGMEASUREMENTPT == OIU_PR_MP.MP_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIU_PR_MP.MANDT
Participant Interest Type I_PRAACCTGDOCDETAIL.OWNERINTERESTTYPE == OIU_CM_PINTTY.OWN_INT_TYPE_CD
Trading Partner
  • Trading Partner
  • Client
  • I_PRAACCTGDOCDETAIL.PARTNERCOMPANY == T880.RCOMP
  • I_PRAACCTGDOCDETAIL.MANDT == T880.MANDT
Contract Number
  • Contract Number
  • Client
PRA owner
  • PRA owner
  • Client
Primary geographical location (PRI geo. loc.)
  • Primary geographical location (PRI geo. loc.)
  • Country/Region Key
  • Client
Adjustment Reason Code
  • Adjustment Reason Code
  • Client
Processing Company Code
  • Processing Company Code
  • Client
PBA Number
  • PBA Number
  • Client
  • I_PRAACCTGDOCDETAIL.PRODUCTBALANCINGAGREEMENT == OIUBL01_PBA.PBA_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIUBL01_PBA.MANDT
Purchaser Number
  • Purchaser Number
  • Client
  • I_PRAACCTGDOCDETAIL.PURCHASER == KNA1.KUNNR
  • I_PRAACCTGDOCDETAIL.MANDT == KNA1.MANDT
Related contract number
  • Related contract number
  • Client
Remitter (Customer)
  • Remitter (Customer)
  • Client
  • I_PRAACCTGDOCDETAIL.REMITTER == KNA1.KUNNR
  • I_PRAACCTGDOCDETAIL.MANDT == KNA1.MANDT
Suspense Reason Code
  • Suspense Reason Code
  • Client
Transporter number
  • Transporter number
  • Client
  • I_PRAACCTGDOCDETAIL.TRANSPORTER == KNA1.KUNNR
  • I_PRAACCTGDOCDETAIL.MANDT == KNA1.MANDT
Volume Type Code I_PRAACCTGDOCDETAIL.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Volume Base Unit of Measure
  • Volume Base Unit of Measure
  • Client
  • I_PRAACCTGDOCDETAIL.VOLUMEUNIT == T006.MSEHI
  • I_PRAACCTGDOCDETAIL.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Well Completion Number
  • Client
  • I_PRAACCTGDOCDETAIL.WELL == OIU_PR_WC.WL_NO
  • I_PRAACCTGDOCDETAIL.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • I_PRAACCTGDOCDETAIL.MANDT == OIU_PR_WC.MANDT