topic Re: alv grid in Application Development and Automation Discussions

alv grid

Former Member — Sun, 10 Nov 2013 19:31:50 GMT

Hello Experts,

please help me to create this layout in alv grid display .

Item no.

Material no

quantity

Delivery date

Purchase requisition 1000001

11111616

12/06/2013

67678688

12/06/2013

Purchase requisition 1000002

56464646

12/04/2013

Purchase requisition 1000003

45521514

12/06/2013

87975451

8/05/2013

what code i have to use here for purchase requisition only .

Thanks

Re: alv grid

aferngas — Sun, 10 Nov 2013 20:12:09 GMT

Hi,

Unfortunately ALV Grid doesn't allow different types of lines. This layout can only be created with the old write-style REUSE_ALV_HIERSEQ_LIST_DISPLAY. Also you can use the ALV Tree but it isn't exactly the same layout.

Regards,

Alex

Re: alv grid

Former Member — Sun, 10 Nov 2013 22:45:28 GMT

thank you alex ,

i am new to abap but if you look into ME5A (in alv mode) report it will show you the same output as i shown you . after debugging the whole report i haven't seen REUSE_ALV_HIERSEQ_LIST_DISPLAY or alv tree .

is there any other way or method to do this ?

Re: alv grid

Former Member — Mon, 11 Nov 2013 05:04:25 GMT

The function used there is REUSE_ALV_GRID_DISPLAY_LVC

Re: alv grid

nabheetscn — Mon, 11 Nov 2013 05:17:48 GMT

Please check ME5A and try to adapt the same logic. Check in debugging how it is doing it

Re: alv grid

aferngas — Mon, 11 Nov 2013 12:23:32 GMT

Hi Jess,

ME5A doesn't use any type of ALV. It's a simple write report... The REUSE_ALV_HIERSEQ_LIST_DISPLAY framework can helps you to create the same ME5A layout.

There is an example of use:

http://wiki.scn.sap.com/wiki/display/Snippets/ALV+Hierarchical+Table+Using+FM+-+REUSE_ALV_HIERSEQ_LIST_DISPLAY

Regards,

Alex

Re: alv grid

Former Member — Mon, 11 Nov 2013 13:28:26 GMT

If it is ok to have the purchase requisition as the summary after all line items, then you can do it using the normal reuse_alv_grid_display FM

Just make the Purchase requisition in the field catalog no_out attribute = 'X'. And give the text for purchase requsition 'Purchase Requisition'.

lv_pos = lv_pos + 1.
   CLEAR gw_alv_fieldcat.
   gw_alv_fieldcat-fieldname = 'EBELN'.
   gw_alv_fieldcat-tabname   = 'IT_TAB'.
   gw_alv_fieldcat-seltext_l = 'Purchase Requisition'.
   gw_alv_fieldcat-col_pos   = lv_pos.
   gw_alv_fieldcat-outputlen = 7.
   gw_alv_fieldcat-no_out = 'X'.
   gw_alv_fieldcat-key = 'X'.
   APPEND gw_alv_fieldcat TO gt_alv_fieldcat.

Include ALV sort table to sort the table by purchase requisition field.

   wa_sort-spos = '01' .
   wa_sort-fieldname = 'EBELN'.
   wa_sort-tabname = 'IT_ITAB'.
   wa_sort-up = 'X'.
   wa_sort-subtot = 'X'.
   APPEND wa_sort TO i_sort .

Would this be fine? 🙂

Re: alv grid

aferngas — Mon, 11 Nov 2013 14:34:18 GMT

Great! It's looks fine and really similar to concept issued

Re: alv grid

Former Member — Tue, 12 Nov 2013 07:01:27 GMT

Re: alv grid

Former Member — Thu, 14 Nov 2013 18:28:48 GMT

thank you susmitha its working .

Re: alv grid

Former Member — Thu, 14 Nov 2013 19:33:08 GMT

How did you do it?

Re: alv grid

Former Member — Tue, 26 Nov 2013 07:54:11 GMT

solution of this thread ....

(1) prepare field catalog .

wa_fcat-fieldname = 'BANFN'.

wa_fcat-tabname = 'IT_TAB'.

wa_fcat-seltext_l = 'Purchase Requisition'. " this will display text of summary .

wa_fcat-col_pos = lv_pos.

wa_fcat-outputlen = 7.

wa_fact-no_out = 'X'. " this is must if u want to display as summary after all line items.

(2) note that you have at least one numeric or quantity/currency filed to be marked as do_sum = 'X'.

wa_fcat-fieldname = 'MENGE'. " quantity field

wa_fcat-tabname = 'IT_TAB'.

wa_fcat-seltext_l = 'QUANTITY'.

wa_fcat-col_pos = lv_pos.

wa_fcat-do_sum = 'X'.

(3) prepare sort table .

sort the table by purchase requisition field.

   wa_sort-spos = '01' .
   wa_sort-fieldname = 'BANFN'.
   wa_sort-up = 'X'.
   wa_sort-subtot = 'X'.
   APPEND wa_sort TO i_sort .

(4) now add the filedcatalog and sort table in reuse_alv_grid_display .

this is also applicable in oo alv as i did in set_table_for_first_display .