smart forms.

[Former Member]

I have a requirement similar to the MS Word Merge feature. It's a letter we have to print out in which data from an ODS in BW has to be merged. What is the best approach to this? Can this be done using smartforms? I wanted to confirm it before taking the smart forms approach.

Example of what I am trying to do:

Dear Field1,

The old address of your payment location was Field2. The new address is Field3.

Thank you.

Basically, the three field names come from an ODS/Cube and they have to be merged to this letter. There should also be an option where the user can enter a parameter for which there is a corresponding field in ODS (say data parameter - 0CALMONTH). Please let me know what the best approach to this is. Thanks!

[reedtzj]

Hi Uday,

Yes, you can do this with Smartform if you would like that approach.

I think you need to follow a path something like this:

1. Create an ABAP "driver" program that invokes the desgned Smartform form. This can be a normal ABAP report if you like and can be "submitted" from any other report if this may be the case. Search for "smartforms abap" in SDN for example or have a look at ABAP programs SF_EXAMPLE_01/02/03/04.

2. Design your Smartform form as needed.

3. To handle the BW "integration" - There is an good instruction here by Durairaj Athavan Raja handling BW Query from ABAP source:<a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/43db5ee1-0701-0010-2d90-c3b991eb616c">Execute BW Query using ABAP</a>. Also have a look at this blog by Raja as well: <a href="/people/durairaj.athavanraja/blog/2005/12/05/execute-bw-query-using-abap-part-iii BW query using ABAP Part III</a>

4. Parameters can be asked for in the Smartform ABAP code if you like or earlier when in the ABAP driver program. In the latter case you must pass these parameters to the Smartform created function module of course. Here you can use some FM like POPUP* if you are starting this in SAPGUI.

There might be other options like Adobe Forms replacing Smartforms if you have access to a 2004s system but the above should still be some good guidelines.

I have done something similar with Smartform although not accessing BW/BI.

Regards, Johan