1. SAP Tutorial
  2. Oil & Gas

OIUX3_RPT_PROF SAP table for – Tax Reporting – Reporting Profile

Here we would like to draw your attention to OIUX3_RPT_PROF 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). OIUX3_RPT_PROF is a SAP standard transp table used for storing Tax Reporting – Reporting Profile related data in SAP. It comes under the package OIU_X3.

SAP OIUX3_RPT_PROF table

Table OIUX3_RPT_PROF technical data

TableOIUX3_RPT_PROF
Data storingTax Reporting – Reporting Profile
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X3
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RPT_COMP : Reporting Company
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • RPT_ID : Tax Reporting – Report ID
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • 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
  • TAXPAYER_NUMBER : Tax Reporting – Taxpayer Number
    Its data type is CHAR (Character String) with field length 20
  • TAXPAYER_NAME : Taxpayer Name
    Its data type is CHAR (Character String) with field length 100
  • ADDRESS_LINE1 : Tax Reporting – Taxpayer Address Line
    Its data type is CHAR (Character String) with field length 35
  • ADDRESS_LINE2 : Tax Reporting – Taxpayer Address Line
    Its data type is CHAR (Character String) with field length 35
  • ADDRESS_LINE3 : Tax Reporting – Taxpayer Address Line
    Its data type is CHAR (Character String) with field length 35
  • ORT01 : City
    Its data type is CHAR (Character String) with field length 35
  • REGIO : Region (State, Province, County)
    Its data type is CHAR (Character String) with field length 3
  • PSTLZ : Postal Code
    Its data type is CHAR (Character String) with field length 10
  • LAND1 : Country Key
    Its data type is CHAR (Character String) with field length 3
  • CONTACT_NAME : Tax Reporting – Contact Name
    Its data type is CHAR (Character String) with field length 50
  • CONTACT_PHONE_NO : Tax Reporting – Contact Phone Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • CONTACT_PHONE_EX : Tax Reporting – Contact Phone Extension
    Its data type is CHAR (Character String) with field length 5
  • CONTACT_EMAIL : Tax Reporting – Contact Email Address
    Its data type is CHAR (Character String) with field length 80
  • FEIN_SSN : Tax 2.0 – FEIN/SSN
    Its data type is NUMC (Character String with Digits Only) with field length 9
  • .INCLUDE : Tax Reporting – Last Changed Structure
  • CHANGE_USER : Tax Reporting – Last Changed User
    Its data type is CHAR (Character String) with field length 12
  • CHANGE_DATE : Tax Reporting – Last Changed Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CHANGE_TIME : Tax Reporting – Last Changed Time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CONTACT_FAX_NO : Contact Fax Number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • BAN_NO : Blanket Authorization Number
    Its data type is CHAR (Character String) with field length 4
  • ACCOUNT_NO : Rpt 2.0 – Account Number
    Its data type is NUMC (Character String with Digits Only) with field length 10

    • OIUX3_RPT_PROF related tables

    • OIUX3_TX_MSTOVR : Tax Reporting – Texas Master Data Overrides
    • OIUX3_TX_ASU_HD : Tax Reporting – Auto Suspend Header
    • OIUX3_TX_PRDTI : Tax Reporting – Texas PRA Detail Txns-Tier Tax Incremental
    • OIUX3_TX_RPODTE : Tax Reporting – Texas Oil Report Details Errors
    • OIUX3_TX_RP_EDT2 : OBSOLETE – Tax 2.0 – Texas Report Field Edits #2
    • OIUX3_TX_OOSWO : Tax Reporting – Texas Out Of Statute Write Off
    • OIUX3_TX_RPOSME : Tax Reporting – Texas Oil Report Summary Errors
    • OIUX3_JEINTF : Tax Reporting – JE Interface Table
    • OIUX3_PORTGRP2 : Tax Reporting – Node Group 2 Control Table
    • OIUX3_RPT_GRP : Tax Reporting – Report Group
    • OIUX3_RPT_COMPT : Tax Reporting – Reporting Company Text
    • OIUX3_PORT_TREE : Tax Reporting – Generic Portal Tree Control Table
    • OIUX3_RPT : Tax Reporting – Reports
    • OIUX3_TX_REJT : Tax Reporting – Texas Reject Code Text
    • OIUX3_MIG_CTRL : Tax Reporting – Migration Control
    • OIUX3_TX_ASU_DT : Tax Reporting – Auto Suspend Detail
    • OIUX3_RPT_STEP : Tax Reporting – Reporting Step
    • OIUX3_TX_EDITS2T : OBSOLETE – Tax 2.0 – Texas Report Field Edits #2
    • OIUX3_TX_PRDTN : Tax Reporting – Texas PRA Detail Txns – No Tier Tax
    • OIUX3_TX_EDITS2 : OBSOLETE – Tax 2.0 – Texas Report Field Edits #2

    OIUX3_RPT_PROF related transaction codes under SAP package OIU_X3

    • S_SOG_81000175 : IMG activity: OIUX3_TX_TXCLEX
    • S_SOG_81000182 : IMG activity: OIUX3_RPT_STEP
    • S_SOG_81000172 : IMG activity: OIUX3_RPT_GRPPX
    • O3UX3_TX_SOLE : Texas Statute of Limitation Exceptn
    • O3UX3_DISP_TX_OOSWO : Display Texas OOS Write Off Info
    • O3UX3_PORTAL : Generic Portal
    • S_SOG_81000168 : IMG activity: OIUX3_RPT_COMP
    • O3UX3_TX_BATXID : Texas BA Tax ID Maintenance
    • S_SOG_81000177 : IMG activity: V_OIUX3_TX_REJC
    • O3UX3_TX_LEASE : Texas Lease Maintenace
    • S_SOG_81000192 : IMG activity: OIUX3_TX_RP_EDT1
    • O3UX3_TX_TAXTXN : Display Texas Tax Transactions
    • O3UX3_RPT_PROF : Reporting Profile Maintenance
    • S_SOG_81000183 : IMG activity: OIUX3_RPT_STEPX
    • O3UX3_PORTAL_001 : Tax Reporting Portal
    • S_SOG_81000173 : IMG activity: OIUX3_SN_NR_TX
    • O3UX3_DISP_TX_EDTERR : Texas Additional Edit Errors
    • S_SOG_81000185 : IMG activity: OIUX3_MIG_GRP
    • S_SOG_81000171 : IMG activity: OIUX3_CONF_PP
    • S_SOG_81000181 : IMG activity: OIUX3_RPT

    Related References

    Related Tutorials

    OIUX3Y_TX_BATXID SAP table for – Tax Reporting – Texas BA Tax ID PPN

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

    OIUX3_RPT_COMP SAP table for – Tax Reporting – Reporting Company

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

    OIUX3_RPT_STEPX SAP table for – Tax Reporting – Reporting/Step XRef

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

    OIUX3_RPT_STEPT SAP table for – Tax Reporting – Reporting Step Text

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

    OIUX3_RPT_STEP SAP table for – Tax Reporting – Reporting Step

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

    OIUX3_TX_LEASE SAP table for – Tax Reporting – Texas Lease

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

    OIUX3_RPT_COMPT SAP table for – Tax Reporting – Reporting Company Text

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

    «
    »