Spool generated for program RFFOUS_T on basis of organizational key

[Former Member]

Hello All,

The program RFFOUS_T is used for Payment Medium USA - Transfers/Bank Direct Debits in ACH Format.

According to standard procedure, it will generate the spool for each employee on basis of BANK KEY.

But according to our requirement, we need to  generate multiple spool files on the basis of Organizational key in IT0001 (P0001-WERKS) and each spool will be restricted to respective locations and contact persons.

Once different spool files are generated in SP01, contact persons can print different Spool outputs by selecting their respective Printers located at their locations

How do we achieve this ?

Regards,

Ally

[Former Member]

Hi,

For your requirement you can do implicit enhancements to populate custom table ( with data requird for spool ) and then write your custom program for printing spool.

Alternatively you can copy the standard program and do the changes.

The first one would be an ideal solution .

Thanks

Pavan

[Former Member]

Hello Pavan,

Thank you for your reply.

This is how we have tried to work the requirement

After enhancement, when we run RFFOUS_T, the organizational key (Field Name: VDSK1) maintained in IT0001 will be mapped to the custom table  ZHR_ORGKEY. In this custom table, the organizational key will correspond to a location and a contact person.

Based on the multiple spool files generated for different org keys after executing program RFFOUS_T,

business users can print different Spool outputs by selecting their respective Printers located at their locationa

However, the issue we are facing is:-

.       a) Here Total data is coming in FIELD_GROUP extract; it is not possible to add our Orgkey in that field group.  If we add that field we need to change the LDB of the program RFFOUS_T.

But the same LDB is using in many programs. We don’t know what will happens if I change that LDB.

b) Even if we generate the spool on orgkey basis , still many conditions are there based on some other fields like New bank of payee, new bank account number of payee, payment document number

Can you please advise on where we maybe be going wrong

Regards,

Ally

[Former Member]

Hello All,

Any workable solutions for  this issue.

Your ideas will be much appreciated.

Regards,

Ally

[Former Member]

Hi Ally,

We are not supposed to change the LDB, If you know the place where the data is populated in the program, you can build your own custom table with data. say ZHR_EXTRACT

I could not find P0001-WERKS field in the structures of the program RFFOUS_T, you may need to have some selection logic here.

Then you can process your custom table ZHR_EXTRACT with a custom program say ZPROCESS_DATA for your requirement.

Please let me know where you are enhancing the program RFFOUS_T

Thanks

Pavan

[Former Member]

Hello Pavan,

We have created custom table which has the organizational key (based on cost center), location and contact person stored

1.     The Technical consultant will need to develop a new Include in program RFFOUS_T  to split current spool based on the Custom table which has Org keys, their respective locations and Contact Persons.

2.      The Technical consultant also needs to work on an Include in program RFFOUS_T, which will change printing authority (user name) and restrict Jobsite users in SP01.

Note: - Here changing printing authority on spool’s means that, Job Sites end users ‘User Name’ will be populated on their respective Job site spool in SP01.

.

Are there any includes available for spool 'Payment Advice notes' which will fulfill the above requirement?

Is there any back-end configuration possible to spilt spools based on organizational keys?