OIUX4_BALANCE SAP (Taxes Payable Balance) Table details
Dictionary Type: Table
Description: Taxes Payable Balance
Description: Taxes Payable Balance
ABAP Code to SELECT data from OIUX4_BALANCE
Related tables to OIUX4_BALANCE
Access table OIUX4_BALANCE
Related tables to OIUX4_BALANCE
Access table OIUX4_BALANCE
Table field list including key, data, relationships and ABAP select examples
OIUX4_BALANCE is a standard SAP Table which is used to store Taxes Payable Balance data and is available within R/3 SAP systems depending on the version and release level.
The OIUX4_BALANCE table consists of various fields, each holding specific information or linking keys about Taxes Payable Balance data available in SAP. These include COMPANY (Organization level 1 number (Company Code)), STATE_CD (State Code), SA_DT (Sales Date / Month), PD_CD (Product).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIUX4_BALANCE table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
COMPANY | Organization level 1 number (Company Code) | OIUH_OR_LVL_1_NO | CHAR | 3 | Assigned to domain | OIUH_OR_LVL_1_NO | |||
STATE_CD | State Code | OIUH_STATE_CODE | CHAR | 2 | CHAR2 | ||||
SA_DT | Sales Date / Month | OIU_SALE_DT | DATS | 8 | DATUM | ||||
PD_CD | Product | OIUH_PRODUCT | CHAR | 3 | CHAR3 | ||||
PROPERTY | Property / DOI | OIUH_PROPERTY_DOI | CHAR | 8 | CHAR8 | H_PR_PID | H_PR_SRCH | ||
DOI | Division of Interest (DOI) Number | OIUH_DOI_NO | CHAR | 5 | CHAR5 | ||||
TAX_CD | Tax Code | OIUH_TAX_CODE | CHAR | 2 | CHAR2 | ||||
GL_ACCT_NO | GL Account No. | OIUREP_GL_ACCT_NO | CHAR | 10 | CHAR10 | ||||
UNIT_PROPERTY | Unit Property Number | OIUH_UNIT_PROPERTY_NUMBER | CHAR | 8 | CHAR8 | ||||
CUR_BAL | Local Amount | OIUX4_LOCAL_AMOUNT | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
STATUS | Taxes Payable Status | OIUX4_STATUS | CHAR | 2 | OIUX4_STATUS | ||||
ORIG_STATUS_AMT | Local Amount | OIUX4_LOCAL_AMOUNT | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
STATUS_USER | Taxes Payable Status User | OIUX4_STATUS_USER | CHAR | 12 | |||||
AGE | Taxes Payable Write-off Age | OIUX4_AGE | CHAR | 3 | OIUX4_AGE | ||||
RESP_ID | Taxes Payable Responsibility ID | OIUX4_RESPONSIBILITY_ID | CHAR | 12 | |||||
WO_AMT | Local Amount | OIUX4_LOCAL_AMOUNT | CURR | 11(2) | OIUX3_SIGNED_CURR_11_2 | ||||
WO_USER | Taxes Payable Writeoff User | OIUX4_WO_USER | CHAR | 12 | |||||
AGING_ACCT_PERD | Accounting Period(YYYYMM01) | OIUH_ACCOUNTING_PERIOD8 | CHAR | 8 | CHAR8 | ||||
TARGET_DT | Target Date | OIUX4_TARGET_DT | CHAR | 7 | CHAR07 |
Key field | Non-key field |
How do I retrieve data from SAP table OIUX4_BALANCE using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUX4_BALANCE to SELECT all data from the tableDATA: WA_OIUX4_BALANCE TYPE OIUX4_BALANCE.
SELECT SINGLE *
FROM OIUX4_BALANCE
INTO CORRESPONDING FIELDS OF WA_OIUX4_BALANCE
WHERE...
How to access SAP table OIUX4_BALANCE
Within an ECC or HANA version of SAP you can also view further information about OIUX4_BALANCE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects