cancel
Showing results for 
Search instead for 
Did you mean: 

SAP SD Live figures on spreadsheet

Former Member
0 Kudos
77

Hi

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.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

former_member209761
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

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Hegal, do you have some transaction codes that may be used for this so I can check for access?

former_member209761
Active Contributor
0 Kudos

Dear Ripps12,

As SAP User, i do not think you will be having access.

To Check the program of report : tcode : se38

To check the ztable : se11 or se16n

To set the background job :SM36

Speak with your functional and technical consultants.

Thanks & Regards,

Hegal K Charles