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
Give examples of transparent table?
What is the differrences between structure and table in data dictionary in abap? : abap hr
What is buffering allowed but switched off?
Concepts of OO ABAP and why we are using it?
what will happen if called program is not executable ?
What are the types of table fields in the sap abap?
What are the table controls in bdc ? What is the difference between bdc and lsmw ?what is the difference between bdc and rfc ? : abap bdc
What are the drill-down features provided by abap/4 in interactive lists?
Is there any BAPI to retrieve list of customers and their sales areas i.e., Cust No, Distr Channel and Division for all the customers.
Hi! I want to join SAP ABAP course in Hyderabad, can any one tell me where should I join? and Which is the best institute for SAP WORKSHOP? Thank you...
Define structure in abap data dictionary?
How do you take care of performance issues in your ABAP programs?
What are the differences between a database index and a match code? : abap data dictionary
How to transfer data into line items using batch input session method? : abap bdc
Abstract class and interface, multiple inheritance, live example