1. Home
  2. Resources
  3. SAP Tables
  4. J_1BTXGRUOP - Dynamic Determination of Tax-Related Master Data

SAP Table J_1BTXGRUOP

Dynamic Determination of Tax-Related Master Data

J_1BTXGRUOP (Dynamic Determination of Tax-Related Master Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link J_1BTXGRUOP to other SAP tables.

J_1BTXGRUOP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
GRUOP Tax Group for Dynamic Tax Exceptions J_1BTXGRP NUMC 2 0
FIELD Master Data Fields for Tax Groups J_1BTXFIELDS CHAR 10 0
ASNUM Service Number
MATNR Material
NBM NCM Code
MATKL Material Class, Material Group
MWSKZ Tax Code
LIFNR Vendor
KUNNR Customer
BRSCH Industry Sector
CITYC City Code
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
OIHCGROUP Vendor Tax Group (Oil)
USAGE Tax Calculation: Material Usage
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
BUKRS Company Code
WERKS Plant
MTUSE_MARC Material Usage (Material Master Record)
MTORG Origin of Goods
CNAE CNAE Code
CRTN CRT Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
TDT Tax Declaration Type
COMSIZE Company Size
DECREGPC Declaration Regimen for PIS/COFINS
LEGALNAT Legal Nature
EXTWG External Material Group
PRDHA Product Hierarchy
OIC_OLAND1 Origin country code (Oil-MAP)
OIC_OREGIO Origin region (Oil-MAP)
OIC_OCOUNC Origin county code (Oil-MAP)
OIC_OCITYC Origin city code (Oil-MAP)
OIC_DLAND1 Destination country (Oil-MAP)
OIC_DREGIO Destination region (Oil-MAP)
OIC_DCOUNC Destination county code (Oil-MAP)
OIC_DCITYC Destination city code (Oil-MAP)
OIHVTYPE Business type (distributor,refinery/mill/other); Brazil Oil
FIELD2 Master Data Fields for Tax Groups J_1BTXFIELDS CHAR 10 0
ASNUM Service Number
MATNR Material
NBM NCM Code
MATKL Material Class, Material Group
MWSKZ Tax Code
LIFNR Vendor
KUNNR Customer
BRSCH Industry Sector
CITYC City Code
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
OIHCGROUP Vendor Tax Group (Oil)
USAGE Tax Calculation: Material Usage
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
BUKRS Company Code
WERKS Plant
MTUSE_MARC Material Usage (Material Master Record)
MTORG Origin of Goods
CNAE CNAE Code
CRTN CRT Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
TDT Tax Declaration Type
COMSIZE Company Size
DECREGPC Declaration Regimen for PIS/COFINS
LEGALNAT Legal Nature
EXTWG External Material Group
PRDHA Product Hierarchy
OIC_OLAND1 Origin country code (Oil-MAP)
OIC_OREGIO Origin region (Oil-MAP)
OIC_OCOUNC Origin county code (Oil-MAP)
OIC_OCITYC Origin city code (Oil-MAP)
OIC_DLAND1 Destination country (Oil-MAP)
OIC_DREGIO Destination region (Oil-MAP)
OIC_DCOUNC Destination county code (Oil-MAP)
OIC_DCITYC Destination city code (Oil-MAP)
OIHVTYPE Business type (distributor,refinery/mill/other); Brazil Oil
FIELD3 Master Data Fields for Tax Groups J_1BTXFIELDS CHAR 10 0
ASNUM Service Number
MATNR Material
NBM NCM Code
MATKL Material Class, Material Group
MWSKZ Tax Code
LIFNR Vendor
KUNNR Customer
BRSCH Industry Sector
CITYC City Code
OIHMTXGP Tax Group (Oil)
OIHVGROUP Customer Tax Group (Oil)
OIHCGROUP Vendor Tax Group (Oil)
USAGE Tax Calculation: Material Usage
LOC_PR Location of Service Provider
LOC_SE Location of Service Provision
LOC_SR Location of Service Customer
BUKRS Company Code
WERKS Plant
MTUSE_MARC Material Usage (Material Master Record)
MTORG Origin of Goods
CNAE CNAE Code
CRTN CRT Number
ICMSTAXPAY ICMS Tax Payer
INDTYP Industry Main Type
TDT Tax Declaration Type
COMSIZE Company Size
DECREGPC Declaration Regimen for PIS/COFINS
LEGALNAT Legal Nature
EXTWG External Material Group
PRDHA Product Hierarchy
OIC_OLAND1 Origin country code (Oil-MAP)
OIC_OREGIO Origin region (Oil-MAP)
OIC_OCOUNC Origin county code (Oil-MAP)
OIC_OCITYC Origin city code (Oil-MAP)
OIC_DLAND1 Destination country (Oil-MAP)
OIC_DREGIO Destination region (Oil-MAP)
OIC_DCOUNC Destination county code (Oil-MAP)
OIC_DCITYC Destination city code (Oil-MAP)
OIHVTYPE Business type (distributor,refinery/mill/other); Brazil Oil
CALLER Calling Application J_1BCALLER CHAR 2 0
SD Sales and Distribution
MM Materials Management
IM Inventory Management (Obsolete)
IV Invoice Verification (Obsolete)
PO Purchasing (Obsolete)
NULL General
ACTIVIC ICMS Tax Group Active J_1BACTIVIC CHAR 1 0
X Yes
NULL No
ACTIVIP IPI Tax Group Active J_1BACTIVIP CHAR 1 0
X Yes
NULL No
ACTIVIS ISS Tax Group Active J_1BACTIVIS CHAR 1 0
X Yes
NULL No
ACTIVST Substitui��o Tribut�ria Tax Group J_1BACTIVST CHAR 1 0
X Yes
NULL No
ACTIVPI PIS Tax Group Active J_1BACTIVPI CHAR 1 0
X Yes
NULL No
ACTIVCO COFINS Tax Group Active J_1BACTIVCO CHAR 1 0
X Yes
NULL No
ACTIVWT Withholding Tax Group Active J_1BACTIVWT CHAR 1 0
X Yes
NULL No