Delete entries from PPFTTRIGG

[Former Member]

Hello All,

We have a huge number of entries in table 'PPFTTRIGG' for certain opportunities.

What are the effects of deleting the entries for these particular Opportunities..apart from the fact that these opportunities will not have email alerts sent ( in our case we use smartform to send emails) ..These entries are causing the opportunity save to time out as each time the opportunity is saved, it scans the PPFTTRIGG for any actions that should be triggered.

Thanks.

Regards,

Monica

[former_member196467 · Accepted solution]

Hi Monica,

For the table PPFTTRIGG, you should check which actions are in

the status 'processed successfully' or 'processed with error'; and

which of these can be deleted to reduce the number of records in

the table. Maybe you can use the report RSPPFCLEAN to check for

actions for which the corresponding application object does not

exists anymore. Such actions can normaly be deleted.

Please consider note 1350903.

Hoping that this will be helpful.

Best regards

Christophe

[Former Member · Accepted solution]

Hello Christophe,

Thanks for the information .

Do you have further information on how to create Sort Fields.

We are using Actions for Opportunities .

In the Action Definition : we have 4 fields listed for Sort Field 1..Gues they are standard..We have OUTPUT_PPFCALL_COM_H,Not_active, Static and Status_print..

I thought the most relevant is OUTPUT_PPFCALL_COM_H.

but after this, how do I proceed with adding attribute values and selecting them in 'rsppfprocess' report.

Thanks.

[former_member196467 · Accepted solution]

Hi Monica,

I see what you mena but unfortunatelhy I am not too familiar with your latest question.

Please see the help description of the 'sort fiield' in RSPPFPROCESS which could be of help:

Sort Field

Use

You can use the sort fields to process a series of actions in a defined order during batch processing. For this, you have to assign an attribute of the application object to the sort field in the action Customizing. When the action is generated, the value of this attribute is then entered into the corresponding sort field. First, the sorting defines how the selected actions are displayed in the list. During the batch run, the actions are then also processed in this order.

For the sorting, you must create and specify a variant that orders the ALV according to the entries in the sort fields. The dialog allows you to check the correct sort sequence in the ALV.

Example

For example, if the postal code of the document recipient is entered into one of the sort fields, documents can be printed sorted by their postal code.

===============================================================================================

Best regards

Christophe

[nelson_raj2 · Accepted solution]

Hi Christophe & Monica,

The way to delete additional entries in PPFTTRIGG is by using the RSPPFPROCESS program itself.

There is a radio button for "Delete without Dialog", and it must be scheduled in a background Job.

Alternately if you want to view the actions before deleting them, you can use the option "Allow Deletion of Actions".

Hope this helps someone with the same issue.

Regards,

Nelson