topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Mon, 02 Jul 2007 13:57:44 GMT

Hi experts,

i am developing one report...the expected output is given as follows:

customer | qty | amount |

customer is selected from likp and other data(quantity, amount) of customer is selected from lips.

so my question is that how do i do that??

ne sample code?

Re: Report

Former Member — Mon, 02 Jul 2007 14:03:24 GMT


SELECT KUNNR NTGEW LFIMG
INTO T_DATA
FROM ( LIKP INNER JOIN LIPS
ON LIKP~VBELN EQ LIPS~LIPS )
WHERE..."Do you parameters filter...

LOOP AT T_DATA ASSIGNING <DATA>.
WRITE:/ <DATA>-KUNNR, <DATA>-NTGEW, <DATA>-LFIMG.
ENDLOOP.

Greetings,

Blag.

Re: Report

Former Member — Mon, 02 Jul 2007 14:08:27 GMT

Hello Saurabh,

For this you have to create an internal table like this...

data: begin of itab occursw 0,

customer like likp-customer,

qty like lips-qty,

amount like lips-amount,

end of itab.

after this write a select query to populate the above internal table using innerjoin.

select likp_{customer lips}qty lips~amount

into corresponding fields of table itab

from ( likp

inner join lips on

likp_{customer = lips}customer ).

loop at itab.

write: / itab-customer, itab-qty, itab-amount.

endloop.

Note: USE PROPER FIELD NAMES FOR customer, qty and amount.

reward points if helpful.

Regards

Sasidhar Reddy Matli.

Message was edited by:

Sasidhar Reddy Matli

Re: Report

Former Member — Mon, 02 Jul 2007 14:23:12 GMT

hi,

you use<b> SY-VLINE</b> system variable for vertical line while creating list.

<b>follow this sample code.</b>

LOOP AT ITAB.
WRITE:/  itab-kunnr,
              sy-vline,
              itab-<quant>,
              sy-vline,
              itab-<currency>,
              sy-vline.
ENDLOOP.

follow this ink for more information.

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dba1ae35c111d1829f0000e829fbfe/frameset.htm

regards,

Ashok Reddy

Message was edited by:

Ashok Reddy

Re: Report

Former Member — Mon, 02 Jul 2007 14:27:34 GMT

select vbeln kunnr from likp into table i_likp.

Select amt qty from lips into table i_lips

for all entries in i_likp

where vbeln = i_likp-vbeln.

Re: Report

Former Member — Tue, 03 Jul 2007 04:35:38 GMT

experts, any other suggestions or sample code?