Skip to Content
0
Former Member
Apr 01, 2008 at 10:46 AM

urgent: regarding sub select statement

18 Views

I making a report in which i have to display the STOCK and i want to do the sum in a select statement of the value coming from the field AFRU-GMNGA so that i can do calculation of the value of 1st field to be subtracted from the last value of the same field .

can anybody provide me example of it as i am currently using dis select statement:-

SELECT AMATNR ALGORT BGMNGA BVORNR C~MEINS FROM AFPO AS A

INNER JOIN AFRU AS B ON AAUFNR = BAUFNR

INNER JOIN MARA AS C ON AMATNR = CMATNR

INTO TABLE ITAB

WHERE MTART IN MAT_TYPE AND A~MATNR IN P_MATNR .

plzz help me out as it is really urgent to me.