/PRA/KS_TAXTXN

Tax Reporting Kansas Tax Transactions | #transactional | Component: Production and Revenue Accounting
Column Name Description
MANDT FK Client
BUKRS FK Company Code
SALES_DT Sales Date / Month
PDCD FK Full three char. product code (Major and Detail Products)
WL_NO FK Well ID number
WC_NO FK Well Completion Number
MP_NO Measurement point number
VNAME FK Joint venture
DOI_NO FK Division of interest (DOI)
DN_NO FK Delivery network number
CT_NO FK Contract Number
VL_TYPE_CD FK Volume type code
TAX_CLS FK Tax Class
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
Column Name Description
💲 Currency Key (T001.WAERS):
GROSS_VAL Gross Value
TAX_VAL Taxable Value
EXEMPT_VAL Exempt Value
KCC_ASS_DUE KCC Assessment Value
SEV_TAX_DUE Taxable Liability
MKT_COST Marketing Cost
MKT_COST_REIMB Marketing Cost Reimbursement
TAX_REIMB Tax Reimbursement
Column Name Description
Column Name Description
SALES_DT Sales Date / Month
Column Name Description
REV_BOOK_ADJ_IND Reversal/Booking/Adjustment Show values
OPER_PURC_IND Tax Reporting: Kansas Operator and Purchaser Indicators Show values
EXM_PROC_FLAG Tax Reporting - Kansas Exemption Show values
REJ_SUSP_IND Rejection-Suspension Status Show values
Column Name Description Domain name
CERTIFICATE_NO Exemption Certificate Number CHAR3
PAY_FL Tax Severance Tax Calculation Payment Obligations Types OIU_SEVT_PAY_FL
RPT_FL State Severance Tax Reporting Indicators CHAR1
GROSS_VOL Gross Volume /PRA/SIGNED_DEC_13_3
TAX_VOL Taxable Volume /PRA/SIGNED_DEC_13_3
EXEMPT_VOL Exempt Volume /PRA/SIGNED_DEC_13_3
WLR_VOL Tax 2.0 Kansas Wetgas Less Residue /PRA/SIGNED_DEC_13_3
API_NO Tax 2.0 KS - Kansas API Number
OPTION1 null
OPTION2 null
OPTION3 null
DOC_NO Val. document number OIU_MP_NO
DOC_YEAR Document year GJAHR
REJ_CD Tax Reporting : Kansas Reject code /PRA/KS_REJ_CODE
OIU_CRUSER Name of Person Responsible for Creating the Object USNAM
OIU_TIMESTAMP Tax 2.0 Data Element for Timestamp /PRA/KS_TMP
Master Data Relations Join Conditions
Company Code
Delivery network number
Division of interest (DOI)
  • Joint venture
  • Division of interest (DOI)
  • Company Code
Client /PRA/KS_TAXTXN.MANDT == T000.MANDT
Full three char. product code (Major and Detail Products) /PRA/KS_TAXTXN.PDCD == OIUX3_PDCD.PDCD
Tax Class
  • ?
  • ?
  • Client
  • Tax Class
Joint venture
  • Joint venture
  • Company Code
Measurement unit
  • /PRA/KS_TAXTXN.MANDT == T006.MANDT
  • /PRA/KS_TAXTXN.UOM == T006.MSEHI
Volume type code /PRA/KS_TAXTXN.VL_TYPE_CD == OIU_PR_VLTYP.VL_TYPE_CD
Joint venture
  • Joint venture
  • Company Code
Well Completion Number
  • Well ID number
  • Well Completion Number
Well ID number