Query due which the report is failing with TIME_OUT.

Hi,

Check for gt_street_district is not initial before select.

Sujay

Edited by: Sujay Venkateswaran Krishnakumar on Oct 14, 2010 1:58 PM

Hi ,

SELECT adrstreet~strt_code
adrstreet~city_code
adrstreet~commu_code
adrstreet~regiogroup
adrpcdcity~post_code
INTO TABLE gt_adrstreet
FROM adrstreet
INNER JOIN adrpcdcity ON adrpcdcity~city_code = adrstreet~city_code
FOR ALL entries IN gt_street_district
WHERE adrstreet~strt_code = gt_street_district-strt_code.

Before using all entries in gt_street_district , CHECK if gt_street_district[] is not initial .

and also see all primary key fields of tables are there in select statement and workarea declared .

if gt_street_district[] is not initial .

SELECT adrstreet~strt_code

adrstreet~city_code

adrstreet~commu_code

adrstreet~regiogroup

adrpcdcity~post_code

INTO

corresponding fields of

table TABLE gt_adrstreet

FROM adrstreet

INNER JOIN adrpcdcity ON adrpcdcity_{city_code = adrstreet}city_code

FOR ALL entries IN gt_street_district

WHERE adrstreet~strt_code = gt_street_district-strt_code.

endif.

Regards

Deepak.