topic Re: Mailtext (SAPscript) enrichment with program variables in Application Development and Automation Discussions

Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Mon, 28 Sep 2015 06:15:17 GMT

Hi,

I have a SAPscript text, which contains an email text, I have to send via bcs-classes. Email sending is working fine, but now I am supposed to translate some program variables within the SAPscript text.

I think "program symbols" and the FM text_symbol_replace are the right way, but which attributes such a program variable has to have to be determined?

I have to say, that my mail is sent by a method, not by a report (so, no "global" fields are available).

Re: Mailtext (SAPscript) enrichment with program variables

Juwin — Mon, 28 Sep 2015 18:13:19 GMT

The same concept is used in POPUP_TO_CONFIRM, where the function replaces variables from a text object, using the values passed by the calling program.

Thanks,

Juwin

Re: Mailtext (SAPscript) enrichment with program variables

Jelena_Perfiljeva — Tue, 29 Sep 2015 02:23:08 GMT

I used READ_TEXT followed by TEXT_CONTROL_REPLACE in one of the programs, but it was a report, so no such issues. Have a look at the FM documentation. There is parameter PROGRAM that might be helpful (although I didn't quite get the documentation text, seems like a bad translation).

Also take a look at 'where used' -> Classes for this FM.

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Tue, 29 Sep 2015 08:22:19 GMT

Unfortunately not. I call TEXT_SYMBOL_REPLACE with parameter PROGRAM = 'ZCL.....CP', it searches in global variables (which does not exist in a class) and for that reason, my text symbol is deleted. I do have tried:

* using a local variable of the same name in my method

* using a class-data public variable of the same name in my global class

What can I do, now?

Re: Mailtext (SAPscript) enrichment with program variables

RaymondGiuseppi — Tue, 29 Sep 2015 08:34:33 GMT

You could use in sequence

DOCU_GET (message long text) or READ_TEXT (sapscript text)
SET_TEXTSYMBOL
REPLACE_TEXTSYMBOL
CONVERT_ITF_TO_HTML.

and send the final html in mail body

Regards,

Raymond

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Tue, 29 Sep 2015 08:39:10 GMT

This is the same Calling Chain, TEXT_SYMBOL_REPLACE uses.... What could I win by calling them manually?

Re: Mailtext (SAPscript) enrichment with program variables

RaymondGiuseppi — Tue, 29 Sep 2015 08:47:16 GMT

You can "manually" get yourself the fields required and pass them to sapscript using SET_TEXTSYMBOL.

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Tue, 29 Sep 2015 09:01:52 GMT

As you can see, the following code row shows, that TEXT_SYMBOL_REPLACE can not used in any type of classes - because a dirty assign will never run into a class:

If THIS is the way, SAP wants to power OO coding, it will fail. According to the coding, it detects ONLY "tables" (which are forbidden in classes) and "global variables" (which are also forbidden in classes). This results into the fact, that this FB will NEVER run properly, if it's called from a method.

So, I have to write a procedural function module, just for transporting my variables to this TEXT_SYMBOL_REPLACE.

I won't write here, what I shouted through the room, when I saw this, SCN would ban me.

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Tue, 29 Sep 2015 09:28:22 GMT

No, POPUP_TO_CONFIRM uses a very different concept.

Re: Mailtext (SAPscript) enrichment with program variables

Private_Member_7726 — Tue, 29 Sep 2015 16:20:44 GMT

Hi,

Provided you can pass the text lines on to mail processing dynamically, and the subsequent text processing is "SapScript conform", the easiest to quickly put something together (while staying in OO) would probably be to use the trick CL_SAPSCRIPT_LONGTEXT->ADD_PLACEHOLDER_VALUES is using. Namely, prepend the text with the lines containing SapScript symbol and formatted value pair definitions.

One could verify if the subsequent processing is "SapScript conform" by adding some symbol definitions to the text manually; something like this:

The symbol table can be collected using FM TEXT_SYMBOL_COLLECT, and it's entirely up to you where the values are gonna come from. There are limitations on the length of formatted values: 60 characters, or 80 - when the value contains another symbol.

cheers

Janis

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Tue, 29 Sep 2015 16:37:59 GMT

I'll try this tomorrow. Thanks for your Posting.

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Wed, 30 Sep 2015 16:06:33 GMT

The problem is, that this method adds the DEFINEs into the text, but I don't believe, that the CL_BCS-classes will replace the symbols by the values (which you called "SAPscript conformity"

Re: Mailtext (SAPscript) enrichment with program variables

Private_Member_7726 — Thu, 01 Oct 2015 08:02:17 GMT

The symbol replacement kind of "works" for both the attachment (I_ATTACHMENT_TYPE = 'SCR'; see TSOTD entry) and the body (I_TYPE = 'SCR'):

but:

- the result is IMO unusable, because there is no way to supply the style definition to BCS (formatting lost in SAPConnect) or the layout information;

- our SAPConnect settings would turn SapScript body into pdf anyway,

- SOST display is not correct (line breaks around variable):

However, the text so prepared can be converted using FM 'CONVERT_ITF_TO_HTML' (I_REPLACE = 'X', I_PRINT_COMMANDS = space), and would display properly in SOST (would preserve at least basic formatting):

What I have problem with is that the html (apart from the opening <html> tag) would apparently get taken out both from the body and the attachment somewhere during sending... (I believe this is SAPConnect setup problem at our place). There are discussions on SCN about this, but, as with so many topics on SCN, I wasn't able to find a solution thus far...

"Fazit": SapScript symbol replacement would work properly on a text so prepared. How useful SapScript text would be in mail or other processing, considering the meager "API" for these texts that can be found in SAP (I would not use word "offered" here...), is... *ahem* open for debate.

Frankly, I'd be messing with SapScript text only if it's processed via PWB Application Form (or at least "naked" Smartform)...

cheers

Jānis

Re: Mailtext (SAPscript) enrichment with program variables

Jelena_Perfiljeva — Thu, 01 Oct 2015 16:56:34 GMT

Ralf, I'm not sure how complex your standard text is, but maybe a simple solution would be to just read the text and do some kind of DIY symbol replacement? If it's just a few variables then simple string search/replace would do.

Or consider using something else entirely (again - depends on how complex the text is).

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Mon, 05 Oct 2015 14:33:28 GMT

It seems to work - with a litte problem:

CONVERT_ITF_TO_HTML creates a HTML text with surplus paragraph-tags:

How can I avoid this? There is no reason to create a special paragraph for '12345'....

Re: Mailtext (SAPscript) enrichment with program variables

Former Member — Mon, 05 Oct 2015 14:59:26 GMT

Hi Ralf,

i have done some replacements using CONVERT_ITF_TO_HTML.

your HTLM can just have simple formatings. as far as i know floating-text should work, never tried more than just simple symbol replacements. i dont think something like "DEFINE" or "IF" gets translatet correctly. in this case its no sap-script, its just a simple SO10-Text that can be used for your email-Body. if you need something more complex you will have to "build" your own HTML-Code.

Maybe you can call "TEXT_SYMBOL_REPLACE" befor CONVERT_ITF_TO_HTML. looking to the interface of TEXT_SYMBOL_REPLACE looks like it would also translate SAP-SCRIPT-Statements.

Regards

Stefan Seeburger

Re: Mailtext (SAPscript) enrichment with program variables

ralf_wenzel_heuristika — Mon, 05 Oct 2015 15:04:17 GMT

As I wrote: TEXT_SYMBOL_REPLACE does not work properly in methods, because it makes a dirty assign into the main program (which does not exist for a method).

See my posting above ( Sep 29, 2015 11:02 AM )

Re: Mailtext (SAPscript) enrichment with program variables

Private_Member_7726 — Tue, 06 Oct 2015 05:54:15 GMT

Hi,

No idea where the extra paragraph comes from. The TEXT_SYMBOL_REPLACE would work on a text with DEFINEs - that's what the CONVERT_ITF_TO_HTML calls internally (among other stuff; see Form REPLACE_ITF_TEXT in LSTXNF05).

cheers

Jānis

Re: Mailtext (SAPscript) enrichment with program variables

rosenberg_eitan — Tue, 06 Oct 2015 07:57:12 GMT

Hi,

Thinking aloud....

If you call a function from your method...

In the function group at the top you put your variable data.

And my test: (very crud)

Function group top include


FUNCTION y_r_eitan_tests_06.
 *"----------------------------------------------------------------------
 *"*"Local Interface:
 *"----------------------------------------------------------------------
 
   DATA: st_thead TYPE thead .
 
   DATA: it_lines TYPE tline_tab .
 
   st_thead-tdobject = 'TEXT' .
   st_thead-tdname   = 'Y_R_EITAN_01' .
   st_thead-tdid     = 'ST' .
   st_thead-tdspras  = 'E'  .
 
   CALL FUNCTION 'READ_TEXT'
     EXPORTING
       id                      = st_thead-tdid
       language                = st_thead-tdspras
       name                    = st_thead-tdname
       object                  = st_thead-tdobject
     IMPORTING
       header                  = st_thead
     TABLES
       lines                   = it_lines
     EXCEPTIONS
       id                      = 1
       language                = 2
       name                    = 3
       not_found               = 4
       object                  = 5
       reference_check         = 6
       wrong_access_to_archive = 7
       OTHERS                  = 8.
 
   IF sy-subrc NE 0 .
     MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
             WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4 .
   ENDIF.
 
   st_makt-matnr = '1234567890' .
   st_makt-maktx = 'I am a description !!!' .
 
 * Not used !!!!!!!!!!
 *  CALL FUNCTION 'TEXT_SYMBOL_REPLACE'
 *    EXPORTING
 *      header                 = st_thead
 *     INIT                   = ' '
 *      option_dialog          = abap_true
 *      program                = sy-repid
 *     REPLACE_PROGRAM        = 'X'
 *     REPLACE_STANDARD       = 'X'
 *     REPLACE_SYSTEM         = 'X'
 *     REPLACE_TEXT           = 'X'
 *     STARTLINE              = 1
 *     ENDLINE                = 99999
 *   IMPORTING
 *     CHANGED                =
 *     NEWHEADER              =
 *    TABLES
 *      lines                  = it_lines .
 
   DATA: st_options TYPE itcpo.
 
   st_options-tdprogram = sy-repid .
 
   CALL FUNCTION 'PRINT_TEXT'
     EXPORTING
       OPTIONS                  = st_options
       dialog                   = abap_true
       header                   = st_thead
     TABLES
       lines                    = it_lines
     EXCEPTIONS
       canceled                 = 1
       device                   = 2
       form                     = 3
       OPTIONS                  = 4
       unclosed                 = 5
       unknown                  = 6
       format                   = 7
       textformat               = 8
       communication            = 9
       bad_pageformat_for_print = 10
       OTHERS                   = 11.
 
   IF sy-subrc NE 0.
     MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
             WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
   ENDIF.
 
 
 
 
 ENDFUNCTION.

Note that the use of PRINT_TEXT .

You can suspend the dialog and get your OTFDATA from there.

Regards.

Re: Mailtext (SAPscript) enrichment with program variables

Former Member — Tue, 06 Oct 2015 10:44:01 GMT

Hi,

there is always a main programm... maybe support it to your method via interface-parameter, or do an external assign.

regards

Stefan Seeburger