topic Re: Smartform printing based on Dynamic Data in Application Development and Automation Discussions

Smartform printing based on Dynamic Data

Former Member — Sat, 23 Nov 2013 10:23:36 GMT

Dear All,

i am new to ABAP, now i have to create a smartform in which i have created a page

having a main window, in the main window i have created a template and a table,

my problem is that, i can show only three sets of data per page,

But as in a PR, there may be many sets of data (PO) ocuurs (lets say there are 8 sets of data),

so i wants to show all these 8 sets of data in my smartform.

One more thing is that, i have 2 internal table in which first table have unique materils and second table

have unique PO. So i have to print unique materials in row of my smartform and unique PO should be shown

as column in my smartforms.

So please see my issue, and sujjest me how can i code and call my smartform to show all PO's value.

Thanks in advance.

Re: Smartform printing based on Dynamic Data

venkateswaran_k — Sat, 23 Nov 2013 10:51:12 GMT

Hi Shweta

Can you please give some example, I am not able to understand the requirement.

Prefereably with screenshots

Regards,

Venkat

Re: Smartform printing based on Dynamic Data

thangam_perumal — Sat, 23 Nov 2013 10:52:48 GMT

Dear Shweta Chouhan,

Create the Table Inside the Loop in Smartforms.

consider internal Table name Itab_Mat and Work Area Wa_Mat which have details of Material.

Itab_Po and Work area wa_Po Which have details of Po.

keep mind there is common field should be available for both internal Table.

consider Material field Name is Matnr.

After Creating Loop and Table Please Refer My Below Screen Shots.

Please try in this method.. it may help u..

Regards,

Thangam

Re: Smartform printing based on Dynamic Data

venkat_aileni — Sat, 23 Nov 2013 11:05:36 GMT

Hi-

For question 1 to display only 3 line items per page you can make use of Page Break concept.

Steps to achieve the same:

Create a program line in your table with code like below:

lv_cnt = lv_cnt + 1.

Then create a command with condition lv_cnt = 3 and set Go to New Page option to next page.

Create a Program Line inside your command and clear variable lv_cnt.

For question 2:

Table1 -> Material.

Table2 -> PO

You would like to display Po's based on Materials.

Create a loop on table1 where you will be displaying Materials and you can make use of loop/table to display table2 with condition material = table1-material.

-Venkat

Re: Smartform printing based on Dynamic Data

Former Member — Sat, 23 Nov 2013 11:42:24 GMT

Dear Venkat,

i didn't wants to show 3 line items, but i have to show 3 PO's values in my smartforms in one page,and

remaining others should come in next pages in the multiple of 3.

Lets say i have 7 PO to be shown, my question is that, as i have shown first three PO's values, so

how could i show my remaining PO's values, that is to be printed when my first page values gets printed

and so on...and this process goes on untill i am able to print all PO's data.

Re: Smartform printing based on Dynamic Data

former_member187748 — Sat, 23 Nov 2013 12:04:15 GMT

Hi Shweta,

based on your requirement please check this,

lets say

it_final -> having all the data for your PO

it_final1-> having uniuqe PO

it_final2 -> having unique material

Now when you will pick unique material, in that internal table you may not have all the PO's values.

LOOP AT it_final2 INTO wa_final2.

READ TABLE it_final1 INDEX 1.

LOOP AT it_final INTO wa_final WHERE ebeln = it_final1-ebeln

matnr = wa_final2-matnr.

IF sy-subrc = 0

wa_final2-ebeln = wa_final-ebeln.

put all your data in wa_final as same as i have done for ebeln.

Modify it_final2 FROM wa_final2 TRANSPORTING ebeln............

ENDIF.

ENDLOOP.

Do it for all index upto your internal table and pass it to your smartform ,

Re: Smartform printing based on Dynamic Data

venkat_aileni — Sat, 23 Nov 2013 12:28:49 GMT

Hello Shweta-

The simpler way which I feel is to build a final internal table with details like below:

IT_FINAL:

Material PO1 PO2 PO3

ABC 123 234 345

ABC 456 567

In your driver program or in smartform initialization build above table based on your material and PO table details.

Then you can loop over this final internal table and you can fetch details from material and PO tables and display them accordingly.

-Venkat

Re: Smartform printing based on Dynamic Data

Former Member — Sat, 23 Nov 2013 12:44:29 GMT

Hi Venkat,

Let me clear more about it, say i have 7 PO and its related values as you can see below,

now if i have shown first 3 PO's values, say PO1, PO2, PO3, then i wants to know that when i wnats

to print another PO's like PO4, PO5 and PO6 values in smartform , should i have to use seperate variable for it, or i can use previous defined values, can you provide some code for the same,

it would be more advantage for me.

Material PO1 PO2 PO3 PO4 PO5 PO6 PO7

ABC 1 2 3 2 3 4 3 4 5 1 2 3 2 4 5 2 5 4 9 8 6

ABC 4 5 6 5 6 7 1 2 3 2 5 4

Re: Smartform printing based on Dynamic Data

venkat_aileni — Sun, 24 Nov 2013 06:38:15 GMT

Hi Shweta-

This is what I recommend: Rather than writing the logic in Smart Form -> Table/Template for determining which PO needs to be displayed like for PO1, PO2 and PO3.

What I would do is to create a new internal table with structure like below:

IT_FINAL:

Material PO1 PO2 PO3

ABC 123 234 345

ABC 456 567

Now I would write logic (to build my final internal table as shown above) either in driver program or in Smart From -> Global Definitions -> initialization.

After above step you will knowing for a Material which PO needs to be displayed and where to be displayed.

Now next step is how to fill these PO details in Table / Template.

In your Smart Form -> Table make use of program lines to fetch details from Material table and PO table.

READ TABLE it_po INTO wa_po WITH KEY ebeln = wa_final-po1.

IF sy-sybrc = 0.

"fill your text's in smartform

ENDIF.

In the same way you can fetch details for other PO's and you can display them in your text's.

Here is the code for building final internal table based on unique materials(it_matnr) and unique PO's(it_po).

TYPES: BEGIN OF t_matnr,

matnr TYPE mara-matnr,

END OF t_matnr,

BEGIN OF t_po,

matnr TYPE mara-matnr,

ebeln TYPE ekko-ebeln,

END OF t_po,

BEGIN OF t_final,

matnr TYPE mara-matnr,

po1 TYPE ekko-ebeln,

po2 TYPE ekko-ebeln,

po3 TYPE ekko-ebeln,

END OF t_final.

DATA: it_matnr TYPE STANDARD TABLE OF t_matnr,

wa_matnr TYPE t_matnr,

it_po TYPE STANDARD TABLE OF t_po,

wa_po TYPE t_po,

it_final TYPE STANDARD TABLE OF t_final,

wa_final TYPE t_final.

CLEAR: wa_matnr.

wa_matnr = 'ABC'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'DEF'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'GHI'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '123'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '234'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '345'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '456'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '567'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '678'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '789'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '890'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '901'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '012'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '001'.

APPEND wa_po TO it_po.

SORT : it_matnr BY matnr ASCENDING,

it_po BY matnr ASCENDING

ebeln ASCENDING.

LOOP AT it_matnr INTO wa_matnr.

* CLEAR: wa_final.

LOOP AT it_po INTO wa_po WHERE matnr = wa_matnr-matnr.

IF sy-tabix NE 1.

AT NEW matnr.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDAT.

ENDIF.

wa_final-matnr = wa_matnr-matnr.

IF wa_final-po1 IS INITIAL.

wa_final-po1 = wa_po-ebeln.

CONTINUE.

ENDIF.

IF wa_final-po2 IS INITIAL.

wa_final-po2 = wa_po-ebeln.

CONTINUE.

ENDIF.

IF wa_final-po3 IS INITIAL.

wa_final-po3 = wa_po-ebeln.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDIF.

ENDLOOP.

APPEND wa_final TO it_final.

ENDLOOP.

DELETE ADJACENT DUPLICATES FROM it_final COMPARING ALL FIELDS.

IF it_final IS NOT INITIAL.

LOOP AT it_final INTO wa_final.

WRITE: / wa_final-matnr, wa_final-po1, wa_final-po2, wa_final-po3.

ENDLOOP.

ENDIF.

Output:

I'm sorry for writing such a long story...:)

-Venkat

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 05:25:32 GMT

Dear Sanjeev,

i have segregate my data as you told, and as you can see i am showing mine 3 PO's values

in first page, now the matter is that, when i will fill once me page with these 3 PO's values,

then to show the remaining PO's value how could i fetch my internal table and i can show

remaining data.

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 05:36:46 GMT

Dear Venkat,

thanks a lot for your support, let me clear one more thing before proceeding your ways,

First thing is that i have to show many data related to every PO.

As you have shown the output, i don't have such requirement, as you are showing,

ABC then again ABC, its not so, actually i have only one ABC in material (unique material)

and then its corresponding PO's, but as i told you that let i have shown correctly 3 PO's values

now using the same table in my smartform , i just wants to know how could i show another

PO's values. This is your output...........

But my output should be as shown below (say for first page)

ABC 123 234 345

DEF 678 789 890

GHI 167 774 321

and in second page

ABC 456 567

DEF 901

GHI

so please consider these output and then tell me the changes, i will appreciate your

sujjestion.....and thanks a lot again for helping me.

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 06:07:31 GMT

Dear Venkateswaran,

please see these table , these are the final output for my smartforms.Lets say in my first page

i am showing first 3 PO,s value

Material Des.	PO 1	PO2	PO3
Material 1	PO1's values	PO2's values	PO3's values
Material 2	PO1's values	PO2's values	PO3's values
Material 3	PO1's values	PO2's values	PO3's values
Material 4	PO1's values	PO2's values	PO3's values

and for remaining PO's values, which i wants to show should appear after this as in next page.

Material Des.	PO4	PO5	PO6
Material 1	PO4 values	PO5's values	PO6's values
Material 2	PO4's values	PO5's values	PO6's values
Material 3	PO4's values	PO5's values	PO6's values
Material 4

for which i have created two internal table, one having materials (unique values), and other having unique PO

values, and one having all the values related to all PO's (obvious, because the table having unique material

should not have all PO's values and vice versa). Now as i can show only 3 PO's at once, please tell me how could i fetch

the data and put in the same table in my smartform(which has been used to show first 3 PO's values).

Please do the needful.

Re: Smartform printing based on Dynamic Data

venkat_aileni — Mon, 25 Nov 2013 06:28:15 GMT

Hi Shweta-

Good requirement!!

Use below sample code for table alignment:

TYPES: BEGIN OF t_matnr,

matnr TYPE mara-matnr,

END OF t_matnr,

BEGIN OF t_po,

matnr TYPE mara-matnr,

ebeln TYPE ekko-ebeln,

END OF t_po,

BEGIN OF t_final,

matnr TYPE mara-matnr,

po1 TYPE ekko-ebeln,

po2 TYPE ekko-ebeln,

po3 TYPE ekko-ebeln,

END OF t_final.

DATA: it_matnr TYPE STANDARD TABLE OF t_matnr,

wa_matnr TYPE t_matnr,

it_po TYPE STANDARD TABLE OF t_po,

wa_po TYPE t_po,

it_final TYPE STANDARD TABLE OF t_final,

wa_final TYPE t_final,

it_final_temp TYPE STANDARD TABLE OF t_final,

wa_final_temp TYPE t_final.

DATA: lv_mat_cnt TYPE i,

lv_do TYPE p DECIMALS 2,

lv_line_cnt TYPE i,

lv_tabix TYPE sy-tabix.

CLEAR: wa_matnr.

wa_matnr = 'ABC'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'DEF'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'GHI'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '123'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '234'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '345'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '456'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '567'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '678'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '789'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '890'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '901'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '012'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '001'.

APPEND wa_po TO it_po.

SORT : it_matnr BY matnr ASCENDING,

it_po BY matnr ASCENDING

ebeln ASCENDING.

LOOP AT it_matnr INTO wa_matnr.

* CLEAR: wa_final.

LOOP AT it_po INTO wa_po WHERE matnr = wa_matnr-matnr.

IF sy-tabix NE 1.

AT NEW matnr.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDAT.

ENDIF.

wa_final-matnr = wa_matnr-matnr.

IF wa_final-po1 IS INITIAL.

wa_final-po1 = wa_po-ebeln.

CONTINUE.

ENDIF.

IF wa_final-po2 IS INITIAL.

wa_final-po2 = wa_po-ebeln.

CONTINUE.

ENDIF.

IF wa_final-po3 IS INITIAL.

wa_final-po3 = wa_po-ebeln.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDIF.

ENDLOOP.

APPEND wa_final TO it_final.

ENDLOOP.

DELETE ADJACENT DUPLICATES FROM it_final COMPARING ALL FIELDS.

SORT it_final BY matnr ASCENDING

po1 ASCENDING

po2 ASCENDING

po3 ASCENDING.

lv_mat_cnt = lines( it_matnr ).

lv_line_cnt = lines( it_final ).

lv_do = lv_line_cnt / lv_mat_cnt.

lv_do = ceil( lv_do ).

DO lv_do TIMES.

LOOP AT it_matnr INTO wa_matnr.

LOOP AT it_final INTO wa_final WHERE matnr = wa_matnr-matnr.

CLEAR: wa_final_temp.

wa_final_temp = wa_final.

AT NEW matnr.

APPEND wa_final_temp TO it_final_temp.

lv_tabix = sy-tabix.

ENDAT.

ENDLOOP.

IF lv_tabix IS NOT INITIAL.

DELETE it_final INDEX lv_tabix.

CLEAR lv_tabix.

ENDIF.

ENDLOOP.

ENDDO.

IF it_final_temp IS NOT INITIAL.

LOOP AT it_final_temp INTO wa_final.

WRITE: / wa_final-matnr, wa_final-po1, wa_final-po2, wa_final-po3.

ENDLOOP.

ENDIF.

Output:

-Venkat

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 06:32:09 GMT

Hi,
you can create two pages, and create one table each in main window. in first page, fetch value from your itable and pring what are the fields you want, and do the same for second page also.

and regarding how to fetch values, i would like to know how did you define your ineternal table and what are the fields in each table and what are the fields you needed to print,

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 09:07:55 GMT

Dear Venkat,

thanks a lot for your sujjestions, i am not getting your points clearly so i am giving you this data.

Lets i have three internal tables

it_matnr -> having unique material no. (it may have any no of materials) ,

it_po -> having unique PO's values(any no of PO)

it_all -> having data for all PO, and for its line items(means having all PO's and all material values,)

Now, as i don't know how many line items will be there for materials, so i can't do like this

as you have sujjested

CLEAR: wa_matnr.

wa_matnr = 'ABC'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'DEF'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'GHI'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '123'.

APPEND wa_po TO it_po.

So i think , i have to write my code as shown below,

LOOP AT it_matnr INTO wa_matnr.

   READ TABLE IT_PO INDEX 1.
   LOOP AT IT_ALL INTO WA_ALL WHERE EBELN = IT_PO-EBELN
                                       AND MATNR = WA_MATNR-MATNR.

IF SY-SUBRC = 0.

*********************

i have to put my data in new internal table from it_all.

so that by itterating , i will get all material values for each ebeln accordingly.

*************************

ENDIF.

ENDLOOP.

and doing the same way for INDEX 2 and INDEX 3 for PO's table i have segregate it for 3 PO's values,

which i am able to show correctly, but after that, i am not getting what to do next.

In the same way , i can get all my data, but the question is how can i show these data after 3 PO's value

in my smartforms.

So please tell me is this a right way to achieve the target, because what you are sujjesting , i am not getting

it upto the mark.

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 09:27:35 GMT

Hi Sebin,

if i will create another page, then what type of window it will have, if i will use secondary window

then i can't take it for next page, i can't use secondary window because it may not having such

flexibility as we finds in main window, i can't use copies window too, because my second page

having different data from my first page.

One more thing is that, if i will use second page then my smartform will always print for two pages

irrespective of data it has, means if i have only one PO's value to be print then still, it will print two pages, with my one PO's values..........

I have already used this concept, but not succeeded, due to the problem i stated to you.

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 09:44:23 GMT

hi,

you can create two pages, and do not use seconday windows as it will not expand according to the data you are displaying.

you can have one main window in each pages(not in the same pages), but make sure the size of all the main windows are same, else it will generate error,

reagarding printing, yes you are right. you would always get two pages and i guess thats what you exactly asked for, one unique material and some 'po's in one page and the same material with deifferent po in another page,

(for this you may check if a material has got more than 3 'PO's if yes, do pass data to the second main window. and give your conditions at the tab 'conditions')

according to

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 10:03:52 GMT

Hi Sebin,

you are right i have to show some material and some PO in first page and with same material and remaining PO's in next page, but i have again two questions here.

1. It is possible to have more than one main window in one smartform ?.

2. If i will make second page then how could i call my second page, because i can't call

second page having main window as usual.

(so have you used before the main window second time in a smartform ? )

Re: Smartform printing based on Dynamic Data

venkat_aileni — Mon, 25 Nov 2013 10:05:56 GMT

Hello Shweta-

Please try to understand the logic first then it will be easy for you to design your Smart Form later.

CLEAR: wa_matnr.

wa_matnr = 'ABC'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'DEF'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'GHI'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '123'.

APPEND wa_po TO it_po.

I have added above code just to populate data you don't need to do this.

-> We need only it_matnr and it_all data to design final internal table.

-> In our new logic I have changed it_final field length of po1, po2, po3 from 10 to 15.(so that you will be storing both po and line item together and while displaying data in your smart form you can differentiate for po which line item needs to be displayed hope this is clear).

Sample Code:

TYPES: BEGIN OF t_matnr,

matnr TYPE mara-matnr,

END OF t_matnr,

BEGIN OF t_po,

matnr TYPE mara-matnr,

ebeln TYPE ekpo-ebeln,

ebelp TYPE ekpo-ebelp,

END OF t_po,

BEGIN OF t_final,

matnr TYPE mara-matnr,

po1 TYPE char15,

po2 TYPE char15,

po3 TYPE char15,

END OF t_final.

DATA: it_matnr TYPE STANDARD TABLE OF t_matnr,

wa_matnr TYPE t_matnr,

it_po TYPE STANDARD TABLE OF t_po,

wa_po TYPE t_po,

it_final TYPE STANDARD TABLE OF t_final,

wa_final TYPE t_final,

it_final_temp TYPE STANDARD TABLE OF t_final,

wa_final_temp TYPE t_final.

DATA: lv_mat_cnt TYPE i,

lv_do TYPE p DECIMALS 2,

lv_line_cnt TYPE i,

lv_tabix TYPE sy-tabix.

CLEAR: wa_matnr.

wa_matnr = 'ABC'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'DEF'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_matnr.

wa_matnr = 'GHI'.

APPEND wa_matnr TO it_matnr.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '123'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '234'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '345'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '456'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'ABC'.

wa_po-ebeln = '567'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '678'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '789'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '890'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'DEF'.

wa_po-ebeln = '901'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '012'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

CLEAR: wa_po.

wa_po-matnr = 'GHI'.

wa_po-ebeln = '001'.

wa_po-ebelp = '00001'.

APPEND wa_po TO it_po.

SORT : it_matnr BY matnr ASCENDING,

it_po BY matnr ASCENDING

ebeln ASCENDING.

LOOP AT it_matnr INTO wa_matnr.

* CLEAR: wa_final.

LOOP AT it_po INTO wa_po WHERE matnr = wa_matnr-matnr.

IF sy-tabix NE 1.

AT NEW matnr.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDAT.

ENDIF.

wa_final-matnr = wa_matnr-matnr.

IF wa_final-po1 IS INITIAL.

CONCATENATE wa_po-ebeln wa_po-ebelp INTO wa_final-po1.

CONTINUE.

ENDIF.

IF wa_final-po2 IS INITIAL.

CONCATENATE wa_po-ebeln wa_po-ebelp INTO wa_final-po2.

CONTINUE.

ENDIF.

IF wa_final-po3 IS INITIAL.

CONCATENATE wa_po-ebeln wa_po-ebelp INTO wa_final-po3.

APPEND wa_final TO it_final.

CLEAR wa_final.

ENDIF.

ENDLOOP.

APPEND wa_final TO it_final.

ENDLOOP.

DELETE ADJACENT DUPLICATES FROM it_final COMPARING ALL FIELDS.

SORT it_final BY matnr ASCENDING

po1 ASCENDING

po2 ASCENDING

po3 ASCENDING.

lv_mat_cnt = lines( it_matnr ).

lv_line_cnt = lines( it_final ).

lv_do = lv_line_cnt / lv_mat_cnt.

lv_do = ceil( lv_do ).

DO lv_do TIMES.

LOOP AT it_matnr INTO wa_matnr.

LOOP AT it_final INTO wa_final WHERE matnr = wa_matnr-matnr.

CLEAR: wa_final_temp.

wa_final_temp = wa_final.

AT NEW matnr.

APPEND wa_final_temp TO it_final_temp.

lv_tabix = sy-tabix.

ENDAT.

ENDLOOP.

IF lv_tabix IS NOT INITIAL.

DELETE it_final INDEX lv_tabix.

CLEAR lv_tabix.

ENDIF.

ENDLOOP.

ENDDO.

IF it_final_temp IS NOT INITIAL.

LOOP AT it_final_temp INTO wa_final.

WRITE: / wa_final-matnr, wa_final-po1, wa_final-po2, wa_final-po3.

ENDLOOP.

ENDIF.

Output:

So now your po1 field will be PO Number + PO line Item.

In your smart form retrieve data based on PO and its corresponding line item.

Use above logic this will definitely work.

-Venkat

Re: Smartform printing based on Dynamic Data

Former Member — Mon, 25 Nov 2013 10:11:58 GMT

Hi Venkat,

can i have two Main window in single smartforms having in a different pages ?

If yes then how can i call my second page only if it is having any values to be displayed

otherwise my second page should not be called.

Have you done it ever ?

If yes please sujjest me how can i do that.

Means if i will show 3 PO in first page and next in second page having again a main window

so can i restrict my second page for not getting displayed if it has no data for second page.

Please tell me about this scenario also.

I am using EHP5 , and i have heard that i can use more than two window in latest version.