Marking Z table entry for Deletion

[Former Member]

Hi All,

Based on some condition in my program,

I am entrying one entry in Custom Z table.

Also for some other condition,

I need to mark the Table entry for deletion only, but it should not Delete.

So pls guide me for:

1) How to make Custom table entry as Mark for Deletion?

2) When I put Select Query on table, how can I write that do not Select those

Records which are marked for Deletion ?

Rishi

[i048168]

Hi,

I think its pretty simple. Just add the field for deletion indicator which should be set when the record is deleted and space otherwise.

Regards,

Vadi

[Former Member]

Hi,

I think you need to include one more field say Flag in the Ztable.

If the flag is set in that field that entry can be skipped while selecting data.

Hope this helps you

Regards

Manasa

[Former Member]

Hi Rishi,

Create a new field of type 'CDXFELD' (Data Type) in the Custom Z table. Now populate that new field with 'X' if it is marked for deletion. Then you can select all those entries which that field 'CDXFELD' = Space.

i.e., if the field 'CDXFELD' = 'X' then it is marked for deletion else not.

Select *

from Zcustom talbe

in to IT_TAB

where CDXFELD = space.

Hope this will help..

Regards,

Ravi..

[Former Member]

Thanks all