C_PRATaxRptgHistoryKSQry

PRA Tax Reporting History Kansas Query | view: CPVTAXRPTGHKS | Extraction: Not supported | Component: Production and Revenue Accounting
Tables used: /PRA/KS_TAXHST, T001, TKA02
Column Name Description
CompanyCode FK Company Code
SalesDate Sales Date / Month
Product FK Full three char. product code (Major and Detail Products)
Well FK Well ID number
WellCompletion FK Well Completion Number
MeasurementPoint Measurement point number
JointVenture FK Joint venture
DivisionOfInterest FK Division of interest (DOI)
DeliveryNetwork FK Delivery network number
PRAContract FK Contract Number
VolumeType FK Volume type code
TaxClassification FK Tax Class
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
GrossValInCoCodeCrcy Gross Value
TaxableValInCoCodeCrcy Taxable Value
TaxExmptValInCoCodeCrcy Exempt Value
TaxAssmtValInCoCodeCrcy KCC Assessment Value
SeveranceTaxAmtInCoCodeCrcy Taxable Liability
MktgCostInCoCodeCrcy Marketing Cost
MktgReimbmtCostInCoCodeCrcy Marketing Cost Reimbursement
TaxReimbmtAmtInCoCodeCrcy Tax Reimbursement
Column Name Description
Column Name Description
SalesDate Sales Date / Month
Column Name Description
TaxRptgRvslOrBkgOrAdjmt Reversal/Booking/Adjustment Show values
OperatorOrPurchaserCode Tax Reporting: Kansas Operator and Purchaser Indicators Show values
TaxExemptCode Tax Reporting - Kansas Exemption Show values
Column Name Description Domain name
TaxExmpCertNmbr Exemption Certificate Number CHAR3
ValuationDocumentNumber Val. document number OIU_MP_NO
ValuationDocumentYear Document year GJAHR
HasSeveranceTaxPaytOblgn Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
SeveranceTaxRptgType State Severance Tax Reporting Indicators CHAR1
CreatedByUser Created By XUBNAME
CreationDateTime Created On Timestamp TZNTSTMPS
GrossVolInBaseUnit Gross Volume /PRA/SIGNED_DEC_13_3
TaxableVolInBaseUnit Taxable Volume /PRA/SIGNED_DEC_13_3
WetGasLessResidueGasVolInMCF Tax 2.0 Kansas Wetgas Less Residue /PRA/SIGNED_DEC_13_3
TaxExmptVolInBaseUnit Exempt Volume /PRA/SIGNED_DEC_13_3
Country Country/Region Key LAND1
PrimaryGeogrlLocation Primary geographical location (PRI geo. loc.) OIU_PRI_GEO_LOC
Master Data Relations Join Conditions
Measurement unit
  • Client
  • Measurement unit
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == T006.MANDT
  • C_PRATAXRPTGHISTORYKSQRY.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
Currency Key
  • Currency Key
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.COMPANYCODECURRENCY == TCURC.WAERS
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == TCURC.MANDT
Delivery network number
  • Delivery network number
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.DELIVERYNETWORK == OIU_PR_DN.DN_NO
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_PR_DN.MANDT
Division of interest (DOI)
  • Joint venture
  • Company Code
  • Division of interest (DOI)
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.JOINTVENTURE == OIU_DO_DI.VNAME
  • C_PRATAXRPTGHISTORYKSQRY.COMPANYCODE == OIU_DO_DI.BUKRS
  • C_PRATAXRPTGHISTORYKSQRY.DIVISIONOFINTEREST == OIU_DO_DI.DOI_NO
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_DO_DI.MANDT
Joint venture
  • Joint venture
  • Company Code
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.JOINTVENTURE == OIU_DO_JV.VNAME
  • C_PRATAXRPTGHISTORYKSQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_DO_JV.MANDT
Full three char. product code (Major and Detail Products) C_PRATAXRPTGHISTORYKSQRY.PRODUCT == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Tax Class
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.[column in domain "OIU_PRI_GEO_LOC"] == OIU_CM_TAXCLS.PRI_GEO_LOC
  • C_PRATAXRPTGHISTORYKSQRY.[column in domain "LAND1"] == OIU_CM_TAXCLS.COUNTRY
  • C_PRATAXRPTGHISTORYKSQRY.TAXCLASSIFICATION == OIU_CM_TAXCLS.TAX_CLS
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_CM_TAXCLS.MANDT
Unit Venture
  • Company Code
  • Client
  • Unit Venture
  • C_PRATAXRPTGHISTORYKSQRY.COMPANYCODE == OIU_DO_JV.BUKRS
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_DO_JV.MANDT
  • C_PRATAXRPTGHISTORYKSQRY.UNITJOINTVENTURE == OIU_DO_JV.VNAME
Volume type code C_PRATAXRPTGHISTORYKSQRY.VOLUMETYPE == OIU_PR_VLTYP.VL_TYPE_CD
Well ID number
  • Well ID number
  • Client
Well Completion Number
  • Well Completion Number
  • Well ID number
  • Client
  • C_PRATAXRPTGHISTORYKSQRY.WELLCOMPLETION == OIU_PR_WC.WC_NO
  • C_PRATAXRPTGHISTORYKSQRY.WELL == OIU_PR_WC.WL_NO
  • C_PRATAXRPTGHISTORYKSQRY.MANDT == OIU_PR_WC.MANDT