J_1IGAR7 SAP table for – Recordings of GAR7

Here we would like to draw your attention to J_1IGAR7 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_1IGAR7 is a SAP standard transp table used for storing Recordings of GAR7 related data in SAP. It comes under the package J1I2.

SAP J_1IGAR7 table

Table J_1IGAR7 technical data

TableJ_1IGAR7
Data storingRecordings of GAR7
ModuleFI
Sub ModuleFI-LOC
SAP PackageJ1I2
Delivery ClassC – Customer table, data is only maintained by the customer
ComponentSAP_APPL
Table CategoryTRANSP

SAP J_1IGAR7 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_1IGAR7 table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • WERKS : Plant
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • J_1IINTCHLN : Internal Challan Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 10
  • BUDAT : Posting Date in the Document
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • J_1ICHLN : Challan Number
    Its a key field. Its data type is CHAR (Character String) with field length 16
  • J_1ICHLNDT : Challan Date
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • J_1ISER : Service Tax
    Its data type is CURR (Currency Field) with field length 13
  • J_1IECSST : Ecess on Service tax
    Its data type is CURR (Currency Field) with field length 13
  • J_1ISHCESSST : Secess on Service Tax
    Its data type is CURR (Currency Field) with field length 13
  • J_1ISER_AR : Service tax -Arrears
    Its data type is CURR (Currency Field) with field length 13
  • J_1IECSST_AR : Ecess on service tax -Arrears
    Its data type is CURR (Currency Field) with field length 13
  • J_1ISHCESSST_AR : Secess on service tax -Arrears
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_SER : Exempted – Service Tax Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_ECSST : Exempted – ECS Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_SHCESSST : Exempted – SEess Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_SER_AR : Exempted – Arrears Service Tax Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_ECSST_AR : Exempted – Arrears – ECS Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IEXM_SCST_AR : Exempted – Arrears SHCess Paid in Cash
    Its data type is CURR (Currency Field) with field length 13
  • J_1IPENALTY : Penalty Paid – Arrears
    Its data type is CURR (Currency Field) with field length 13
  • J_1IINTEREST : Interest Paid – Arrears
    Its data type is CURR (Currency Field) with field length 13
  • J_1IDOCTYPE : Document type-Indicator
    Its data type is CHAR (Character String) with field length 1
  • J_1ISTATUS : Excise Document Status
    Its data type is CHAR (Character String) with field length 1
  • USNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • CPUDT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8