Here we would like to draw your attention to J_1IEXCDTL table in SAP. As we know it is being mainly used with the SAP FI-LOC (Localization in FI) component which is coming under FI module (Financial Accounting). J_1IEXCDTL is a SAP standard transp table used for storing Excise invoice line item details related data in SAP. It comes under the package J1I2.
Table J_1IEXCDTL technical data
| Table | J_1IEXCDTL |
| Data storing | Excise invoice line item details |
| Module | FI |
| Sub Module | FI-LOC |
| SAP Package | J1I2 |
| Delivery Class | A – Application table (master and transaction data) |
| Component | SAP_APPL |
| Table Category | TRANSP |
SAP J_1IEXCDTL 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 J_1IEXCDTL table.
Its a key field. Its data type is CLNT (Character with length 3) with field length 3
Its a key field. Its data type is CHAR (Character String) with field length 4
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is CHAR (Character String) with field length 4
Its data type is CHAR (Character String) with field length 10
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is CHAR (Character String) with field length 2
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 4
Its data type is CHAR (Character String) with field length 4
Its data type is CHAR (Character String) with field length 4
Its data type is CHAR (Character String) with field length 18
Its data type is CHAR (Character String) with field length 40
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 12
Its data type is QUAN (Quantity field) with field length 13
Its data type is QUAN (Quantity field) with field length 13
Its data type is QUAN (Quantity field) with field length 13
Its data type is QUAN (Quantity field) with field length 13
Its data type is QUAN (Quantity field) with field length 13
Its data type is UNIT (Unit key for a Quantity field) with field length 3
Its data type is UNIT (Unit key for a Quantity field) with field length 3
Its data type is CUKY (Currency key for a currency field) with field length 5
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is NUMC (Character String with Digits Only) with field length 10
Its data type is NUMC (Character String with Digits Only) with field length 10
Its data type is NUMC (Character String with Digits Only) with field length 10
Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is NUMC (Character String with Digits Only) with field length 10
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 4
Its data type is NUMC (Character String with Digits Only) with field length 6
Its data type is CHAR (Character String) with field length 1
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 4
Its data type is NUMC (Character String with Digits Only) with field length 6
Its data type is CHAR (Character String) with field length 1
Its data type is CHAR (Character String) with field length 40
Its data type is CHAR (Character String) with field length 1
Its data type is CHAR (Character String) with field length 1
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 5
Its data type is CHAR (Character String) with field length 1
Its data type is CHAR (Character String) with field length 1
Its data type is CHAR (Character String) with field length 3
Its data type is CHAR (Character String) with field length 12
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
Its data type is CHAR (Character String) with field length 12
Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
Its data type is CHAR (Character String) with field length 60
Its data type is CHAR (Character String) with field length 60
Its data type is CHAR (Character String) with field length 60
Its data type is CHAR (Character String) with field length 60
Its data type is CURR (Currency Field) with field length 17
Its data type is CURR (Currency Field) with field length 17
Its data type is CHAR (Character String) with field length 10
Its data type is CHAR (Character String) with field length 30
Its data type is QUAN (Quantity field) with field length 15
Its data type is QUAN (Quantity field) with field length 15
Its data type is UNIT (Unit key for a Quantity field) with field length 3
Its data type is CHAR (Character String) with field length 30
Its data type is CHAR (Character String) with field length 30
Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is NUMC (Character String with Digits Only) with field length 10
Its data type is NUMC (Character String with Digits Only) with field length 4
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is CURR (Currency Field) with field length 13
Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 7
Its data type is CURR (Currency Field) with field length 13
Its data type is NUMC (Character String with Digits Only) with field length 10