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
What are the different abap editors? What is the used of different editors in abap?
What are the domains and data elements?
Which function module reads the data for particular infotype ? : abap hr
What are multiple use BADIS?
How do you Export a session ?
What is open sql?
What are system fields for secondary lists?
What function does data dictionary perform?
What are the differences between macro and subroutine?
What application areas are you comfortable in?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?
What actually happens in real-time recruitment? : sap abap hr
Difference between sap script and report?
Hi, I have a requirement for locking the fax field in user master records. As you know user can edit the details using the System>profile>own data (SU3), it is causing some security threat to our model. What i want is users should not be able to change the fax field under communications when they get into su3.I have heard of user Exist functionality but don't know how to implement it. Can you suggest something, it will be greatly appreciated.
What are the differences between structure and table in data dictionary in abap? : sap abap data dictionary