Skip to Content
avatar image
Former Member

Material Master where procuring material from different Vendor

Oct 21, 2016 at 11:49 AM | 300 Views

Dear All,

Need your help!

Our Client is procuring materials like bearings, rollers, Pens(stationary) with different sizes and from different Vendor, Also the vendor price may differ differ as per quality of goods provided by specific vendor. Client also wants to keep stationary in stock with value.

Should I suggest user to create material master based on vendor.

For e.g:

Material Desc. Vendor Price

Bearing1- ABC ABC 10/pc

Bearing2-XYZ XYZ 100/pc

Pen ABC 5/pc

Pilot Pen ABC 100/pc

If I go with this method, moving average price will have small differences

But If I go for info records, then moving average price will have drastic difference.

Material Vendor Price

bearing1 ABC 10/pc

Bearing1 XYZ 100/pc

Also client does not want to go with Spilt Valuation.

Kindly suggest a solution.

Thanks!

MM (Materials Management)
material master
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Oct 25, 2016 at 04:54 PM

    When your same material have different pricing- you need to go for split valuation where based on valuation types for material, you can maintain different price.

    Material--------valuation type------Price

    Bearing--------ZVT1-----------------10

    Bearing--------ZVT2-----------------20

    Or if material subdivided based on characteristic - you can go for batch management.

    OR

    If business not happy with above-You can go for different material code in each case.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    PRASOON AK
    Oct 21, 2016 at 12:16 PM

    Hi,

    I would suggest you to check the below options:

    1. Batch specific valuation - Valuation category X - Refer the help doc:

    http://help.sap.com/saphelp_erp60_sp/helpdata/en/61/969838e914a20de10000009b38f8cf/content.htm

    2. Split Valuation with pre-defined valuation types.

    Regards,

    AKPT

    Add comment
    10|10000 characters needed characters exceeded

    • PRASOON AK Former Member
      Oct 25, 2016 at 04:04 PM

      Hi,

      If you want to valuate the material differently, there should be an option to differentiate the stock. The differntiation can be done with valuation type or batch - This can be achieved with direct split valuation or with batch specific valuation (with batch number as automatic valuation type). You may check whch option you can adopt - but in any case, split valuation is the basic concept!

      If you can not go for split valuation, you may go for different material code!

      Regards,

      AKPT

  • avatar image
    Ankur Chauhan
    Oct 25, 2016 at 09:28 AM

    There is only option for your specific condition split valuation!!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2016 at 06:58 AM

    Hi,

    What is the reason your client doesn't want to use Split Valuation? There is no other solution: split valutation or different material code.

    It will be better if you give them some consultancy and force them to accept the moving price differently. If this is same material, then should not separate material code. You client should compare who is the better supplier...

    Rgds,

    Thuc

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 01, 2016 at 07:42 AM

    Hi,

    Handling different codes for the same material will require more efforts to manage and will cause redundancy of data, that is not a best practice in SAP.

    Att, Leonardo de Freitas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 09:17 AM

    whenever there is difference in price for material from different vendor - split valuation is the best practice to adopt for business process.

    Thanks,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 03, 2016 at 09:12 AM

      Hi Vivek,

      If I go for spilt valuation, I am not able to decide what should be the valuation type.

      It should be based on vendor?