How to find only duplicate records from table ?
Answer Posted / sunil kumar gautam
In my code it is consider that duplication is checked on
the basis of empcd field of emp table.
REPORT ZTESTDUP.
types:begin of ty_du,
EMPID type ZEMP_ASHU_SUNIL-EMPID ,
EMPCD type ZEMP_ASHU_SUNIL-EMPCD,
EMPNM type ZEMP_ASHU_SUNIL-EMPNM,
end of ty_du.
Data: IT_du type standard table of ty_du,
Wa_du type ty_du.
select * INTO CORRESPONDING FIELDS OF TABLE IT_DU
from ZEMP_ASHU_SUNIL.
data: i type I.
data:IT_final type table of ty_du,
wa_final type ty_du.
loop at IT_DU into WA_DU.
i = 0.
loop at IT_DU into WA_DU where empcd = WA_DU-
empcd.
i = i + 1.
endloop.
if i = 2.
wa_final-empid = WA_DU-empid.
wa_final-empcd = WA_DU-empcd.
wa_final-empnm = WA_DU-empnm.
append wa_final to it_final.
clear wa_final.
endif.
endloop.
In above code final internal table contains duplictae data.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is the use of the statement leave to list-processing?
Why cant we use Normal function module for data transfer?
Mention the various databases integrities?
What are the different types of internal table?
What is processing class, where we do them and why? : sap abap hr
What are the update types possible?
The commands through which an abap/4 module can “branch to “ or “call” the next screen are?
What is the function of a data element? : abap data dictionary
What is a data dictionary? : sap abap data dictionary
10) How to get Item Header in Sales Order?
java script for push button in adobe forms.
If I want to execute a bdc program only in background not in foreground is there any option for this? : abap bdc
What is the difference of update types in call transaction method ? : abap bdc
What are the major steps will you use for tuning?
What are the basic functions of database utility? : abap data dictionary