How to deal with SAP tables - PART 1

In this video I want to show You how to deal with SAP tables in case of shell container type.

WATCH NEXT:

TIME STAMPS:
0:00 Intro
1:10 SAP table
2:08 Script recording
3:15 VBS
6:15 VBA editor
10:10 Create array with column names
11:49 Count rows & create SAP array from SAP table
14:04 Summary
16:33 Stay tuned for next SAP table video!
17:05 Leave a like & subscribe!

MY EQUIPMENT:

FREE TubeBuddy 30-DAYS TRIAL:

SHOP

SITE & SOCIALS:

CONTACT:

Don't forget to leave like and subscribe to my channel, it means a lot to me :)

DISCLAIMER: Links included in this description might be affiliate links. If you purchase a product or service with the links that I provide I may receive a small commission. There is no additional charge to you! Thank you for supporting my channel so I can continue to create and provide more content for You!

[athanasiosnestoras]

Hi thank you so much for your help! It's really nice that I see that many more people into excel & Sap collaboration. May I ask which references do you use? My excel doesn't read the table as an object, I actually get errors and straggling to pull up details from the tables.

[MKEWSH]

Awesome stuff! Question for you, when adding to my watch window, I don’t have the ColumnOrder displayed. I have a Columns option, where I can expand and ultimately find Columns.Count property as well as a Columns.Item(row #goes here).Title

I can’t seem to get the nested for loop part to work though. Specifically, the getcellvalue line. I added the SAP GUI scripting API reference already, so it should work, but it’s saying the object doesn’t support this properly or method. When I hover my cursor over the colOrd_arr(j), it displays the correct value for j

Any thoughts? Looking forward to part 2! Love your SAP scripting videos

[ridanaeem]

Hey, thank you for the help. I have a question. I have a SAP Hierarchy view and can't find rows. How to get data from such type of Hierarchical tables using VBA ?

[nburaq]

Thanks for this great tutorial it was really helpful! However I have two question regarding tables;
1. Is there any option running script not via excel interface but from playback option in SAP? In general, I use excel file just for the data to be transferred to sap not for login sessions etc..then coding part becomes really easier
2.Is it possible to run loops to check and fill a value if the cell in sap is not correct? It will check every row and specific cell and then if it does not match the value stored in excel file then it will paste that value from excel to SAP.
Again thanks a lot for hardwork!

[蘇禾傑]

Thank you so much, it is very helpful for me.But when I run the code to fetch data from SAP, I find a problem.If the table.RowCount>110, I can not get the values of the cells.It return empty.So I can not fetch all the data from SAP to Excel.I have try to serach the problem by Google, but I do not get useful infomation.Could you help me to resolve this problem.Thank you a lot.

[robin]

Thank you for you work! Its really help me a lot :з
Btw do you know is it possible to make an Excel macro which will be automatic updates data from the SAP table from time-to-time (for example once a week \ day)
Or we need to open Excel-file and run macro manually anyway? (Or perhaps we can use other languages script to RUN Excel macro which will RUN SAP and updates the data :D ?)