Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What does an exec sql statement do in abap?

1256


When value table becomes check table?

1129


What are the two ways for restricting the value range for a domain ?

1252


Explain lsmw?

1129


What are the advantages and disadvantages of using views in abap programming ?

1162


What is the difference between synchronous and asynchronous update? : abap bdc

1246


What is the sap abap?

1121


Explain the Types of Select statements?

1134


What are two methods of modifying sap standard tables?

1202


Can you create an internal table dynamically?(at run time)

1964


What is output determination?

1282


there are 2 selection screens. material num in screen 200 and plant in screen 300. so how can you write in INITIALISATION event?

2251


What is the syntex used to call a screen as dialog box (pop up)?

1215


What are the different types of luws. What are they?

1198


What is dialog module?

1139