topic Re: Sort /Group by in SmartForms in Application Development and Automation Discussions

Sort /Group by in SmartForms

Former Member — Fri, 22 Jun 2007 05:50:00 GMT

Hi ABAPers,

Im having a hard time using a smartforms...actually my problem is that i need to sort /group my data by hkont and Currency..which is supposed to be a General Ledger Account and Currency.

Here is a sample data in my internal table :

Burks Hkont Currency Ebeln Waers

MMC 1130001 USD 1400000673 1000

USD 1400000674 200

USD 1400000675 150

4110001 EUR 1400000676 100

EUR 1400000677 100

the output report must be like this:

GL ACCT : 10000123

COMPANY DOCUMENT # CURRENCY AMOUNT

MMC 1400000673 USD 1000

1400000674 USD 200

1400000675 USD 150

GL ACCT : 452644

COMPANY DOCUMENT # CURRENCY AMOUNT

4110001 EUR 1400000676 100

EUR 1400000677 100

Please give me some advice

Thanks in advance

aVaDuDz

Re: Sort /Group by in SmartForms

Former Member — Fri, 22 Jun 2007 05:52:12 GMT

Move your data into another internal table with structure as

Hkont

Currency

Bukrs

Ebeln

Waers

Sort on Hkont and Currency.

Use this new internal table for displaying your data.

Regards

Raj

Re: Sort /Group by in SmartForms

Former Member — Fri, 22 Jun 2007 05:54:14 GMT

Hi,

Tables option there is a sort option you pass the field then it will sort itab accordingly,otherwise before passing to tables in SF, sort it in global definitions or before that

Regards

Shiva

Re: Sort /Group by in SmartForms

Former Member — Fri, 22 Jun 2007 06:08:25 GMT

> Hi,

> Tables option there is a sort option you pass the

> field then it will sort itab accordingly,otherwise

> before passing to tables in SF, sort it in global

> definitions or before that

> Regards

> Shiva

Hi Shiva,

I tried the table option Sort Criteria...but every time a create a Fieldname like HKONT it prompts in an eror " You may only read from Table IT_OR-stadata.

Please help me what to do..

my internal table is :

IT_OR-Stadata into WA_OR

Thanks

aVaDuDz