Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Need Date Selection Criteria

Hii, Experts.

I need one help I am having one query in which i want 'from date' and 'to date'

Here is my query please help me

-------------

SELECT T1.Code as 'Raw Material',

            (select sum(T2.Quantity) from IGE1 T2 where T1.Code  = T2.ItemCode ) as 'issue' ,

T0.[Code] 'Finished Goods',

(select sum(T3.Quantity)  from IGN1 T3 where T0.Code  = T3.ItemCode ) 'Receipt' ,

 

    ( isnull ((select sum(T2.Quantity) from IGE1 T2 where T1.Code  = T2.ItemCode ),0)-

isnull ( (select sum(T3.Quantity)  from IGN1 T3  where T0.Code  = T3.ItemCode ),0 )

    

)

            as ' Closing'

             FROM OITT T0  INNER JOIN ITT1 T1 ON T0.[Code] = T1.[Father]

-----------------------

Thank you in advance

Former Member
Not what you were looking for? View more on this topic or Ask a question