dynamic field catalog

Former Member — Mon, 09 Aug 2010 04:54:04 GMT

Hi all,

i have a strange problem,

in table WITH_ITEM the field ITT and wt_qbshh , we have different kinds of tax codes and tax amounts.

i was displaying these as two columns in my report.

but my client ask me to display the wt_qbshh field in different columns based on the witht value.

i mean lets say for example there are 2 types of tax codes 1 and 2 in witht.

and let my report will display lik this

tax amnt tax code

100.00 ; 1

150.00 ; 2

130.00 ; 1

120.00 ; 2

the client wants the report like this

tax amnt-type1 tax amnt-type 2

100.00

150.00

130.00 ;

120.00

is there any method for this kind of situation ?

currently i defined all kinds of tax types as fields in my internal tables also in fieldcatalog

and doing thie following

loop at tbl into temp.

case 'witht'.

when '1'.

temp-tax1 = temp-tax.

when '2'.

temp-tax2 = temp-tax.

endcase.

modify tbl from temp.

endloop.

i am asking for better way than this if exists

thanks in advance.

Re: dynamic field catalog

Former Member — Tue, 10 Aug 2010 05:52:28 GMT

Hey check out this link

May be you can modify your code lil bit.