cancel
Showing results for 
Search instead for 
Did you mean: 

smartform for multiple customer

Former Member
0 Kudos

Hi Experts,

i am doing a smartform. in that i am having 2 itab.

itab1 contains 10 customer information

itab 2 contains each customers account balance details.

now i want to display all customer and their details in the smart form with out pressing back pushbutton. for each customer and their details it should display a new page. please provide me some idea with sample.

rgds,

Ahila

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hai Ashok,

Just add the condition in your SMART FORM as below:

Declare One more itab(ITAB3) WITH fields fromitab1 and itab2(Final Fields that you want to print)

Then

LOOP AT ITAB1.

<b>if itab1-primarykey(part of primary key) eq itab2-same fields.</b>

MOVE CORRESPONG ITAB1 TO ITAB3.

MOVE CORRESPONG ITAB2 TO ITAB3.

endif.

ENDLOOP.

For having each in a separate page

Just add :

AT NEW PRIMARY KEY.

NEW-PAGE.

in the loop.

Reward points if it helps you.

Regds,

Rama chary.Pammi

Former Member
0 Kudos

Hi,

Instead of new-page i used a command line and check the go new page checkbox. now i am getting in new page but with one extra empty page. can avoid this. because i not yet transfer to itab3. if have solution reply me . once my problems solved i will award points immediatly.

thanks

Ahila

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ashok,

In smartforms instead of using TABLES use LOOP statement.

Loop itab1 into wa1->then loop itab2 into wa2.

Now create 2 templates under second LOOP i.e.(itab2 into wa2),one to display customer info & second to display customer account balance details.

Now adjust the height of these 2 templates according to the format of the page.

By doing this info & details of first customer will get displayed on first page & due to height of templates the data of second employee will automatically go to next page.

Reward all helpful answers.

regards,

rajesh.

Former Member
0 Kudos

Hi Rajesh,

now i can get different customer at one time . but all customer data's display continuesly. i want to make it new page for every customer. Please give me some idea.

thanks,

Ahila