J_1IEXITEM SAP (Incoming Excise Invoice: CIN40A : Item Details) Structure details

Dictionary Type: Structure
Description: Incoming Excise Invoice: CIN40A : Item Details




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




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

J_1IEXITEM is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Incoming Excise Invoice: CIN40A : Item Details" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_J_1IEXITEM TYPE J_1IEXITEM.

The J_1IEXITEM table consists of various fields, each holding specific information or linking keys about Incoming Excise Invoice: CIN40A : Item Details data available in SAP. These include DOCYR (Year), DOCNO (Internal Excise Document Number), ZEILE (Item Number), WERKS (Plant).. 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:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1IEXITEM structure 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
TRNTYPExcise Transaction Type J_1ITRNTYPCHAR4Assigned to domainJ_1ITRNTYP
DOCYRYear J_1IDOCUYRNUMC4J_1IDOCUYRGJR
DOCNOInternal Excise Document Number J_1IDOCNONUMC10Assigned to domainJ_1IDOCNOJ2G
ZEILEItem Number J_1IZEILENUMC4J_1IZEILE
WERKSPlant WERKS_DCHAR4Assigned to domainWERKSWRKH_T001W_C
EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
EXDATExcise Document Date J_1IEXCDATDATS8J_1IEXCDAT
EXYEARExcise Year J_1IEXYEARNUMC4GJAHRGJAHRGJR
EXGRPExcise Group J_1IEXCGRPCHAR2Assigned to domainJ_1IEXCGRPJ2I
LIFNRVendor J_1ILIFNRCHAR10J_1ILIFNRLIF
SHIPFROMShip-From Vendor J_1IEXSHIPFROMCHAR10Assigned to domainALPHALIFNR
RCWRKReceiving/Issuing Plant UMWRKCHAR4Assigned to domainWERKS
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
LGORTStorage Location LGORT_DCHAR4Assigned to domainLGORTLAG
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
CHARGBatch Number CHARG_DCHAR10Assigned to domainCHARGCHA
CHAPIDChapter ID J_1ICHIDCHAR12J_1ICHPTERCHAR12
OLD_CHAPIDChapter ID J_1ICHIDCHAR12CHAR12
MENGEExcise Invoice Quantity J_1IEXMENGEQUAN13(3) MENG13
MEINSUnit of Measure J_1IMEINSUNIT3T006CUNITMEINS
ORIG_MENGEExcise Invoice Quantity J_1IEXMENGEQUAN13(3) MENG13
ORIG_MEINSUnit of Measure J_1IMEINSUNIT3Assigned to domainCUNITMEINS
MENGAPart I Quantity J_1IEXMENGAQUAN13(3) MENG13
ORIG_MENGAPart I Quantity J_1IEXMENGAQUAN13(3) MENG13
MENGROpen Quantity J_1IEXMENGRQUAN13(3) MENG13
ORIG_MENGROpen Quantity J_1IEXMENGRQUAN13(3) MENG13
CREDIT_QTYQuantity Credited to CENVAT Acount J_1IEXMENGCQUAN13(3) MENG13
AVB_CREDIT_QTYQuantity Still Available for CENVAT Credit J_1IEXMENGAVBQUAN13(3) MENG13
ORIG_AVB_CREDIT_QTYQuantity Still Available for CENVAT Credit J_1IEXMENGAVBQUAN13(3) MENG13
SCPGNQuantity of Scrap generated J_1ISCPGNQUAN13(3) MENG13
MENGR_UOMBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
EXCURCurrency J_1IEXCCURCUKY5Assigned to domainWAERS
EXBASExcise Duty Base Amount J_1IEXCBASCURR13(2) WERT7
ORIG_EXBASExcise Duty Base Amount J_1IEXCBASCURR13(2) WERT7
EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
ORIG_EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
EXAEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
ORIG_EXAEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
EXSEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
ORIG_EXSEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
CESSCess amount J_1IEXCESSCURR13(2) WERT7
BEDINVInventorized BED J_1IBEDINVCURR13(2) WERT7
ORIG_BEDINVInventorized BED J_1IBEDINVCURR13(2) WERT7
AEDINVInventorized AED J_1IAEDINVCURR13(2) WERT7
ORIG_AEDINVInventorized AED J_1IAEDINVCURR13(2) WERT7
SEDINVInventorized SED J_1ISEDINVCURR13(2) WERT7
ORIG_SEDINVInventorized SED J_1ISEDINVCURR13(2) WERT7
ADDBEDAdditional BED J_1IADDBEDCURR13(2) WERT7
ADDAEDAdditional AED J_1IADDAEDCURR13(2) WERT7
ADDSEDAdditional SED J_1IADDSEDCURR13(2) WERT7
AVAILABLE_BEDBED Still Available for CENVAT Credit J_1IEXAVLBEDCURR13(2) WERT7
ORIG_AVAILABLE_BEDBED Still Available for CENVAT Credit J_1IEXAVLBEDCURR13(2) WERT7
AVAILABLE_AEDAED Still Available for CENVAT Credit J_1IEXAVLAEDCURR13(2) WERT7
ORIG_AVAILABLE_AEDAED Still Available for CENVAT Credit J_1IEXAVLAEDCURR13(2) WERT7
AVAILABLE_SEDSED Still Available for CENVAT Credit J_1IEXAVLSEDCURR13(2) WERT7
ORIG_AVAILABLE_SEDSED Still Available for CENVAT Credit J_1IEXAVLSEDCURR13(2) WERT7
AVAILED_BEDBED Credited to CENVAT Account J_1IEXAVLDBEDCURR13(2) WERT7
ORIG_AVAILED_BEDBED Credited to CENVAT Account J_1IEXAVLDBEDCURR13(2) WERT7
AVAILED_AEDAED Credited to CENVAT Account J_1IEXAVLDAEDCURR13(2) WERT7
ORIG_AVAILED_AEDAED Credited to CENVAT Account J_1IEXAVLDAEDCURR13(2) WERT7
AVAILED_SEDSED Credited to CENVAT Account J_1IEXAVLDSEDCURR13(2) WERT7
ORIG_AVAILED_SEDSED Credited to CENVAT Account J_1IEXAVLDSEDCURR13(2) WERT7
DUE_BEDBED Due for Credit J_1IEXDUEBEDCURR13(2) WERT7
ORIG_DUE_BEDBED Due for Credit J_1IEXDUEBEDCURR13(2) WERT7
DUE_AEDAED Due for Credit J_1IEXDUEAEDCURR13(2) WERT7
ORIG_DUE_AEDAED Due for Credit J_1IEXDUEAEDCURR13(2) WERT7
DUE_SEDSED Due for Credit J_1IEXDUESEDCURR13(2) WERT7
ORIG_DUE_SEDSED Due for Credit J_1IEXDUESEDCURR13(2) WERT7
SALES_TAXNon-deductible tax value J_1INDTAXCURR13(2) WERT7
OTHERSNon-deductible tax value J_1INDTAXCURR13(2) WERT7
INDTAXNon-deductible tax value J_1INDTAXCURR13(2) WERT7
PART2YRYear of Register Entry J_1IYEARNUMC4NUMC4
RG23ASERRG23A serial no. J_1I23ASERNUMC10NUMC10
RG23CSERRG23C serial no. J_1I23CSERNUMC10NUMC10
RGPLASERPLA serial no. J_1IPLASERNUMC10NUMC10
PART1YRYear of Register Entry J_1IYEARNUMC4NUMC4
PART1SERRegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
RDOC1Reference Document 1 J_1IRDOC1CHAR10CHAR10
RYEAR1Reference year 1 J_1IRYEAR1CHAR4CHAR4
RITEM1Reference Item 1 J_1IRITEM1NUMC6NUMC6
RIND1Reference Document Type 1 J_1IRIND1CHAR1J_1IRIND
RDOC2Reference Document 2 J_1IRDOC2CHAR10CHAR10
RYEAR2Reference year 2 J_1IRYEAR2CHAR4CHAR4
RITEM2Reference Item 2 J_1IRITEM2NUMC6NUMC6
RIND2Reference Document Type 2 J_1IRIND2CHAR1J_1IRIND
RDOC3Reference Document 3 J_1IRDOC3CHAR40CHAR40
RIND3Reference document type 3 J_1IRIND3CHAR1J_1IRIND
STATUSExcise Document Status J_1ISTATUSCHAR1J_1ISTATUS
BEDRATEBED Rate J_1IEXBEDRATDEC7(4) PRZ34
AEDRATEAED Rate J_1IEXAEDRATDEC7(4) PRZ34
SEDRATESED Rate J_1IEXSEDRATDEC7(4) PRZ34
ORIG_BEDRATEBED Rate J_1IEXBEDRATDEC7(4) PRZ34
ORIG_AEDRATEAED Rate J_1IEXAEDRATDEC7(4) PRZ34
ORIG_SEDRATESED Rate J_1IEXSEDRATDEC7(4) PRZ34
CESSRATECess percentage J_1ICESSDEC5(3) PRZ23
CAPINDIndicator for Material type J_1IEXCAPINDCHAR1J_1IEXCAPIND
ORIG_CAPINDIndicator for Material type J_1IEXCAPINDCHAR1J_1IEXCAPIND
MRPINDSingle-Character Indicator CHAR1CHAR1CHAR1
REJ_CODERejection Code J_1IREJCODECHAR3CHAR3
USNAMCreated By J_1IUSNAMCHAR12CHAR12
CPUDTExcise Document Entry Date J_1ICPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AENAMChanged by the user J_1IUSNAMCCHAR12CHAR12
AEDATChanged on date J_1IAEDATDATS8J_1IAEDAT
ADDLDATA1Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA2Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA3Additional Data J_1IADDATACHAR60CHAR60
ADDLDATA4Additional Data J_1IADDATACHAR60CHAR60
ADDLVAL1Additional Value J_1IADDVALCURR17(2) WERT9
ADDLVAL2Additional Value J_1IADDVALCURR17(2) WERT9
SP_BEDExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
BED_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
BED_KPEINCondition pricing unit KPEINDEC5KPEIN
BED_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
SP_AEDExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
AED_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
AED_KPEINCondition pricing unit KPEINDEC5KPEIN
AED_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
SP_SEDExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
SED_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
SED_KPEINCondition pricing unit KPEINDEC5KPEIN
SED_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
GLOBAL_COUNTERUnique number for one line J_1IEX_GLOBAL_COUNTERNUMC6NUMC6
LOGLEVELError status J_1IEX_LOGLEVELCHAR50TEXT50
DELETE_LINEItem is Deleted XLOEKCHAR1XFELD
INVISIBLELine is invisible MIGO_LINE_INVISIBLECHAR1XFELD
TAKE_ITItem Is OK J_1I_TAKE_ITCHAR1XFELD
EXCISE_INDIndicator for Excisable / Non Excisable material J_1IEX_EXCISECHAR1J_1IEX_EXCISE
EXCISE_RECALRecalculate Excise Duty J_1IEX_RECALCHAR1CHAR1
REVERSESingle-Character Indicator CHAR1CHAR1CHAR1
PART2_POSTEDIndicator for line item having Part2 posting J_1IEX_P2POSTEDCHAR1CHAR1
J_1IGRXREFNumber of Goods Receipts per Excise Invoice J_1IGREXCHAR1J_1IXREF
TOTAL_BEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
TOTAL_AEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
TOTAL_SEDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
BEDINV_IQInventorized BED J_1IBEDINVCURR13(2) WERT7
ORIG_BEDINV_IQInventorized BED J_1IBEDINVCURR13(2) WERT7
BEDINV_CQInventorized BED J_1IBEDINVCURR13(2) WERT7
ORIG_BEDINV_CQInventorized BED J_1IBEDINVCURR13(2) WERT7
AEDINV_IQInventorized AED J_1IAEDINVCURR13(2) WERT7
ORIG_AEDINV_IQInventorized AED J_1IAEDINVCURR13(2) WERT7
AEDINV_CQInventorized AED J_1IAEDINVCURR13(2) WERT7
ORIG_AEDINV_CQInventorized AED J_1IAEDINVCURR13(2) WERT7
SEDINV_IQInventorized SED J_1ISEDINVCURR13(2) WERT7
ORIG_SEDINV_IQInventorized SED J_1ISEDINVCURR13(2) WERT7
SEDINV_CQInventorized SED J_1ISEDINVCURR13(2) WERT7
ORIG_SEDINV_CQInventorized SED J_1ISEDINVCURR13(2) WERT7
SPLIT_BEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_BEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
SPLIT_AEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_AEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
SPLIT_SEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_SEDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
RESTORERestore Defaults J_1IEX_RESTORECHAR1CHAR1
XMANU Item Entered Manually0
SALES_TAX_RATESales tax rate J_1IEXSTRATEDEC7(4) PRZ34
SALES_TAX_BASEST Base J_1IEXSTBASECURR13(2) WERT7
MANUAL Indicator for manual duty for excise item0
GR_STO Indicator for GR 's STO0
CVD_TAKE_IT Indicator that PO line item is part of bill of entry0
PLANT_IND Plant Indicator0
DEPOT_IND Depot Indicator0
SUBCON_IND Subcontracting Indicator0
EXCISE_BOND_IND Excise Bonding Indicator0
NUM_OF_PKGSNumber of Packages J_1INUM_OF_PKGCHAR10J_1ICHAR10LOW
DESC_PKGPackage Description J_1IDESC_PKGCHAR30CHAR30LOW
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3Assigned to domainCUNITMEINS
MRK_PKGMarks on Package J_1IMRK_PKGCHAR30CHAR30LOW
NOS_ON_PKGNumbers on Package J_1INOS_ON_PKGCHAR30CHAR30LOW
MIGO_ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
MIGO_ERFMEUnit of Entry ERFMEUNIT3Assigned to domainCUNITMEINS
SP_CESSExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
CESS_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
CESS_KPEINCondition pricing unit KPEINDEC5KPEIN
CESS_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
ORIG_CESSCess amount J_1IEXCESSCURR13(2) WERT7
ALT_MATNRExcise Bonding: alternate customer material number J_1IALT_MATNRCHAR18Assigned to domainMATN1MATNR
ALT_MAKTXExcise Bonding: alternate customer material description J_1IALT_MAKTXCHAR40TEXT40
MIGO_MENGEQuantity MENGE_DQUAN13(3) MENG13
MIGO_MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
RCPTISSRSNRcpt/Issu classification codes J_2IRIINDICHAR3J_2IRIINDI
LICYRLicense Year J_1ILICYRNUMC4GJAHRGJAHR
LICNOInternal License Number J_1ILICNONUMC10J_1ILICNO
LICZEILEItem Number J_1IZEILENUMC4J_1IZEILE
NCCDNational Calamity Contingency Duty J_1IEXCNCCDCURR13(2) WERT7
ORIG_NCCDNational Calamity Contingency Duty J_1IEXCNCCDCURR13(2) WERT7
NCCDINVNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
ORIG_NCCDINVNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
ADDNCCDAdditional NCCD J_1IADDNCCDCURR13(2) WERT7
AVAILABLE_NCCDNCCD Still Available for CENVAT Credit J_1IEXAVLNCCDCURR13(2) WERT7
ORIG_AVAILABLE_NCCDNCCD Still Available for CENVAT Credit J_1IEXAVLNCCDCURR13(2) WERT7
AVAILED_NCCDNCCD Credited to CENVAT Account J_1IEXAVLDNCCDCURR13(2) WERT7
ORIG_AVAILED_NCCDNCCD Credited to CENVAT Account J_1IEXAVLDNCCDCURR13(2) WERT7
DUE_NCCDNCCD Due for Credit J_1IEXDUENCCDCURR13(2) WERT7
ORIG_DUE_NCCDNCCD Due for Credit J_1IEXDUENCCDCURR13(2) WERT7
NCCDRATENCCD Rate J_1IEXNCCDRATDEC7(4) PRZ34
ORIG_NCCDRATENCCD Rate J_1IEXNCCDRATDEC7(4) PRZ34
SP_NCCDExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
NCCD_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
NCCD_KPEINCondition pricing unit KPEINDEC5KPEIN
NCCD_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
TOTAL_NCCDTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
NCCDINV_IQNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
ORIG_NCCDINV_IQNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
NCCDINV_CQNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
ORIG_NCCDINV_CQNCCD Inventory Component J_1INCCDINVCURR13(2) WERT7
SPLIT_NCCDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_NCCDSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ECSECS Value J_1IEXECSCURR13(2) WERT7
ORIG_ECSECS Value J_1IEXECSCURR13(2) WERT7
ECSINVECS Inventory component J_1IECSINVCURR13(2) WERT7
ORIG_ECSINVECS Inventory component J_1IECSINVCURR13(2) WERT7
ADDECSAdditional educational cess J_1IADDECSCURR13(2) WERT7
AVAILABLE_ECSECS Still Available for CENVAT Credit J_1IEXAVLECSCURR13(2) WERT7
ORIG_AVAILABLE_ECSECS Still Available for CENVAT Credit J_1IEXAVLECSCURR13(2) WERT7
ORIG_AVAILED_ECSECS Credited to CENVAT Account J_1IEXAVLDECSCURR13(2) WERT7
AVAILED_ECSECS Credited to CENVAT Account J_1IEXAVLDECSCURR13(2) WERT7
DUE_ECSECS Due for Credit J_1IEXDUEECSCURR13(2) WERT7
ORIG_DUE_ECSECS Due for Credit J_1IEXDUEECSCURR13(2) WERT7
ECSRATEECS Rate J_1IEXECSRATDEC7(4) PRZ34
ORIG_ECSRATEECS Rate J_1IEXECSRATDEC7(4) PRZ34
SP_ECSExcise Duty Rate J_1IEXCAMTCURR13(2) WERT7
ECS_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
ECS_KPEINCondition pricing unit KPEINDEC5KPEIN
ECS_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
TOTAL_ECSTotal Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
ECSINV_IQECS Inventory component J_1IECSINVCURR13(2) WERT7
ORIG_ECSINV_IQECS Inventory component J_1IECSINVCURR13(2) WERT7
ECSINV_CQECS Inventory component J_1IECSINVCURR13(2) WERT7
ORIG_ECSINV_CQECS Inventory component J_1IECSINVCURR13(2) WERT7
SPLIT_ECSSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_ECSSplit Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
EXADDTAX1Additional Tax1 value J_1IEXADDTAX1CURR13(2) WERT7
ORIG_AT1Additional Tax1 value J_1IEXADDTAX1CURR13(2) WERT7
EXADDINV1Inventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
ORIG_AT1INVInventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
ADDAT1Additional AT1 J_1IADDAT1CURR13(2) WERT7
AVAILABLE_AT1AT1 Still Available for CENVAT Credit J_1IEXAVLAT1CURR13(2) WERT7
ORIG_AVAILABLE_AT1AT1 Still Available for CENVAT Credit J_1IEXAVLAT1CURR13(2) WERT7
ORIG_AVAILED_AT1AT1 Credited to CENVAT Account J_1IEXAVLDAT1CURR13(2) WERT7
AVAILED_AT1AT1 Credited to CENVAT Account J_1IEXAVLDAT1CURR13(2) WERT7
DUE_AT1AT1 Due for Credit J_1IEXDUEAT1CURR13(2) WERT7
ORIG_DUE_AT1AT1 Due for Credit J_1IEXDUEAT1CURR13(2) WERT7
EXADDRATE1AT1 rate in % J_1IEXADDRAT1DEC7(4) PRZ34
ORIG_EXADDRATE1AT1 rate in % J_1IEXADDRAT1DEC7(4) PRZ34
SP_AT1Excise Duty Rate J_1IEXCAMTCURR13(2) WERT7
AT1_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
AT1_KPEINCondition pricing unit KPEINDEC5KPEIN
AT1_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
TOTAL_AT1Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
AT1INV_IQInventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
ORIG_AT1INV_IQInventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
AT1INV_CQInventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
ORIG_AT1INV_CQInventorized AT1 J_1IEXADDINV1CURR13(2) WERT7
SPLIT_AT1Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_AT1Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
EXADDTAX2Additional Tax2 value J_1IEXADDTAX2CURR13(2) WERT7
ORIG_AT2Additional Tax2 value J_1IEXADDTAX2CURR13(2) WERT7
EXADDINV2Inventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
ORIG_AT2INVInventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
ADDAT2Additional AT2 J_1IADDAT2CURR13(2) WERT7
AVAILABLE_AT2AT2 Still Available for CENVAT Credit J_1IEXAVLAT2CURR13(2) WERT7
ORIG_AVAILABLE_AT2AT2 Still Available for CENVAT Credit J_1IEXAVLAT2CURR13(2) WERT7
ORIG_AVAILED_AT2AT2 Credited to CENVAT Account J_1IEXAVLDAT2CURR13(2) WERT7
AVAILED_AT2AT2 Credited to CENVAT Account J_1IEXAVLDAT2CURR13(2) WERT7
DUE_AT2AT2 Due for Credit J_1IEXDUEAT2CURR13(2) WERT7
ORIG_DUE_AT2AT2 Due for Credit J_1IEXDUEAT2CURR13(2) WERT7
EXADDRATE2AT2 rate in % J_1IEXADDRAT2DEC7(4) PRZ34
ORIG_EXADDRATE2AT2 rate in % J_1IEXADDRAT2DEC7(4) PRZ34
SP_AT2Excise Duty Rate J_1IEXCAMTCURR13(2) WERT7
AT2_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
AT2_KPEINCondition pricing unit KPEINDEC5KPEIN
AT2_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
TOTAL_AT2Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
AT2INV_IQInventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
ORIG_AT2INV_IQInventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
AT2INV_CQInventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
ORIG_AT2INV_CQInventorized AT2 J_1IEXADDINV2CURR13(2) WERT7
SPLIT_AT2Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_AT2Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
EXADDTAX3Additional Tax3 value J_1IEXADDTAX3CURR13(2) WERT7
ORIG_AT3Additional Tax3 value J_1IEXADDTAX3CURR13(2) WERT7
EXADDINV3Inventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
ORIG_AT3INVInventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
ADDAT3Additional AT3 J_1IADDAT3CURR13(2) WERT7
AVAILABLE_AT3AT3 Still Available for CENVAT Credit J_1IEXAVLAT3CURR13(2) WERT7
ORIG_AVAILABLE_AT3AT3 Still Available for CENVAT Credit J_1IEXAVLAT3CURR13(2) WERT7
ORIG_AVAILED_AT3AT3 Credited to CENVAT Account J_1IEXAVLDAT3CURR13(2) WERT7
AVAILED_AT3AT3 Credited to CENVAT Account J_1IEXAVLDAT3CURR13(2) WERT7
DUE_AT3AT3 Due for Credit J_1IEXDUEAT3CURR13(2) WERT7
ORIG_DUE_AT3AT3 Due for Credit J_1IEXDUEAT3CURR13(2) WERT7
EXADDRATE3AT3 rate in % J_1IEXADDRAT3DEC7(4) PRZ34
ORIG_EXADDRATE3AT3 rate in % J_1IEXADDRAT3DEC7(4) PRZ34
SP_AT3Excise Duty Rate J_1IEXCAMTCURR13(2) WERT7
AT3_KONWARate unit (currency or percentage) KONWACUKY5Assigned to domainWAERS
AT3_KPEINCondition pricing unit KPEINDEC5KPEIN
AT3_KMEINCondition unit KMEINUNIT3Assigned to domainCUNITMEINS
TOTAL_AT3Total Excise Duty J_1IEX_TOT_AMTCURR13(2) WERT7
AT3INV_IQInventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
ORIG_AT3INV_IQInventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
AT3INV_CQInventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
ORIG_AT3INV_CQInventorized AT3 J_1IEXADDINV3CURR13(2) WERT7
SPLIT_AT3Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
ORIG_SPLIT_AT3Split Ratio J_1IEX_SPLITCURR12(10) J_1IEX_SPLIT
MIGO_BPMNGQuantity in Purchase Order Price Unit BPMNG_INPUTQUAN13(3) MENG13
MIGO_BPRMEQuantity in Purchase Order Price Unit MB_BPRMEUNIT3Assigned to domainCUNITMEINS

Key field Non-key field



How do I retrieve data from SAP structure J_1IEXITEM using ABAP code?

As J_1IEXITEM is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on J_1IEXITEM as there is no data to select.

How to access SAP table J_1IEXITEM

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