problem in alv

[Former Member]

Hello Abap ers,

required output:

projid   proj def     wbs ele     wbs descri        day01   day02   day03   day04.........................day31

abc      ffff              p-109       building

total quantity                                                        5        10    .........

total weight                                                         550      450............

total volume                                                         340     380...........

abc      fff               p-110       office                

total quantity                                                        4        6    .........

total weight                                                         530      420............

total volume                                                         340     300...........

i have created a internal table where projid ,proj def,, wbs ele, and wbs description is present. in another internal table i have collected material and its quantity

volume, weight corresponding to wbs element.... in this table delivery date is also present.  now my requirement is to sum quantity, gross wt, gross volume with respect to delivery date. i have also done this. this internal table value:::

date             totquan   tot wt    tot vol

01.01.2013      5         550        340      -> internal table

02.01.2013     10        450         380

projid        projdef        wbs ele       wbs des

abc            fff               p-109          building   -> internal table

how can i achive the required output in alv.........plz help.....its very urgent.

Thanks

Sabyasachi

[Former Member]

Hello Abap ers,

required output:

projid   proj def     wbs ele     wbs descri        day01   day02   day03   day04.........................day31

abc      ffff              p-109       building

total quantity                                                        5        10    .........

total weight                                                         550      450............

total volume                                                         340     380...........

abc      fff               p-110       office                

total quantity                                                        4        6    .........

total weight                                                         530      420............

total volume                                                         340     300...........

i have created a internal table where projid ,proj def,, wbs ele, and wbs description is present. in another internal table i have collected material and its quantity

volume, weight corresponding to wbs element.... in this table delivery date is also present.  now my requirement is to sum quantity, gross wt, gross volume with respect to delivery date. i have also done this. this internal table value:::

date             totquan   tot wt    tot vol

01.01.2013      5         550        340      -> internal table

02.01.2013     10        450         380

projid        projdef        wbs ele       wbs des

abc            fff               p-109          building   -> internal table

how can i achive the required output in alv.........plz help.....its very urgent.

Thanks

Sabyasachi

[viswamurthy_devagudi]

Hi Sabyasachi,

It's not possible to merge two structures in to one field cat log rather you can try like below.

1) Display header details using reuse_alv_commentary_write.

2) Display item details using reuse_alv_grid.

Put the above logic in loop it looks like as below.

[Former Member]

HI,

      how can i create this field line by line

total quan

total weight

total vol

Thanks

Sabyasachi

[viswamurthy_devagudi]

You can achieve this by dynamic coding, if you want to implement in the above format i can help you out..

[Former Member]

REQ NEED ED LIKE THAT::

PROJID   PROJDESC   WBSELM     WBSELDESC   DAY01     DAY31

1234                xyz                 123-XYZ        YYYT     

TOTALQNTY                                                                                    10              21

TOTVOLUM                                                                                       20            90

TOT WIGHT                                                                                      60           100

45667            DFER        45667-DFER     NHY

TOT QNTY                                                                                              19        00

TOTVOLUM                                                                                           12        10

TOT WIGH                                                                                              11        18

Hello this is my org req................

plzzzz help.............

[former_member491621]

Hi Sabyasachi,

The best way to have an output like this is to use classic report(using write and manual formatting).

If you insist on using ALV GRID, then the field PROJID must be of type char.

Append the value like "1234                xyz                 123-XYZ        YYYT     " to the internal table from your second table.

Now, pass the hardcoded values for totquan, tot wt, tot vol to field PROJID and pass the datewise calculations to the respective fields.

Hope this helps

[Former Member]

As per my understanding, you can use the fm REUSE_ALV_HIERSEQ_LIST_DISPLAY. In this you can display 3 items.

Please correct me if I am wrong.

Regards

Purnand Dhingra

[Former Member]

pl try REUSE_ALV_FIELDCATALOG_MERGE fm also.

Hope it helps

[Former Member]

HI ANIKET,

exactly you are right...i think lot......but already i use hard coded value TOT qty, tot wt, tot val.....

Thanks for your reply.....

Sabyasachi

[former_member491621]

Also, you can use REUSE_ALV_HIERSEQ_LIST_DISPLAY as suggested by Purnand(if it suits your requirement).

You can check program BCALV_TEST_FULLSCREEN_EXCEPT for your reference.(Check the output once)

[former_member491621]

Hi Sabyasachi,

Please close the thread if you have got the resolution

[Former Member]

Hi Aniket, purnand thanks to all.......i have completed report in my logic...and its run successfully.....

Thanks

Sabyasachi

[former_member491621]

Hi Sabyasachi,

Please close the thread and mark it as answered

[Former Member]

Yes i can solve it and req was grid display not others............

[former_member491621]

Yeah sure

But i don;t think your original post says anything about GRID

Chillax Bro!!

[Former Member]

sorry extremely..........but i like your answer......hope you watch..........

[former_member491621]

Lol

I am not begging for points....just asked you to mark the thread as answered.

[Former Member]

okk....then how can i close my thread?????

i already click on assumed answer......hope it close.........