{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CustomerCreate","Instructions"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"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":"CustomerCreate","index":0,"n_rows":2,"n_cols":54,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["_PMD","KUNNR","VKORG","VTWEG","SPART","KNVV-LOEVM","KNVV-AUFSD","KDGRP","BZIRK","INCO1","INCO2","KNVV-LIFSD","LPRIO","EIKTO","VSBED","KNVV-FAKSD","PERFK","PERRL","WAERS","ZTERM","VKGRP","VKBUR","BOKRE","PRFRE","KABSS","KKBER","KALKS","PLTYP","KVGR1","KVGR2","KVGR3","KVGR4","KVGR5","VWERK","KZAZU","CASSD","AWAHR","RDOFF","PVKSM","VERSG","KONDA","AGREL","KZTLF","UEBTO","UNTTO","AUTLF","UEBTK","ANTLF","PODKZ","PODTG","KURST","MRNKZ","KLABC","KTGRD"]
["Customer 0000763172 has been created for company code 1002 sales area CB01 01 00",4763172,"CB01","01","00",null,"01","7U","DE1021","CPT","ROSEBURG","X0",61,null,"R",null,null,null,"USD","NT30","J02","US92","X","X"," "," ","1",null,null,null,null,null,null,2077,"X"," ","100"," "," ","1"," "," ","C"," "," "," "," ","0"]

{"sheet":"Instructions","index":1,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Start by changing the value in cell A1 on the CustomerCreate tab to the Name of the server to which this tool will connect.  This is how the VBA code knows in which server the data will be loaded and must be the full Description from SAP Logon and not just the 3-character ID of the server.   \n\nWhen trying to update fields that exist in both KNA1 and KNVV, be sure to use the whole name of the field as the column header.  If just the name of the field without the name of the table is supplied then the tool will try to update both fields.  Fields that only exist in KNVV are fine to have just the name of the field as the column header. \n\nFields like AUFSD, LIFSD, FAKSD and LOEVM should be prefixed by \"KNVV-\" so that these are not set in \"All Sales Areas\" fields. \n\nThis tool comes with no warranty, expressed or implied.  Always test thoroughly in a sandbox to ensure that the tool is doing what is desired. "]