Part List Creation

I have part list in xls fromat downloaded from SAP. How to upload it in JDE enterperise one

Can you clarify a little bit please.
What Release and Version?
Do you want to import only one work order parts list at the time? Or you need to import many?

Depending of your version, you can import parts by Copy/Paste or Import into a Work order parts.
Otherwise, there is no inbound available for WO Parts list, but only for Item Bill of material. If somebody know about a WO parts list inbound, please tell me!!!

I assume you mean items (SKU:s) into JDE item master and item branch tables (F4101, F4102) and not parts list to work orders?

Import you records into P4101Z1 (add new import batch document)
You need to do some mapping beforehand so the excel file has all the required columns in correct order.

Set values for first two columns to indicate whether you're importing item master or item branch records and if the records are for Add or change

then run R4101Z1I to import the updates into item master / item branch


Hope this helps
/Aarto

We cloned P13017 to upload Equipment Parts List directly (no Z files used) into F13017. As I don't know your release, I've attached the 8.10 version