Broadcast email Custom Text Variables

[Former Member]

Hi Gurus,

Is it possible to introduce in Subject or Content of the mail a custom Text Variable ?

My idea is to introduce in the Subject of the mail a Text Variable representing the value of the Company for which i have scheduled the query, like in the standard BEx reporting.

Thank you in advance.

Ciao.

Riccardo.

[former_member188972 · Accepted solution]

Hi Riccardo,

is exactly the problem that we solved as follows.

The subject and the body are stored in the table

rsrd_sett_node_t

with the key:

ID = 'DI_SUBJECT' or 'DI_BODY'

setting_id = <technical name of the ID of broadcasting report that you have saved>

You can substitute the subject and body before the broadcasting execution with a simple ABAP program.

Pay attention at table, it is language-dependent.

unfortunately it's not possible to change the name of workbook file:

Regards,

Sergio

Message was edited by:

Sergio Locatelli

[Former Member · Accepted solution]

Hi Sergio,

thank you very much for your idea.

One more question: if I generate the different queries with a Control Query how can I manage the substitution with the program and the table you are suggesting ?

Thank you in advance.

Riccardo.

[former_member188972 · Accepted solution]

I suggest to substitute text and launch the query from the same report or the same chain (if you're in 7.0).

In the body and subject you can insert a tag to identify where you want to insert the text. An example:

"Report delivered from broadcasting for <COMPANY>"

the code could be as follow:

SELECT SINGLE * FROM rsrd_sett_node_t INTO l_s_sett_node_t

WHERE setting_id = t_broad-idbroadcas

AND id = 'DI_SUBJECT'.

IF sy-subrc EQ 0.

REPLACE '<COMPANY>' INTO zsd_broadrep_tex-value_subject WITH t_broad-company.

REPLACE '<TEXTCOMPANY>' INTO zsd_broadrep_tex-value_subject WITH /bic/t0company-txtmd.

condense zsd_broadrep_tex-value_subject.

l_s_sett_node_t-value = zsd_broadrep_tex-value_subject.

MODIFY rsrd_sett_node_t FROM l_s_sett_node_t.

ENDIF.

Regards,

Sergio

[Former Member]

Hi,

If you by any chance are watching this thread: Where do we place the above code? Is there a customer exit for the broadcaster?

Regards,

Rikard

[Former Member]

Hi,

I know this was posted a while ago, but I'm working on a similar problem so I thought i'd include my comments.

Write an abap program which updates the settings as described in the thread.

Run the broadcasting from a process chain and include the update of the settings before the broadcast step by executing the abap in the chain.

In my scenario I have a range of settings broadcasting reports to depot managers and operating company managers. The managers email addresses are held in a custom table with their respective broadcast setting.

I use the abap to update the broadcast setting text subject - Reporting for OpCo <OPERATING COMPANY> and Depot <DEPOT> and the body text with the run date and more information.

If the email address has changed I update the RSRD_SETT_NODE_A record accordingly.

Then the chain executes the broadcast for the revised setting.

Simple.

)

Hope it helps.

[thomasnelissen]

Hi Neville,

Again a while ago but i'm facing a similiar problem right now.

We have a montly broadcast that sends an overview of travel costs to each manager.

Now we want to add a comparison with the total budget for the current year. This needs to be included in the body of the broadcasted e-mail.

Our broadcast uses a control query to determine the recipients.

Can I use this ABAP code to calculate the budget spend before sending the e-mail, for each recipients? How can I make sure the ABAP code is executed before each broadcasting step?

Any help or info is greatly appreciated.

Best regards,

Thomas Nelissen

[Former Member]

Hi,

Asper my knowledge , it is not possible since we have only some standard text variables are displayed in the broadcaster settings ( in text tab).

Perhaps you can attach a text variable (replacement path) at the end of query description in the query, so that the header line of the report will be having some description as well as company value.