Report

[Former Member]

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?

[Former Member]

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.

[Former Member]

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

[Former Member]

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

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

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

regards,

Ashok Reddy

Message was edited by:

Ashok Reddy

[Former Member]

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.

[Former Member]

experts, any other suggestions or sample code?