topic Re: report in Application Development and Automation Discussions

report

Former Member — Fri, 04 May 2007 13:21:28 GMT

ho to all my querry is as follows

i want the report output as follows

i have 3 fields in report output

custno

123 345 345 678 456 213

custname

suman kumar sunil sudhir suresh sudha

location

skl chennai pune mumbai hyd vsp

i mean i have 3 fields in my int table and total 6 records in int table how shold i handle get the output as above

pls send me the code

its urgent

Re: report

sreeramkumar_madisetty — Fri, 04 May 2007 13:23:25 GMT

Loop at itab.

Write:/ internal table fields.

endloop.

Regards,

Sreeram

Re: report

Former Member — Fri, 04 May 2007 13:26:19 GMT

Hi, try this.

WRITE:/ 'CUSTNO'.

SKIP 1.

LOOP AT ITAB.

WRITE: ITAB-CUSTNO, ' '.

ENDLOOP.

SKIP 2.

WRITE:/ 'CUSTNAME'.

SKIP 1.

LOOP AT ITAB.

WRITE: ITAB-CUSTNAME, ' '.

ENDLOOP.

SKIP 2.

WRITE:/ 'LOCATION'.

SKIP 1.

LOOP AT ITAB.

WRITE: ITAB-LOCATION, ' '.

ENDLOOP.

This might help you.

Regards,

Hemant.

Re: report

pradeep_nellore — Fri, 04 May 2007 14:23:32 GMT

Hi,

Try the follwing code.

loop at itab.

write : itab-custno.

give a new line.

endloop.

follow the above same lines for remaining fields.

Reward if helpful.

Bye.

Re: report

Clemenss — Fri, 04 May 2007 15:05:31 GMT

Hi sunil,

loop at table 3 times, speed-optimized

field-symbols:
  <line> type any,
  <field> type any.
do 3 times.
  loop at itab assigning <line>
    at first.
      case sy-index.
        when 1.
          write: 'custno', /.
        when 2.
          write: 'custname', /.
        when 3.
          write: 'location', /.
      endcase.
    endat.
    assign component sy-index of structure <line> to <field>.
    Write <field>.
  endloop.
enddo

Regards,

Clemens