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
Difference between sap script and report?
What are the uses of interactive reporting?
What is the difference between upload and ws_upload ? : abap bdc
What is view proxy in abap?
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?
how to Create a smart form related to gate pass to be submitted to vendor’s location. This form outputs document number, date, vendors name, address, material details, quantity, unit,and the company logo.
Normally how many and what files get created when a transaction program is written?
Do we have to migrate all sapscript forms to smart forms?
What are the types of subroutines? : abap modularization
What is the bapi?
What are two methods of modifying sap standard tables? : abap data dictionary
Example of table cluster and cluster tables.
What are the classifications of the sap abap data classes?
What is Buffering Concept? When should a Table be buffered?