Urgent Plzz(Layout Formatting Issue)

[Former Member]

Hi All,

I have Fetched the material No ,HU no and the corresponding serial nos in 3 diff tables and passed it to the smartform. 1 material will have n no of HUs and 1 HU will have n no of serial Nos.Now the issue is how do i form it.Coz all the 3 fields cannot come in a single table. Or is there any method , wherin we can put a table itself inside a field of a created table in a smartform dynamically?

[Former Member · Accepted solution]

The easist way would be to combine the 3 tables into a single internal table.

What are the structures like?

Are they like this?

Table 1 = Material No.

Table 2 = Material No., HU No.

Table 3 = HU No., Serial No.

Are you gathering this data in the print program?

[Former Member · Accepted solution]

Hi Matt,

The structure is as follows

Table 1 Mat no, Mat desc

Table 2 Mat no, venum.

Table 3 venum,HuNo

Table 4 HuNo,Sr No

Field venum is used for linking.

Thanx

Vimal

[Former Member · Accepted solution]

Here's what I think you should do.

1) Consolidate the tables into a single internal table.

2) Then in the SF create a Table Node that loops throught the internal table

3) Use the Sorting Criteria in the Data tab to create events for the change of the Material Number, HU No., and Serial No.

4) Create variables to store the HU No. and Serial No.

5) Under the sort event for the Material No. use a Program Lines Node to save the HU No. Also create text nodes to print all 3 fields.

6) Under the sort event for the HU No. use a Program Lines node to save the Serial No. Also create text nodes to print HU No and Serial No. if the workarea HU no does not match the saved HU No from #5.

7) Under the sort event for Serial No. print the Serial No. if the workara Serial No. does not match the saved Serial No.

There's got to be an easier way, but....

[Former Member]

in the above sample serial nos shud be printed 1 below the other.

[Former Member]

Hi All,

This is sumwat the way i want my form to be.

-

---

Matnr1 | HU NO1 | ser no 1 |

ser no 2

__________|___________|____ser no n_______|

HU NO2

ser no 1

ser no 2

___________

____ser no n_______

HU NO n

ser no 1

ser no 2

__________|____ser no n_______|

Matnr2 | HU NO1 | ser no 1 |

ser no 2

___________

____ser no n_______

HU NO2

ser no 1

ser no 2

___________

____ser no n_______

HU NO n

ser no 1

ser no 2

__________|___________|____ser no n_______|

Matnr n | HU NO1 | ser no 1 |

ser no 2

___________

____ser no n_______

HU NO2

ser no 1

ser no 2

___________

____ser no n_______

HU NO n

ser no 1

ser no 2

__________|___________|____ser no n_______|

Thanks

Vimal Valsan.