Financial Management Blogs by SAP
Get financial management insights from blog posts by SAP experts. Find and share tips on how to increase efficiency, reduce risk, and optimize working capital.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

TDF: EFD-Reinf 2.1.1 – How to Determine the Nature of Income

rodolfo_celante
Employee
Employee
‎03-23-2023 4:01 PM

Você quer ver esse blog post em português? Clique aqui.



Hello, 

In this blog post, I will explain about the nature of income and demonstrate how it can be determined for the generation of R-4000 series events from EFD-Reinf 2.1.1. 

Prerequisites


You must have Support Package 17 of TDF installed and updated according to the list of prerequisite notes for the installation of the following SAP Notes: 

Nature of Income


This field was added for the new R-4000 series events of the report EFD-Reinf 2.1.1. The field classifies the withholding of taxes on services. 

This topic needs to be analyzed for each case, whatever your scenario. To help you, the Brazilian federal revenue service has provided some links that can assist in understanding how to fill in this field. See the links below: 

The content that will be explained below belongs to a subject matter that we will still address in following blog posts: the transaction EFD-Reinf Preprocessing (/TMF/REINF_PRE_PROC). 

Configuring the Nature of Income in Events


After understanding which nature of income code will be used in the events to be generated, we will now go into detail on how to determine this information correctly when generating events. 

The configuration table Income Nature (/TMF/D_R_NATREND) must be used to determine the following fields: 

  • Income Nature Code (/TMF/D_R_NATREND-NAT_REND)

  • Income Nature Observation (/TMF/D_R_NATREND-NAT_REND_OBS)


Based on the configuration table, the system cross-checks the data involving the Accounting Entry fields, using the Supplier/Customer Code (/TMF/D_R_NATREND-COD_PART), Document Type (/TMF/D_R_NATREND-TIPO_DOC) and Expense Accounts (/TMF/D_R_NATREND-COD_CTA_DESP), including the accounts found on the purchase order. 

Then, two priorities will be issued to determine the NAT_REND and NAT_REND_OBS: the first priority is when all the values of the issuing document are completely equal to one of lines configured in the Customizing /TMF/D_R_NATREND. 

In our example, the issuing document has the following data: 



























NUM_LCTO TIPO_DOC COD_PART COD_CTA_DESP
100004105 RE CodPart1 191000
100004105 RE CodPart1 177000
100004105 RE CodPart1 154004

The following data was configured in the customizing:






































TIPO_DOC COD_PART COD_CTA_DESP NAT_REND NAT_REND_OBS
RE CodPart1 191000 10004 Obs for 10004
RE 191000 11002 Obs for 11002
RE Fornec01 177000 11002 Obs for 11002
RE CodPart1 999999 12034 Obs for 12034

When searching for nature of income code using all fields (Maximum Priority), we will find the following result highlighted in green: 






































TIPO_DOC COD_PART COD_CTA_DESP NAT_REND NAT_REND_OBS
RE CodPart1 191000 10004 Obs for 10004
RE 191000 11002 Obs for 11002
RE Fornec01 177000 11002 Obs for 11002
RE CodPart1 999999 12034 Obs for 12034

Therefore, for the document “100004105”, the system would report using the Income Nature with the code equal to “10004” and Income Nature Observation equal to “Obs for 10004”.  

If the “Maximum Priority” scenario is not found, a secondary search is performed without comparing the COD_PART, using the lines found in the customization where the COD_PART is blank. Assuming that customizing is configured as shown below: 






































TIPO_DOC COD_PART COD_CTA_DESP NAT_REND NAT_REND_OBS
RE Fornec01 191000 10004 Obs for 10004
RE 191000 11002 Obs for 11002
RE Fornec01 177000 11002 Obs for 11002
RE CodPart1 999999 12034 Obs for 12034

Note that there is no row where all the data are the same as in the issuing document. With this, the secondary priority line (Without COD_PART) will be selected. 






































TIPO_DOC COD_PART COD_CTA_DESP NAT_REND NAT_REND_OBS
RE Fornec01 191000 10004 Obs for 10004
RE 191000 11002 Obs for 11002
RE Fornec01 177000 11002 Obs for 11002
RE CodPart1 999999 12034 Obs for 12034

In this case, the document “100004105” would be reported using the Income Nature with the code equal to “11002” and Income Nature Observation equal to “Obs for 11002”. 

Regardless of how the event is generated (pre-processing or manually added to the table), for each event generated, the two fields, NAT_REND and NAT_REND_OBS can be found in the table Income Postings/Payments with Withholdings (/TMF/D_LCTORENRT), for each event generated/to be generated. 

For more information about the main event generation table of the 4000 series, visit the blog post TDF EFD-Reinf 2.1.1 – Overview of the Income Postings/Payments with Retention table.In the next blog post, we will learn how preprocessing works for the 4000 series events.

We would love to have your feedback. If you have any questions or suggestions for an upcoming post, please leave your comment below. Apart from the comment section, you can also contact us through the Customer Influence platform, where you can propose ideas to improve our product, vote on previously released ideas and follow those ideas being currently implemented. Follow the SAP Tax Declaration Framework for Brazil vtag here at the SAP Community to keep updated with the latest news on the TDF Add-On. 

 

See you next time!

Rodolfo Felipe Celante

SAP TDF Development Team

#SAPGoGlobal #SAPLocalization

 
Labels:
Popular Blog Posts