The recommended approach for Accountants with limited IT support to access SAP tables or direct connectivity data is to manage secondary data using folders.
Secondary data are information extracted from another location such as SAP, bank statement downloads, accounting software or websites.
SAP transaction that helps in bringing data efficiently includes GD12 formerly known as 2KEE and FBL3N. Just to name a few as there are more SAP t-code that can help in building your data set for analysis.
On periodic basis, new data can be added to the same folder as long as the format are consistent.
You power query editor can be setup to allow seamless refresh of new data, making sure the effort spent during original setup represent 90% of final build.
Wish you good luck in using folders as your data warehouse.
