OIUX8_NM_SUFFXRF SAP table for – Tax 2.0 – New Mexico Suffix and tax rate x-ref

Here we would like to draw your attention to OIUX8_NM_SUFFXRF 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). OIUX8_NM_SUFFXRF is a SAP standard transp table used for storing Tax 2.0 – New Mexico Suffix and tax rate x-ref related data in SAP. It comes under the package OIU_X8.

SAP OIUX8_NM_SUFFXRF table

Table OIUX8_NM_SUFFXRF technical data

TableOIUX8_NM_SUFFXRF
Data storingTax 2.0 – New Mexico Suffix and tax rate x-ref
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X8
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • SUFFIX : Tax 2.0 – New Mexico Suffix for School Dist Code
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • MAJ_PD_CD : Major product code
    Its a key field. Its data type is CHAR (Character String) with field length 1
  • EFF_FROM_DT : Effective from date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • EFF_TO_DT : Effective To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AV_TAX_RATE : Valuation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • CN_TAX_RATE : Valuation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • ES_TAX_RATE : Valuation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SV_TAX_RATE : Valuation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • SEC_GEO_LOC : Secondary geographic location
    Its data type is CHAR (Character String) with field length 3
  • MUNICIPALITY : Tax 2.0 – New Mexico Municipality Name
    Its data type is CHAR (Character String) with field length 30
  • SCHOOL_DIST_CD : School district code
    Its data type is CHAR (Character String) with field length 3
  • .INCLUDE : Creator and date/time created
  • OIU_CRUSER : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • OIU_TIMESTAMP : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15