topic Re: Insert blank row in interal table in Application Development and Automation Discussions

Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:22:05 GMT

Hi all,

I have one internal table wherein I have several records. I want to insert a blank row to group the records based on vendor code.

thns in advance,

Salman

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:24:53 GMT

default insert one colume value remaining null.

after insert time u can modify the value

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:29:14 GMT

try this

first sort your table on vendore code

SORT itab BY vendore_code.

then use control structure AT NEW ....ENDAT inside the loop on internal table

Loop at itab

AT NEW vendore_code

use insert command to insert a blank record.

ENDAT

endloop

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:30:28 GMT

Hi,

A row can be added only when you have value for atleast one key field.

For your problem ,instead of adding one blank row, you can add one more field in your internal table and you can set different values according to different vendors and then you can group them based on this field.

Hope this will help.

Regards,

Mukesh J.

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:30:38 GMT

Hi,

Follow this link.

http://help.sap.com/saphelp_nw70/helpdata/EN/79/5b094ca0c211d3a6d80000e83dd863/frameset.htm

hope this will help you.

Regards:

Alok

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:31:13 GMT

Hello,

In you case you need to loop at the final table which has all the vendor codes (final table must be sorted by vendor code). You need to compare the current record in the loop with the previous record, if it is different then append a blank work area in internal table. This way you can seperate the internal table with grouping of vendor code separated by blank lines.

Thanks,

Jayant Sahu.

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:31:30 GMT

use the below piece of code.

loop at itab.

at new field1.

clear itab.

append itab to itab1.

endat.

endloop.

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:33:15 GMT

Instead of inserting a blank row in itab, use the SORT and AT..ENDAT stmt suggested above to display the contents of your itab as a group.

Regards,

Jayanthi.K

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:33:27 GMT

HI.

APPEND INITIAL LINE TO ITAB.

Regards.

Jay

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:37:43 GMT

Hi Salman,

suppose ur internal table has 5 records,

 loop at itab into wa_tab.
             if sy-tabix eq 3 .
               clear wa_tab.
               append wa_tab to itab.     " Adds 6 th row to itab.
             endif. 
           endloop.

After executing this ,check in debugging mode , 6 records are available now.

or check sy-tabix for the empty record.

Reagrds,

Aby

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:41:53 GMT

Hi,

As per my Knowledge emply row canot be added. Column can be possible. Try to add any additional field and add some value make rest of field empty.

Hope this will help.

Regards

Md.MahaboobKhan

Re: Insert blank row in interal table

Former Member — Tue, 20 Jan 2009 05:48:31 GMT

INSERT INITIAL LINE INTO <internal_table> INDEX <n>.

A blank row will be inserted in the internal table according to the specified index.

Re: Insert blank row in interal table

faisalatsap — Tue, 20 Jan 2009 05:50:06 GMT

Hi, Salman Zahir

Please test the following program it will solve out your problem,

REPORT zfsl_test_search_help NO STANDARD PAGE HEADING.


TYPES: BEGIN OF t_type,
  name(10),
  sale TYPE p,
  END OF t_type.

DATA: it1 TYPE STANDARD TABLE OF t_type WITH HEADER LINE,
      it2 TYPE STANDARD TABLE OF t_type WITH HEADER LINE,
      wa_it1 TYPE t_type,
      wa_it2 TYPE t_type.

DO 10 TIMES.
  wa_it1-name = 'Faisal'.
  wa_it1-sale = sy-index.
  APPEND wa_it1 TO it1.
ENDDO.
DO 10 TIMES.
  wa_it1-name = 'Altaf'.
  wa_it1-sale = sy-index.
  APPEND wa_it1 TO it1.
ENDDO.

SORT it1 BY name sale.
clear: wa_it2.
LOOP AT it1 INTO wa_it1.

  APPEND wa_it1 TO it2.

  AT END OF name.
    SUM.
    wa_it1-name = 'Name Sum'.
    APPEND wa_it1 TO it2.  " Here I am Inserting the SUM of Sale
    APPEND wa_it2 to it2.    " Here I am inserting Blank Line
  ENDAT.

ENDLOOP.

Please Reply if any problem

Kind Regards,

Faisal

Edited by: Faisal Altaf on Jan 20, 2009 10:50 AM