topic Re: ALV Report in Application Development and Automation Discussions

ALV Report

Former Member — Thu, 18 Dec 2014 05:36:26 GMT

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

Item No.:AS01

BOM Items: D

Item No.:AU01

BOM Items : F

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

Thanks in advance.

Re: ALV Report

Former Member — Thu, 18 Dec 2014 05:43:30 GMT

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

Re: ALV Report

Former Member — Thu, 18 Dec 2014 05:43:35 GMT

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

Re: ALV Report

former_member1716 — Thu, 18 Dec 2014 05:46:02 GMT

Hi Divya,

Please Try using ALV tree Display using OOPs concept.

Thanks,

Satish

Re: ALV Report

Former Member — Thu, 18 Dec 2014 05:52:20 GMT

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

Thank you.

Re: ALV Report

former_member1716 — Thu, 18 Dec 2014 06:00:17 GMT

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.

Re: ALV Report

Former Member — Thu, 18 Dec 2014 06:04:24 GMT

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.

Re: ALV Report

VenkatRamesh_V — Thu, 18 Dec 2014 12:59:07 GMT

Hi Divya,

Check this program BCALV_TREE_DEMO.

Hope it helpful.

Regards,

Venkat.

Re: ALV Report

jayanthi_jayaraman — Thu, 18 Dec 2014 15:52:44 GMT

Hi,

Check using Hierarchical ALV as suggested.

Re: ALV Report

SujeetMishra — Thu, 18 Dec 2014 20:03:06 GMT

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