Creating and filling Work area dynamically

[manali_gunjal]

Hi,

We need to fill data in work area dynamically.

for example: I am having following fields in one internal table

viz. product location keyfigure period and valueofperiod

example values:

column names: product location keyfigure period value

values: p1 l1 k1 p1 v1

p1 l1 k1 p2 v2

p1 l1 k1 p3 v3

but I need o/p table in below format

column names: product location keyfigure p1 p2

values: p1 l1 k1 v1 v2

So how I can achieve this?

Thanks & Regards,

Manali

[manali_gunjal]

Hi,

We need to fill data in work area dynamically.

for example: I am having following fields in one internal table

viz. product location keyfigure period and valueofperiod

example values:

column names: product location keyfigure period value

values: p1 l1 k1 p1 v1

p1 l1 k1 p2 v2

p1 l1 k1 p3 v3

but I need o/p table in below format

column names: product location keyfigure p1 p2

values: p1 l1 k1 v1 v2

So how I can achieve this?

Thanks & Regards,

Manali

[Former Member]

This is probably now a FAQ...search the forum....others have asked similar questions.

[manali_gunjal]

Hi,

May be others have asked similar type of question earlier but no one answered it yet.

Problem is field names are changing not just value so how to create wa dynamically

Thanks,

Manli

Edited by: Manali Gunjal on Jun 30, 2010 8:33 PM

[MarcinPciak]

This is kind of a pivot table where values from one table are to be transformed to a column of other table.

I described the process of creating such table here .

Also you can use RTTC to create the similar.

Regards

Marcin

[manali_gunjal]

Thanks Marcin it solved my Problem.

We used below example provided on another link provided by you

http://divulgesap.com/blog.php?p=MTI4

Edited by: Manali Gunjal on Jul 1, 2010 12:03 PM