I need a help in a report in sap for deleting duplicate and null entries in the report
Asked by Aditya P Last Modified
Follow 0 
Answer 
delete adjacent duplicates from tabel comparing f1 f2.. for deleting duplicates and delete from itab where field = ' ' for null entries.
1
Comments
Suman Kumar Priyadarshi
SAP ABAP Consultant/Trainer
please share complete scenario, to delete duplicate you can use statement- DELETE ADJACENT DUPLICATES, for null don't fetch null value from db table by putting condition with WHERE clause of SELECT statement or run the loop on internal table and match the null entry with ''.
1
Comments
Dear Aditya, you can use the below code to delete duplicate entries. Sort the table first and do the below statement. 'DELETE ADJACENT DUPLICATES FROM Internal Table Name' Kindly reply back if the issue still persists.
0
Comments
Aditya, You can use "Delete adjacent Duplicate" and delete duplicate entries from your final(output) internal tables.
0
Comments
DELETE ADJECENT DUPLICATES COMPARING FIELD1 FIELD2... DELETE IT_VBAP WHERE MATNR EQ 0.
0
Comments
One of the fields being reported on is termination date. The report should show one line per employee, but terminated employees are displaying two lines - one with the termination date and one without.
0
Comments
you can delete by first sorting then deleting adjacent duplicate
0
Comments
In that case Suppose you have 10 fields in internal table and if any of them is blank, you need to delete record. Try this command delete itab where field1 is initial or field2 is initial or . . . field10...
read more In that case Suppose you have 10 fields in internal table and if any of them is blank, you need to delete record. Try this command delete itab where field1 is initial or field2 is initial or . . . field10 is initial. read less
0
Comments
View 6 more Answers
Related Questions
Hello everyone, I have completed B-com, MBA Fin and 5 yr working experience in Sap Plm/ MM (engineering documentation mgt) handing clients projects on SAP working with clients - Statoil, Shell, BP, ENI, Reliance, Total S.A. etc. Please suggest me which IT course /SAP module I should be choosing for my career growth in future or do I need to choose Sap Hana instead of choosing SAP functions courses. Please suggest me which is the correct career path or would have scope in future for my career? 
Hi, Stop working for others, work for your self. Plan a good business in your field.
9 What are the main SAP ABAP modules for logistics?
There is no ABAP module for logistics, ABAP is a high level programming language. SAP SD, SAP MM, SAP WM these SAP modules are for Logistics...
I have 2 years of experience on SAP ABAP. But I have knowledge only on the basic concepts. I wanted to learn SAP ABAP RICEF concepts completely in depth.
Hi Kalyani, When you say basics , what are the topics? I am happy to provide you the in depth training on advanced abap including the workflow.
Hello Everyone, I have done MBA, 5 yr working exp in SAP MM Field in pune Also, I have done SAP MM Consultant Training. Could anyone help /suggest me that should I take Internship for getting job as SAP MM Consultant fresher job? or how can I get entry as fresher?
some of the companies like Infosys, Accenture , capgemini are conducting interviews for freshers .....but try to upload your resume directly in their own websites instead of naukri, indeed. you'll sure receive the call .... all the best maaa.
Respected sir... i m nirav parekh n i completed my BE in IT in 2011 currently i working as a lecturer in engineering college since 5 years but sir i m really intrested in SAP but dont have knowleged about SAP module n i have knowledge about the language and database but i don't have SAP modules knowledge so plz suggest me best module regarding my qualification and also five years gap between my graduation what can i do and send me all detail about SAP module and training fees n timing duration.....
You should go for SAP ABAP training. Choose your trainer who is working in any (good) company as he would have good practical knowledge as well as he can refer you in some organisation(s) which will be...
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
SAP ABAP Course Overview By Future Labs Technology
SAP ABAP (Advanced Business Application Programming) is just about the most sought modules of SAP. Prior to its manifold yield, the pattern for the training of SAP ABAP is continually on an acute upgrowth. In...
Instead of searching, make one...!
The best way to learn a concept in a better way is to create a self prepared notes after compiling all the notes. Benefits are as follows: 1. Understand a concept in a way that you love to remember. 2....
Learn ABAP for Free
ABAP is a 4th generation programming language for data processing.It's very easy to learn in case if you prior knowlege in any SQL. Best websites to start ABAP SAP SCN Guru 99 SAP Technical learnsapforfree.blogspot.in/ sapnuts.com/courses/Object-Oriented-ABAP Abap...
SAP Training
Dear Candidate, Please accept my greetings, SAP, It stands for Systems Applications and Products in Data processing. It’s German software and is being implemented in all companies from SME’s...
N
Nest GCS -Top 10 SAP ABAP Institutes in Hyderabad Enhanced his Professional Value
As a computer science graduate with an MBA in Systems, Fahim was working as an in-charge of the ERP software implementation and maintenance project of a logistics firm with country-wide presence. The entire...
Find SAP ABAP Training near you
Looking for SAP ABAP Training ?
Learn from the Best Tutors on UrbanPro
Are you a Tutor or Training Institute?
Join UrbanPro Today to find students near you
