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 are the different types of work process?
What is the difference between select statement and provide statement ? : abap hr
In which time constraint does the infotype records depend on the subtype ? : abap hr
What is the tcode for sapscript forms?
What are the components of sap scripts? : abap hr
What will you code in start-of-selection & end-of-selection ?
What are the two statements which are required in an abap program to output an icon using a write statement?
In sap script how to print bar code in vertical manner
Explain client-dependent and client-independent tables.
What are Pull and Push Methods?
Name the abap/4 modularization techniques? : abap modularization
What are logical databases? : abap hr
What are the different functions used in sap script?
What are the pooled and cluster tables?
What are the different types of internal table?