{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CustomerPartnerFunctions","Instructions"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"CustomerPartnerFunctions","index":0,"n_rows":1,"n_cols":8,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Q01","KUNNR","VKORG","VTWEG","SPART","PARVW","KTONR","XDELE"]

{"sheet":"Instructions","index":1,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["This is a very simple tool for adding or removing Partner Functions in Customer Masters.  Please always test this tool first in a sandbox system to ensure that it is working properly for you.\n\nWhen adding, the code does not bother to check if the Partner Function already exists, but instead simply attempts to add it and then capture the error messages when that add fails.  Failure to add Partner Functions can be the result of that Partner already existing in the list, the Partner not existing in the SAP system or another problem like the Customer Master Type not being configured for the Partner Function type in the config table TPAKD.\n\nWhen deleting the Partner Functions, the code steps through every line of the list of Partner Functions searching for the combination of PARVW and KTONR to delete and, when found, selects that line, presses the Delete Row button and then clicks the Save button.  This isn't the fastest code, but it is thorough. \n\nIf there is an SLT server (or SAP Replicator--see http://saplsmw.com/replicator for details) then this snippet of SQL code below can be used to copy the Partner Functions from one system to another.  This produces a load file that can be pasted into this tool and, if necessary, doctored to perform mass deletes.\n\nThis tool comes with no warranty expressed or implied.  It is free to use, change or modify for personal and commercial purposes. "]
["\nselect KUNNR,VKORG,VTWEG,SPART,\n  case \n    when PARVW = 'WE' then 'SH'\n    when PARVW = 'RE' then 'BP'\n    when PARVW = 'RG' then 'PY'\n    when PARVW = 'AG' then 'SP'\n\telse KNVP.PARVW\n  end as PARVW,\n  case\n    when KUNN2 ='' then KNVP.LIFNR\n\telse KNVP.KUNN2\n  end as KTONR\n from dgSAP_PBC_528.dbo.KNVP\n where kunnr in (\n'0014622799',\n'0029126213',\n'0039126235'\n) "]