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

how to see the tables of 200 in client 100?

1409


How to creat transactions? : abap data dictionary

644


What is web dynpro for abap?

567


What is the difference between a structure and a table?

548


What are the different attributes that can be assigned to a variant?

583






How many secondary indexes can we create in a table?

617


what are the various types of parameters and how are they distinguished from one another?

725


What are different abap/4 editors?

605


HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?

2404


Can we reuse a userexit?

1072


How to transfer the objects? Have to transferred any objects?

574


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

1587


What is the transaction code to display the payroll results ? : abap hr

568


What functions does a data dictionary perform? : abap data dictionary

616


What is time constraint ? : abap hr

692