- Home
- Resources
- SAP Tables
- 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.
Source: J_1BTXGRUOP (Dynamic Determination of Tax-Related Master Data)
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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
| 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 |
Possible values
|
| ACTIVIP |
IPI Tax Group Active |
J_1BACTIVIP |
|
CHAR |
|
1 |
0 |
Possible values
|
| ACTIVIS |
ISS Tax Group Active |
J_1BACTIVIS |
|
CHAR |
|
1 |
0 |
Possible values
|
| ACTIVST |
Substituição Tributária Tax Group |
J_1BACTIVST |
|
CHAR |
|
1 |
0 |
Possible values
|
| ACTIVPI |
PIS Tax Group Active |
J_1BACTIVPI |
|
CHAR |
|
1 |
0 |
Possible values
|
| ACTIVCO |
COFINS Tax Group Active |
J_1BACTIVCO |
|
CHAR |
|
1 |
0 |
Possible values
|
| ACTIVWT |
Withholding Tax Group Active |
J_1BACTIVWT |
|
CHAR |
|
1 |
0 |
Possible values
|
