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
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
What kind of BDC programs are written ?
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 ?
What is the difference between refresh and free statements?
What is personnel sub are
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
What is the function of the transport system and workbench organiser? : abap data dictionary
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.
Explain the disadvantages of abap query tool?
Explain how data is stored in cluster table?
Can we reuse a userexit?
What is asap methodology? : sap abap hr
In order to upload purchase order details, how you handle multiple values for a single field?
What is the maximum number of match code id's that can be defined for one match code object? : abap data dictionary
How to find Kernal badi ?