OIUX1_TRN_TAXHL SAP table for – Tax transaction header for reporting

Here we would like to draw your attention to OIUX1_TRN_TAXHL table in SAP. As we know it is being mainly used with the SAP IS-OIL-PRA (Production and Revenue Accounting in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIUX1_TRN_TAXHL is a SAP standard transp table used for storing Tax transaction header for reporting related data in SAP. It comes under the package OIU_X1.

SAP OIUX1_TRN_TAXHL table

Table OIUX1_TRN_TAXHL technical data

TableOIUX1_TRN_TAXHL
Data storingTax transaction header for reporting
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X1
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUX1_TRN_TAXHL Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIUX1_TRN_TAXHL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • VNAME : Joint venture
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • DOI_NO : Division of interest (DOI)
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • WL_NO : Well ID number
    Its a key field. Its data type is CHAR (Character String) with field length 15
  • WC_NO : Well Completion Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MP_NO : Measurement point number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • SALE_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • MATNR : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • CT_NO : Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • DN_NO : Delivery network number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • VL_TYPE_CD : Volume type code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • TAXHC_SYSNO : Tax header sysno for reporting
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • DOC_YEAR : Document year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • DOC_NO : Val. document number
    Its data type is CHAR (Character String) with field length 20
  • MAJPD_CD : Major product code
    Its data type is CHAR (Character String) with field length 1
  • UNIT_VNAME : Joint venture
    Its data type is CHAR (Character String) with field length 6
  • PU_NO : Purchaser
    Its data type is CHAR (Character String) with field length 10
  • PPA_RSN_CD : Prior Period Adjustment Reason Code
    Its data type is CHAR (Character String) with field length 2
  • PRI_GEO_LOC : Primary geographical location (PRI geo. loc.)
    Its data type is CHAR (Character String) with field length 2
  • SEC_GEO_LOC : Secondary geographic location
    Its data type is CHAR (Character String) with field length 3
  • GRV_AM : Oil/gas density at standard/base conditions
    Its data type is FLTP (Floating point number) with field length 16
  • PRD_DAYS : Days produced
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • REJECT_FLAG : Reject flag
    Its data type is CHAR (Character String) with field length 1
  • USERNAME : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • TIMESTAMP : Time stamp in Numeric Character
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • .INCLUDE : Execution Parameters for Tax Reporting
  • RPT_YYYYMM : Reporting Year and Month
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • RSG : Report Submission Group
    Its data type is CHAR (Character String) with field length 4
  • AGENCY : Agency for Reporting
    Its data type is CHAR (Character String) with field length 3
  • OGIND : Oil and Gas Indicator
    Its data type is CHAR (Character String) with field length 1
  • TAXHL_SYSNO : Tax header sysno for reporting
    Its data type is NUMC (Character String with Digits Only) with field length 20