Getting queries and inventory status daily

[former_member1306923]

Hi, everyone. I just started working as a inventory executive for my company. There are many tasks I need to do, including daily updating for inventory status, product movement, and etc.

After working for a few weeks, I got a hang of things, and wanted to streamline my work and save time on the manual, repetitive tasks, so I have more time to do other tasks.

Currently, I need to generate queries of my Purchase order from List of PO, Sales Order from the List of SO and then Inventory Status. What my company does is they will copy the whole table, paste it in excel and then do the necessary steps to filter and acquire the data they need.

I was wondering, since I am new to SAP and data on general, are there ways that I can get SAP to automatically generate these excels and save them in .xls format in the server or my computer, so I can link my main excel file to the reports.

[former_member27]

Hi solomon_tyc,

Thank you for visiting SAP Community to get answers to your questions.

As you're looking to get the most out of your community membership, please consider including a profile picture to increase user engagement & additional resources to your reference that can really benefit you:

Please make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

Profile https://developers.sap.com/tutorials/community-profile.html

Tips for Questions: https://community.sap.com/resources/questions-and-answers

Consider taking our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html.

I hope you find this advice useful, and we're happy to have you as part of the SAP Community!

All the best,

Dedi