topic Re: Is initial in Application Development and Automation Discussions

Is initial

Former Member — Fri, 09 Sep 2005 20:29:47 GMT

Hi,

Can anybody explain is initial in the following code.

Select matnr from mara into table itab_mara.

if not itab_mara[] is initial.

select maktx from makt into itab_makt for all entries

in itab_mara whre matnr = itab_mara-matnr.

endif.

Thanks,

Sriram.

Re: Is initial

Former Member — Fri, 09 Sep 2005 20:44:35 GMT

Hi sriram,

Checked ur code, it seems it checks whether atleast one record exist in the internal table.

with regards,

praveen.

Re: Is initial

Former Member — Fri, 09 Sep 2005 20:45:13 GMT

Sriram,

Basically IS INITIAL is used to check where the table ot variable or field is empty or not.

In your case...you are selecting materials in to a table and if that table is not empty then retrieve the material description from makt table.

If the internal table is empty then the if condition is false and the statements inside the IF condition doesnt execute.

Thanks,

Naren

Re: Is initial

Former Member — Fri, 09 Sep 2005 21:00:48 GMT

In addition to what Naren correctly explained, the reason why you are doing this in your particular case is that when you use "for all entries in itab" option, and if your "itab" is empty, then the SQL returns you all the entries in the database. So it is essential to check if there are any contents in your itab before you use this option.

Hope this is clear.

Regards,

Srinivas

Re: Is initial

Former Member — Sun, 11 Sep 2005 15:14:58 GMT

Hi Sriram,

Please take time to go through your previous posts and close them if answered.

Thanks,

Srinivas

Re: Is initial

Former Member — Mon, 12 Sep 2005 03:21:23 GMT

Hello Sriram,

Apart from the explanations given by the others, which I agree with, there's one small syntax issue with your code -

select matnr 
  from mara 
  into table itab_mara.

if not itab_mara[] is initial.
  select maktx 
    from makt 
    into itab_makt 
     for all entries in itab_mara 
   where matnr = itab_mara-matnr.
  <b>endselect.</b>
endif.

When you don't say INTO TABLE, then you need to have the SELECT...ENDSELECT. And within that you might append the data to the internal table.

select matnr 
  from mara 
  into table itab_mara.

if not itab_mara[] is initial.
  select maktx 
    from makt 
    into <b>table</b> itab_makt 
     for all entries in itab_mara 
   where matnr = itab_mara-matnr.
endif.

Regards,

Anand Mandalika.

Re: Is initial

Former Member — Mon, 12 Sep 2005 03:23:23 GMT

Good catch Anand. I completely missed that there is no "into table" addtion in his example.

Srinivas

Re: Is initial

Former Member — Wed, 14 Sep 2005 18:42:05 GMT

If these responses helped, please reward and close the post.

Srinivas

Re: Is initial

Former Member — Thu, 15 Sep 2005 06:03:00 GMT

IS INITIAL mean : if value of the variable is still same as it was at the time of declaration of varible.

regards

Re: Is initial

Former Member — Thu, 15 Sep 2005 22:36:04 GMT

Hi Sriram,

If these answers helped you, please reward and close the post.

Thanks,

Srinivas