SAP table T007C (Groupings for tax codes)

SAP table T007C has 3 primary key fields being MANDT,KOART,TAXGR.

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
KOART Account type CHAR 1 0 KOART
A Assets
D Customers
K Vendors
M Material
S G/L accounts
TAXGR Category Indicator for Tax Codes CHAR 3 0 TAXGR
WARNG Show Information in F4 Help During Posting CHAR 1 0 J_1AWRN
WRNEX Exemption Possible CHAR 1 0 J_1AWRNEX
KSCH1 Condition Type: Tax Code in Financial Accounting CHAR 4 0 T685A J_1AKSCHL
KSCHL Condition Type CHAR 4 0 T685A KSCHL
REFKSCHL Reference Condition Type CHAR 4 0 * J_1AREFKSCHL
ISVAT Flag: is VAT like tax CHAR 1 0 J_1AISVAT

T007C foreign key relationships

Table Field Check Table Check Field
0 T007C KSCH1 T685A Conditions: Types: Additional Price Element Data KAPPL
0 T007C KSCH1 T685A Conditions: Types: Additional Price Element Data KSCHL
1 T007C KSCHL T685A Conditions: Types: Additional Price Element Data KAPPL
1 T007C KSCHL T685A Conditions: Types: Additional Price Element Data KSCHL
0 T007C MANDT T000 Clients MANDT