SAP table J_1BTXGRUOP (Dynamic Determination of Tax-Related Master Data)

SAP table J_1BTXGRUOP has 2 primary key fields being MANDT,GRUOP.

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 * MANDT
GRUOP Tax Group for Dynamic Tax Exceptions NUMC 2 0 J_1BTXGRP
FIELD Master Data Fields for Tax Groups CHAR 10 0 J_1BTXFIELDS
ASNUM Service Number
BRSCH Industry Sector
BUKRS Company Code
CITYC City Code
CNAE CNAE Code
COMSIZE Company Size
CRTN CRT Number
DECREGPC Declaration Regimen for PIS/COFINS
EXTWG External Material Group
GPART_KK Business Partner Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
KUNNR Customer
LEGALNAT Legal Nature
LIFNR Vendor
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
MATKL Material Class, Material Group
MATNR Material
MTORG Origin of Goods
MTUSE_MARC Material Usage (Material Master Record)
MWSKZ Tax Code
NBM NCM Code
OIHCGROUP Vendor Tax Group (Oil)
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
PRDHA Product Hierarchy
TDT Tax Declaration Type
USAGE Tax Calculation: Material Usage
WERKS Plant
FIELD2 Master Data Fields for Tax Groups CHAR 10 0 J_1BTXFIELDS
ASNUM Service Number
BRSCH Industry Sector
BUKRS Company Code
CITYC City Code
CNAE CNAE Code
COMSIZE Company Size
CRTN CRT Number
DECREGPC Declaration Regimen for PIS/COFINS
EXTWG External Material Group
GPART_KK Business Partner Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
KUNNR Customer
LEGALNAT Legal Nature
LIFNR Vendor
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
MATKL Material Class, Material Group
MATNR Material
MTORG Origin of Goods
MTUSE_MARC Material Usage (Material Master Record)
MWSKZ Tax Code
NBM NCM Code
OIHCGROUP Vendor Tax Group (Oil)
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
PRDHA Product Hierarchy
TDT Tax Declaration Type
USAGE Tax Calculation: Material Usage
WERKS Plant
FIELD3 Master Data Fields for Tax Groups CHAR 10 0 J_1BTXFIELDS
ASNUM Service Number
BRSCH Industry Sector
BUKRS Company Code
CITYC City Code
CNAE CNAE Code
COMSIZE Company Size
CRTN CRT Number
DECREGPC Declaration Regimen for PIS/COFINS
EXTWG External Material Group
GPART_KK Business Partner Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
KUNNR Customer
LEGALNAT Legal Nature
LIFNR Vendor
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
MATKL Material Class, Material Group
MATNR Material
MTORG Origin of Goods
MTUSE_MARC Material Usage (Material Master Record)
MWSKZ Tax Code
NBM NCM Code
OIHCGROUP Vendor Tax Group (Oil)
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
PRDHA Product Hierarchy
TDT Tax Declaration Type
USAGE Tax Calculation: Material Usage
WERKS Plant
CALLER Calling Application CHAR 2 0 J_1BCALLER
General
IM Inventory Management (Obsolete)
IV Invoice Verification (Obsolete)
MM Materials Management
PO Purchasing (Obsolete)
SD Sales and Distribution
ACTIVIC ICMS Tax Group Active CHAR 1 0 J_1BACTIVIC
ACTIVIP IPI Tax Group Active CHAR 1 0 J_1BACTIVIP
ACTIVIS ISS Tax Group Active CHAR 1 0 J_1BACTIVIS
ACTIVST Substituição Tributária Tax Group CHAR 1 0 J_1BACTIVST
ACTIVPI PIS Tax Group Active CHAR 1 0 J_1BACTIVPI
ACTIVCO COFINS Tax Group Active CHAR 1 0 J_1BACTIVCO
ACTIVWT Withholding Tax Group Active CHAR 1 0 J_1BACTIVWT