{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Intro","Read Me First","EXEC_DATA","MRP_RECORDS","HIDDEN_DATA"],"not_rendered":{"charts":0,"images":8,"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":"Intro","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[[18,2,18,12],[14,2,14,11],[12,2,12,12],[16,2,16,12]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"If you find this upload facility useful and / or enjoy our SAP S/4HANA Cloud Knowledge Snippets, #S4HCKS then please support the channel by subscribing to it (it's free!). \nThank you."]
[]
[null,null,"SAP S/4HANA Cloud Knowledge Snippets on Youtube"]
[]
[null,null,"For Support / Questions / Requests on this tool, then please submit them in the comment question of the video on YouTube --> "]
[]
[null,null,"Disclaimer : This tool is provided as-is. Use it at your own risk. Make sure you thoroughly test it in your Q system first before using it in your P system. It is a clear recommendation to first do a test on a small data set first. This tool will not do any data validation on the data entered, so you need to make sure that the data entered is valid for your system."]

{"sheet":"Read Me First","index":1,"n_rows":79,"n_cols":13,"rows_kept":79,"cut":false,"hidden":false,"merged":[[78,1,78,4],[79,1,79,10],[31,1,31,4],[32,1,32,10],[48,1,48,4],[49,1,49,10],[18,1,18,10],[3,12,3,15],[4,12,4,21],[6,12,6,19],[14,12,15,19],[18,12,18,19],[3,1,3,4],[4,1,4,10],[6,1,6,10],[15,1,15,4],[16,1,16,10]]}
[null,"Basic Help"]
[]
[]
[null,"MRP Area Records",null,null,null,null,null,null,null,null,null,null,"Getting Started"]
[]
[]
[null,"In the MRP_RECORDS tab, you will need to enter the data that you intend to upload via this excel?API capability. The first line of this tab shows the name of the fields that are available, as you might see them in the UI. The second line shows the name of the field, as it is used in the API.",null,null,null,null,null,null,null,null,null,null,"1) Go to the tab named EXEC_DATA and enter your SAP S/4HANA Cloud System ID, the name of the communication user and password, to use to connect to your SAP S/4HANA Cloud System."]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"2) Go to the tab named MRP_RECORDS and enter the data combinations you wish to upload to your system."]
[null,"Processing Mode"]
[]
[]
[null,"You can use this Excel/API capability to create or update MRP area records. You can create and update records in the same session (there is no need to process them seperately). The processing mode is a mandatory field as it will dictate the type of CRUD operation that will be called. I.e will it be a Create (POST) or Update (Patch) call.",null,null,null,null,null,null,null,null,null,null,"3) When you are ready to upload your data to your SAP S/4HANA Cloud System, go back to the tab named EXEC_DATA, and click the buttom named Process MRP Areas."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"In the next sections, a mapping of the UI field to API field mapping is shown."]
[]
[null,"MRP Record Header Data"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MRP 1 View"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"MRP 2 View"]

{"sheet":"EXEC_DATA","index":2,"n_rows":14,"n_cols":9,"rows_kept":14,"cut":false,"hidden":false,"merged":[[5,7,6,8],[9,6,9,8],[11,6,11,8],[13,6,13,8],[5,6,6,6]]}
[]
[null,"SAP S/4HANA Cloud - MRP Area API"]
[]
[]
[null,"General Information",null,null,null,null,"Upload Status"]
[null,"S/4HANA Cloud System ID","myXXXXXX",null,null,null,"Total\nRecords",{"$f":"COUNTA(MRP_RECORDS!A:A)-2","v":2}]
[null,"Communication User","YOUR_COMM_USER_ID"]
[null,"Comm. User Password","YOUR_PASSWORD_SECRET"]
[null,"X-Csrf Token",null,null,null,null,"Created",{"$f":"(I9/H6)*75","v":0},{"$f":"COUNTIFS(MRP_RECORDS!D:D,\"Record Create ok - Return Code: 201\")","v":0}]
[null,"Show the xml Payload","No",null,null,null,{"$f":"REPT(\"|\",H9)","v":""}]
[null,"Show the Server Response","No",null,null,null,"Updated",{"$f":"(I11/H6)*75","v":0},{"$f":"COUNTIFS(MRP_RECORDS!D:D,\"Record Update ok - Return Code: 204\")","v":0}]
[null,null,null,null,null,null,{"$f":"REPT(\"|\",H11)","v":""}]
[null,null,null,null,null,null,"Errors",{"$f":"(I13/H6)*75","v":0},{"$f":"COUNTIFS(MRP_RECORDS!D:D,\"Processing error - Return Code: 400\")","v":0}]
[null,null,null,null,null,null,{"$f":"REPT(\"|\",H13)","v":""}]

{"sheet":"MRP_RECORDS","index":3,"n_rows":4,"n_cols":47,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Product","Plant","MRPArea","Result","Create / Update","MRPType","MRPResponsible","LotSizingProcedure","ProcurementSubType","DfltStorageLocationExtProcmt","SafetyStockQuantity","MRPGroup","LotSizeRoundingQuantity","MinimumLotSizeQuantity","MaximumLotSizeQuantity","MaximumStockQuantity","FixedLotSizeQuantity","PlannedDeliveryDurationInDays","IsPlannedDeliveryTime",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"xml Payload In","Server Response"]
["Material / Product","Plant","MRP Area",null,"[C] or [U]","MRP Type","MRP Controller","Lot Sizing Procedure","Special Procurement","Storage Loc. For EP","Safety Stock","MRP Group","Roundng Value","Minimum Lot Size","Maximum Lot Size","Maximum Stock Level","Fixed Lot Size","Planned Deliv. Time","Consider Planned Delivery Time"]
["MRPAREA_01",1710,"KANBAN1710",null,"U","PD","PRE","EX",null,"171E",20]
["MRPAREA_11",1710,"KANBAN1710",null,"C","PD","PRE","EX",45,"171E",20]

{"sheet":"HIDDEN_DATA","index":4,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
["Payload1","<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<entry xml:base=\"/sap/opu/odata/sap/API_PRODUCT_SRV/A_ProductPlantMRPArea/\" xmlns=\"http://www.w3.org/2005/Atom\" xmlns:m=\"http://schemas.microsoft.com/ado/2007/08/dataservices/metadata\" xmlns:d=\"http://schemas.microsoft.com/ado/2007/08/dataservices\">\n    <link href=\"A_ProductPlantMRPArea\" rel=\"edit\" title=\"A_ProductPlantMRPAreaType\"/>\n    <content type=\"application/xml\">\n        <m:properties>"]
["Payload99","        </m:properties>\n    </content>\n</entry>\""]
[]
["PingUrl","https://XXXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/API_PRODUCT_SRV/A_ProductPlantMRPArea?$top=1"]
["CustPingUrl"]
["FullLoadUrl","https://XXXXXXXX-api.s4hana.ondemand.com/sap/opu/odata/sap/API_PRODUCT_SRV/A_ProductPlantMRPArea"]
["CustFullLoadUrl"]
[]
["UserChoices","Yes"]
[null,"No"]