1. SAP Tutorial
  2. Oil & Gas

OIUX8_NM_TAXDTL SAP table for – Tax 2.0 – New Mexico Tax Details

Here we would like to draw your attention to OIUX8_NM_TAXDTL 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_TAXDTL is a SAP standard transp table used for storing Tax 2.0 – New Mexico Tax Details related data in SAP. It comes under the package OIU_X8.

SAP OIUX8_NM_TAXDTL table

Table OIUX8_NM_TAXDTL technical data

TableOIUX8_NM_TAXDTL
Data storingTax 2.0 – New Mexico Tax Details
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_TAXDTL 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_TAXDTL table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • DOC_NO : Val. document number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • DOC_YEAR : Document year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • LINE_NO : Document Line Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 5
  • POS_NO : Position Number for
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • TAX_TYPE : Severance Tax Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • 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
  • ENTITY_ALLOC_DEC : Net Revenue Interest Percent
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • SUFFIX_DEC : Valuation Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • GROSS_VOL : Gross volume
    Its data type is QUAN (Quantity field) with field length 13
  • GROSS_VAL : Gross value
    Its data type is CURR (Currency Field) with field length 15
  • TAX_VOL : Taxable volume
    Its data type is QUAN (Quantity field) with field length 13
  • TAX_VAL : Taxable value
    Its data type is CURR (Currency Field) with field length 15
  • TAX_RATE : Value tax rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • TAX_AMT : Actual state tax amount
    Its data type is CURR (Currency Field) with field length 15
  • EXEMPT_VOL : Exempt volume
    Its data type is QUAN (Quantity field) with field length 13
  • EXEMPT_VAL : Exempt value
    Its data type is CURR (Currency Field) with field length 15
  • TAX_FREE_05_VAL : Tax free 05 value
    Its data type is CURR (Currency Field) with field length 15
  • TAX_FREE_05_VL : Tax free 05 volume
    Its data type is QUAN (Quantity field) with field length 13
  • REIM_AMT : State Tax reimbursement amount
    Its data type is CURR (Currency Field) with field length 15
  • BLPS_GROSS_VOL : Before lease plant split gross volume
    Its data type is QUAN (Quantity field) with field length 13
  • BLPS_GROSS_VAL : Before lease plant split gross value
    Its data type is CURR (Currency Field) with field length 15
  • RET_LSE_PC : Percent Returned to Lease
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
  • .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

    • OIUX8_NM_TAXDTL related tables

    • OIUX8_NM_OOSWO : Tax 2.0 – New Mexico Out Of Statute Write Off
    • OIUX8_NM_JC_MST : Tax 2.0 – NM – Jicarilla Credit Master
    • OIUX8_NM_ASU_DT : Tax 2.0 – NM – Auto Suspend Detail
    • OIUX8_NM_PDCXRF : Tax 2.0 – NM – Product Code Xref
    • OIUX8_NM_RPDT_H : Tax 2.0 – NM Tax Report Detail – State History
    • OIUX8_NM_REVTXN : Tax 2.0 – NM – Tax Reversals
    • OIUX8_NM_SUFFDEC : Tax 2.0 – New Mexico Suffix Decimal
    • OIUX8_NM_AFFOVR : Tax 2.0 – NM – Affiliation Code Override
    • OIUX8_NM_STRXRF : Tax 2.0 – NM – Special Tax Rate Xref
    • OIUX8_NM_SUFFXRF : Tax 2.0 – New Mexico Suffix and tax rate x-ref
    • OIUX8_NM_OOSHST : Tax 2.0 – NM – Out-Of-Statute Transaction History
    • OIUX8_NM_REVSTG : Tax 2.0 – NM – Tax Reversals (Staging)
    • OIUX8_NM_OOSTXN : Tax 2.0 – NM – Out-Of-Statute Transactions
    • OIUX8_NM_ASUE_DT : Tax 2.0 NM – Auto Suspend Exception Detail
    • OIUX8_NM_ASUE_HD : Tax 2.0 NM – Auto Suspend Exception Header
    • OIUX8_NM_RPDT : Tax 2.0 – NM – Report Detail
    • OIUX8_NM_SOLEDT : Tax 2.0 – NM – Statute of Limitation Exception Detail
    • OIUX8_NM_SOL : Tax 2.0 – NM – Statute of Limitation
    • OIUX8_NM_REJ : Tax 2.0 – NM – Reject Codes
    • OIUX8_NM_CTAFOVR : Tax 2.0 – NM – Contract Type Level Affiliation Cd Override

    OIUX8_NM_TAXDTL related transaction codes under SAP package OIU_X8

    • O3UX8_DISP_NM_TAXDTL : Display New Mexico Tax Trans Decimal
    • S_YEP_27000003 : IMG activity: V_OIUX8_NM_REJ
    • O3UX8_NM_SUFFDEC : Maintain New Mexico Suffix Decimal
    • O3UX8_MIGRATION : New Mexico Migration Workbench
    • O3UX8_UPD_NM_OOS_WO : New Mexico Out-of-Statute Write-Off
    • O3UX8_NM_SUFFXRF : Maintain New Mexico Suffix Cross-ref
    • O3UX8_UPD_NM_TAXTXN : Maintain New Mexico User Tax Trans
    • O3UX8_DISP_NM_OOSWO : List of NM Out-of-Statute Write-Offs
    • O3UX8_NM_SOL : Maintain New Mexico Statute-of-Limit
    • O3UX8_NM_OTH_OWN : Maintain New Mexico Oth Exmpt Owners
    • O3UX8_NM_ASU : Maintain New Mexico Auto-Suspend
    • O3UX8_LOAD_HISTORY : New Mexico State History Upload
    • O3UX8_DISP_NM_TAXTXN : Display New Mexico Tax Transactions
    • S_YEP_27000001 : IMG activity: V_OIUX8_GRPPX
    • S_YEP_27000006 : IMG activity: OIUX8_NM_MKTXRF
    • S_YEP_27000005 : IMG activity: OIUX8_NM_PDCXRF
    • O3UX8_NM_ASUE : Maintain NM Auto Suspend Exception
    • S_YEP_27000008 : IMG activity: OIUX8_SN_NR_NM
    • O3UX8_UPD_NM_TAXHST : Update New Mexico Tax History
    • S_YEP_27000002 : IMG activity: OIUX8_NM_STRXRF

    Related References

    Related Tutorials

    OIUX8_NM_DC_MEMO SAP table for – Tax 2.0 – New Mexico Debit and Credit Memo

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

    O3UX8_DISP_NM_TAXDTL SAP tcode for – Display New Mexico Tax Trans Decimal

    O3UX8_DISP_NM_TAXDTL tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Display New...

    OIUX8_NM_OOSWO SAP table for – Tax 2.0 – New Mexico Out Of Statute Write Off

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

    O3UX8_UPD_NM_TAXTXN SAP tcode for – Maintain New Mexico User Tax Trans

    O3UX8_UPD_NM_TAXTXN tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Maintain New...

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

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

    O3UX8_DISP_NM_TAXTXN SAP tcode for – Display New Mexico Tax Transactions

    O3UX8_DISP_NM_TAXTXN tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Display New...

    O3UX8_UPD_NM_TAXHST SAP tcode for – Update New Mexico Tax History

    O3UX8_UPD_NM_TAXHST tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Update New...

    «
    »