1. SAP Tutorial
  2. Oil & Gas

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

    • OIUX1_TRN_TAXHL related tables

    • OIUX1_FLD_CAT : Field Catalogue for Tax Reporting
    • OIUX1_TAX_SUSP : Records for suspension
    • OIUX1_AGY_TCDTX : Agency tax code text table
    • OIUX1_ADJ_TYP : Adjustment types for reporting
    • OIUX1_RPT_TAXH : Tax transaction header for reporting
    • OIUX1_RPT_SGRPTX : Text table for Report Submission Group
    • OIUX1_RPT_VOLH : Reported Volume Data by Reporting Entities
    • OIUX1_ADJ_TAXDC : Tax adjustments detail for reporting
    • OIUX1_VKEY_XREF : Table for variable key in Tax Reporting
    • OIUX1_ADJ_MKTC : Tax adjustments marketing costs for reporting
    • OIUX1_TRN_XMPL : Tax transaction exemptions for reporting
    • OIUX1_PUID_TAXH : Tax transaction header for reporting
    • OIUX1_RPT_IDB : Legal report time dependent base table
    • OIUX1_PROD_UNIT : Production Units/Leases
    • OIUX1_ADJ_TAXHC : Tax adjustments header for reporting
    • OIUX1_EXEC_COMB : Execution Combinations for Tax Reporting
    • OIUX1_FLD_VALB : Base table for field level data
    • OIUX1_LNK_REPUB : PUID and reporting entities link
    • OIUX1_TRN_TAXHC : Tax transaction header for reporting
    • OIUX1_TXCD_XREF : Cross reference between state tax codes and PRA entities

    OIUX1_TRN_TAXHL related transaction codes under SAP package OIU_X1

    • O3UX1_MIGR_TRN : Migrate tax transaction data
    • O3UX1_TAX_ADJ : Tax adjusments transaction
    • S_SO7_65001291 : IMG activity: OIUX1_EXEC_COMB
    • O3UX1_TAXREP_MSTR : Tax reporting master maintenance
    • S_SO7_65001290 : IMG activity: OIUX1_TXCD_XREF
    • O3UX1_TAXREP_MAIN : Tax Reporting Main
    • S_SO7_65001325 : Exception report for GL/TPSL entries
    • S_SO7_65001186 : Generated Text
    • O3UX1_MIGR_FINAL : Finalize tax reporting migration
    • S_SO7_65001304 : Program ROIUX1_TAX_PUID_MIGR
    • S_SO7_65001287 : IMG activity: OIUX1_ACT_MIGR
    • S_SO7_65001288 : IMG activity: OIUX1_AGY_DEFN
    • S_SO7_65001305 : Program ROIUX1_TAX_MSTR_MIGRATION
    • S_SO7_65001289 : IMG activity: OIUX1_RPT_SGRP

    Related References

    Related Tutorials

    OIUX1_TRN_TAXHC SAP table for – Tax transaction header for reporting

    OIUX1_TRN_TAXHC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_RPT_TAXH SAP table for – Tax transaction header for reporting

    OIUX1_RPT_TAXH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_PUID_TAXH SAP table for – Tax transaction header for reporting

    OIUX1_PUID_TAXH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX2_PUID_TAXH SAP table for – Tax transaction header for reporting

    OIUX2_PUID_TAXH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_ADJ_TAXHC SAP table for – Tax adjustments header for reporting

    OIUX1_ADJ_TAXHC table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX1_ARCH_TAXH SAP table for – Tax transaction header for reporting

    OIUX1_ARCH_TAXH table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    OIUX3_TX_TAXSTG SAP table for – Tax Reporting – Texas Tax Transaction Staging

    OIUX3_TX_TAXSTG table in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This table is used for storing data of...

    «
    »