ALV Report

[Former Member]

Hi all,

     I am developing a alv report which has 3 steps i.e for example, I have a PO no. DX001 which has 3 items in it say, AM01,AS01 and AU01.

All these 3 items further has their BOM items.

The report looks lik,

PO No. : DX001

Item No. : AM01

Bom Items : A

                   B

                   C

Item No.:AS01

BOM Items: D

                   S

                   E

Item No.:AU01

BOM Items : F

                   P

                   H

How do I achieve this. Can anyone gimme some idea pls..

Thanks in advance.

[Former Member]

Hi all,

     I am developing a alv report which has 3 steps i.e for example, I have a PO no. DX001 which has 3 items in it say, AM01,AS01 and AU01.

All these 3 items further has their BOM items.

The report looks lik,

PO No. : DX001

Item No. : AM01

Bom Items : A

                   B

                   C

Item No.:AS01

BOM Items: D

                   S

                   E

Item No.:AU01

BOM Items : F

                   P

                   H

How do I achieve this. Can anyone gimme some idea pls..

Thanks in advance.

[Former Member]

Hii divya

First declare your final o/p table which containing all the fields you want

then declare separate internal tables for po data which is ekpo..

which contains field ebeln matnr

then use table mast for BOM item of each line item for all entries in ekpo with matnr as link.

loop mast internal and use read table concept to pass data from ekpo internal table to mast internal table with key field as matnr

pass value of ebeln in internal table of mast.

and then finally pass all the values to final o/p table.

hope this will help you out

Regards

Gaurav

[Former Member]

Hi Divya,

You can achieve this using hierarchical alv,Below links might be usefull..

http://scn.sap.com/docs/DOC-10371

http://scn.sap.com/thread/223185

Regards,

Shashikanth

[former_member1716]

Hi Divya,

Please Try using ALV tree Display using OOPs concept.

Thanks,

Satish

[Former Member]

Thanks all fa ur answers, I will try wit the suggested solutions and get back.

Thank you.

[former_member1716]

Hi,

You have to explore all these classes mentioned below.

cl_salv_table,

cl_salv_columns_table,

cl_salv_functions,

cl_gui_alv_tree,

cl_gui_custom_container,

cl_rsrq_tree_alv.

[Former Member]

Hi Divya ,

This can be achieved using Hierarchical ALV list display.

create an internal table with all the mentioned fields ie. a header table,

and another internal table with the sub-fields ie. item table.

and use function module 'REUSE_ALV_HIERSEQ_LIST_DISPLAY'.

Thanks.

[VenkatRamesh_V]

Hi Divya,

Check this program BCALV_TREE_DEMO.

Hope it helpful.

Regards,

Venkat.

[jayanthi_jayaraman]

Hi,

Check using Hierarchical ALV as suggested.

[SujeetMishra]

Hi,

Create one simple ALV Report displaying your all fields and then you can set the Layout of your ALV, save the layout and make it default Layout when displaying.

Regards,

Sujeet