Display SAP Data Tables with SE16N: Demo and Advanced Tips

We can display and extract tables to excel using the SAP Data Browser transaction SE16n which is available in SAP ECC and SAP S4HANA.
This is a full demo on how to use SE16n with tips for beginners and advanced users.
Support the channel and get access to Member exclusive content:
/ @abdullahgalal

[@anitaduunlorentsen4083]

I have used SE16N almost daily since 2019, but still learned something useful from this video. Thank you for sharing! You have good teaching skills. ☺️👍

[@karthickk1944]

@ Abdulla -Really a useful insight video... Wanted to add one more feature - the extended serch option -where the user dont know the table names but can find the tables by merely providing text input with key words which we prefer to look

[@BorisxFRA]

Trop trop fort, Bravo ! Super clair, juste l'essentiel !!

[@kennykeenan648]

Thank you! This was really helpful indeed.

[@tabishalam2087]

Very informative Video. Thanks for making it.

[@Sravanthi1111]

Thanks a lot for this tips, atleast once in a working day I use SE16n, most of the tips I don’t know before

[@AbdullahGalal]

Glad it was helpful!

[@soniakhurana350]

I really amazed to learn all these new tips, never used it before but really helpful.. Thanks AG

[@AbdullahGalal]

Happy to help!

[@deepaksonii6355]

Thanks for the insight Abdul, loved this video,

[@AbdullahGalal]

My pleasure! thank you Deepak

[@TollerZero]

Hello, very useful video with a lot of advanced information. Keep going!

[@AbdullahGalal]

Glad it was helpful!

[@ashishshinde2623]

Really helpful video. 😊 Keep posting such videos regarding SAP FICO with explanation as it helps the beginners to understand more quickly and in better way. Also, videos for gaining mastery in SAP and post videos regarding SAP FICO industry knowledge that every working professional should know. You are a great teacher and personally find your video much helpful so I always keep learning from you. SURELY DESERVES SUBSCRIBE!🎉💯👏

[@mguru1982]

Another great video👍 If feasible, Kindly share a video on basic debugging skills for functional consultants to analyze errors!

[@harsha2081]

This video is really helpful, Thanks for sharing!

[@AbdullahGalal]

You're so welcome!

[@CarlosPilaf70]

HI, good video! on your question on the "Determine number of lines displayed", it is used when you filter in the layout a field, it shows the number of lines filtered; elsewhere, it is shown always the number of lines of the selection.

[@AbdullahGalal]

Thanks for the info! will check that

[@gurudasingale2148]

Very usefull for who are new to SE16N..!!!

[@AbdullahGalal]

I have used it for a loong time, but wasn't aware of some of the options :)

[@saibalu4320]

Thank you very much Abdullah for sharing the Knowledge, I should really appreciate it and i also started following it now after you said :)!!.

[@AbdullahGalal]

It's my pleasure! don't forget to subscribe to support the channel 😉

[@omarkhaled2361]

Great demo thanks for your effort

[@AbdullahGalal]

My pleasure!

[@limilhoon1]

Very very useful. Thanks a lot

[@AbdullahGalal]

Glad it was helpful!

[@coolazay]

Very informative, some of the options were not been used earlier. Suggestion: In SE16H - Hope you cover table join condition option. That actually elimnates the use of SQVI Query option to only fetch data when needed. Waiting for SE16H video. Keep Going. Thank you AG.

[@AbdullahGalal]

Done Azay! check the new SE16H video 😉

[@manojmm2310]

Thank you it is very useful for me many thanks to you

[@AbdullahGalal]

You are most welcome

[@muchipallihemanth5352]

Really wonderful✨😍..

[@AbdullahGalal]

Thank you 😍

[@shoebinamdar]

Great tips 👍

[@AbdullahGalal]

Glad it was helpful!

[@bekilturgut]

GREAT!!

[@GuzinTellioglu]

thanks, its usefull

[@AbdullahGalal]

You're welcome

[@jatinkaneria8477]

most valuable tips

[@AbdullahGalal]

Glad you found them helpful

[@harsha7677]

Thank you for sharing

[@AbdullahGalal]

My pleasure

[@kyawthuaung2258]

Yeah, exactly I'm also still using SE16N. Like VLOOKUP in Excel. I know a lot of powerful functions which can replace with VLOOKUP, but still love to use it.

[@AbdullahGalal]

like our grandparents refusing to use mobile phones 😁

[@Maggie-zz6ds]

Great video! Is there a way to change the key columns? i.e. making the timestamp a "fixed" column after executing.

[@pjatkin98]

I just worked out that the two buttons to the right of the "Get Field" box will allow you to download/upload a text file that contains the sorted fields only. So the process is: 1. Sort the fields as required using the Sort by Field Used button at the top of the screen 2. Download the data you your computer/network 3. You can then upload these sorted fields at a later point

[@rajendrapawar6732]

Ty

[@muhammaddanish9149]

Great sir appreciated kindly make a video on how to create a query report for segment reporting

[@AbdullahGalal]

Good idea, give me more details on the report

[@sivanand.b4474]

This video was highly informative. Thank you🙏 I would request you to make video on functional module se38, debugging skills, idoc . Plz cover these topics for functional consultant s

[@AbdullahGalal]

Will do my best Don't forget to subscribe to the channel 😎

[@sivanand.b4474]

@@AbdullahGalal yeah sure. Thanks

[@user-el6vb4qz9l]

Hi Abdullah, Loving your Videos. Would it be possible to do a video on creating a join on 2 fields where the fields are not the same length eg TIBAN-> BANKN and LFBK -> BANKN.

[@sandeepshetty7639]

Can you pls make a session about basic ABAP like debugging, editing table entries which would be useful for functional consultants

[@AbdullahGalal]

Great idea, thank you Sandeep

[@mohieddin5454]

Salam alikom Abdullah, in technical settings the "Determination displyed lines" means: عدد الصفوف المعروضة. That means you will get new line and new colum at the table End with the Sum of all lines are displyed. السلام عليكم. محي الدين

[@AbdullahGalal]

Thank you! will check that

[@dcdien07]

I join the VLPMA table and the LIPS table but the delivery quantity column does not get the correct result and is always 0. How to handle. Thank

[@prashanthbaligar-jj3it]

I don't have Get Field in my SE16N screen. How to get that in the screen?

[@bekilturgut]

how can I easly extract visible name- technical names combinations of ALL columns in order in sap table - easly to excel ? just the names, technical and nontechnical but I need to pair them as well.

[@anitaduunlorentsen4083]

Great question - I also want to know this. 😊

[@045773]

SE16H is also available in Netweaver, not only S/4HANA.

[@AbdullahGalal]

You mean in ECC? ..on any database?

[@hulkreal6393]

Yes se16h is available in ecc. I use everyday this table

[@slocktv27]

what camera u using for this vidio sir?

[@AbdullahGalal]

Canon 200D with standard Canon zoom lens18 - 55 mm

[@ramchandra-tr9fs]

"get field' option is not showing in sap & menubar also not showing "settings" option

[@user-tu7bp4mv6r]

Hello.very nice video. I am looking for a table where I can see the date when PO was created and the date when it was received. When I want also search by material. Can you help me please. Thanks a lot

[@AbdullahGalal]

Check this finance.utoronto.ca/wp-content/uploads/2015/11/Display-a-list-of-POs-with-Outstanding-GR-or-IR-Converted.pdf

[@baidyanathsahoo6885]

hello, all these additional buttons like sort and undo, they are not available in 1809 i believe

[@OhYeahVN]

i think i had it in 1511

[@abapranger7483]

Hi, could you share us how to develop in BTP, ABAP environment?

[@AbdullahGalal]

Hi, sorry not my area of experience

[@vinodsingh0101]

I am not able to select any field of table . Could you please help me regarding this ?

[@AbdullahGalal]

Give me more details

[@vinodsingh0101]

@@AbdullahGalal Thank you for reply . With Login setting this issue rectified. Thank you so much

[@ahmetkara7157]

i get error message transaction se16n does not exist

[@AbdullahGalal]

Which SAP version do you have

[@haydnrust5266]

i use se16h on sap r3 - not s4 exclusive

[@AbdullahGalal]

really! you must have a Hana database?