Problem solve Get help with specific problems with your technologies, process and projects.

Can a Smart Form print data relevant to one employee?

How can one order the Smart Form to print only that data that is relevant to an individual employee? Expert Mark Smithson offers advice.

I am having a problem creating a Smart Form. I pass an internal table with a few employee numbers, but I do not know how to loop at this internal table from the Smart Form. FYI, this internal table has a few lines for the same employee number.

The question is: How do I make a command in the Smart Form to instruct the form to print the details only related to the employee?
Example: The internal table has this entry:

EMPLOYEE PLAN AMOUNT 000900 B001 56.00 000900 B002 100.00 000901 B001 10.00

I would like the Smart Form to print details of employee 00090, followed by employee 000901, without having to loop at the first employee details. I'm stuck and need your help on this. Any ideas are very much appreciated.

There are a number of ways to do what you desire. Using your example, the answer may depend on whether you are interested in showing a separate set of details from both records related to the same employee '900' (all plan-specific info, such as each corresponding amount).

Let's assume that's your objective here. If so, one option is to add some logic to your Initialization section to build a new global index table -- that is, a basic single-column table -- with a unique record for each employee.

Then create a loop in your main window using that new table. Within that loop set up another sub-loop using the original table with the where clause picking up the unique record(s) tied to each employee and showing the relevant sub-detail, as the sub-loop processes all plans tied to that employee. In the outer loop you could show any general info for that employee, and perform other formatting, such as page breaks to show each employee's info on a separate page.

Dig Deeper on SAPscript and Smart Forms

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.