Suppose we are transfer data through BDC from legacy to SAP
and their is some duplicate data in legacy system but we
don’t want this in SAP system .So how can we check that this
data is already exist ?

Answer Posted / dillip kumar mishra

We have to check the key field is there in database table or not.
if we are storing uploaded data into internal table let's say ITAB.
Then we should check like as follows.
loop at itab.
select * from <database table> where <primary key> = itab-key.
if sy-subrc = 0.
logic for update.
else.
write:'Document Exists'.
continue.
endif.
endloop.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi.. sap sd is installed in my PC .i m unable to start becoz ,i have given wrong password many times and it's locked.please tell me how can i open SAP logon. tell the process at my id dst.noida@rediffmail.com please advance thanx

1712


What kind of BDC programs are written ?

767


After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then ?

1676


What is the difference between refresh and free statements?

901


What is personnel sub are

1745






hi..i hav developed an interactive report in which alv list display in basic list and 1st secondary list in alv grid display.I want to get summation(total) of the columns in the secondary list.I hav used 'do_sum' but i couldnt get.is there any other way to get summation(total) in secondary list which is an alv grid display

2721


What is the function of the transport system and workbench organiser? : abap data dictionary

808


Hi guy.. i have to face an interview in a couple of day.. so can you please give me some good and tough question on abap.

1804


Explain the disadvantages of abap query tool?

762


Explain how data is stored in cluster table?

879


Can we reuse a userexit?

1242


What is asap methodology? : sap abap hr

756


In order to upload purchase order details, how you handle multiple values for a single field?

719


What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary

798


How to find Kernal badi ?

1343