on 06-25-2013 11:23 AM
Hi Experts,
does anybody know how to set the UoM Group for an item through SAP internal excel import functionality?
Thanks,
Jacqueline
Hi Jacqueline,
I don't see any field in OITM as UoM Group. Could you show where you get it?
Thanks,
Gordon
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Yes. You are correct, this is the new field in OITM and it can be linked with OUGP Uom Group table.
I have verified 9.0 online help, there is no field for UoM Group in the excel.
Also this field is not added in DTW template. (Refer SAP note 1874004)
Better check with SAP support
Thanks & Regards,
Nagarajan
Hi Jacqueline Wutke
Use the Below field for UOM
Unit of Measure for Purchasing - 5 - Alphanumeric
Unit of Measure for Sales - 5 -Alphanumeric
Hope helpful
Regards
Kennedy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please refer complete information:
Preparing a Microsoft Excel Import File for
Items
Field Name | Max. Length | Data Type |
Item No. | 20 | Alphanumeric |
Item Description | 100 | Alphanumeric |
Description in Foreign Lang. | 100 | Alphanumeric |
Group (1) | 20 | Alphanumeric |
Bar Code | 16 | Alphanumeric |
Tax Definition | 1 | Y – Liable to pay tax N – Not liable to pay tax Entries must be upper case. |
Price List Code (3) | 6 | Numeric |
Price in the Price List | 17 | Numeric |
Currency of the Price List | 3 | Alpha (in accordance with the defined currencies in SAP Business One) |
Sales Account | 15 | Alphanumeric |
Expense Account | 15 | Alphanumeric |
Regular Vendor (4) | 20 | Alphanumeric |
Vendor Catalog Number | 17 | Alphanumeric |
Unit of Measure for Purchasing | 5 | Alphanumeric |
Quantity per Purchase Unit | 20 | Numeric |
Unit of Measure for Sales | 5 | Alphanumeric |
Quantity per Sales Unit | 20 | Numeric |
Target Warehouse Inventory in Purchasing Unit | 20 | Numeric |
Minimum Warehouse Inventory | 20 | Numeric |
Purchasing Item (5) | 1 | Y – Yes N – No Entries must be upper case. |
Sales Item (5) | 1 | Y – Yes N – No Entries must be upper case. |
Warehouse Item (5) | 1 | Y – Yes N – No Entries must be upper case. |
Fixed Assets | 1 | Y – Yes N – No Entries must be upper case. |
Brand (6) | 30 | Alphanumeric |
Customs Group (7) | 20 | Alphanumeric |
Sales Factor 1 | 20 | Numeric |
Sales Factor 2 | 20 | Numeric |
Sales Factor 3 | 20 | Numeric |
Sales Factor 4 | 20 | Numeric |
Purchasing Factor 1 | 20 | Numeric |
Purchasing Factor 2 | 20 | Numeric |
Purchasing Factor 3 | 20 | Numeric |
Purchasing Factor 4 | 20 | Numeric |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Naga Rajan,
first of all, it is more than good style to specify the real source of your information.
Here you directly copied from SAP online help http://help.sap.com/saphelp_sbo900/helpdata/en/45/0708c7f61941dee10000000a1553f6/frameset.htm. Please check.
Second, it's essential to consider the concrete version where the issue is reported for, and so to mark for which version 'your' solution is valid for.
This helps maximizing the value and credibility of your response and increases reusability.
Thank you that you have picked out the information.
Regards, Peter
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.