on 01-12-2015 1:45 PM
Dear Gurus
Our version is HANA SP 83.
this one query i have written in a procedure
tgt_qty=select a.vkorg,a.auart,a.kunnr,c.zname1,b.matnr,c.zmaktx,b.WERKS,c.mtart,
sum(case when (b.VRKME = 'MT' or b.VRKME='TO') then b.zMENG*umziz else b.zMENG*UMZIN end) as conqty, 0 del_qty
from sapagd.vbak a, sapagd.vbap b, (select a.zkunnr,a.zname1,a.zmatnr,a.zmaktx, b.mtart
from sapagd.zhd_rep a, sapagd.mara b
where a.zmatnr = b.matnr
order by a.zkunnr,a.zmatnr) c
where a.vbeln = b.vbeln
and a.vkorg = :p_vkorg
and a.auart = 'ZTLP'
and a.GUEBG >= :p_lfdatf
and a.GUEEN <= :p_lfdatt
-- and a.audat between :p_lfdatf and :p_lfdatt
and a.kunnr = c.zkunnr
and b.matnr = c.zmatnr
group by a.vkorg,a.auart,a.kunnr,c.zname1,b.matnr,c.zmaktx,b.VRKME,b.werks,c.mtart
When I run it in the procedure shows no rows returned.
These are the definition of the variable
in p_vkorg nvarchar(4),
in p_lfdatf date,
in p_lfdatt date
call "AKMENON"."ZSD_HADE_REP"(p_vkorg=>'1000',p_lfdatf=>'20150101',p_lfdatt=>'20151231',hade_rep=>?)
I debugged the procedure it is not returning any rows.
When I run the same in sql window with these values
and a.vkorg = '1000'
and a.GUEBG >= '20150101'
and a.GUEEN <= '20151231'
it returns the results.
What could be the issue
Thanks and Regards.
Arun Kumar Menon
Solved just converted the parameter to to_dats(p_lfdatf)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When I removed the date filtering from the query it returned results.
via call call "AKMENON"."ZSD_HADE_REP"(p_vkorg=>'1000',p_lfdatf=>'20150101',p_lfdatt=>'20151231',hade_rep=>?)
Is there a way i have to pass dates to the procedure.
thanks and regards
Arun Kumar Menon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.