SAP ABAP [2020] - ABAP 7.40/7.50- SELECT

SAP ABAP [2020] - ABAP 7.40/7.50- Select statment with new Syntax
ABAP new syntax
#sapabap #oopsabap #ooabap
In this session, we will discuss how to read an entry of an internal table and also how to modify the record of the table.
What is SAP ABAP?
ABAP is a high-level programming language created by the German software company SAP SE.
ABAP is one of the many application-specific 4th generation languages first developed in the 1980s.
It was originally the report language for SAP R/2, a platform that enabled large corporations to build mainframe business applications for materials management and financial and management accounting.
In ABAP we have basically 2 types of programs:
1)Reports
2)Module pools
The module pool program defines more complex patterns of user interaction using a collection of screens.
The term “screen” refers to the actual, physical image that the user sees.
Each screen also has a "flow logic", which refers to the ABAP code implicitly invoked by the screens, which is divided into a "PBO" (Process Before Output) and "PAI" (Process After Input) section.
Dynpro - Dynamic program - refers to the combination of the screen and its flow logic.
Introduction to ABAP module pool programming.
Module pool programs are also called dialog programs.
The module Pool programs are basically reports that are prepared for different screens and to manage the sequence of events of these screens.
In the transaction SE80, you can see all the dynpros that you have for this kind of report, add new ones, add all types of elements to the report.
In this program, we will discuss new syntaxes in ABAP 7.40

[@gordanaspicer879]

Great Video:) Super nice examples and easy to understand explanations:) Looking forward to watch all your videos:) Please continue!!!

[@rabiulalam2816]

Very good

[@shashankkasar1]

Good presentation, good voice, easy examples. Really helpful. Thanks. Will wait for upcoming videos.

[@SS-rt8oo]

Thank you so much for the video, love your voice

[@ivankaiser3456]

nice nice nice! Thank you a lot Sir!

[@AbhishekYadav-qo9fq]

Thank you so much sir for you informative video.. I really appreciate it

[@mpredolim]

Awesome explanation.

[@Jai_Programmer]

Good Job..Expect a lot from you...

[@Axidy]

Thanks Sooraj for this!

[@sasirekha9724]

thank you sooraj . very useful to me

[@jagadeeshbalaga4191]

Nice explanation with awesome content 🥰

[@Sriga0712]

It was so helpful..🙏🙏

[@RobertKrajncSLO]

Your videos are great. Good sound quality, understandable english, good explanation. Thank you and keep on going. You have a new subscriber.

[@SoorajSasidharanABAP]

Thanks Robert.. :-)

[@CustAndCode]

good explained! 👏

[@rvdadhich]

great learning

[@julfikarali5993]

Very nice season it was 👍, please make video with such a new things in hana .

[@heenabhutani143]

very informative video! much appreciated.

[@SoorajSasidharanABAP]

Thanks Heena.. :-)

[@miguelperez-lj9vk]

i would like more videos about sap ABAP :)

[@mukulgupta7514]

Thanks for making wonderful video's it's help me a lot please make full play list for ABAP

[@thesucofsfather3338]

Thank you so much

[@SoorajSasidharanABAP]

Your welcome :-)

[@MM-bs6bm]

Precise Explained. Subscribed...

[@SoorajSasidharanABAP]

Thanks.. :-)

[@sanjureddy4560]

Thank you Sooraj Sir first i thought that only for select syntax 35 mins like that but after watching the vedio i learned many new functionalities. Thanks alot Sir and if you have time please do on Inner Join if you did already i will check your vedios. Once again thank you Sooraj Sir

[@SoorajSasidharanABAP]

Thanks Sanju.. noted :-)

[@lekshmips8965]

Thank you so much Sooraj for the wonderful session. This is a really useful session.

[@SoorajSasidharanABAP]

Most welcome Lekshmi.. Keep watching..:-)

[@mohammednawazuddin3220]

Hi sooraj , Thank you for making nice video and sharing knowledge with all....Thank you for your efforts...:)

[@SoorajSasidharanABAP]

Thank you Mohammed.. :-)

[@sampadmaity45]

Very much informative.. Please make a video on excel ole object in abap
It will be helpful

[@murari_am]

Yet another informative video! Might have to look one more time.
When you add a new case statement to get a new column like STATUS, would the further Infernal table operation can respond to reading internal table with column STATUS,?

[@jivanbora9862]

Thank you for your efforts. Can you please make a video on loop events?

[@manojmanu7406]

Hi Sooraj ,
you taught us very well, liked the way you explain and that too with new syntax!
have watched many videos, can you make a video on parallel cursor

[@pankajkumaram]

Super Suraj..

[@SoorajSasidharanABAP]

Thank you Pankaj.. :-)

[@mdhamodharam4474]

You are genius in abap

[@SoorajSasidharanABAP]

I'm a normal Abaper.. :-)

[@sanjureddy4560]

@@SoorajSasidharanABAP you are a pro bro in ABAP

[@MarkusDieterle]

Hello Sooraj, great job on providing detailed information about the new features in ABAP.
I would have liked to see a short demo on using more than one condition for filling an additional, inline-defined row for the internal table with the select...case when... statement. I suppose you can use more than one condition there? For example, with the additional final price column, I would like to have a value in there for other currencies than usd. That stuff is pretty handy for a lot of applications...

[@SoorajSasidharanABAP]

Yeah its handy and its possible:-) thanks for your comment:-)

[@AbhishekYadav-qo9fq]

Hey Markus, Yes multiple Case conditions are possible in this way. Select matrn, ersda, mtart, CASE when mtart = 'mat_type' then 'mat_type' end as coulm_name, case when mtart = 'second_mat_type' then 'perform_action' end as column_name

[@nareshnani4444]

More videos on this version sir....

[@TheEnlightened]

Can you please make tutorial of dynamic programming?

[@srivamsiganta5504]

Is it possible to use internal format or external format in the select statement

[@SreejaDeyT]

If there is select-option, what will be the syntax for where clause?

[@snehashriram]

Hi Sooraj, i have one general question, why to use both data elements and domains? Why cant we use only data elements....?please answer

[@thesucofsfather3338]

Please make video about dynamic select syntax

[@SoorajSasidharanABAP]

Noted. :-)

[@prabhakararao8908]

What changes for multi ALV reports in 7.50

[@pradipkesarkar2521]

Great work Sooraj. Can we pass concatenate value in where condition...
Just like object id

[@SoorajSasidharanABAP]

Thanks Pradip.Can u tell me exactly what ur trying to do? Like concatenate 2 fields of a table in the where condition of a select query? Are u trying to do any aggregations while selecting? Aggregations will come in a new video. :-)

[@rajatprajapat3016]

Pls define sql for multiple table🙏

[@PritishTripathy]

Great Video Sooraj. Can You Try Making A Video On Smartforms And Adobeforms?

[@SoorajSasidharanABAP]

Thanks Pritish. Will check:-)

[@PritishTripathy]

@@SoorajSasidharanABAP Is There Any Way To Contact You?

[@kulivamsikrishna]

how to remove preceeding zeros for a specific field in 7.4 syntax

[@meetfarhansaeed]

Dear Sooraj,
As we are using inline declaration of the internal table & it is not creating it with headerline. So how would we declare explicit work area for it?
Great Efforts (Y)

[@SoorajSasidharanABAP]

U may use .. wa like line of itab

[@mankusunil1872]

Please make video on enhancement

[@SoorajSasidharanABAP]

Noted.. :-)

[@vinayramteke4489]

sorry i am posting this here because i dont have your email id. i have a query.
I have a VM (IDES) and i when practice on that, i notice a problem.
when i try using this method
Cl_demo_output (display)
it does not work. it shows the popup...
"Klasse CL_DEMO_OUTPUT does not exist"
then i searched over google and reaslied that this is not a production grade method to display tables.
Can you help me with this?
is ther any standard production grade simple method to display contents of table?
thanks in advance.

[@mdhamodharam4474]

Sooraj can you please tell me how to increase performance in our program

[@SoorajSasidharanABAP]

Which program? I may not get enough time :-)

[@mdhamodharam4474]

I am fresher normal alv reports how to increase performance of our program what and all we need to avoid in our program

[@user-hp8ge4pp9u]

If i could give 100 likes i would give them, thanks.

[@tpshorts8326]

Please do one video on dynamic select query

[@SoorajSasidharanABAP]

Noted Firoz :-)