SAP table IDGT_CONF_LC (GTI China: Tax Invoice table)
SAP table IDGT_CONF_LC has 2 primary key fields being MANDT,KEYID.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
KEYID
Tax Invoice Key
CHAR
4
0
GTCONF
DESPT
Text (20 Characters)
CHAR
20
0
TEXT20
VERIF
User Name
CHAR
12
0
SYUNAME
COLLE
User Name
CHAR
12
0
SYUNAME
OBFILE
Local file for upload/download
CHAR
128
0
LOCALFILE
IBFILE
Local file for upload/download
CHAR
128
0
LOCALFILE
SLITM
Line Item Limit
INT1
3
0
GTSLITM
SPLAMT
Net Value
CURR
17
2
GTNETWR
WAERS
Currency Key
CUKY
5
0
WAERS
PCMODE
Price Mode
CHAR
1
0
GTPEMOD
Possible values
0
Unit price w/o VAT
1
Unit price w/ VAT
NOTTY
Note Type
CHAR
1
0
GTNOTTY
Possible values
1
Billing Document
2
Delivery Note
3
Sales Order
CONNTYP
File Transfer Type
CHAR
1
0
GTCONNTYP
Possible values
A
Aisino Text File
D
Online Integration(Obsolete)
E
BestWonder Online Integration
M
XML File
T
Best-Wonder Text File
U
XML File with Using UKey
X
Aisino Excel File
RDIFF
Rounding Difference Tolerance
DEC
5
3
GTRDIFF_MRG
ISERROR
Follow-up Action
CHAR
1
0
GTISERROR
Possible values
E
Raise an error message
P
Proceed with item split(part quantity to lines)
Q
Proceed with item split(keep quantity as 1 for lines)
COMBFLG
Combine Flag
CHAR
1
0
GTCOMBFLG
Possible values
Not allowed to combine positive documents with negative ones
1
Allowed to combine positive documents with negative ones
2
Combine positive and negative documents automatically
COMBCHK
Combine Check
CHAR
1
0
GTCOMBCHK
Possible values
Allowed to combine documents for different invoices
1
Not allowed to combine documents for different invoices
NOTEFLG
Maintain note of Red-Letter Invoice manually
CHAR
1
0
GTNOTEFLG
Possible values
Not allowed to maintain note of Red-Letter Invoice manuall
1
Allowed to maintain note of Red-Letter Invoice
TAXCHECK
Allowed to send invoices with 0 tax amount or 0 tax rate
CHAR
1
0
GTTAXCHECK
Possible values
Not allowed to send invoices with 0 tax amount or 0 tax rate
1
Allowed to send invoices with 0 tax amount or 0 tax rate
NTTXT_S
Note Text of Special Red-Letter VAT Invoice
CHAR
60
0
GTNTTXT_S
NTTXT_N
Note Text of Normal Red-Letter VAT Invoice
CHAR
60
0
GTNTTXT_N
DCUSTYP
Default Customer Type
CHAR
1
0
GTDCUSTYP
MATL_CODE_VERS
Version of Tax Classification Number
CHAR
50
0
MATL_CODE_VERS
XML_FRMT_VERS
Version of XML Format
CHAR
5
0
XML_FRMT_VERS
INDUSTRY_NAME
Industry Name
CHAR
40
0
EIV_IND_NAME
INDUSTRY_CODE
Industry Code
CHAR
10
0
EIV_IND_CODE
IDGT_CONF_LC foreign key relationships
Table
Field
Check Table
Check Field
0 IDGT_CONF_LC
MANDT
T000
Clients
MANDT