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
iam looking for sap bap parttime training job 
Hi Paneeddra, I'm Jagadish Kumar Bhagwant representing Catalyst ECS, a reputed IT and SAP training institute and Software Development company in bangalore. Please share your contact details for further...
12 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...
Hello all, can anyone help /suggest me how I get entry as Sap mm consultant fresher or do I need to do internship but I have already done curse /training?
You will get very less calls because cloud computing is grooming these days. Everything is going to be integrated with cloud so better if you could go for S4 Hana.
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 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.
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
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...
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...
The Real Value of SAP in the World
The SAP is a standout amongst the most requested innovation in this day and age. SAP was established in the year 1972 going for creating enterprise asset solutions that upgrade information administration...
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....
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
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
