OIUX3_JEINTF SAP table for - Tax Reporting

Table of Contents

Here we would like to draw your attention to OIUX3_JEINTF 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). OIUX3_JEINTF is a SAP standard transp table used for storing Tax Reporting – JE Interface Table related data in SAP. It comes under the package OIU_X3.

SAP OIUX3_JEINTF table

Table OIUX3_JEINTF technical data

Table	OIUX3_JEINTF
Data storing	Tax Reporting – JE Interface Table
Module	IS-OIL
Sub Module	IS-OIL-PRA-REP-TAX
SAP Package	OIU_X3
Delivery Class	L – Table for storing temporary data
Component	IS-OIL
Table Category	TRANSP

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

MANDT : Client
Its a key field. Its data type is CLNT (Character with length 3) with field length 3

.INCLUDE : Tax Reporting – JE Interface Key Fields
Its a key field.

RUN_ID : Tax Reporting – Run ID
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10

OR_LVL_1_NO : Company Name Code
Its a key field. Its data type is CHAR (Character String) with field length 3

ACCT_PERD_DT : Accounting Period(YYYYMM01)
Its a key field. Its data type is CHAR (Character String) with field length 8

BTCH_NO : Batch ID
Its a key field. Its data type is CHAR (Character String) with field length 4

LE_NO : Journal Entry Line Number
Its a key field. Its data type is CHAR (Character String) with field length 8

.INCLUDE : Tax Reporting – JE Interface Non Key Fields

ACCT_NO : Account ID
Its data type is CHAR (Character String) with field length 10

ACCT_CAT_NO : Account category code
Its data type is CHAR (Character String) with field length 4

BTCH_TYP_CD : Batch Type
Its data type is CHAR (Character String) with field length 2

SYS_SRCE_CD : PRA application component source
Its data type is CHAR (Character String) with field length 2

TRANS_AM : JE Transaction Amount
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

TRANS_QY : JE Transaction Quantity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

GR_AM : Gross Amount (Value)
Its data type is CURR (Currency Field) with field length 11

GR_QY : Gross Quantity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

PD_CD : Full three char. product code (Major and Detail Products)
Its data type is CHAR (Character String) with field length 3

VL_TYPE_CD : Volume Type
Its data type is CHAR (Character String) with field length 2

PU_NO : Purchaser Number
Its data type is CHAR (Character String) with field length 6

PU_SEQ_NO : Purchaser Sequence Number
Its data type is CHAR (Character String) with field length 2

PRDR_NO : Producer ID
Its data type is CHAR (Character String) with field length 6

PRDR_SEQ_NO : Producer Sequence Number
Its data type is CHAR (Character String) with field length 2

RVRS_RSN_CD : Reversal Reason Code
Its data type is CHAR (Character String) with field length 2

UNIT_OF_MEAS_CD : Unit of Measure Code
Its data type is CHAR (Character String) with field length 3

CT_NO : Contract ID
Its data type is CHAR (Character String) with field length 6

CT_TYPE_CD : Contract Type code
Its data type is CHAR (Character String) with field length 2

DOI_PR_NO : Property
Its data type is CHAR (Character String) with field length 8

DOI_SEQ_NO : Division of Interest (DOI) Number
Its data type is CHAR (Character String) with field length 5

WL_NO : Well ID Number
Its data type is CHAR (Character String) with field length 6

WC_NO : Well Completion ID
Its data type is CHAR (Character String) with field length 2

ORIG_MP : Originating Measurement Point Number
Its data type is CHAR (Character String) with field length 6

SA_MP_NO : Sales Measurement Point Number
Its data type is CHAR (Character String) with field length 6

SA_DT : Sales Date
Its data type is CHAR (Character String) with field length 10

STATE_CD : State Code
Its data type is CHAR (Character String) with field length 2

UNIT_PR_NO : Unit Property Number
Its data type is CHAR (Character String) with field length 8

PROC_CO : Processing Company code
Its data type is CHAR (Character String) with field length 3

TAX_CD : Tax Code
Its data type is CHAR (Character String) with field length 2

REF_NO : Reference Number
Its data type is CHAR (Character String) with field length 10

NWK_NO : Delivery Network number
Its data type is CHAR (Character String) with field length 4

SUBNWK_NO : Subnetwork Number
Its data type is CHAR (Character String) with field length 4

CHV_RPT_CD : Template cost center
Its data type is CHAR (Character String) with field length 10

.INCLUDE : Royalty Reporting – JE Interface Non Key Fields

BTU_QY : BTU Quantity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7

PS_BASE_QY : Pressure Base Quantity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 6

GRV_QY : Gravity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 3

OWN_NO : Owner Number
Its data type is CHAR (Character String) with field length 6

OWN_SEQ_NO : Owner Sequence Number
Its data type is CHAR (Character String) with field length 2

OWN_INT_DECM_QY : Owner Interest Decimal Quantity
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

OWN_INT_TYPE_CD : Owner Interest Type Code
Its data type is CHAR (Character String) with field length 2

OWN_INT_SEQ_NO : Owner Interest Sequence Number
Its data type is CHAR (Character String) with field length 2

PAY_CD : Pay Code
Its data type is CHAR (Character String) with field length 2

OWN_BAL_DECM_QY : Owner Disbursement (Balance) Decimal
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9

MMBTU_OVL_AM : Owner MMBTU
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 11

NET_TRANSP_AM : Net Transportation Amount
Its data type is CURR (Currency Field) with field length 11

NET_OTH_MK_AM : Net Other Marketing Amount
Its data type is CURR (Currency Field) with field length 11

TXN_VAL_AM : Transaction Owner Amount
Its data type is CURR (Currency Field) with field length 11

DED_RMB_AM : Deduction/Reimbursement Amount
Its data type is CURR (Currency Field) with field length 11

TAX_RMB_AM : Tax Reimbursement Amount
Its data type is CURR (Currency Field) with field length 11

OIUX3_JEINTF related tables

OIUX3_MIG_CTRL : Tax Reporting – Migration Control
OIUX3_TX_TAXTXN : Tax Reporting – Texas Tax Transactions
OIUX3_RUN_DTL : Tax Reporting – Run Detail
OIUX3_RPT_TX : Tax Reporting – Reports
OIUX3_PDCD_TX : Tax Reporting – 3 Character Product Code Text
OIUX3_TX_RPGSM : Tax Reporting – Texas Gas Report Summary
OIUX3_JEINTF : Tax Reporting – JE Interface Table
OIUX3_TX_MASTER : Tax Reporting – Texas Master Data
OIUX3_TX_EXEMPT : Tax Reporting – Texas Exemption Type
OIUX3Y_TX_MASTER : Tax Reporting – Texas Master Data PPN
OIUX3_RPT_PROF : Tax Reporting – Reporting Profile
OIUX3_PDCD : Tax Reporting – 3 Character Product Code
OIUX3_TX_OOSHST : Tax Reporting – Texas Out Of Statute Transaction History
OIUX3_MIG_ITEM : Tax Reporting – Migration Item
OIUX3_TX_RPODT : Tax Reporting – Texas Oil Report Details
OIUX3_MIG_VLDOC : Tax Reporting – Migration Loaded VL Docs
OIUX3_PORTGRP2T : Tax Reporting – Node Group 2 Text Table
OIUX3_TX_EDITS2T : OBSOLETE – Tax 2.0 – Texas Report Field Edits #2
OIUX3_TX_REVTXN : Tax Reporting – Texas Tax Transaction Reversals
OIUX3_RPT_GRP : Tax Reporting – Report Group

OIUX3_JEINTF related transaction codes under SAP package OIU_X3

O3UX3_MIGRATION_001 : Texas Migration Workbench
O3UX3_MIGRATION : Tax Reporting – Migration Workbench
O3UX3_TX_BATXID : Texas BA Tax ID Maintenance
S_SOG_81000182 : IMG activity: OIUX3_RPT_STEP
S_SOG_81000186 : IMG activity: OIUX3_MIG_GRPRX
O3UX3_TX_LEASE : Texas Lease Maintenace
O3UX3_PORTAL_001 : Tax Reporting Portal
S_SOG_81000169 : IMG activity: OIUX3_RPT_COMPX
S_SOG_81000192 : IMG activity: OIUX3_TX_RP_EDT1
S_SOG_81000167 : IMG activity: OIUX3_SN_NR_COMMON
O3UX3_WORKPLACE : Tax 2.0 Workplace
O3UX3_TX_SOLE : Texas Statute of Limitation Exceptn
O3UX3_TX_SOL : Texas Statute of Limitation Maint
O3UX3_TX_TAXTXN : Display Texas Tax Transactions
O3UX3_DISP_TX_EDTERR : Texas Additional Edit Errors
O3UX3_PORTAL : Generic Portal
S_SOG_81000173 : IMG activity: OIUX3_SN_NR_TX
S_SOG_81000188 : IMG activity: OIUX3_ITEM_ST
O3UX3_TX_MASTER : Texas Master Data Maintenance
O3UX3_TX_TAXHST : Texas Up To Date Reported Trans

OIUX3_JEINTF SAP table for – Tax Reporting – JE Interface Table

Table OIUX3_JEINTF technical data

SAP OIUX3_JEINTF Table Fields

OIUX3_JEINTF related tables

OIUX3_JEINTF related transaction codes under SAP package OIU_X3

Related References

About SAP

Most Popular

SAP Analytics & Administration

Useful References

OIUX3_JEINTF SAP table for – Tax Reporting – JE Interface Table

Table OIUX3_JEINTF technical data

SAP OIUX3_JEINTF Table Fields

OIUX3_JEINTF related tables

OIUX3_JEINTF related transaction codes under SAP package OIU_X3

Related References

Related Tutorials

About SAP

Most Popular

SAP Analytics & Administration

Useful References