topic Re: date query in Application Development and Automation Discussions

date query

Former Member — Tue, 07 Apr 2009 05:58:58 GMT

Hi,

I am unable to execute the query.Its not working for date.

REPORT ZIRREPORT.

TABLES: ADRC,crmd_orderadm_h.

SELECTION-SCREEN BEGIN OF BLOCK bl1 WITH FRAME TITLE TEXT-001.

SELECT-OPTIONS : country FOR ADRC-COUNTRY,

date FOR sy-datum .

PARAMETERS: user like crmd_orderadm_h-created_by,

category like crmd_srv_subject-codegruppe.

SELECTION-SCREEN END OF BLOCK bl1.

data : it_guid type table of CRMT_OBJECT_GUID.

select GUID

into table it_guid

from crmd_orderadm_h

where CREATED_BY = user

and PROCESS_TYPE = 'ZPG'

AND posting_date in date.

Thanks and Regards

Shilpi

Re: date query

Former Member — Tue, 07 Apr 2009 06:00:25 GMT

Hi Shilpi

DATE is a reserved word, we cant use it,

Change the declaration with some other name,

Hope it will work fine.

Regards,

Nitin.

Re: date query

Former Member — Tue, 07 Apr 2009 06:02:45 GMT

USe the following


REPORT ZIRREPORT.
TABLES: ADRC,crmd_orderadm_h.
SELECTION-SCREEN BEGIN OF BLOCK bl1 WITH FRAME TITLE TEXT-001.
SELECT-OPTIONS : country FOR ADRC-COUNTRY,
s_date FOR sy-datum .
PARAMETERS: user like crmd_orderadm_h-created_by,
category like crmd_srv_subject-codegruppe.

SELECTION-SCREEN END OF BLOCK bl1.
data : it_guid type table of CRMT_OBJECT_GUID.
select GUID
into table it_guid
from crmd_orderadm_h
where CREATED_BY = user
and PROCESS_TYPE = 'ZPG'
AND posting_date in s_date.

Re: date query

Former Member — Tue, 07 Apr 2009 06:04:13 GMT

Hi,

What is the error message you are getting?

Regards,

Naveen

Re: date query

sarbajitm — Tue, 07 Apr 2009 06:04:39 GMT

May be in the table, there is no data corresponding to the date range that you are providing. Otherwise the query is ok. Please Check giving only LOW option of DATE. Hope you may get some result from that. Also change DATE to V_DATE or S_DATE.......something like that.

Regards.

Sarbajit.

Edited by: Sarbajit Majumdar on Apr 7, 2009 11:35 AM

Re: date query

Former Member — Tue, 07 Apr 2009 06:05:21 GMT

Hi,

Check whether you passing data in field user and check the DB table has entry with the combination your checking for.

Re: date query

Former Member — Tue, 07 Apr 2009 06:07:59 GMT

I am not getting ne error message.sy-subrc is 4 after execution of this query.This is not a data issue.

Regards

Shilpi

Re: date query

Former Member — Tue, 07 Apr 2009 06:11:37 GMT

Hi,

Try this way,,using "corresponding fields of"


select GUID
into *corresponding fields of* table it_guid
from crmd_orderadm_h
where CREATED_BY = user
and PROCESS_TYPE = 'ZPG'
AND posting_date in date.

regards,

naveen