topic Re: Creating smartforms by extracting data from many tables in Application Development and Automation Discussions

Creating smartforms by extracting data from many tables

former_member699003 — Wed, 26 Aug 2020 20:44:24 GMT

Hello friends.

I want those marked with"CAUFV ~ RSNUM = RESB ~ RSNUM" in the photo below to appear in smarform. For example; AUFNR: 800002 contains 1 RSPOS so its table should have 1 row. AUFNR: 800003 contains 3 RSPOS so the table should have 3 rows. There should be one page for each AUFNR. The RESB part on one page should not be on the other page.

But I could not divide the tables into pages according to the order number. What should I do? I hope I was able to explain my problem.

Re: Creating smartforms by extracting data from many tables

Abinathsiva — Thu, 27 Aug 2020 03:26:11 GMT

Hi,

Insert a command inside your Main table, compare order number at New insert Page break condition, this will solve the purpose.

Regards

Re: Creating smartforms by extracting data from many tables

former_member699003 — Thu, 27 Aug 2020 11:40:43 GMT

Are you talking about this part? I'm a newbie yet. For example, I sort by Rsnum. What exactly should I do? Thank you.

Re: Creating smartforms by extracting data from many tables

RaymondGiuseppi — Thu, 27 Aug 2020 11:54:24 GMT

Create a loop node on order, in data tab, define sort criteria with AUFNR, check the box at end of AUFNR. A new node should now appear, under this node add a command node which execute a new-page, add a text node for order. add another loop at same level on reservation...

(Check online documentation)

Re: Creating smartforms by extracting data from many tables

former_member699003 — Fri, 28 Aug 2020 07:59:56 GMT

Is there any tutorial video for how can i do this? I am newbie yet.

Thanks...

Re: Creating smartforms by extracting data from many tables

RaymondGiuseppi — Fri, 28 Aug 2020 08:04:20 GMT

You can easily find many tutorials on youtube, try keywords such as SmartForms, LOOP, TABLE and tutorial.

(You could perform same search using google for video)