Deletion Indicator

[Former Member]

Dear Experts,

Today I had a discussion with functional consultant and they have the below requirement.

I have a Ztable ( let Zven_upload ).

Now I upload the data from excel file and modify the Ztable ( Zven_upload ).

As of now everything thing is working fine.

But now ...

If in that Ztable (Zven_upload ) there are so many fields like matnr, sernr, ean, deleted, ebeln, lifnr like so many fields are there.

my program is sucessfully uploading data to ztable.

now their requirement is like...If the sernr(serial number) value is already exist in the z table ( Zven_upload ) during excel file data modification into ztable that means if there is any existing sernr(serial number) in the Ztable (Zven_upload ), then i need to set the deletion flag so that they will delete the duplicate entries.

if there is no existing sernr(serial number) in excel sheet then it ll upload as usual.

my doubt is what is that deletion indicator and how to set ???

please guide me.

Kind Regards,

Ajit

[Former Member]

Dear Experts,

Today I had a discussion with functional consultant and they have the below requirement.

I have a Ztable ( let Zven_upload ).

Now I upload the data from excel file and modify the Ztable ( Zven_upload ).

As of now everything thing is working fine.

But now ...

If in that Ztable (Zven_upload ) there are so many fields like matnr, sernr, ean, deleted, ebeln, lifnr like so many fields are there.

my program is sucessfully uploading data to ztable.

now their requirement is like...If the sernr(serial number) value is already exist in the z table ( Zven_upload ) during excel file data modification into ztable that means if there is any existing sernr(serial number) in the Ztable (Zven_upload ), then i need to set the deletion flag so that they will delete the duplicate entries.

if there is no existing sernr(serial number) in excel sheet then it ll upload as usual.

my doubt is what is that deletion indicator and how to set ???

please guide me.

Kind Regards,

Ajit

[kyusufzai]

Hi Ajit,

   After reading the issue I believe according to your functional consultant deletion indicator is just to update the deletion flag in a field of that table which can be used by some other program to identify the incorrect record and delete the record.

Thanks

[Former Member]

Hello Ajit,

It may be X char length 1 field.But still m confused. Please try to give more information.

Regards

Sam

[Former Member]

You have a "deleted" field there. Semanticly it seems that your consultant wants to fill value 'X' into this field.

A different question - isn't it more politically correct to ask your consultant what he / she wants before asking in the forum? I believe none of us are able to know your z-table or any customer developments and the relation between you and your consultant

[former_member228804]

Hello Ajit,

     Your requirement is not clear really.But whatever little that I have understood from your post is that you need to set a deletion indicator of your serial number repeats.

     For this, you need to create a custom field say ZDELETIONFLAG of DATA TYPE char1 in your Z table. Now, fetch all the data entries from the Z table FOR ALL ENTRIES comparing SERNR of your internal table with SERNR of your Z table. Now for the entries found against these Serial numbers, just update your deletion indicator flag = 'X'.

Regards,

Dnyanesh.