Skip to Content
Author's profile photo Gabriel Felipe Coleti

DDA – Brazilian Automatic Direct Debit – Improving Vendor Payment Reconciliation

Introduction

The Brazilian DDA replace the old Boleto which is a Bill of Exchange with a 44/47 bar-code digits that the payer can easily perform the payment thru an ATM , Bank Web Site or Bank File Exchange.

Basically DDA is an Electronic Boleto also containing the 44/47 bar code digits as reference for payment.

Previously, the AP open item should be updated by the user, usually using a Bar-code Scanner, with the Bar Code Digits at FB02, screen field RF05L-BRCDE.

Now with DDA replacing the old Boleto, SAP delivered some solutions to have this bar code updated automatically when processing the bank file thru J_1BBR20 and J_1BBR30 programs. SAP also delivers DDA_BR functionality for post processing in case that the automatically identification didn´t happens for some reason.


Business Process for DDA



The vendor will send to the bank a file with the information for DDA creation which send to CIP (Câmara Interbancária de Pagamentos), CIP will process the Vendor request and forward to the House Bank that can be download by the company or receive the file for processing thru a VAN service.


Vendor -> Bank <-> CIP <-> House Bank <-> Company


The company will process and update the open items with the DDA bar-code and process the F110 DME payment file and send to the House Bank which send back to CIP that process the payment of that DDA and communicate the Vendor Bank.


The Challenge

The information such as CNPJ, Due Date, Amount and Reference Field will be used by SAP system to determine the AP open item for bar-code update.

The reference field in Brazil is used to record the Nota Fiscal number (Invoice Number) usually with the following Mask: 999999999-999 – Nine numeric digits as the NF number and three numeric digits called Serie.

The vendor can send the NF number with many possibilities such as:

* 123-1

* 123/1

* 1231

* 000000123-1

Usually SAP create the open item with the following way: 000000123-1 (Leading zeros the NF number, pipe and then the serie)

It is really difficult to match the vendor reference with the SAP reference field and usually the DDAs will be sent to DDA_BR for post processing. Unfortunately, this transaction code is not open to update the reference number with the expected one (REFERENCE_NO) and also the payable accountant usually do not agree to update his/her open item with the vendor reference.

Workaround Solution

The workaround solution that we applied for our business is to open the reference number, so the payable accountant can input the reference according to his open item.

We did that using enhancements on programs “RFFOBR_DDA, RFFOBR_DDA_O00”. The enhancement point is RFFOBR_DDA_POINT that can be used on the information treatment.


Follow bellow some technical inputs and ABAP source code to help you to perform the same to open the Reference Field in DDA_BR transaction without need to copy the program to a Z program:




/wp-content/uploads/2016/03/1_910807.png



Enhancement to apply the ALR user input data before Post Processing function:


/wp-content/uploads/2016/03/2_910806.png

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Dammah Sebiyam
      Dammah Sebiyam

      Great Document!!!

      I implemented Brazil Boleto back in 2008 but now everything has changed with electronic DDA. My client just asked for the implementation of this new process for Brazil entity.  

      Author's profile photo Gabriel Felipe Coleti
      Gabriel Felipe Coleti
      Blog Post Author

      Thanks Dammah...

      Author's profile photo Dammah Sebiyam
      Dammah Sebiyam

      Hi Gabriel,

      Is it typical for Brazil banks not to provide sample test files for the new DDA process? File layout?  Bradesco bank says not possible but feel does not want to provide sample file to test until production and this is weird. I cannot find any sample test file creation program similar to RFEBKAT0-9 for MultiCash/BAI/IDOCs.  Thanks

      Author's profile photo Gabriel Felipe Coleti
      Gabriel Felipe Coleti
      Blog Post Author

      Dear Dammah,

      Yes, it´s not possible to have test file data because Brazilian banks usually don´t have a test environment system.

      Ask your customer to contact the bank to activate the DDA service inside the bank and when the customer receive some Boleto thru DDA you can test this file.

      This was how we did.

      Best regards,

      Gabriel Coleti

      Author's profile photo Dammah Sebiyam
      Dammah Sebiyam

      Ok, great. thank you

      Author's profile photo Dammah Sebiyam
      Dammah Sebiyam

      Hi Gabriel,

      Ok so Bradesco sent sample DDA file but this file is not accepted by SAP. FF.5 throws an error that file format not valid. I and a colleague compared the file with the file specifications provided by Brasdesco. We found about 90% of records as per specification but notice it did not have file trailer and few other items. Still debugging but can't get anywhere and I have never seen an actual DDA file so not sure why FF.5 says file not valid format. 

      Do you have any pointers?   Thanks

      Author's profile photo Gustavo Navas
      Gustavo Navas

      Hello

       

      Could you tell me If you have the solution about the CNPJ 8 digits insted of complete digit fron the file BankĀ  DDA to link the invoice

       

      Thanks