OIUE2_JEINTF SAP (Proc 2.0 - JE Interface Table) Table details

Dictionary Type: Table
Description: Proc 2.0 - JE Interface Table




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




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

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

The OIUE2_JEINTF table consists of various fields, each holding specific information or linking keys about Proc 2.0 - JE Interface Table data available in SAP. These include RUN_ID (Proc 2.0 - Run ID), 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: 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 OIUE2_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_IDProc 2.0 - Run ID OIUE2_RUN_IDNUMC10
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
REC_TYPEPRA Journal Entry Record Type (0=Control, 1= Line item) OIUH_RECORD_TYPECHAR1CHAR1
VOU_NOVoucher Number OIUH_VOUCHER_NUMBERCHAR6CHAR6
REJ_FLLine item Reject Flag (Y=Yes, N=No) OIUH_REJECT_FLAGCHAR1CHAR1
ACCT_NOAccount ID OIUH_ACCTIDCHAR10OIUH_RV_COACHAR10
ACCT_TYPE_CDAccount Type OIUH_ACCTYPECHAR2OIUH_ACCT_TYPE_CD
ACCT_CAT_NOAccount category code OIU_ACCT_CAT_CDCHAR4OIU_ACCT_CAT_CD
BTCH_TYP_CDBatch Type OIUH_BATCH_TYPECHAR2OIUH_BATCH_TYPE
LE_PRCS_ST_CDJournal Entry Line Status OIUH_JELINESTCHAR1CHAR1
SYS_SRCE_CDPRA application component source OIUH_SUB_SYSTEM_SOURCECHAR2CHAR2
TRANS_AMJE Transaction Amount OIUH_TRANS_AMTCURR11(2) OIUH_CURR11_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_CDProduct Code OIUH_PRODUCT_CODECHAR3Assigned to domainCHAR3
CK_NOCheck Number OIUH_CHECK_NUMBERCHAR10CHAR10
CK_DTCheck Date OIUH_CHECKDATECHAR10CHAR10
VL_TYPE_CDVolume Type OIUH_VOLTYPECHAR2CHAR2
VL_CLASS_CDVolume Class Code OIUH_VOL_CLASS_CODECHAR1CHAR1
VL_SRCE_CDVolume source code OIUH_VOL_SOURCE_CODECHAR1CHAR1
VL_FRQ_CDVolume Frequency code OIUH_VOL_FREQUENCY_CODECHAR1CHAR1
BTU_QYBTU Quantity OIUH_BTU_QUANTITYDEC7(3) OIUH_DEC7_3
MMBTU_DET_CDMMBTU Determination Code OIUH_MMBTU_DET_CODECHAR1CHAR1
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
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
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
RVRS_RSN_CDReversal Reason Code OIUH_RVRS_REASON_CODECHAR2CHAR2
UNIT_OF_MEAS_CDUnit of Measure Code OIUH_UNIT_OF_MEASURECHAR3CHAR3
CASH_RCPT_DTCash Receipt Date OIUH_CASH_RECEIPT_DATECHAR10CHAR10
SUS_RSN_CDSuspense Reason Code OIUH_SUSPENSE_REASON_CODECHAR2CHAR2
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
SECT_PR_NOSection Property Number OIUH_SECTION_PROP_NUMBERCHAR8CHAR8
SECT_SEQ_NOSection Sequence Number OIUH_SECTION_SEQ_NUMBERCHAR5CHAR5
TRACE_CO_NOCompany Name Code OIUH_COMPANYCHAR3CHAR3
TRACE_APRD_DTAccounting Period(YYYYMM01) OIUH_ACCOUNTING_PERIOD8CHAR8CHAR8
TRACE_ACCT_NOAccount ID OIUH_ACCTIDCHAR10CHAR10
TRACE_BTCH_NOBatch ID OIUH_BATCH_IDCHAR4CHAR4
TRACE_VOUC_NOVoucher Number OIUH_VOUCHER_NUMBERCHAR6CHAR6
TRACE_LE_NOJournal Entry Line Number OIUH_JELINENOCHAR8CHAR8
TRACE_BTCH_TYBatch Type OIUH_BATCH_TYPECHAR2OIUH_BATCH_TYPE
WL_NOWell ID Number OIUH_WELL_NOCHAR6CHAR6
WC_NOWell Completion ID OIUH_WELL_COMPLETION_IDCHAR2CHAR2
ORIG_MPOriginating Measurement Point Number OIUH_ORIGINATING_MP_NOCHAR6CHAR6
ORIG_MP_TYPEOriginating Measurement Point Type OIUH_ORIGINATING_MP_TYPECHAR2CHAR2
DED_RMB_AMDeduction/Reimbursement Amount OIUH_DED_REIMB_AMOUNTCURR11(2) OIUH_CURR11_2
DED_GR_RMB_AMGross Deduction/Reimbursement amount OIUH_DED_GR_REIMB_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_1_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_2_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_3_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_4_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_5_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_6_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_7_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_8_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_9_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_10_AMTax amount OIUH_TAX_AMOUNTCURR11(2) OIUH_CURR11_2
TAX_RMB_AMTax Reimbursement Amount OIUH_TAX_REIMBURSEMENT_AMTCURR11(2) OIUH_CURR11_2
TAX_GR_RMB_AMGross Tax Reimbursement Amount OIUH_GROSS_TAX_REIMB_AMTCURR11(2) OIUH_CURR11_2
INV_NOInvoice Number OIUH_INVOICE_NUMBERCHAR6CHAR6
INV_DTInvoice Date OIUH_INVOICE_DATECHAR10CHAR10
INV_TYPE_CDInvoice Type code OIUH_INVOICE_TYPE_CODECHAR2CHAR2
PAY_CDPay Code OIUH_PAY_CODECHAR2CHAR2
SA_MP_NOSales Measurement Point Number OIUH_SALES_MP_NUMBERCHAR6CHAR6
SA_DTSales Date OIUH_SALES_DATECHAR10CHAR10
STATE_CDState Code OIUH_STATE_CODECHAR2CHAR2
TAX_AUTH_NOTax Authority Number OIUH_TAX_AUTHORITY_NUMBERCHAR6CHAR6
TAX_AUTH_SEQ_NOTax Authority Sequence Number OIUH_TAX_AUTHORITY_SEQ_NUMBERCHAR2CHAR2
OWN_BAL_DECM_QYOwner Disbursement (Balance) Decimal OIUH_OWNER_DISBUR_DECIMALDEC9(8) OIUH_DEC9_8
PR_TYPE_CDProperty Type Code OIUH_PROPERTY_TYPE_CODECHAR2CHAR2
OP_NON_OP_FLOperated Flag OIUH_OPERATED_FLAGCHAR1CHAR1
PU_PR_NOPurchaser Property Number OIUH_PURCHASER_PROPERTY_NUMBERCHAR18CHAR18
PU_PD_CDPurchaser Product Code OIUH_PURCHASER_PRODUCT_CODECHAR3CHAR3
UNIT_PR_NOUnit Property Number OIUH_UNIT_PROPERTY_NUMBERCHAR8CHAR8
ARMT_LVL_1_CDA/R Remittance Level 1 code OIUH_AR_REMIT_LVL_1_CODECHAR8CHAR8
ARMT_LVL_2_CDA/R Remittance Level 2 code OIUH_AR_REMIT_LVL_2_CODECHAR5CHAR5
TRANS_DEDescriptive Text for financial transaction OIUH_DESCRIPTIONCHAR60CHAR60
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
GR_TRANSP_AMGross Transportation Amount OIUH_GROSS_TRANP_AMOUNTCURR11(2) OIUH_CURR11_2
GR_OTH_MK_AMGross Other Marketing Amount OIUH_GROSS_OTH_MARKETING_AMTCURR11(2) OIUH_CURR11_2
OTH_DED_01_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_02_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_03_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_04_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_05_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_06_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_07_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_08_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_09_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_10_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_11_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_12_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_13_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_14_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_15_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_16_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_17_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
OTH_DED_18_AMOther Deductions Amount OIUH_OTHER_DEDUCTION_AMOUNTCURR11(2) OIUH_CURR11_2
PROC_COProcessing Company code OIUH_PROCESSING_COMPANY_CODECHAR3CHAR3
AES_FLActual / Entitled / Settlement Code OIU_AES_CDCHAR1CHAR1
TAX_CDTax Code OIUH_TAX_CODECHAR2CHAR2
GRP_GROUP_NOGroup Number OIUH_GROUP_NUMBERCHAR8CHAR8
INT_SYMBOLInterest Symbol OIUH_INTEREST_SYMBOLCHAR2CHAR2
TXN_VAL_AMTransaction Owner Amount OIUH_TRAN_OWNER_AMOUNTCURR11(2) OIUH_CURR11_2
TXN_DTTransaction Date OIUH_TRANS_DATECHAR10CHAR10
GAS_PLANT_NOGas Plant Property Number OIUH_GAS_PLANT_PROPERTY_NUMBERCHAR8CHAR8
GAS_PLANT_DOIGas Plant DOI Number OIUH_GAS_PLANT_DOI_NUMBERCHAR5CHAR5
REF_NOReference Number OIUH_REFERENCE_NUMBERCHAR10CHAR10
SELLER_NOSeller Number OIUH_SELLER_NUMBERCHAR6CHAR6
SELLER_SEQ_NOSeller Sequence Number OIUH_SELLER_SEQUENCE_NUMBERCHAR2CHAR2
NWK_NODelivery Network number OIUH_DN_NOCHAR4H_DELIVERY_NWKH_NW_PIDH_SUBNWK
SUBNWK_NOSubnetwork Number OIUH_SUBNWK_NOCHAR4H_SUBDN_NOH_SNW_PIDH_SUBNWK
AUDIT_BTCH_NOAudit Batch Number OIUH_AUDIT_BATCH_NUMBERCHAR4CHAR4
JDI_PR_NOJDI Expense Property Number OIUH_JDI_PROPERTY_NUMBERCHAR8CHAR8
JDI_NOJDI Expense Property Sequence Number OIUH_JDI_PROPERTY_SEQ_NUMBERCHAR5CHAR5
DI_PR_NOExpense Property Number OIUH_DI_PROPERTY_NUMBERCHAR8CHAR8
DI_NOExpense Property Sequence Number OIUH_DI_PROPERTY_SEQ_NUMBERCHAR5CHAR5
REMT_NORemitter ID OIUH_REMITTER_IDCHAR6CHAR6
REMT_SEQ_NORemitter Sequence Number OIUH_REMITTER_SEQUENCE_NUMBERCHAR2CHAR2
RCV_GL_WL_NOOff Lease Well Number OIUH_OFF_LEASE_WELL_NUMBERCHAR6CHAR6
RCV_GL_WC_NOOff Lease Well Completion Number OIUH_OFF_LEASE_WELL_COMPLETIONCHAR2CHAR2
REL_CT_NOREL Contract Number OIUH_REL_CONTRACT_NUMBERCHAR6CHAR6
PLT_VL_GRED_AMGross Plant Volume Reduction amount OIUH_GROSS_PLANT_VOLUME_RED_AMDEC11(2) OIUH_DEC11_2
PLT_VL_ORED_AMOwner Plant Volume Reduction amount OIUH_OWNER_PLANT_VOLUME_RED_AMDEC11(2) OIUH_DEC11_2
INT_PAID_FLInterest Paid Flag OIUH_INTEREST_PAID_FLAGCHAR1CHAR1
MMBTU_OVL_AMOwner MMBTU OIUH_OWNER_MMBTUDEC11(2) OIUH_DEC11_2
MMBTU_GRVL_AMMMBTU Gross Volume OIUH_MMBTUDEC11(2) OIUH_DEC11_2
PHASE_NOPhase number OIUVL_PHASE_NOCHAR1CHAR1
PD_CD_SUM_INDProduct Code Summarize Indicator OIUH_PRODUCT_CODE_SUMMARIZE_INCHAR1CHAR1
VL_LEVEL_CDValuation Level Code OIUH_VALUATION_LEVEL_CODECHAR2CHAR2
CHV_RPT_CDTemplate cost center RKOSTLCHAR10Assigned to domainALPHAKOSTLRKOS
GR_TAX_1_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_2_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_3_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_4_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_5_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_6_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_7_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_8_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_9_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
GR_TAX_10_AMGross Tax Amount OIUH_GROSS_TAX_AMOUNTCURR13(2) OIUH_CURR13_2
SPEC_PYMNT_CDSpecial Payment Code OIUH_SPECIAL_PAYMENT_CODECHAR1CHAR1
LGND_CDLegend Code OIUH_LEGEND_CODECHAR2CHAR2
RBUR_DECRoyalty Burden Decimal OIUH_ROYALTY_BURDEN_DECIMALDEC9(8) OIUH_DEC9_8
ESCH_FLEscheat Flag OIUH_ESCHEAT_FLAGCHAR1CHAR1
CMT_SYS_NOComment System Number OIUH_COMMENT_SYSTEM_NUMBERDEC18DEC18
OVRD_OWN_CDOverride Owner code OIU_OVRD_OWN_CDCHAR2CHAR2
BRD_CDBrand Code OIUH_BRAND_CODECHAR4CHAR4
RCPTN_PT_NOReception Point Number OIUH_RECEPTION_POINT_NUMBERCHAR6CHAR6
TRNSP_NOTransporter Number OIUH_TRANSPORTER_NUMBERCHAR6CHAR6
TRNSP_SEQ_NOTransporter Sequence Number OIUH_TRANSPORTER_SEQ_NUMBERCHAR2CHAR2
OR_LVL_2_NORegion Code (Org. Lvl 2) OIUH_REGION_CODECHAR1CHAR1
MK_TYPE_NOMarketing Type Number OIUH_MARKETING_TYPE_NUMBERCHAR2CHAR2
ORIG_PR_NOOriginating Property Number OIUH_ORGINATING_PROPERTY_NOCHAR8CHAR8
INJ_DTInjection Date OIUH_INJECTION_DATECHAR10CHAR10
GR_APC_RMBGross APC Reimbursement OIUH_GROSS_APC_REIMBURSEMENTCURR13(2) OIUH_CURR13_2
NET_APC_RMBNet APC Reimbursement Amount OIUH_NET_APC_REIMBURSEMENTCURR13(2) OIUH_CURR13_2
JI_OWN_NOJI Owner Number OIUH_JI_OWNER_NUMBERCHAR6CHAR6
JI_OWN_SEQ_NOJI Owner Sequence Number OIUH_JI_OWNER_SEQUENCE_NUMBERCHAR2CHAR2
DEAL_I_NODeal I Number OIUH_DEAL_I_NUMBERCHAR12CHAR12
CUSA_TRSPK_NOCUSA Transportation Number OIUH_CUSA_TRANSPORTATION_NOCHAR8CHAR8
VER_NOVersion Number OIUH_TT_VER_NODEC5DEC5
USER_IDUser ID OIUH_USER_IDCHAR8CHAR8
TIMESTAMPTime Stamp OIUH_TT_TIMESTAMPCHAR14CHAR14
ERROR_1_CDJE posting Validation Error Code OIUH_ERROR_CODECHAR5CHAR5
ERROR_2_CDJE posting Validation Error Code OIUH_ERROR_CODECHAR5CHAR5
ERROR_3_CDJE posting Validation Error Code OIUH_ERROR_CODECHAR5CHAR5
ERROR_4_CDJE posting Validation Error Code OIUH_ERROR_CODECHAR5CHAR5
ERROR_5_CDJE posting Validation Error Code OIUH_ERROR_CODECHAR5CHAR5

Key field Non-key field



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

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

SELECT SINGLE *
FROM OIUE2_JEINTF
INTO CORRESPONDING FIELDS OF WA_OIUE2_JEINTF
WHERE...

How to access SAP table OIUE2_JEINTF

Within an ECC or HANA version of SAP you can also view further information about OIUE2_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!