J_1IEXITEM SAP (Incoming Excise Invoice: CIN40A : Item Details) Structure details
Description: Incoming Excise Invoice: CIN40A : Item Details
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 |
TRNTYP | Excise Transaction Type | J_1ITRNTYP | CHAR | 4 | Assigned to domain | J_1ITRNTYP | |||
DOCYR | Year | J_1IDOCUYR | NUMC | 4 | J_1IDOCUYR | GJR | |||
DOCNO | Internal Excise Document Number | J_1IDOCNO | NUMC | 10 | Assigned to domain | J_1IDOCNO | J2G | ||
ZEILE | Item Number | J_1IZEILE | NUMC | 4 | J_1IZEILE | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
EXNUM | Official Excise Document Number | J_1IEXCNUM | CHAR | 10 | J_1IEXCNUM | J2F | |||
EXDAT | Excise Document Date | J_1IEXCDAT | DATS | 8 | J_1IEXCDAT | ||||
EXYEAR | Excise Year | J_1IEXYEAR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
EXGRP | Excise Group | J_1IEXCGRP | CHAR | 2 | Assigned to domain | J_1IEXCGRP | J2I | ||
LIFNR | Vendor | J_1ILIFNR | CHAR | 10 | J_1ILIFNR | LIF | |||
SHIPFROM | Ship-From Vendor | J_1IEXSHIPFROM | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | ||
RCWRK | Receiving/Issuing Plant | UMWRK | CHAR | 4 | Assigned to domain | WERKS | |||
GSBER | Business Area | GSBER | CHAR | 4 | Assigned to domain | GSBER | GSB | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
MAKTX | Material Description (Short Text) | MAKTX | CHAR | 40 | TEXT40 | ||||
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
CHAPID | Chapter ID | J_1ICHID | CHAR | 12 | J_1ICHPTER | CHAR12 | |||
OLD_CHAPID | Chapter ID | J_1ICHID | CHAR | 12 | CHAR12 | ||||
MENGE | Excise Invoice Quantity | J_1IEXMENGE | QUAN | 13(3) | MENG13 | ||||
MEINS | Unit of Measure | J_1IMEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
ORIG_MENGE | Excise Invoice Quantity | J_1IEXMENGE | QUAN | 13(3) | MENG13 | ||||
ORIG_MEINS | Unit of Measure | J_1IMEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MENGA | Part I Quantity | J_1IEXMENGA | QUAN | 13(3) | MENG13 | ||||
ORIG_MENGA | Part I Quantity | J_1IEXMENGA | QUAN | 13(3) | MENG13 | ||||
MENGR | Open Quantity | J_1IEXMENGR | QUAN | 13(3) | MENG13 | ||||
ORIG_MENGR | Open Quantity | J_1IEXMENGR | QUAN | 13(3) | MENG13 | ||||
CREDIT_QTY | Quantity Credited to CENVAT Acount | J_1IEXMENGC | QUAN | 13(3) | MENG13 | ||||
AVB_CREDIT_QTY | Quantity Still Available for CENVAT Credit | J_1IEXMENGAVB | QUAN | 13(3) | MENG13 | ||||
ORIG_AVB_CREDIT_QTY | Quantity Still Available for CENVAT Credit | J_1IEXMENGAVB | QUAN | 13(3) | MENG13 | ||||
SCPGN | Quantity of Scrap generated | J_1ISCPGN | QUAN | 13(3) | MENG13 | ||||
MENGR_UOM | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
EXCUR | Currency | J_1IEXCCUR | CUKY | 5 | Assigned to domain | WAERS | |||
EXBAS | Excise Duty Base Amount | J_1IEXCBAS | CURR | 13(2) | WERT7 | ||||
ORIG_EXBAS | Excise Duty Base Amount | J_1IEXCBAS | CURR | 13(2) | WERT7 | ||||
EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13(2) | WERT7 | ||||
ORIG_EXBED | Basic Excise Duty | J_1IEXCBED | CURR | 13(2) | WERT7 | ||||
EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13(2) | WERT7 | ||||
ORIG_EXAED | Additional Excise Duty | J_1IEXCAED | CURR | 13(2) | WERT7 | ||||
EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13(2) | WERT7 | ||||
ORIG_EXSED | Special Excise Duty | J_1IEXCSED | CURR | 13(2) | WERT7 | ||||
CESS | Cess amount | J_1IEXCESS | CURR | 13(2) | WERT7 | ||||
BEDINV | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_BEDINV | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
AEDINV | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_AEDINV | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
SEDINV | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_SEDINV | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
ADDBED | Additional BED | J_1IADDBED | CURR | 13(2) | WERT7 | ||||
ADDAED | Additional AED | J_1IADDAED | CURR | 13(2) | WERT7 | ||||
ADDSED | Additional SED | J_1IADDSED | CURR | 13(2) | WERT7 | ||||
AVAILABLE_BED | BED Still Available for CENVAT Credit | J_1IEXAVLBED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_BED | BED Still Available for CENVAT Credit | J_1IEXAVLBED | CURR | 13(2) | WERT7 | ||||
AVAILABLE_AED | AED Still Available for CENVAT Credit | J_1IEXAVLAED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_AED | AED Still Available for CENVAT Credit | J_1IEXAVLAED | CURR | 13(2) | WERT7 | ||||
AVAILABLE_SED | SED Still Available for CENVAT Credit | J_1IEXAVLSED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_SED | SED Still Available for CENVAT Credit | J_1IEXAVLSED | CURR | 13(2) | WERT7 | ||||
AVAILED_BED | BED Credited to CENVAT Account | J_1IEXAVLDBED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_BED | BED Credited to CENVAT Account | J_1IEXAVLDBED | CURR | 13(2) | WERT7 | ||||
AVAILED_AED | AED Credited to CENVAT Account | J_1IEXAVLDAED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_AED | AED Credited to CENVAT Account | J_1IEXAVLDAED | CURR | 13(2) | WERT7 | ||||
AVAILED_SED | SED Credited to CENVAT Account | J_1IEXAVLDSED | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_SED | SED Credited to CENVAT Account | J_1IEXAVLDSED | CURR | 13(2) | WERT7 | ||||
DUE_BED | BED Due for Credit | J_1IEXDUEBED | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_BED | BED Due for Credit | J_1IEXDUEBED | CURR | 13(2) | WERT7 | ||||
DUE_AED | AED Due for Credit | J_1IEXDUEAED | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_AED | AED Due for Credit | J_1IEXDUEAED | CURR | 13(2) | WERT7 | ||||
DUE_SED | SED Due for Credit | J_1IEXDUESED | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_SED | SED Due for Credit | J_1IEXDUESED | CURR | 13(2) | WERT7 | ||||
SALES_TAX | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
OTHERS | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
INDTAX | Non-deductible tax value | J_1INDTAX | CURR | 13(2) | WERT7 | ||||
PART2YR | Year of Register Entry | J_1IYEAR | NUMC | 4 | NUMC4 | ||||
RG23ASER | RG23A serial no. | J_1I23ASER | NUMC | 10 | NUMC10 | ||||
RG23CSER | RG23C serial no. | J_1I23CSER | NUMC | 10 | NUMC10 | ||||
RGPLASER | PLA serial no. | J_1IPLASER | NUMC | 10 | NUMC10 | ||||
PART1YR | Year of Register Entry | J_1IYEAR | NUMC | 4 | NUMC4 | ||||
PART1SER | Register Entry Serial Number | J_1ISRLNO1 | NUMC | 10 | NUMC10 | ||||
RDOC1 | Reference Document 1 | J_1IRDOC1 | CHAR | 10 | CHAR10 | ||||
RYEAR1 | Reference year 1 | J_1IRYEAR1 | CHAR | 4 | CHAR4 | ||||
RITEM1 | Reference Item 1 | J_1IRITEM1 | NUMC | 6 | NUMC6 | ||||
RIND1 | Reference Document Type 1 | J_1IRIND1 | CHAR | 1 | J_1IRIND | ||||
RDOC2 | Reference Document 2 | J_1IRDOC2 | CHAR | 10 | CHAR10 | ||||
RYEAR2 | Reference year 2 | J_1IRYEAR2 | CHAR | 4 | CHAR4 | ||||
RITEM2 | Reference Item 2 | J_1IRITEM2 | NUMC | 6 | NUMC6 | ||||
RIND2 | Reference Document Type 2 | J_1IRIND2 | CHAR | 1 | J_1IRIND | ||||
RDOC3 | Reference Document 3 | J_1IRDOC3 | CHAR | 40 | CHAR40 | ||||
RIND3 | Reference document type 3 | J_1IRIND3 | CHAR | 1 | J_1IRIND | ||||
STATUS | Excise Document Status | J_1ISTATUS | CHAR | 1 | J_1ISTATUS | ||||
BEDRATE | BED Rate | J_1IEXBEDRAT | DEC | 7(4) | PRZ34 | ||||
AEDRATE | AED Rate | J_1IEXAEDRAT | DEC | 7(4) | PRZ34 | ||||
SEDRATE | SED Rate | J_1IEXSEDRAT | DEC | 7(4) | PRZ34 | ||||
ORIG_BEDRATE | BED Rate | J_1IEXBEDRAT | DEC | 7(4) | PRZ34 | ||||
ORIG_AEDRATE | AED Rate | J_1IEXAEDRAT | DEC | 7(4) | PRZ34 | ||||
ORIG_SEDRATE | SED Rate | J_1IEXSEDRAT | DEC | 7(4) | PRZ34 | ||||
CESSRATE | Cess percentage | J_1ICESS | DEC | 5(3) | PRZ23 | ||||
CAPIND | Indicator for Material type | J_1IEXCAPIND | CHAR | 1 | J_1IEXCAPIND | ||||
ORIG_CAPIND | Indicator for Material type | J_1IEXCAPIND | CHAR | 1 | J_1IEXCAPIND | ||||
MRPIND | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
REJ_CODE | Rejection Code | J_1IREJCODE | CHAR | 3 | CHAR3 | ||||
USNAM | Created By | J_1IUSNAM | CHAR | 12 | CHAR12 | ||||
CPUDT | Excise Document Entry Date | J_1ICPUDT | DATS | 8 | DATUM | ||||
CPUTM | Time of Entry | CPUTM | TIMS | 6 | UZEIT | ||||
AENAM | Changed by the user | J_1IUSNAMC | CHAR | 12 | CHAR12 | ||||
AEDAT | Changed on date | J_1IAEDAT | DATS | 8 | J_1IAEDAT | ||||
ADDLDATA1 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA2 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA3 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLDATA4 | Additional Data | J_1IADDATA | CHAR | 60 | CHAR60 | ||||
ADDLVAL1 | Additional Value | J_1IADDVAL | CURR | 17(2) | WERT9 | ||||
ADDLVAL2 | Additional Value | J_1IADDVAL | CURR | 17(2) | WERT9 | ||||
SP_BED | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
BED_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
BED_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
BED_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SP_AED | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
AED_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AED_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
AED_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SP_SED | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
SED_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
SED_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
SED_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
GLOBAL_COUNTER | Unique number for one line | J_1IEX_GLOBAL_COUNTER | NUMC | 6 | NUMC6 | ||||
LOGLEVEL | Error status | J_1IEX_LOGLEVEL | CHAR | 50 | TEXT50 | ||||
DELETE_LINE | Item is Deleted | XLOEK | CHAR | 1 | XFELD | ||||
INVISIBLE | Line is invisible | MIGO_LINE_INVISIBLE | CHAR | 1 | XFELD | ||||
TAKE_IT | Item Is OK | J_1I_TAKE_IT | CHAR | 1 | XFELD | ||||
EXCISE_IND | Indicator for Excisable / Non Excisable material | J_1IEX_EXCISE | CHAR | 1 | J_1IEX_EXCISE | ||||
EXCISE_RECAL | Recalculate Excise Duty | J_1IEX_RECAL | CHAR | 1 | CHAR1 | ||||
REVERSE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
PART2_POSTED | Indicator for line item having Part2 posting | J_1IEX_P2POSTED | CHAR | 1 | CHAR1 | ||||
J_1IGRXREF | Number of Goods Receipts per Excise Invoice | J_1IGREX | CHAR | 1 | J_1IXREF | ||||
TOTAL_BED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
TOTAL_AED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
TOTAL_SED | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
BEDINV_IQ | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_BEDINV_IQ | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
BEDINV_CQ | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_BEDINV_CQ | Inventorized BED | J_1IBEDINV | CURR | 13(2) | WERT7 | ||||
AEDINV_IQ | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_AEDINV_IQ | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
AEDINV_CQ | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_AEDINV_CQ | Inventorized AED | J_1IAEDINV | CURR | 13(2) | WERT7 | ||||
SEDINV_IQ | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_SEDINV_IQ | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
SEDINV_CQ | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
ORIG_SEDINV_CQ | Inventorized SED | J_1ISEDINV | CURR | 13(2) | WERT7 | ||||
SPLIT_BED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_BED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
SPLIT_AED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_AED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
SPLIT_SED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_SED | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
RESTORE | Restore Defaults | J_1IEX_RESTORE | CHAR | 1 | CHAR1 | ||||
XMANU | Item Entered Manually | 0 | |||||||
SALES_TAX_RATE | Sales tax rate | J_1IEXSTRATE | DEC | 7(4) | PRZ34 | ||||
SALES_TAX_BASE | ST Base | J_1IEXSTBASE | CURR | 13(2) | WERT7 | ||||
MANUAL | Indicator for manual duty for excise item | 0 | |||||||
GR_STO | Indicator for GR 's STO | 0 | |||||||
CVD_TAKE_IT | Indicator that PO line item is part of bill of entry | 0 | |||||||
PLANT_IND | Plant Indicator | 0 | |||||||
DEPOT_IND | Depot Indicator | 0 | |||||||
SUBCON_IND | Subcontracting Indicator | 0 | |||||||
EXCISE_BOND_IND | Excise Bonding Indicator | 0 | |||||||
NUM_OF_PKGS | Number of Packages | J_1INUM_OF_PKG | CHAR | 10 | J_1ICHAR10LOW | ||||
DESC_PKG | Package Description | J_1IDESC_PKG | CHAR | 30 | CHAR30LOW | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
MRK_PKG | Marks on Package | J_1IMRK_PKG | CHAR | 30 | CHAR30LOW | ||||
NOS_ON_PKG | Numbers on Package | J_1INOS_ON_PKG | CHAR | 30 | CHAR30LOW | ||||
MIGO_ERFMG | Quantity in Unit of Entry | ERFMG | QUAN | 13(3) | MENG13 | ||||
MIGO_ERFME | Unit of Entry | ERFME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
SP_CESS | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
CESS_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
CESS_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
CESS_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
ORIG_CESS | Cess amount | J_1IEXCESS | CURR | 13(2) | WERT7 | ||||
ALT_MATNR | Excise Bonding: alternate customer material number | J_1IALT_MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
ALT_MAKTX | Excise Bonding: alternate customer material description | J_1IALT_MAKTX | CHAR | 40 | TEXT40 | ||||
MIGO_MENGE | Quantity | MENGE_D | QUAN | 13(3) | MENG13 | ||||
MIGO_MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
RCPTISSRSN | Rcpt/Issu classification codes | J_2IRIINDI | CHAR | 3 | J_2IRIINDI | ||||
LICYR | License Year | J_1ILICYR | NUMC | 4 | GJAHR | GJAHR | |||
LICNO | Internal License Number | J_1ILICNO | NUMC | 10 | J_1ILICNO | ||||
LICZEILE | Item Number | J_1IZEILE | NUMC | 4 | J_1IZEILE | ||||
NCCD | National Calamity Contingency Duty | J_1IEXCNCCD | CURR | 13(2) | WERT7 | ||||
ORIG_NCCD | National Calamity Contingency Duty | J_1IEXCNCCD | CURR | 13(2) | WERT7 | ||||
NCCDINV | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
ORIG_NCCDINV | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
ADDNCCD | Additional NCCD | J_1IADDNCCD | CURR | 13(2) | WERT7 | ||||
AVAILABLE_NCCD | NCCD Still Available for CENVAT Credit | J_1IEXAVLNCCD | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_NCCD | NCCD Still Available for CENVAT Credit | J_1IEXAVLNCCD | CURR | 13(2) | WERT7 | ||||
AVAILED_NCCD | NCCD Credited to CENVAT Account | J_1IEXAVLDNCCD | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_NCCD | NCCD Credited to CENVAT Account | J_1IEXAVLDNCCD | CURR | 13(2) | WERT7 | ||||
DUE_NCCD | NCCD Due for Credit | J_1IEXDUENCCD | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_NCCD | NCCD Due for Credit | J_1IEXDUENCCD | CURR | 13(2) | WERT7 | ||||
NCCDRATE | NCCD Rate | J_1IEXNCCDRAT | DEC | 7(4) | PRZ34 | ||||
ORIG_NCCDRATE | NCCD Rate | J_1IEXNCCDRAT | DEC | 7(4) | PRZ34 | ||||
SP_NCCD | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
NCCD_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
NCCD_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
NCCD_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_NCCD | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
NCCDINV_IQ | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
ORIG_NCCDINV_IQ | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
NCCDINV_CQ | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
ORIG_NCCDINV_CQ | NCCD Inventory Component | J_1INCCDINV | CURR | 13(2) | WERT7 | ||||
SPLIT_NCCD | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_NCCD | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ECS | ECS Value | J_1IEXECS | CURR | 13(2) | WERT7 | ||||
ORIG_ECS | ECS Value | J_1IEXECS | CURR | 13(2) | WERT7 | ||||
ECSINV | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
ORIG_ECSINV | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
ADDECS | Additional educational cess | J_1IADDECS | CURR | 13(2) | WERT7 | ||||
AVAILABLE_ECS | ECS Still Available for CENVAT Credit | J_1IEXAVLECS | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_ECS | ECS Still Available for CENVAT Credit | J_1IEXAVLECS | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_ECS | ECS Credited to CENVAT Account | J_1IEXAVLDECS | CURR | 13(2) | WERT7 | ||||
AVAILED_ECS | ECS Credited to CENVAT Account | J_1IEXAVLDECS | CURR | 13(2) | WERT7 | ||||
DUE_ECS | ECS Due for Credit | J_1IEXDUEECS | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_ECS | ECS Due for Credit | J_1IEXDUEECS | CURR | 13(2) | WERT7 | ||||
ECSRATE | ECS Rate | J_1IEXECSRAT | DEC | 7(4) | PRZ34 | ||||
ORIG_ECSRATE | ECS Rate | J_1IEXECSRAT | DEC | 7(4) | PRZ34 | ||||
SP_ECS | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
ECS_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
ECS_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
ECS_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_ECS | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
ECSINV_IQ | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
ORIG_ECSINV_IQ | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
ECSINV_CQ | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
ORIG_ECSINV_CQ | ECS Inventory component | J_1IECSINV | CURR | 13(2) | WERT7 | ||||
SPLIT_ECS | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_ECS | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
EXADDTAX1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 13(2) | WERT7 | ||||
ORIG_AT1 | Additional Tax1 value | J_1IEXADDTAX1 | CURR | 13(2) | WERT7 | ||||
EXADDINV1 | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
ORIG_AT1INV | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
ADDAT1 | Additional AT1 | J_1IADDAT1 | CURR | 13(2) | WERT7 | ||||
AVAILABLE_AT1 | AT1 Still Available for CENVAT Credit | J_1IEXAVLAT1 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_AT1 | AT1 Still Available for CENVAT Credit | J_1IEXAVLAT1 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_AT1 | AT1 Credited to CENVAT Account | J_1IEXAVLDAT1 | CURR | 13(2) | WERT7 | ||||
AVAILED_AT1 | AT1 Credited to CENVAT Account | J_1IEXAVLDAT1 | CURR | 13(2) | WERT7 | ||||
DUE_AT1 | AT1 Due for Credit | J_1IEXDUEAT1 | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_AT1 | AT1 Due for Credit | J_1IEXDUEAT1 | CURR | 13(2) | WERT7 | ||||
EXADDRATE1 | AT1 rate in % | J_1IEXADDRAT1 | DEC | 7(4) | PRZ34 | ||||
ORIG_EXADDRATE1 | AT1 rate in % | J_1IEXADDRAT1 | DEC | 7(4) | PRZ34 | ||||
SP_AT1 | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
AT1_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AT1_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
AT1_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_AT1 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
AT1INV_IQ | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
ORIG_AT1INV_IQ | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
AT1INV_CQ | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
ORIG_AT1INV_CQ | Inventorized AT1 | J_1IEXADDINV1 | CURR | 13(2) | WERT7 | ||||
SPLIT_AT1 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_AT1 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
EXADDTAX2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 13(2) | WERT7 | ||||
ORIG_AT2 | Additional Tax2 value | J_1IEXADDTAX2 | CURR | 13(2) | WERT7 | ||||
EXADDINV2 | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
ORIG_AT2INV | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
ADDAT2 | Additional AT2 | J_1IADDAT2 | CURR | 13(2) | WERT7 | ||||
AVAILABLE_AT2 | AT2 Still Available for CENVAT Credit | J_1IEXAVLAT2 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_AT2 | AT2 Still Available for CENVAT Credit | J_1IEXAVLAT2 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_AT2 | AT2 Credited to CENVAT Account | J_1IEXAVLDAT2 | CURR | 13(2) | WERT7 | ||||
AVAILED_AT2 | AT2 Credited to CENVAT Account | J_1IEXAVLDAT2 | CURR | 13(2) | WERT7 | ||||
DUE_AT2 | AT2 Due for Credit | J_1IEXDUEAT2 | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_AT2 | AT2 Due for Credit | J_1IEXDUEAT2 | CURR | 13(2) | WERT7 | ||||
EXADDRATE2 | AT2 rate in % | J_1IEXADDRAT2 | DEC | 7(4) | PRZ34 | ||||
ORIG_EXADDRATE2 | AT2 rate in % | J_1IEXADDRAT2 | DEC | 7(4) | PRZ34 | ||||
SP_AT2 | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
AT2_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AT2_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
AT2_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_AT2 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
AT2INV_IQ | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
ORIG_AT2INV_IQ | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
AT2INV_CQ | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
ORIG_AT2INV_CQ | Inventorized AT2 | J_1IEXADDINV2 | CURR | 13(2) | WERT7 | ||||
SPLIT_AT2 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_AT2 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
EXADDTAX3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 13(2) | WERT7 | ||||
ORIG_AT3 | Additional Tax3 value | J_1IEXADDTAX3 | CURR | 13(2) | WERT7 | ||||
EXADDINV3 | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
ORIG_AT3INV | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
ADDAT3 | Additional AT3 | J_1IADDAT3 | CURR | 13(2) | WERT7 | ||||
AVAILABLE_AT3 | AT3 Still Available for CENVAT Credit | J_1IEXAVLAT3 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILABLE_AT3 | AT3 Still Available for CENVAT Credit | J_1IEXAVLAT3 | CURR | 13(2) | WERT7 | ||||
ORIG_AVAILED_AT3 | AT3 Credited to CENVAT Account | J_1IEXAVLDAT3 | CURR | 13(2) | WERT7 | ||||
AVAILED_AT3 | AT3 Credited to CENVAT Account | J_1IEXAVLDAT3 | CURR | 13(2) | WERT7 | ||||
DUE_AT3 | AT3 Due for Credit | J_1IEXDUEAT3 | CURR | 13(2) | WERT7 | ||||
ORIG_DUE_AT3 | AT3 Due for Credit | J_1IEXDUEAT3 | CURR | 13(2) | WERT7 | ||||
EXADDRATE3 | AT3 rate in % | J_1IEXADDRAT3 | DEC | 7(4) | PRZ34 | ||||
ORIG_EXADDRATE3 | AT3 rate in % | J_1IEXADDRAT3 | DEC | 7(4) | PRZ34 | ||||
SP_AT3 | Excise Duty Rate | J_1IEXCAMT | CURR | 13(2) | WERT7 | ||||
AT3_KONWA | Rate unit (currency or percentage) | KONWA | CUKY | 5 | Assigned to domain | WAERS | |||
AT3_KPEIN | Condition pricing unit | KPEIN | DEC | 5 | KPEIN | ||||
AT3_KMEIN | Condition unit | KMEIN | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_AT3 | Total Excise Duty | J_1IEX_TOT_AMT | CURR | 13(2) | WERT7 | ||||
AT3INV_IQ | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
ORIG_AT3INV_IQ | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
AT3INV_CQ | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
ORIG_AT3INV_CQ | Inventorized AT3 | J_1IEXADDINV3 | CURR | 13(2) | WERT7 | ||||
SPLIT_AT3 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
ORIG_SPLIT_AT3 | Split Ratio | J_1IEX_SPLIT | CURR | 12(10) | J_1IEX_SPLIT | ||||
MIGO_BPMNG | Quantity in Purchase Order Price Unit | BPMNG_INPUT | QUAN | 13(3) | MENG13 | ||||
MIGO_BPRME | Quantity in Purchase Order Price Unit | MB_BPRME | UNIT | 3 | Assigned to domain | CUNIT | MEINS |
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 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