UrbanPro
Login Ask & Answer Success Stories Paid Courses Free Classes Tuition & Classes Fees Write a Review All Categories Help Center
Post your Learning Need Signup as a Tutor
✕

Popular Cities

Bangalore

Hyderabad

Delhi

Mumbai

Chennai

Pune

Kolkata

Gurgaon

Ahmedabad

Jaipur

Noida

✕

Learn SAP ABAP Training from the Best Tutors

  • Affordable fees
  • 1-1 or Group class
  • Flexible Timings
  • Verified Tutors

Book a Free Demo

SAP ABAP > Learn SAP ABAP > I need a help in a report in sap for deleting duplicate...
✕

Search in

I need a help in a report in sap for deleting duplicate and null entries in the report

Asked by Last Modified  

8 Answers

Learn SAP ABAP

Follow 0
Answer

Please enter your answer

Trainer

delete adjacent duplicates from tabel comparing f1 f2.. for deleting duplicates and delete from itab where field = ' ' for null entries.
Comments
Dislike Bookmark

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 ''.
Comments
Dislike Bookmark

Tutor

Aditya, You can use "Delete adjacent Duplicate" and delete duplicate entries from your final(output) internal tables.
Comments
Dislike Bookmark

Best SAP SuccessFactors Online Training

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.
Comments
Dislike Bookmark

Tutor

DELETE ADJECENT DUPLICATES COMPARING FIELD1 FIELD2... DELETE IT_VBAP WHERE MATNR EQ 0.
Comments
Dislike Bookmark

Best SAP SuccessFactors Online Training

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
Comments
Dislike Bookmark

SAP ABAP ,ABAP OO,SAP ABAP on HANA,SAP FIORI

you can delete by first sorting then deleting adjacent duplicate
Comments
Dislike Bookmark

SAP ABAP | S4 HANA Simple Logistics | SAP Analytics Cloud Trainer

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.
Comments
Dislike Bookmark

View 6 more Answers

Related Questions

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.
Shalaka
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...
Nirav
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.
Priya
0 0
7
I need some logic of a report of ABAP in SAP so can anybody help me for the logic of the report so please share your number to me I will call you and time mention your conviences
Okay, share your requirement to me. On the basis of your requirement, I will tell you the time and conveniences..
Aditya
0 0
7

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.
Kalyani
0 0
9

Now ask question in any of the 1000+ Categories, and get Answers from Tutors and Trainers on UrbanPro.com

Ask a Question

Related 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...

Future

0 0
0
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....

Ashik S.

2 0
0
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...

Nest Gcs

0 0
0
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...

Bright Computer Education

1 0
0
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...

Amit Kumar

0 0
0
Find SAP ABAP Training near you
SAP ABAP Training in Bangalore
SAP ABAP Training in Hyderabad
SAP ABAP Training in Chennai
SAP ABAP Training in Mumbai
SAP ABAP Training in Kolkata
SAP ABAP Training in Pune
SAP ABAP Training in Coimbatore

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
X

Looking for SAP ABAP Training Classes?

The best tutors for SAP ABAP Training Classes are on UrbanPro

  • Select the best Tutor
  • Book & Attend a Free Demo
  • Pay and start Learning

Learn SAP ABAP Training with the Best Tutors

The best Tutors for SAP ABAP Training Classes are on UrbanPro

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more

ThinkVidya Learning Pvt Ltd © 2010-2024All Rights Reserved