FAQ: PM/CS Upload/Download Options
Please contribute.
Legacy System Migration Workbench
TCode: LSMW
CATTs
TCode: SCAT, SECAT
PM Upload/Download
TCode: IBIP
See OSS Note 583698 and 38300 for details
SAP GUI Scripting
TCode: N/A
Microsoft Visual Basic
You can use VB in Access and Excel to pull data from R/3. These scripts can call standard RFCs/BAPIs to retreive the data, then use them in the standard Access/Excel applications to create forms, charts, queries, reports, etc.
IDOCs
TCode: WEDI, WE30, IORD, INOT
Standard Reports & ALV Grids
TCode: Multiple e.g. IW73
Download to MS Excel, Access, Word etc
ABAP program
TCode: SE38
QuickView & SAP Query
TCode: SQVI, SQ01, SQ02
SAP Lumira
http://scn.sap.com/community/lumira
SAP Predictive Analysis
http://scn.sap.com/community/predictive-analysis
3rd Party Tools
Thanks for sharing. I did not know that we can use VB in Access/Excel to call BAPI directly. This might become a way to generate status reports from SAP data (like post go-live matrix)