The RRFOUS_T program enables an organization to create a payroll payment file in the format that meets the requirements of the the US financial institutions. Some of the information on the ACH file can be based on configuration (via transaction FBZP) or programming within user exits. Knowing that most banks have differing minor requirements even for a standardized format, the purpose of this document is to help you find out which fields within the RFFOUS_T program can be populated using standard configuration and which ones will need to be populated using the user exit approach. It is advisable to use the configuration approach whenever possible.
The ACH file is composed of 5 different sections:
- A File Header
- Company/Batch Header Record
- Entry Detail Record
- Company/Batch Control Record
- File Control Record
Those five different sections correspond to 5 different dictionary structures in the RFFOUS_T program for the ACH format. To display them, access the ABAP Development Workbench via transaction SE80. Once you are in the transaction, enter the program name "RFFOUS_T" and expand the "Dictionary Structures".
You will notice the "DTAM***" structures employed by the user exits while the "DTAU***" structures are the ones that can be filled via standard configuration. Please refer to the table below for a detailed breakdown of the structures.
Let’s see how this can be useful to us. Let’s take for instance, the field "Individual’s Identification" required by the bank in their specifications in the "Entry Detail Record" section as shown below:
Let’s now open the corresponding standard structure "DTAUSCCD" by double clicking on it:
The second double click will provide us with the list of fields within the structure as seen below. The field "Individual’s Identification" as referenced by the bank corresponds to the field "Identification Number" (CCD7) within the DTAUSCCD structure.
When the RFFOUS_T program is executed to generate a payroll bank file, the employee number (Identification Number) is not populated within the standard file. Now that we know how the field is called, we can look into the user exits and see if this field is included. The user exit corresponding to this structure is "DTAMUSCCD". So let’s double click on it to display its content as per below:
Notice that the "Identification Number" field is included along with a few others. This is not a complete list of all the fields within the CCD structure. However, these are accessible fields within the user exit.
If you want another confirmation that the employee number is not delivered without using the user exit, you can also search for the code in the program based on the field name "CCD7". You may notice that when the standard structure is populated this field is skipped as per the screen capture below:
In order to locate this particular line of code, please follow the next steps.
Double click on the program name itself in the "Object Name" column (left hand side), this will display the program code on the right hand side.
Search the code by selecting the menu "EDIT > Find/Replace" by entering the field name "CCD7".
The search will bring back the following.
Double click on line 848 to display the code where structure "dtausccd" is filled and you will notice that field CCD7 is not populated at this stage. Please note that every structure is populated by a form called "fill_xxxxx", where xxxxx equals the name of the structure.
So if you are wondering - after configuring your ACH payments files, payment methods, house banks and other bank related steps - why certain fields are still not showing up in your bank test file, you can use this process to confirm whether or not the field you are looking for is populated via standard configuration or if an user exit is required.
ABOUT HR FOCAL POINT
- When time, accuracy and high-quality support are essential, HR Focal Point's precision approach to SAP HCM solutions is the clear choice.
- HR Focal Point has been the SAP HCM expert since 2004 with hundreds of years of combined consulting experience its team.
- HR Focal Point has the SAP HCM experts that will allow you to achieve your goals on time, on point and on budget, thus maximizing your ROI.
- HR Focal Point offers a flexible engagement model so you only pay for the services you require, when you require them.
- As an SAP Services Partner, HR Focal Point is known for delivering high-quality solutions, in support of SAP HCM, that are completed accurately and on schedule.
- HR Focal Point has partnered with SuccessFactors to develop and deliver innovative Cloud solutions, including Employee Central Payroll, for their clients.
FOR MORE INFORMATION
HR Focal Point
Telephone: +1 855.464.4737