{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["PlantUpdateRFC","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"PlantUpdateRFC","index":0,"n_rows":1,"n_cols":9,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
[null,"MATNR","WERKS","DISMM","DISPO","MTVFP","STRGR","DISLS","FHORI"]

{"sheet":"Instructions","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["The RFC load tool relies on RFC calls to the server, so ensure that your SAP logon account has the ability to login using RFCs.  \n\nPopulate the MATNR and WERKS fields with the values for the Plant extensions that will be updated.  In the yellow cells of the header row, put the names of the fields as they appear in MARC and/or MBEW.\n\nBlank any headers that are not to be used for the load.  SAP considers blank values to be actual values, so do not leave these headers in place and assume that the values will not be updated if they are blank. \n\nIn the VBA code, populate at least the System, SystemNumber, Client and ApplicationServer values to use when loading (see image to the right).  If the User or Password values are left blank then the software will prompt you for them with the software runs. \n\nOnce all of the data to be loaded is populated in the spreadsheet, click the \"Check\" button.  This will download the tables necessary to ensure that the values provided can be loaded to the Material Master Plant extensions and prepare the data that will be passed to the BAPI in order to update the Material Masters."]
["When all of the Material Master and Plants are highlighted in yellow, the data is ready to be loaded.  Any issues will be explained in the A column next to the Material Master number.\n\nClick the \"Load\" button when satisfied and wait for the run to complete.  Try not to use other Excel spreadsheets as Excel can be easily confused and try to pull data from the wrong spreadsheet.  \n\nIt is possible to have multiple Excel spreadsheets open simultaneously while the load is running, but they must be opened in their own instance of Excel.  Hold down the Alt key immediately after launching a spreadsheet in order to open it in its own instance of Excel. \n\nIf an error occurs that interrupts the load then do not worry.  Just close the open SAP window and click the \"Load\" button again; the tool will pick up where it left off. \n\n* * * Important!!! * * *\nAlways save a snapshot of the data being updated so that a backup is available.  This software is provided for free without warranty (expressed or implied), so there is nobody to hold accountable in the event of an error.  Always test this tool thoroughly in a sandbox before using it in a production system to ensure that it works as desired."]