Skip to Content
0
Former Member
Jun 13, 2013 at 10:31 AM

Creation of internal table and collect in query infoset

228 Views

Hello Experts,

I am trying to create an infoset (SQ02) based on table FAGLFLEXT in order to allow users to compare different plan versions (the format is similar to REPORT PAINTER but with more than one Leading Column).

I created the Infoset starting with "Data retrivial by program" indicating FAGLFLEXT Table as Data Structure with integrated program.

In Data Reading Program Tab I created two internal tables:

1) T_FAGLFLEXT in oder to limit fields to process

2) TAB_TOT1 where to transpose values belonging to each plan version (FAGLFLEXT-RVERS '000', '001', '003') in dedicated columns and collect amounts using as collecting criteria:

a) Profit center (PRCTR)

b) Account (RACCT)

c) Cost Center (RCNTR)

d) Cost Element (COST_ELEM)

e) Sending Cost Center (SCNTR)

I have problems in generating Infoset and query dumps.

I attached the code I wrote in "Data Reading Program" Tab.

Thank you for your help.

Andrea

Attachments

INFOSET.TXT.zip (1.6 kB)