Display SAP Data Tables with SE16N: Demo and Advanced Tips
Vložit
- čas přidán 13. 07. 2024
- 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
@ 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
Trop trop fort, Bravo ! Super clair, juste l'essentiel !!
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. ☺️👍
Thank you! This was really helpful indeed.
Thanks a lot for this tips, atleast once in a working day I use SE16n, most of the tips I don’t know before
Glad it was helpful!
Very informative Video. Thanks for making it.
I really amazed to learn all these new tips, never used it before but really helpful.. Thanks AG
Happy to help!
Hello, very useful video with a lot of advanced information. Keep going!
Glad it was helpful!
Thanks for the insight Abdul, loved this video,
My pleasure! thank you Deepak
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!🎉💯👏
Another great video👍
If feasible, Kindly share a video on basic debugging skills for functional consultants to analyze errors!
This video is really helpful, Thanks for sharing!
You're so welcome!
Very usefull for who are new to SE16N..!!!
I have used it for a loong time, but wasn't aware of some of the options :)
Thank you very much Abdullah for sharing the Knowledge, I should really appreciate it and i also started following it now after you said :)!!.
It's my pleasure! don't forget to subscribe to support the channel 😉
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.
Thanks for the info! will check that
Great demo thanks for your effort
My pleasure!
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
Very very useful. Thanks a lot
Glad it was helpful!
Thank you it is very useful for me many thanks to you
You are most welcome
GREAT!!
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.
Done Azay! check the new SE16H video 😉
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.
like our grandparents refusing to use mobile phones 😁
thanks, its usefull
You're welcome
most valuable tips
Glad you found them helpful
Great tips 👍
Glad it was helpful!
Thank you for sharing
My pleasure
Really wonderful✨😍..
Thank you 😍
Ty
Great video! Is there a way to change the key columns? i.e. making the timestamp a "fixed" column after executing.
Great sir appreciated kindly make a video on how to create a query report for segment reporting
Good idea, give me more details on the report
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
Will do my best
Don't forget to subscribe to the channel 😎
@@AbdullahGalal yeah sure. Thanks
Can you pls make a session about basic ABAP like debugging, editing table entries which would be useful for functional consultants
Great idea, thank you Sandeep
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. السلام عليكم. محي الدين
Thank you! will check that
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.
SE16H is also available in Netweaver, not only S/4HANA.
You mean in ECC? ..on any database?
Yes se16h is available in ecc. I use everyday this table
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
I don't have Get Field in my SE16N screen. How to get that in the screen?
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.
Great question - I also want to know this. 😊
"get field' option is not showing in sap & menubar also not showing "settings" option
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
Check this finance.utoronto.ca/wp-content/uploads/2015/11/Display-a-list-of-POs-with-Outstanding-GR-or-IR-Converted.pdf
what camera u using for this vidio sir?
Canon 200D with standard Canon zoom lens18 - 55 mm
hello, all these additional buttons like sort and undo, they are not available in 1809 i believe
i think i had it in 1511
Hi, could you share us how to develop in BTP, ABAP environment?
Hi, sorry not my area of experience
I am not able to select any field of table . Could you please help me regarding this ?
Give me more details
@@AbdullahGalal Thank you for reply . With Login setting this issue rectified. Thank you so much
i get error message transaction se16n does not exist
Which SAP version do you have
i use se16h on sap r3 - not s4 exclusive
really! you must have a Hana database?