Showing results for 
Search instead for 
Did you mean: 

SAP SD Live figures on spreadsheet

Former Member
0 Kudos


I have searched the forum and found plenty of excel related topics but none that suit my query.

I run a ZMBE report everyday for material figures and export this to excel.

I would like to not have to run this report but instead have a master spreadsheet that updates itself from sap every hour or so automatically. Is this possible using code or queries or anything.

I am a SAP user so have no admin access and I do not have BW logins so cannot use BEXAnalyser, also scripting is not installed.

Any help would be greatly appretiated, if I have not explained myself clearly please feel free to ask questions.


View Entire Topic
Active Contributor
0 Kudos

Dear Ripps12,

Your requirement can be met by updating the Ztable (which is used for the report currently) in background (you can specify the time of the job with the help of functional consultant).

Please check with your technical consultant whether the same can be updated in spreadsheet from time to time.

Thanks & Regards,

Hegal K Charles