taxbra sap
TRANSCRIPT
-
5/20/2018 Taxbra Sap
1/67
Development Link SAP Brasil
-
5/20/2018 Taxbra Sap
2/67
SAP 2005 Localizao Brasil Development Link / 2
!!
-
5/20/2018 Taxbra Sap
3/67
SAP 2005 Localizao Brasil Development Link / 3
-
5/20/2018 Taxbra Sap
4/67
SAP 2005 Localizao Brasil Development Link / 4
"#$%#&''
Direitos Fiscais:
Foi criada a tabela J_1BTXLAWSEQ, atravs da qual possvel definir a seqncia de acesso s vrias fontes de
dados j existentes para determinao do Tax Law.
-
5/20/2018 Taxbra Sap
5/67
SAP 2005 Localizao Brasil Development Link / 5
As opes existentes so:
0 --> Tax Rate Exception Tables1 --> Item Category2 --> Customer Master Record
-
5/20/2018 Taxbra Sap
6/67
SAP 2005 Localizao Brasil Development Link / 6
Seqncia na Fonte de informao Tax LawDeterminao na determinao de Determinadode Tax Law Tax Law na O. de Venda
1 Tax Exception Tables IC0 / IP02 Item Category Table3 Customer Master
1 Customer Master IC2 / IP22 Item Category Table3 Tax Exception Tables
1 Item Category Table IC1 / IP12 Tax Exception Tables
3 Customer Master
-
5/20/2018 Taxbra Sap
7/67
SAP 2005 Localizao Brasil Development Link / 7
Tax Code:
Foi criada a tabela J_1BTXCODESEQ, atravs da qual possvel definir a seqncia de acesso s vrias fontes de
dados j existentes para determinao do Tax Code.
"#$%#&''
-
5/20/2018 Taxbra Sap
8/67
SAP 2005 Localizao Brasil Development Link / 8
As opes existentes so:
0 --> Item Category Table1 --> Customer Material Info
-
5/20/2018 Taxbra Sap
9/67
SAP 2005 Localizao Brasil Development Link / 9
Item Category Table - J_1BSDICA
-
5/20/2018 Taxbra Sap
10/67
SAP 2005 Localizao Brasil Development Link / 10
Customer Material Info - VD51
-
5/20/2018 Taxbra Sap
11/67
SAP 2005 Localizao Brasil Development Link / 11
-
5/20/2018 Taxbra Sap
12/67
SAP 2005 Localizao Brasil Development Link / 12
Seqncia na Fonte de informao Tax Code
Determinao na determinao de Determinadode Tax Code Tax Code na O. de Venda
1 Item Category Table I3
2 Customer Material Info
1 Customer Material Info C32 Item Category Table
-
5/20/2018 Taxbra Sap
13/67
SAP 2005 Localizao Brasil Development Link / 13
Contm a maioria das configuraes relevantes para oBrasil.
IMG Financial Accounting Financial Accounting Global Settings
Tax on Sales/Purchases
Calculation
Settings for Tax Calculation inBrazil Access Tax Manager's Workplace
-
5/20/2018 Taxbra Sap
14/67
SAP 2005 Localizao Brasil Development Link / 14
!"#!"#!"#!"#
-
5/20/2018 Taxbra Sap
15/67
SAP 2005 Localizao Brasil Development Link / 15
Ordem de prioridades para determinao de
alquotas de impostos
Exceo Por Material
Tabela Dinmica
Alquotas Normais
Valores Propostos
$%$%$%$%&&&&' %' %' %' %
-
5/20/2018 Taxbra Sap
16/67
SAP 2005 Localizao Brasil Development Link / 16
( )
* +' $,
-
( ' ,. ,+ ,,
/ 0
0 12
3 - 4 5+1206 7 7! 72 ( 0
% ( $)% % ( $)% % ( $)% % ( $)%
-
5/20/2018 Taxbra Sap
17/67
SAP 2005 Localizao Brasil Development Link / 17
Tabela J_1BTXGRUOP
At 3 chaves combinadas (ex. Material, cliente e IVA) Setor Industrial Cdigo da Cidade
Cliente Fornecedor Classe de material, Grupo de mercadoria Material IVA
NBM/NCM Code Vendor Tax Group (Oil) Tax Group (Oil) Customer Tax Group (Oil)
Clculo de Imposto: Utilizao de Material Local do Fornecedor de servio Local de execuo do servio Local do Recebedor do servio Planta Empresa
*)% ( $)%*)% ( $)%*)% ( $)%*)% ( $)%
-
5/20/2018 Taxbra Sap
18/67
SAP 2005 Localizao Brasil Development Link / 18
%(%(%(%(&&&&' ' ' ' ++++ ,- ,- ,- ,-
-
5/20/2018 Taxbra Sap
19/67
SAP 2005 Localizao Brasil Development Link / 19
-
5/20/2018 Taxbra Sap
20/67
SAP 2005 Localizao Brasil Development Link / 20
-
5/20/2018 Taxbra Sap
21/67
SAP 2005 Localizao Brasil Development Link / 21
!" #$
%& '
-
5/20/2018 Taxbra Sap
22/67
SAP 2005 Localizao Brasil Development Link / 22
$.$.$.$.&&&& - - - -
89
O clculo dos impostos brasileiros feito com o
uso de uma extensa interface externa de impostosatravs do mdulo de funo na frmula 320:
J_1BCALCULATE_TAXES
Alguns casos especiais no so cobertos
As tabelas so lidas diretamente daJ_1BCALCULATE_TAXES
A gerao da NF tambm era conduzida pelo mdulo
de funo
-
5/20/2018 Taxbra Sap
23/67
SAP 2005 Localizao Brasil Development Link / 23
SDSD
Calc.ProcedureCalc.Procedure
RVXBRARVXBRA
600 IBRX 320600 IBRX 320
620 ICM3 523620 ICM3 523
Brazilian Tax Calc.Brazilian Tax Calc.
SDSD
DatabaseDatabase
Brazil TaxesBrazil Taxes
DatabaseDatabase
SD ConditionsSD Conditions
DatabaseDatabase
%%%% /$ * /$ * /$ * /$ *
-
5/20/2018 Taxbra Sap
24/67
SAP 2005 Localizao Brasil Development Link / 24
BillingBilling
Calc.ProcedureCalc.Procedure
RVXBRARVXBRA
600 IBRX 320600 IBRX 320
620 ICM3 523620 ICM3 523
Brazilian Tax Calc.Brazilian Tax Calc.
NF SubsystemNF Subsystem
SDSD
DatabaseDatabase
NFNF
DatabaseDatabaseFIFI
Brazil TaxesBrazil Taxes
DatabaseDatabase
SD ConditionsSD Conditions
DatabaseDatabase
%%%% /$ * /$ * /$ * /$ *
-
5/20/2018 Taxbra Sap
25/67
SAP 2005 Localizao Brasil Development Link / 25
MMMM
CalcCalc.. ProcedureProcedure
TAXBRJTAXBRJ
150 320150 320
230 ICM1 523230 ICM1 523
Brazilian Tax Calc.Brazilian Tax Calc.
MMMM
DatabaseDatabase
Brazil TaxesBrazil Taxes
DatabaseDatabase
%%%% * * * *
MM ConditionsMM Conditions
DatabaseDatabase
-
5/20/2018 Taxbra Sap
26/67
SAP 2005 Localizao Brasil Development Link / 26
InvoiceInvoice
VerificationVerification
Brazilian Tax Calc.Brazilian Tax Calc.
NF SubsystemNF Subsystem
MMMM
DatabaseDatabase
NFNF
DatabaseDatabaseFIFI
Brazil TaxesBrazil Taxes
DatabaseDatabaseCalc.ProcedureCalc.Procedure
TAXBRJTAXBRJ
150 320150 320
230 ICM1 523230 ICM1 523
%%%% * * * *
MM ConditionsMM Conditions
DatabaseDatabase
-
5/20/2018 Taxbra Sap
27/67
SAP 2005 Localizao Brasil Development Link / 27
*" 12
O clculo dos impostos brasileiros feito com o
uso da mesma interface externa de impostos, porm
mais simplificado. No h acesso as tabelas delocalizao.
Baseado em Condition Technique.
As informaes so armazenadas em condition
records.
-
5/20/2018 Taxbra Sap
28/67
SAP 2005 Localizao Brasil Development Link / 28
Tax Codes
SAP R/3
Enterprise
Tax RatesTax
Exemptions
Rules Tax
Determination
Maintenance of tax rates and exceptions(IMG)
. . . .
-
5/20/2018 Taxbra Sap
29/67
SAP 2005 Localizao Brasil Development Link / 29
SalesSales
Calc.ProcedureCalc.ProcedureRVABRARVABRA
300 IBRX 320300 IBRX 320
310 ICVA310 ICVA
SDSD
DatabaseDatabase
SD ConditionsSD Conditions
DatabaseDatabase
Brazilian PricingBrazilian Pricing
FormulaFormula
0 /$ *0 /$ *0 /$ *0 /$ *
-
5/20/2018 Taxbra Sap
30/67
SAP 2005 Localizao Brasil Development Link / 30
BillingBilling
Calc.ProcedureCalc.Procedure
RVABRARVABRA
300 IBRX 320300 IBRX 320
310 ICVA310 ICVA
NF SubsystemNF Subsystem
SDSD
DatabaseDatabase
NFNF
DatabaseDatabaseFIFI
SD ConditionsSD Conditions
DatabaseDatabase
Brazilian PricingBrazilian Pricing
FormulaFormula
0 /$ *0 /$ *0 /$ *0 /$ *
-
5/20/2018 Taxbra Sap
31/67
SAP 2005 Localizao Brasil Development Link / 31
PurchasePurchase
OrderOrder
Calc.ProcedureCalc.ProcedureTAXBRATAXBRA
191 BX01 320191 BX01 320
415 ICM1415 ICM1
MMMM
DatabaseDatabase
MM ConditionsMM Conditions
DatabaseDatabase
Brazilian PricingBrazilian Pricing
FormulaFormula
0 *0 *0 *0 *
-
5/20/2018 Taxbra Sap
32/67
SAP 2005 Localizao Brasil Development Link / 32
InvoiceInvoice
VerificationVerification
Calc.ProcedureCalc.Procedure
TAXBRATAXBRA
191 BX01 320191 BX01 320
415 ICM1415 ICM1
NF SubsystemNF Subsystem
MMMM
DatabaseDatabase
NFNF
DatabaseDatabaseFIFI
MM ConditionsMM Conditions
DatabaseDatabase
Brazilian PricingBrazilian Pricing
FormulaFormula
0 *0 *0 *0 *
-
5/20/2018 Taxbra Sap
33/67
SAP 2005 Localizao Brasil Development Link / 33
1
09 / 2061*0 *801*0:
; *!:
*801*0 *!
@,"@,' *! 1-
@,","& *! 1- ). A)
?44 2
>>&$%% 1- ? 1 2
"@>,+% 1-= *!
*"
-
5/20/2018 Taxbra Sap
34/67
SAP 2005 Localizao Brasil Development Link / 34
1
0 = / B
( / / 0
* 9 /
) 9 0 *!. *!.
C-/ D E*F
2 9 ;
/ 5+1206
! 9
-
5/20/2018 Taxbra Sap
35/67
SAP 2005 Localizao Brasil Development Link / 35
Transaction data retrieval
Customizing data retrieval
Tax calculation
Results of tax calculation
Tax code conditions
TAXBRA(MM) / RVABRA(SD e CRM)
Os Esquemas de clculo CBT estruturado da seguintemaneira:
2%2%2%2% 3333
-
5/20/2018 Taxbra Sap
36/67
SAP 2005 Localizao Brasil Development Link / 36
O novo esquema de clculo TAXBRA deve ser
atribudo por pas no IMG ->Financial Accounting ->
Financial Accounting Global Settings -> Tax on Sales/Purchases ->Basic Settings -> BR -> Assign Country to Calc. Procedure
....&&&&'''' 44443333
* . * . * . * .
-
5/20/2018 Taxbra Sap
37/67
SAP 2005 Localizao Brasil Development Link / 37
Os esquemas de clculo TAXBRA e RVABRA
devem ser ativados como esquemas CBT no
IMG ->Financial Accounting -> Financial Accounting Global Settings ->Tax on Sales/Purchases -> Basic Settings -> BR -> CBT -> Specify Calc.Procedures for Condition-Based Tax Calculation
* . * . * . * .
-
5/20/2018 Taxbra Sap
38/67
SAP 2005 Localizao Brasil Development Link / 38
O CBT deve ser ativo por pas no IMG FinancialAccounting Financial Accounting Global Settings Tax on
Sales/Purchases Basic Settings Brazil Condition-Based TaxCalculationActivate Condition Generation
"- . "- . "- . "- .
-
5/20/2018 Taxbra Sap
39/67
SAP 2005 Localizao Brasil Development Link / 39
5 1% "#" 1""5 1% "#" 1""5 1% "#" 1""5 1% "#" 1""
Mapeamento das condies para os campos da Nota Fiscalpermitindo uma maior flexibilidade em atender cenriosespecficos de compra/venda.
-
5/20/2018 Taxbra Sap
40/67
SAP 2005 Localizao Brasil Development Link / 40
%
/$
2% *& 1""
2%2%2%2% 3333 %%%% /$ 1""/$ 1""/$ 1""/$ 1""
-
5/20/2018 Taxbra Sap
41/67
SAP 2005 Localizao Brasil Development Link / 41
2%2%2%2% 3333 %%%% /$ 1""/$ 1""/$ 1""/$ 1""
RVABRA estruturada com os seguintes blocos de condies:
Determinao do preo lquido
Busca de dados em customizao
Clculo de impostos no valor lquido (Step 1)
Modificaes no preo base (including ICMS) relevantes para Nota Fiscal
Clculo dos impostos no montante modificado (incluindo ICMS) (Step 2)
Resultado dos clculos dos impostos
Condies dos Tax Codes
O clculo ocorre dentro da frmula 320, que foi estendida para oconceito CBT. Dois dos pontos em que a frmula aparece:
-ICMI, onde o imposto calculado.
- IBRX, clculo inclundo ICMS + outras condies entre ICMI e IBRX.
A frmula 320 tambm aparece nos pontos em que ocorre busca dosresultados dos clculos.
-
5/20/2018 Taxbra Sap
42/67
SAP 2005 Localizao Brasil Development Link / 42
>>&$%%
0/ 2061**861* GA2! HA*2 0 0. A!2
2061*0*801*0II
-
5/20/2018 Taxbra Sap
43/67
SAP 2005 Localizao Brasil Development Link / 43
Exemplos PrticosMM
Criao de pedido de compras
-
5/20/2018 Taxbra Sap
44/67
SAP 2005 Localizao Brasil Development Link / 44
Criao de pedido de compras
Tela Exibir Impostos
Transaction Data
Retrieval
Customizing DataRetrieval
-
5/20/2018 Taxbra Sap
45/67
SAP 2005 Localizao Brasil Development Link / 45
Customizing Data
Retrieval
Chamada da
frmula 320
Results ofTax Calculation
-
5/20/2018 Taxbra Sap
46/67
SAP 2005 Localizao Brasil Development Link / 46
Results ofTax Calculation
-
5/20/2018 Taxbra Sap
47/67
SAP 2005 Localizao Brasil Development Link / 47
Results ofTax Calculation
-
5/20/2018 Taxbra Sap
48/67
SAP 2005 Localizao Brasil Development Link / 48
Tax CodeConditions
-
5/20/2018 Taxbra Sap
49/67
SAP 2005 Localizao Brasil Development Link / 49
Tela Exibir Impostos - Anlise Detalhada das Conditions
-
5/20/2018 Taxbra Sap
50/67
SAP 2005 Localizao Brasil Development Link / 50
-
5/20/2018 Taxbra Sap
51/67
SAP 2005 Localizao Brasil Development Link / 51
Clicar no grupo 10
-
5/20/2018 Taxbra Sap
52/67
SAP 2005 Localizao Brasil Development Link / 52
-
5/20/2018 Taxbra Sap
53/67
SAP 2005 Localizao Brasil Development Link / 53
0% siginifica que esta conditionno foi satisfeita
BICX: Verifica se o FlagOutras est ativo
-
5/20/2018 Taxbra Sap
54/67
SAP 2005 Localizao Brasil Development Link / 54
-
5/20/2018 Taxbra Sap
55/67
SAP 2005 Localizao Brasil Development Link / 55
Exemplos PrticosSD
/$ % 6!
-
5/20/2018 Taxbra Sap
56/67
SAP 2005 Localizao Brasil Development Link / 56
Impostos Calculados:
ICMS
IPIPIS
COFINS
-
5/20/2018 Taxbra Sap
57/67
SAP 2005 Localizao Brasil Development Link / 57
-
5/20/2018 Taxbra Sap
58/67
SAP 2005 Localizao Brasil Development Link / 58
-
5/20/2018 Taxbra Sap
59/67
SAP 2005 Localizao Brasil Development Link / 59
-
5/20/2018 Taxbra Sap
60/67
SAP 2005 Localizao Brasil Development Link / 60
/$ % 67 8 /-& 8 // $- *-
-
5/20/2018 Taxbra Sap
61/67
SAP 2005 Localizao Brasil Development Link / 61
Impostos Calculados:
ISS
PISCOFINS
-
5/20/2018 Taxbra Sap
62/67
SAP 2005 Localizao Brasil Development Link / 62
-
5/20/2018 Taxbra Sap
63/67
SAP 2005 Localizao Brasil Development Link / 63
-
5/20/2018 Taxbra Sap
64/67
SAP 2005 Localizao Brasil Development Link / 64
ISS local do provedor: ISVFdeve ser = 1
ISS local da execuo: ISVRdeve ser = 2
-
5/20/2018 Taxbra Sap
65/67
SAP 2005 Localizao Brasil Development Link / 65
-
5/20/2018 Taxbra Sap
66/67
SAP 2005 Localizao Brasil Development Link / 66
*9*9*9*9
-
5/20/2018 Taxbra Sap
67/67
SAP 2005 Localizao Brasil Development Link / 67