OIUX2_PUID_XMPH SAP table for – Reporting history for tax exemptions

Here we would like to draw your attention to OIUX2_PUID_XMPH 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). OIUX2_PUID_XMPH is a SAP standard transp table used for storing Reporting history for tax exemptions related data in SAP. It comes under the package OIU.

SAP OIUX2_PUID_XMPH table

Table OIUX2_PUID_XMPH technical data

TableOIUX2_PUID_XMPH
Data storingReporting history for tax exemptions
ModuleIS-OIL
Sub ModuleIS-OIL-PRA
SAP PackageOIU
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIUX2_PUID_XMPH 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 OIUX2_PUID_XMPH table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RPT_YYYYMM : Reporting Year and Month
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • RSG : Report Submission Group
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • AGENCY : Agency for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • OGIND : Oil and Gas Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • SALES_YYYYMM : Sales YYYYMM
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • PUID : Production Unit ID for tax reporting
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • AGENCY_VOL_TYPE : Agency defined Volume type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • AGENCY_TAX_CODE : Agency defined Tax Code for Reporting
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • PDIND : Purchaser/Producer Indicator
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • AFFL_COMP : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • EXEMPT_TYPE : Exempt Entity Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • EXMP_VL : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • STD_VOL_U : Standard volume unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • EXMP_VAL : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • CURRENCY : Currency
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • 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