C_PRAPaymentDetailQry

PRA Payment Detail Query | view: CPVPAYMENTDTLQ | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/PP_CHK_DTL, T001, TKA02
Column Name Description
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossAmount Gross value
OwnerGrossAmount Owner Gross Value
OwnerNetAmount Owner Net Value
GrossMarketingCost Gross marketing costs
GrossTaxAmount Gross Tax
TotalMarketingAmt Total owner marketing cost
OwnerTaxAmount Owner tax
TotalDeductionAmt Total Owner Other Deducts
GrossLessDeductionAmt Gross value less deductions
WeightedNetPrice Price
Column Name Description
📏 Heating Unit Of Measure (HeatingValUnit):
HeatingValue Heating value
📏 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
Column Name Description
SalesDate Sales Date / Month
PaymentDate Check Date
Column Name Description
RecordType Payment Processing - Record Type Show values
CalculationBasis Actual, Entitlement, Settlement Codes Show values
Column Name Description Domain name
PaymentReference Check Number CHCKN
OwnerInterestType Participant Interest Type OIU_PART_INT_TYPE
OwnerInterestSequence Owner Interest Sequence Number OIU_OWN_ISQ_NO
DisbursementDecimalRatio Payment Processing - Disbursement decimal
FiscalPeriod Fiscal Period OIU_VDM_FIS_PERIOD
JntIntrstBilgVenture JIB Venture JV_NAME
JointVentureEquityType Equity type JV_ETYPE
JointVentureEquityGroup Equity group JV_EGROUP
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
NetRevenueInterestRatio Net Revenue Interest Percent OIU_PERCENT98
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • C_PRAPAYMENTDETAILQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PRAPAYMENTDETAILQRY.MANDT == TCURC.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • C_PRAPAYMENTDETAILQRY.COUNTRY == T005.LAND1
  • C_PRAPAYMENTDETAILQRY.MANDT == T005.MANDT
County Code
  • County Code
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_PRAPAYMENTDETAILQRY.COUNTY == T005E.COUNC
  • C_PRAPAYMENTDETAILQRY.COUNTRY == T005E.LAND1
  • C_PRAPAYMENTDETAILQRY.MANDT == T005E.MANDT
  • C_PRAPAYMENTDETAILQRY.REGION == T005E.REGIO
Delivery network number
  • Delivery network number
  • Client
  • C_PRAPAYMENTDETAILQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRAPAYMENTDETAILQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Company Code
  • Division of interest (DOI)
  • Client
  • Joint venture
  • C_PRAPAYMENTDETAILQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRAPAYMENTDETAILQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRAPAYMENTDETAILQRY.MANDT == OIU_DO_DI.MANDT
  • C_PRAPAYMENTDETAILQRY.JOINTVENTURE == OIU_DO_DI.VNAME
Energy Base Unit Of Measure
  • Energy Base Unit Of Measure
  • Client
  • C_PRAPAYMENTDETAILQRY.ENERGYUNIT == T006.MSEHI
  • C_PRAPAYMENTDETAILQRY.MANDT == T006.MANDT
G/L Account Number
  • ?
  • G/L Account Number
  • Client
  • C_PRAPAYMENTDETAILQRY.[column in domain "KTOPL"] == SKA1.KTOPL
  • C_PRAPAYMENTDETAILQRY.GLACCOUNT == SKA1.SAKNR
  • C_PRAPAYMENTDETAILQRY.MANDT == SKA1.MANDT
Heating Unit Of Measure
  • Heating Unit Of Measure
  • Client
  • C_PRAPAYMENTDETAILQRY.HEATINGVALUNIT == T006.MSEHI
  • C_PRAPAYMENTDETAILQRY.MANDT == T006.MANDT
Joint venture
  • Company Code
  • Client
  • Joint venture
  • C_PRAPAYMENTDETAILQRY.COMPANYCODE == T8JV.BUKRS
  • C_PRAPAYMENTDETAILQRY.MANDT == T8JV.MANDT
  • C_PRAPAYMENTDETAILQRY.JOINTVENTURE == T8JV.VNAME
Payment Processing - Detail Level Reject Code
  • Payment Processing - Detail Level Reject Code
  • Client
PRA owner
  • PRA owner
  • Client
  • C_PRAPAYMENTDETAILQRY.PRAOWNER == LFA1.LIFNR
  • C_PRAPAYMENTDETAILQRY.MANDT == LFA1.MANDT
Prior Period Adjustment Reason Code
  • Client
  • Prior Period Adjustment Reason Code
Full three char. product code (Major and Detail Products) C_PRAPAYMENTDETAILQRY.PRODUCT == OIUX3_PDCD.PDCD
Region (State, Province, County)
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_PRAPAYMENTDETAILQRY.COUNTRY == T005S.LAND1
  • C_PRAPAYMENTDETAILQRY.MANDT == T005S.MANDT
  • C_PRAPAYMENTDETAILQRY.REGION == T005S.BLAND
Suspense Reason Code
  • Suspense Reason Code
  • Client
Unit venture
  • Company Code
  • Unit venture
  • Client
  • C_PRAPAYMENTDETAILQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRAPAYMENTDETAILQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRAPAYMENTDETAILQRY.MANDT == OIU_DO_JV.MANDT
Volume Base Unit of Measure
  • Volume Base Unit of Measure
  • Client
  • C_PRAPAYMENTDETAILQRY.VOLUMEUNIT == T006.MSEHI
  • C_PRAPAYMENTDETAILQRY.MANDT == T006.MANDT
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well ID number
  • Client
  • Well Completion Number
  • C_PRAPAYMENTDETAILQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRAPAYMENTDETAILQRY.MANDT == OIU_PR_WC.MANDT
  • C_PRAPAYMENTDETAILQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO