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
how to see the tables of 200 in client 100?
How to creat transactions? : abap data dictionary
What is web dynpro for abap?
What is the difference between a structure and a table?
What are the different attributes that can be assigned to a variant?
How many secondary indexes can we create in a table?
what are the various types of parameters and how are they distinguished from one another?
What are different abap/4 editors?
HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?
Can we reuse a userexit?
How to transfer the objects? Have to transferred any objects?
Hello All, Requesting to all user of this site. Please post your Questions in Proper sub Category of chosen category. Some users post the questions in common category whether sub category for that is available ..like some users still post the SAP Script & ALE Related questions in common ABAP Category. Due to this it becomes very difficult to find the topic wise Questions. Please cooperate with the site & to other users. Thanks & Regards Tamseel
What is the transaction code to display the payroll results ? : abap hr
What functions does a data dictionary perform? : abap data dictionary
What is time constraint ? : abap hr