Skip to Content
author's profile photo Former Member
Former Member

urgent: regarding sub select statement

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2008 at 11:27 AM

    Hi,

    Go thr the below select query.

    select tvkwzwerks a350kschl a350vkorg konpkbetr

    from tvkwz inner join a350 on tvkwzvkorg = a350vkorg inner join konp

    on a350knumh = konpknumh into table itab where tvkwz~werks = '1003'

    and a350~kschl = 'ZCPA'.

    Regards,

    vijay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.