NotYet - ooxxvv/MySAPnotes GitHub Wiki
PageOutline {{{#!comment -------------------- 以上的部份是固定的，不要變動 ----- ---------------------------------------- 在建立連結時，請標明連結的頁面類型，例如：wiki:WikiStart，而不要只用 WikiStart ----- }}}
Not Yet
- 還沒時間看，先放在這裡
BASIS
Upload
SAP upload: if you have hundreds of materials to create or to modify, the solutions available are:
* Build a program in ABAP.
* Use one SAP tool called LSMW (Legacy Systems Migration Workbench).
* Use one internal test tool called CATT (Computer Aided Test Tool).
* Use some easy to use third party tools such as ERP² or Qubed from Quadrate,Process Runner, Z Option, EzySolutions from Gesix, WinShuttle, DSM ERP from EPI-USE, or PDM Personal Data Miner for SAP.
* For some business objects, use the SAP mass maintenance transactions such as MASS or MM17
* If SAPGui scripting is enabled, the user can "script" an upload / modify job by looping through say an Excel table with vbscript. See Use_Script_Recording_and_Playback_to_automate_user_updates. Requires a medium level of skill to edit a recorded script
* Use the GUIXT tool from Synactive Inc. with the InputAssistant add-on (expensive!)
Download
To download from SAP to Excel:
* Many SAP reports have direct download function to EXCEL.
* SAP Query and SAP QuickViewer are excellent tools for Downloading (BvdR AO).
* Transaction SE16N allows you to access any sap table and download result to Excel
* SAP RFC functions can be called directly from Excel / VBA.
Use transaction BAPI in SAP to find your business object and study the function.
If you know the SAP table the RFC RFC_READ_TABLE offers a SQL query of the table
Trouble is .. you can not use joins here. you have to put the join in as a query in the SAP database and use the query in RFC_READ_TABLE
To upload data from Excel into SAP:
* Some of the Business functions (BAPI's / RFC unctions) offer data upload
* The general tool in SAP for data upload is the Batch input / call transactions
In the batch input file you specify screen by screen and field by field the input to SAP.
SAP has a recorder to create the sample file. Just run trans SHDB and within this trans you run a case of the changes you want to do. On exit of the trans you will have a batch input file that you can download and from excel manipulate the file before you call the RFC function RFC_CALL_TRANSACTION.
Did I say it was easy ? No , not really , but it's a set of very powerful tools there if you take your time to study them. Our company would not manage without them.