|
(0021481)
|
|
harikrishnan
|
2009-10-30 09:32
(edited on: 2009-10-30 09:38) |
|
* Short description: Create the format to be able to import the data
* Steps:
o Login with permissions to Master Data Management || Import Data || Import Loader Format
o Click new and fill:
+ Name: Orders
+ Table: I_Order
+ Format: Comma separated
o Move to field format tab and create new records following this:
Name || Column || Data type || Constant value
======================================================================
1.Organization || ad_org_id || Constant || 1000000
2.Warehouse || m_warehouse_id || Constant || warehouse-id
3.Document No || Documentno || String ||
4.Document type|| DocTypeName || String ||
5.Business partner|| bpartnervalue|| String ||
6.Product || Productvalue || String ||
7.Quantity ordered|| Qtyordered || Number ||
8.Price actual || priceactual || Number ||.
9.Currency ID || c_currency_id || String ||
I_Orders.txt should be in the following format:
AA875875875RRTT,Standard Order,bellphone,beer,100,10.5,102
AA875875875RRTT,Standard Order,bellphone,shirts,400,13.4,102
BB7747FFQQ,POS Order,Millman,beer,500,10.6,100
*Go to Import File Loader(Master Data Management || Import Data || Import File Loader || Import File Loader ) and load the above created file (I_Orders.txt) with Format file (Orders).
*Click on OK button,this ll verify the format of the uploading file.
*Click the process button.
Now the Process message is displayed.
|
|