OIUX3_JEINTF SAP (Tax Reporting - JE Interface Table) Table details

Dictionary Type: Table
Description: Tax Reporting - JE Interface Table




ABAP Code to SELECT data from OIUX3_JEINTF
Related tables to OIUX3_JEINTF
Access table OIUX3_JEINTF




Table field list including key, data, relationships and ABAP select examples

OIUX3_JEINTF is a standard SAP Table which is used to store Tax Reporting - JE Interface Table data and is available within R/3 SAP systems depending on the version and release level.

The OIUX3_JEINTF table consists of various fields, each holding specific information or linking keys about Tax Reporting - JE Interface Table data available in SAP. These include RUN_ID (Run ID of Tax Report), OR_LVL_1_NO (Company Name Code), ACCT_PERD_DT (Accounting Period(YYYYMM01)), BTCH_NO (Batch ID).. 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: L - Table for storing temporary data, is delivered empty
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP OIUX3_JEINTF 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
MANDTClient MANDTCLNT3T000MANDT
RUN_IDRun ID of Tax Report OIUX3_RUN_IDNUMC10NUMC10
OR_LVL_1_NOCompany Name Code OIUH_COMPANYCHAR3CHAR3
ACCT_PERD_DTAccounting Period(YYYYMM01) OIUH_ACCOUNTING_PERIOD8CHAR8CHAR8
BTCH_NOBatch ID OIUH_BATCH_IDCHAR4CHAR4
LE_NOJournal Entry Line Number OIUH_JELINENOCHAR8CHAR8
ACCT_NOAccount ID OIUH_ACCTIDCHAR10OIUH_RV_COACHAR10
ACCT_CAT_NOAccount category code OIU_ACCT_CAT_CDCHAR4OIU_ACCT_CAT_CD
BTCH_TYP_CDBatch Type OIUH_BATCH_TYPECHAR2OIUH_BATCH_TYPE
SYS_SRCE_CDPRA application component source OIUH_SUB_SYSTEM_SOURCECHAR2CHAR2
TRANS_AMJE Transaction Amount OIUX3_TRANS_AMTDEC11(2) OIUX3_SIGNED_DEC_11_2
TRANS_QYJE Transaction Quantity OIUH_TRANS_QUANTITYDEC11(2) OIUH_DEC11_2
GR_AMGross Amount (Value) OIUH_GROSS_AMOUNTCURR11(2) OIUH_CURR11_2
GR_QYGross Quantity OIUH_GROSS_QTYDEC11(2) OIUH_DEC11_2
PD_CDFull three char. product code (Major and Detail Products) OIU_FULL_PD_CDCHAR3OIUX3_PDCDOIU_FULL_PD_CD
VL_TYPE_CDVolume Type OIUH_VOLTYPECHAR2CHAR2
PU_NOPurchaser Number OIUH_PU_NOCHAR6CHAR6
PU_SEQ_NOPurchaser Sequence Number OIUH_PURCHASER_SEQUENCE_NUMBERCHAR2CHAR2
PRDR_NOProducer ID OIUH_PRODUCERCHAR6CHAR6
PRDR_SEQ_NOProducer Sequence Number OIUH_PRODUCER_SEQUENCE_NUMBERCHAR2CHAR2
RVRS_RSN_CDReversal Reason Code OIUH_RVRS_REASON_CODECHAR2CHAR2
UNIT_OF_MEAS_CDUnit of Measure Code OIUH_UNIT_OF_MEASURECHAR3CHAR3
CT_NOContract ID OIUH_CONTRACT_IDCHAR6CHAR6
CT_TYPE_CDContract Type code OIUH_CONTRACT_TYPE_CODECHAR2CHAR2
DOI_PR_NOProperty OIUH_PR_NOCHAR8CHAR8
DOI_SEQ_NODivision of Interest (DOI) Number OIUH_DOI_NOCHAR5CHAR5
WL_NOWell ID Number OIUH_WELL_NOCHAR6CHAR6
WC_NOWell Completion ID OIUH_WELL_COMPLETION_IDCHAR2CHAR2
ORIG_MPOriginating Measurement Point Number OIUH_ORIGINATING_MP_NOCHAR6CHAR6
SA_MP_NOSales Measurement Point Number OIUH_SALES_MP_NUMBERCHAR6CHAR6
SA_DTSales Date OIUH_SALES_DATECHAR10CHAR10
STATE_CDState Code OIUH_STATE_CODECHAR2CHAR2
UNIT_PR_NOUnit Property Number OIUH_UNIT_PROPERTY_NUMBERCHAR8CHAR8
PROC_COProcessing Company code OIUH_PROCESSING_COMPANY_CODECHAR3CHAR3
TAX_CDTax Code OIUH_TAX_CODECHAR2CHAR2
REF_NOReference Number OIUH_REFERENCE_NUMBERCHAR10CHAR10
NWK_NODelivery Network number OIUH_DN_NOCHAR4H_DELIVERY_NWKH_NW_PIDH_SUBNWK
SUBNWK_NOSubnetwork Number OIUH_SUBNWK_NOCHAR4H_SUBDN_NOH_SNW_PIDH_SUBNWK
CHV_RPT_CDTemplate cost center RKOSTLCHAR10Assigned to domainALPHAKOSTLRKOS
BTU_QYBTU Quantity OIUH_BTU_QUANTITYDEC7(3) OIUH_DEC7_3
PS_BASE_QYPressure Base Quantity OIUH_PRESSURE_BASEDEC6(3) OIUH_DEC6_3
GRV_QYGravity OIUH_GRAVITYDEC3(1) OIUH_DEC3_1
OWN_NOOwner Number OIUH_OWNERCHAR6CHAR6
OWN_SEQ_NOOwner Sequence Number OIUH_OWNER_SEQUENCE_NUMBERCHAR2CHAR2
OWN_INT_DECM_QYOwner Interest Decimal Quantity OIUH_OWN_INTEREST_DECIMAL_QTYDEC9(8) OIUH_DEC9_8
OWN_INT_TYPE_CDOwner Interest Type Code OIUH_OWN_INTEREST_TYPE_CODECHAR2CHAR2
OWN_INT_SEQ_NOOwner Interest Sequence Number OIUH_OWN_INTEREST_SEQ_NUMBERCHAR2CHAR2
PAY_CDPay Code OIUH_PAY_CODECHAR2CHAR2
OWN_BAL_DECM_QYOwner Disbursement (Balance) Decimal OIUH_OWNER_DISBUR_DECIMALDEC9(8) OIUH_DEC9_8
MMBTU_OVL_AMOwner MMBTU OIUH_OWNER_MMBTUDEC11(2) OIUH_DEC11_2
NET_TRANSP_AMNet Transportation Amount OIUH_TRANSPORTATION_AMTCURR11(2) OIUH_CURR11_2
NET_OTH_MK_AMNet Other Marketing Amount OIUH_NET_OTH_MARKETING_AMOUNTCURR11(2) OIUH_CURR11_2
TXN_VAL_AMTransaction Owner Amount OIUH_TRAN_OWNER_AMOUNTCURR11(2) OIUH_CURR11_2
DED_RMB_AMDeduction/Reimbursement Amount OIUH_DED_REIMB_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_RMB_AMTax Reimbursement Amount OIUH_TAX_REIMBURSEMENT_AMTCURR11(2) OIUH_CURR11_2

Key field Non-key field



How do I retrieve data from SAP table OIUX3_JEINTF using ABAP code

The following ABAP code Example will allow you to do a basic selection on OIUX3_JEINTF to SELECT all data from the table
DATA: WA_OIUX3_JEINTF TYPE OIUX3_JEINTF.

SELECT SINGLE *
FROM OIUX3_JEINTF
INTO CORRESPONDING FIELDS OF WA_OIUX3_JEINTF
WHERE...

How to access SAP table OIUX3_JEINTF

Within an ECC or HANA version of SAP you can also view further information about OIUX3_JEINTF and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!