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