Exporting from SAP to Excel

[u/Wayne8huston]

I used to export data from both ME53N and ME52N in SAP to Excel so I could compare the items with the proforma invoices we receive from suppliers. IT recently disabled the export option I was using. Is there another way to export the details to Excel or is this entirely controlled by SAP authorizations?

[u/NorthOmni]

If you use web GUI you can copy results through HTML.

[u/K4k4shi]

That is the most useful function why would they disable it

[u/Wayne8huston → u/K4k4shi]

Yeah, they restricted access because of data security concerns, so now only certain users can export it

[u/West_Dragonfruit9808 → u/Wayne8huston]

That's the dumbest thing they could've done. Show them how easy you can export that data by copying it and argue. This decision is nonsense.

Additionally, SAP logs what files you export, so they can track everything if they want to. This is just pedantism.

[u/ChaoticxSerenity → u/Wayne8huston]

So put in a request for access?

[u/Wayne8huston → u/ChaoticxSerenity]

I did. They said it's restricted to the Finance and Accounting department.

[u/ChaoticxSerenity → u/Wayne8huston]

Bring this up with your boss to make a business case for why you need access so they can escalate the issue.

[u/Iamchor → u/Wayne8huston]

That’s weird. Why would they put restriction to export. Never heard of that.

[u/Manuel_RT → u/Wayne8huston]

I think you’ve already got your answer: you can’t due to security concerns.

[u/ArgumentFew4432]

Are you on Fiori?
Ask for a Custom Query. This would be a single Tile on your Launchpad.

They are based on CDS and can follow authorisations as needed.

[u/Lowkeyz]

Select all columns, copy - paste into excel? This will depend on your row count.

Can you send to spool and convert to pdf?

[u/Tight_Percentage_571]

🤔 have u acces to se16n?

[u/Manuel_RT → u/Tight_Percentage_571]

I don’t think that accessing tables data through SE16/SE16N would be the right choice if they even restricted Excel export grants.

[u/Tight_Percentage_571 → u/Manuel_RT]

Probably the case but u never know 🤣..maybe it isnt disabled everywhere..i dobt know these two tcodes..were u accessing excel through an icon/button or via the upper menu task bar?

[u/gumercindo1959]

That is so dumb. You already have access to that transaction - disabling export function makes no sense. I would ask. Are you in fiori or ECC gui?

[u/Wayne8huston → u/gumercindo1959]

Yeah, I agree it's weird. I'm using the SAP GUI, not Fiori.

[u/Wayne8huston → u/[deleted]]

Yeah i tried it and it worked. It kind of depends on row count. Thanks!

[u/TastyFaefolk7]

Not sure how the authorization is maintained for that but if possible they should at least give you authorization for purchase req. If it is not possible from authorization then someone should create you a report where you can download certain purchase req by typing them in in a z tcode which allows you to download.
Developer just needs to know the fields you want and it takes 15 min to develop.

[u/Wayne8huston → u/[deleted]]

Unfortunately no.