1. SAP Tutorial
  2. FI Module

IDGT_INFO SAP table for – GTI China: Data sent to GT

Here we would like to draw your attention to IDGT_INFO 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). IDGT_INFO is a SAP standard transp table used for storing GTI China: Data sent to GT related data in SAP. It comes under the package ID-SD-CN-GT.

SAP IDGT_INFO table

Table IDGT_INFO technical data

TableIDGT_INFO
Data storingGTI China: Data sent to GT
ModuleFI
Sub ModuleFI-LOC
SAP PackageID-SD-CN-GT
Delivery ClassA – Application table (master and transaction data)
ComponentSAP_APPL
Table CategoryTRANSP

SAP IDGT_INFO 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 IDGT_INFO table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • REFVBELN : Golden Tax Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • POSNR : Item Number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • VFPOS : Billing item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • FILETYPE : File Type
    Its data type is CHAR (Character String) with field length 1
  • GTVBELN : GT Invoice Number
    Its data type is CHAR (Character String) with field length 8
  • INVTYP : Invoice Type
    Its data type is CHAR (Character String) with field length 1
  • TYPCODE : GT Invoice Type Code
    Its data type is CHAR (Character String) with field length 10
  • NOTE : GT Note
    Its data type is CHAR (Character String) with field length 160
  • GTSTATUS : Invoice Status in Reference to GT
    Its data type is CHAR (Character String) with field length 12
  • CANCELIND : Cancellation Indicator
    Its data type is CHAR (Character String) with field length 1
  • GOODSLIST : Name of the Goods List
    Its data type is CHAR (Character String) with field length 30
  • GLISTIND : Goods List Indicator
    Its data type is CHAR (Character String) with field length 1
  • SENTDATE : Date: Invoice sent to GT
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • USERNAME : Created By
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Legal Change Append Strucuture
  • TLINES : Item Number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • KUNNR : Customer Number
    Its data type is CHAR (Character String) with field length 10
  • KNAME1 : Customer Name
    Its data type is CHAR (Character String) with field length 100
  • KSTCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • KSTRAS : Address
    Its data type is CHAR (Character String) with field length 80
  • KBANKA : Bank Account
    Its data type is CHAR (Character String) with field length 80
  • VUSNAM : User name
    Its data type is CHAR (Character String) with field length 12
  • CUSNAM : Receiver
    Its data type is CHAR (Character String) with field length 12
  • VBANKA : Bank Account
    Its data type is CHAR (Character String) with field length 80
  • VSTRAS : Address
    Its data type is CHAR (Character String) with field length 80
  • VSTCD1 : Tax Number 1
    Its data type is CHAR (Character String) with field length 16
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • MAKTX : Material Description
    Its data type is CHAR (Character String) with field length 60
  • MSPEC : Material Specification
    Its data type is CHAR (Character String) with field length 30
  • MEINS : Base Unit of Measure
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • FKIMG : Billed Quantity
    Its data type is QUAN (Quantity field) with field length 15
  • NETWR : Net Value
    Its data type is CURR (Currency Field) with field length 17
  • TAXAMT : Tax Amount
    Its data type is CURR (Currency Field) with field length 14
  • TAXRATE : VAT Tax Rate
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 9
  • UNITPE : Unit Price
    Its data type is CURR (Currency Field) with field length 15
  • TAXCOD : Tax Catalog Code
    Its data type is CHAR (Character String) with field length 4
  • CURRENCY : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • PEMOD : Price Mode
    Its data type is CHAR (Character String) with field length 1
  • TAXAMT_S_T : Tax Amount
    Its data type is CURR (Currency Field) with field length 14
  • TAXAMT_S : Tax Amount
    Its data type is CURR (Currency Field) with field length 14
  • UNITPE_S : Unit Price
    Its data type is CURR (Currency Field) with field length 15
  • NETWR_S : Net Value
    Its data type is CURR (Currency Field) with field length 17
  • .INCLUDE : Include Strucure for IDGT_INFO
  • VKORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • SPART : Division
    Its data type is CHAR (Character String) with field length 2
  • BUKRS : Company Code
    Its data type is CHAR (Character String) with field length 4
  • KSTCD5 : Tax Number 5
    Its data type is CHAR (Character String) with field length 60
  • GTDOCTYPE : Source Document Type
    Its data type is CHAR (Character String) with field length 1
  • ITEMMERGE : Item Merge Indicator
    Its data type is CHAR (Character String) with field length 1
  • DISC : Discount Amount
    Its data type is CURR (Currency Field) with field length 17
  • DISCTAX : Tax Amount of Discount Value
    Its data type is CURR (Currency Field) with field length 14
  • PRINTDAT : Print Date of VAT Invoice
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • COMBINEID : Combine ID
    Its data type is CHAR (Character String) with field length 20
  • POS_GTVBELN : GT Invoice Number
    Its data type is CHAR (Character String) with field length 8
  • POS_TYPCODE : GT Invoice Type Code
    Its data type is CHAR (Character String) with field length 10
  • AUBEL : Sales Document
    Its data type is CHAR (Character String) with field length 10
  • AUPOS : Sales Document Item
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • POS_VBELN : Sales and Distribution Document Number
    Its data type is CHAR (Character String) with field length 10
  • UOMDESC : Unit Measurement Desc.
    Its data type is CHAR (Character String) with field length 16

    • IDGT_INFO related tables

    • IDGT_CONF_LC_T : GTI China: Tax Invoice Text table
    • IDGT_CUSTTYPE : VAT Invoice Type
    • IDGT_CODE_LC : Tax Catalog Code
    • IDGT_UOM_CONV : UoM Conversion
    • IDGT_INFO : GTI China: Data sent to GT
    • IDGT_CONF_LC : GTI China: Tax Invoice table

    IDGT_INFO related transaction codes under SAP package ID-SD-CN-GT

    • GT_DL : Upload Inbound File from GT
    • GT_UL : Create Outbound File for GT
    • GT_ULN : Create Outbound File for GTS
    • GT_DLN : Upload Inbound File from GTS
    • GT_IVL : Invoice List

    Related References

    Related Tutorials

    IDGT_CONF_LC SAP table for – GTI China: Tax Invoice table

    IDGT_CONF_LC table in SAP FI (Localization in FI) module. This table is used for storing data of GTI China: Tax...

    IDGT_CONF_LC_T SAP table for – GTI China: Tax Invoice Text table

    IDGT_CONF_LC_T table in SAP FI (Localization in FI) module. This table is used for storing data of GTI China: Tax...

    J_1AWITH SAP table for – Withholding transaction data

    J_1AWITH table in SAP FI (Localization in FI) module. This table is used for storing data of Withholding transaction data....

    DFKKHUREPDS SAP table for – Recording Data for Domestic Sales Hungary

    DFKKHUREPDS table in SAP FI (Contract Accounts Receivable and Payable in FI) module. This table is used for storing data...

    RFUMSV00_HIST SAP table for – Maintain data for previous VAT return run

    RFUMSV00_HIST table in SAP FI (Localization in FI) module. This table is used for storing data of Maintain data for...

    IDGT_CONF_SA SAP table for – GTI Configuration by Sales Area

    IDGT_CONF_SA table in SAP FI (Localization in FI) module. This table is used for storing data of GTI Configuration by...

    VIXCESIBIDATA SAP table for – IBI master data

    VIXCESIBIDATA table in SAP FI (Localization in FI) module. This table is used for storing data of IBI master data....

    «
    »