J_1BTXPIS

Tax Calculation: PIS | #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 PIS Rate Per Unit (Pauta) J_1BTXRATE
FACTOR PIS 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_1BTXPIS.CLIENT == T000.MANDT
Country/Region Key
  • Country/Region Key
  • Client
  • J_1BTXPIS.COUNTRY == T005.LAND1
  • J_1BTXPIS.CLIENT == T005.MANDT
Minimum Price: Currency
  • J_1BTXPIS.CLIENT == TCURC.MANDT
  • J_1BTXPIS.MINPRICE_CURRENCY == TCURC.WAERS
Minimum Price: PIS Tax Law
  • J_1BTXPIS.CLIENT == J_1BATL5.MANDT
  • J_1BTXPIS.MINPRICE_TAXLAW == J_1BATL5.TAXLAW
Minimum Price: Unit of measurement
  • J_1BTXPIS.CLIENT == T006.MANDT
  • J_1BTXPIS.MINPRICE_UOM == T006.MSEHI
PIS Tax Law
PIS Pauta Unit
  • J_1BTXPIS.CLIENT == T006.MANDT
  • J_1BTXPIS.UNIT == T006.MSEHI
Currency Key
  • J_1BTXPIS.CLIENT == TCURC.MANDT
  • J_1BTXPIS.WAERS == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Tax Group for Dynamic Tax Exceptions
  • Tax Group for Dynamic Tax Exceptions
  • Client