1. SAP Tutorial
  2. FI Module

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

    • J_1IGAR7 related tables

    • J_1IGRXREF : Goods Receipt to Excise Invoice Coss Reference
    • J_1ISTRATE : Sales tax set off percentages
    • J_1IEXGRPS : Excise Groups
    • J_1IFRDTOT : Transaction Table for Forms Tracking-Non SAP docs.
    • J_1ISERCATSD1 : Ser Category based on Customer, Material and Sales Area (L1)
    • J_1IEXCDTL : Excise invoice line item details
    • J_1I_INBDELV : INBOUND DELIVERY DETAILS FROM sus
    • J_1ISERCAT : Service tax category description table
    • J_1ISERCATMM2 : Cust table to determine the Service Category on MM – Level2
    • J_1ISERCATMM5 : Cust table to determine the Service Category on MM – Level5
    • J_1IMESG : Message Control
    • J_1ISRGRPS : Excise Document Series
    • J_1INEWJCODE : VAT Transition Dummy Jurisdiction Code
    • J_1ICALOC : Allocation of materials to assets
    • J_1ISERCATSD4 : Service Category determination based on Material Group (L4)
    • J_1IEXCREF : Delivery document to excise invoice refrence document link
    • J_1ISERCATSD3 : Service Category based on Material (L3)
    • J_1ISUBTYP : Subtransaction type text
    • J_1IPART2 : Excise Part II details
    • J_1IITMDTL : Item Details – for Capital goods and subcontracting

    J_1IGAR7 related transaction codes under SAP package J1I2

    • S_AL0_96000121 : IMG activity: J_1IMESG
    • S_AL0_96000119 : IMG activity: J_1IJ1I9
    • S_EBS_44000563 : Depot Quarterly Returns
    • S_AL0_96000104 : IMG activity: J_1ISRGRPS
    • J1IO : Retrospective price amendments
    • J1I9 : Number ranges for excise invoice
    • J1IC194D : Annual Return under section 194d
    • J1IU : Forms capture
    • S_AL0_96000112 : IMG activity: J_1IREJMAS
    • J1IME2W : Open Orders- PO & Scheduling Agrmnt
    • S_AL0_96000116 : IMG activity: J_1IEXCREF
    • J1IW : Excise Invoice without PO
    • J1IJ : Excise invoice selec. at depot sale
    • S_AL0_96000120 : IMG activity: J_1IVTTXID
    • J1IG : RG23D register receipt at depot
    • J1IB : Excise Verification And Posting
    • J1IL : India Localization
    • J1IH : Create Excise JV
    • J1IQ : Year-End IT Depreciation Report
    • J1IS : Excise invoice for other movements

    Related References

    Related Tutorials

    J1IGAR7 SAP tcode for – Capture – GAR7 Information

    J1IGAR7 tcode in SAP FI (Localization in FI) module. This transaction code is used for Capture - GAR7 Information. See...

    J_1IGRXREF SAP table for – Goods Receipt to Excise Invoice Coss Reference

    J_1IGRXREF table in SAP FI (Localization in FI) module. This table is used for storing data of Goods Receipt to...

    J_1ISERVC SAP table for – Service tax details

    J_1ISERVC table in SAP FI (Localization in FI) module. This table is used for storing data of Service tax details....

    J_1ISER_BSEG SAP table for – Transaction table having the Invoices with Service Category

    J_1ISER_BSEG table in SAP FI (Localization in FI) module. This table is used for storing data of Transaction table having...

    J_1IEXCHDR SAP table for – Excise invoice header detail

    J_1IEXCHDR table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice header...

    J_1ITDS SAP table for – Classic TDS – reference table

    J_1ITDS table in SAP FI (Localization in FI) module. This table is used for storing data of Classic TDS -...

    J_1IEXCDTL SAP table for – Excise invoice line item details

    J_1IEXCDTL table in SAP FI (Localization in FI) module. This table is used for storing data of Excise invoice line...

    «
    »