topic Query in Application Development and Automation Discussions

Query

Former Member — Thu, 07 Sep 2006 17:35:39 GMT

hi friends,

1. Select all records from table CDHDR where

AND OBJECTCLAS in S_OBJCLS

AND UDATE = P_DATE

AND CHANGE_IND in S_CHGIND

retrieve only the fields required

upto above i written a select statement

the below thing i didnt under stood

i have little bit confusion Could plese help me below one how to do

IF no record is found

THEN

Create a trailer record with zero count

WRITE the validation report showing only the null trailer details

EXIT the program

ENDIF

Thanks And Regards

Srilavi

Former Member — Thu, 07 Sep 2006 17:40:51 GMT

Hi Srivali..

I didn't understand either when you say

"Create a trailer record with zero count

WRITE the validation report showing only the null trailer details".

but as far as i understood,

do this after select stmt...

data: lin type i.

describe table itab lines lin. "where itab is filled up from cdhdr table

if lin eq 0.

count = count + 1.

write: / count.

exit.

endif.

Regards,

Vivek

Former Member — Thu, 07 Sep 2006 17:48:21 GMT

hi vivek,

Thanks

Regards

Srilavi