Insert record into DB - record with data only

[Former Member]

Hi gurus,

I tried to insert data from itab into db.

When there is no data from itab, there is still one row of record as such

00000

0000

in this case, the above record went into my db.

Since, there is really no data, how can i avoid this data into my db?

Many thanks.

[Former Member]

hi,

do this way ....

loop at itab.
  if not itab IS INITIAL.
    INSERT ztable FROM itab.
  endif.
endloop.

Regards,

Santosh

[Former Member]

Hi,

Simply check in the internal table.

LOOP AT itab.

IF itab IS INITIAL.

DELETE itab.

ENDLOOP.

Regards,

Atish

[Former Member]

Hi,

I managed to solve it this way too.

IF NOT itab_voc IS INITIAL.

INSERT zeuc127_v FROM itab_voc[].

endif.

Thanks for your help too

[Former Member]

resolved.

[Former Member]

hi,

do this way ....

loop at itab.
  if not itab IS INITIAL.
    INSERT ztable FROM itab.
  endif.
endloop.

Regards,

Santosh