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 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.
7 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 completed BCA and MCA and thinking of going for SAP training. Please suggest which module should I go for? I am good with programming and Database.
You can go with SAP HANA is an In-Memory, Columnar Database and Application Development Platform from SAP which can be deployed on-premise or in cloud.
what is the difference between sap abap vs HR ABAP
Hy HR is a module in sap it's different process that some different type of development . In Abap use logical database . Some other statement .like SAP CRM but not use in core Abap
Which module would be preferable SAP FI-CO or SAP ABAP for a non-techie and non-finance background guy?
Hi, Now cloud computing is ruling over everywhere.. Instead of SAP-FICO, you can opt s/4 Hana simple Finance. . If you are a non-techie guy, you can go with functional modules.
Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com
Ask a QuestionRelated Lessons
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
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...
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...
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....
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
