J_1BTXCOF

Tax Calculation: COFINS | #other | Component: Logistics Brazil
Column Name Description
CLIENT FK Client
COUNTRY FK Country/Region Key
GRUOP FK Tax Group for Dynamic Tax Exceptions
VALUE Dynamic Key Field
VALUE2 Dynamic Key Field
VALUE3 Dynamic Key Field
VALIDFROM Date from which the tax rule is valid
Column Name Description
Column Name Description
📏 Minimum Price: Unit of measurement (MINPRICE_UOM):
MINPRICE_QUANTITY Minimum Price: Quantity
Column Name Description
Column Name Description
Column Name Description Domain name
VALIDTO Date to which the tax rule is valid DATUM_INV
RATE Tax Rate J_1BTXRATE
BASE Tax base (%) J_1BTXBASE
AMOUNT COFINS Rate Per Unit (Pauta) J_1BTXRATE
FACTOR COFINS Number of Units DEC4_2
RATE4DEC Tax Rate with 4 Decimal Places J_1BTXRATE4DEC
AMOUNT4DEC Rate Per Unit (Pauta) with 4 Decimal Places J_1BTXRATE4DEC
FACTOR4DEC Number of Units for Pauta with 4 DP (for Reporting Only) DEC4_2
MINPRICE_AMOUNT Minimum Price: Amount
Master Data Relations Join Conditions
Client J_1BTXCOF.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BTXCOF.COUNTRY == T005.LAND1
  • J_1BTXCOF.CLIENT == T005.MANDT
Minimum Price: Currency
  • J_1BTXCOF.CLIENT == TCURC.MANDT
  • J_1BTXCOF.MINPRICE_CURRENCY == TCURC.WAERS
Minimum Price: COFINS Tax Law
Minimum Price: Unit of measurement
  • J_1BTXCOF.CLIENT == T006.MANDT
  • J_1BTXCOF.MINPRICE_UOM == T006.MSEHI
COFINS Tax Law
COFINS Pauta UoM
  • J_1BTXCOF.CLIENT == T006.MANDT
  • J_1BTXCOF.UNIT == T006.MSEHI
Currency Key
  • J_1BTXCOF.CLIENT == TCURC.MANDT
  • J_1BTXCOF.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Group for Dynamic Tax Exceptions
  • Tax Group for Dynamic Tax Exceptions
  • Client