1. SAP Tutorial
  2. Oil & Gas

OIUX4_BALANCE SAP table for – Taxes Payable Balance

Here we would like to draw your attention to OIUX4_BALANCE 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). OIUX4_BALANCE is a SAP standard transp table used for storing Taxes Payable Balance related data in SAP. It comes under the package OIU_X4.

SAP OIUX4_BALANCE table

Table OIUX4_BALANCE technical data

TableOIUX4_BALANCE
Data storingTaxes Payable Balance
ModuleIS-OIL
Sub ModuleIS-OIL-PRA-REP-TAX
SAP PackageOIU_X4
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : TP Recon – Balance Table Key
    Its a key field.
  • COMPANY : Organization level 1 number (Company Code)
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • STATE_CD : State Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • SA_DT : Sales Date / Month
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • PD_CD : Product
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • PROPERTY : Property / DOI
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • DOI : Division of Interest (DOI) Number
    Its a key field. Its data type is CHAR (Character String) with field length 5
  • TAX_CD : Tax Code
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • GL_ACCT_NO : GL Account No.
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • UNIT_PROPERTY : Unit Property Number
    Its data type is CHAR (Character String) with field length 8
  • CUR_BAL : Local Amount
    Its data type is CURR (Currency Field) with field length 11
  • STATUS : Taxes Payable Status
    Its data type is CHAR (Character String) with field length 2
  • ORIG_STATUS_AMT : Local Amount
    Its data type is CURR (Currency Field) with field length 11
  • STATUS_USER : Taxes Payable Status User
    Its data type is CHAR (Character String) with field length 12
  • AGE : Taxes Payable Write-off Age
    Its data type is CHAR (Character String) with field length 3
  • RESP_ID : Taxes Payable Responsibility ID
    Its data type is CHAR (Character String) with field length 12
  • WO_AMT : Local Amount
    Its data type is CURR (Currency Field) with field length 11
  • WO_USER : Taxes Payable Writeoff User
    Its data type is CHAR (Character String) with field length 12
  • AGING_ACCT_PERD : Accounting Period(YYYYMM01)
    Its data type is CHAR (Character String) with field length 8
  • TARGET_DT : Target Date
    Its data type is CHAR (Character String) with field length 7

    • OIUX4_BALANCE related tables

    • OIUX4_BALANCE_H : Taxes Payable Balance History
    • OIUX4_BAL_CTG : Taxes Payable Balance Categories
    • OIUX4_WO_SETUP : Taxes Payable Writeoff Configuration
    • OIUX4_RESP_ID : Taxes Payable Responsibility ID
    • OIUX4_BAL_CTGZN : Taxes Payable Balance Categorization
    • OIUX4_COMMENTS : Taxes Payable Comments
    • OIUX4_BALANCE : Taxes Payable Balance
    • OIUX4_BAL_CTGTX : TP Balance Categories – Text tabe

    OIUX4_BALANCE related transaction codes under SAP package OIU_X4

    • O3UX4_TP_MIGRATE : Transaction for TP Recon Migration
    • O3UX4_TPMIG_VERIFY : Transaction to verify TP Migration
    • O3UX4_OUT_BAL : TPSL/TP out of balance report
    • O3UX4_PORTAL_002 : Taxes Payable Reconciliation Portal
    • O3UX4_WO_SETUP : Taxes Payable Write Off Setup
    • S_SOG_81000191 : IMG activity: OIUX4_BAL_CTG
    • O3UX4_WORKPLACE : TP Summary Workplace
    • O3UX4_RESP_ID : Maintain Taxes Payable Resp. ID
    • S_SOG_81000190 : IMG activity: OIUX4_SN_NR

    Related References

    Related Tutorials

    OIUX4_BAL_CTG SAP table for – Taxes Payable Balance Categories

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

    OIUX4_BAL_CTGZN SAP table for – Taxes Payable Balance Categorization

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

    OIUX4_BALANCE_H SAP table for – Taxes Payable Balance History

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

    OIUX4_WO_SETUP SAP table for – Taxes Payable Writeoff Configuration

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

    OIUX4_COMMENTS SAP table for – Taxes Payable Comments

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

    OIUX4_RESP_ID SAP table for – Taxes Payable Responsibility ID

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

    O3UX4_PORTAL_002 SAP tcode for – Taxes Payable Reconciliation Portal

    O3UX4_PORTAL_002 tcode in SAP IS-OIL (Production and Revenue Accounting in IS-OIL) module. This transaction code is used for Taxes Payable...

    «
    »