Skip to Content
author's profile photo Former Member
Former Member

Equivalent Material Code

Hi All,

We have one requirement as follows.

Technically materials are same. But it has different code and descriptions. When we check the material system should show other material in stock.

Example:

We have material X, Y Z

These materials are technically same specification. But It has different material codes.

When we check Material X in system, if not in stock, immediately system should show other stock Y & Z material if stock available.

how do we do in standard configuration?

thanks

Swathi

Add comment
10|10000 characters needed characters exceeded

13 Answers

  • Posted on Jul 10, 2016 at 06:01 PM

    Hi,

    As material is same and specifications are different- Better go for ONE material code creation and then go for Split valuation( keep 3 valuation types which you procure from different 3 vendors from market) or for Batch Management( have 3 batches for different specifications.

    Regards,

    Biju K

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      All you need to activate batch at either plant level or material level or client level. Once it is activated any of these level can't be modified ( careful observation is needed )

      Create class using T code: CL01:

      Material 1 = X1

      Material 2 = Y1

      Material 3 = Z1

      Class Type: 001 (Material Class)

      Enter the Class and the Class type, choose and enter the details by maintaining other tabs:

      Basic data, Keywords, Char , Texts, Document, Std

      and save it.

      After that,

      Material Master Creation:

      By using MM01,

      Classification screen, enter class 'X1' input field class and choose enter.

      choose save.

      Classification screen, enter class 'Y1' input field class and choose enter.

      Choose save.


      Classification screen, enter class 'Z1' input field class and choose enter.

      choose save.

      Thanks,

      Vivek

  • Posted on Jul 07, 2016 at 08:54 AM

    Hi Swathi,

    You can try this approach.

    1. Add a field in Material Master to keep Primary Material Code in subordinate materials.

    ( Primary material: X, then material Y & Z will keep X in material master)

    2. Customized Stock report to get stock from X, if zero stock, read stock from Y & Z.

    Regards,

    Bisweswar

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2016 at 08:56 AM

    Hi, in sap normally materials are classified based upon the Material type / material group . If materials are to be with Physical property differences or any such , classification based differenciation or variant configuration is used . since your materials are not having any such differentiation shown in SAP , std sap is not offering any std report . You will have to jave common property identified the group of the materials which you have with slight varination ( the variation can be on based upon say density --- Hydrochloric acid --- density 01 and another material HCL of density 03 ETC ) and this has to be mentioned in the system in any of the field .The you can write a program to fetch the stock data of such grouped materials . Better have a classification assigned http://scn.sap.com/docs/DOC-25224 then plan for a report alternatively maintain that difference in any of the un used fields and fetch the data based upon the tables like MARC/MARD etc . Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2016 at 09:00 AM

    What is the reason for having 3 material codes for the same specification? Can't you just delete 2 and continue with 1?

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 07, 2016 at 09:31 AM

    Hi Swathi,

    In SAP Standard process its not possible, but somehow you can achieve it through batch management.

    Maintain the same batch number for material X,Y & Z. run the code BMBC, through this report you can extract the materials with same batch. after that you can check whether you want to procure/ Issue.

    Thanks & regards,

    Ankur Chauhan

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 07, 2016 at 12:03 PM

    Hi Swathi,

    Standard report don't have the option. Best way to discuss with abaper in order to develop a Customized Z Report.

    Thanks,

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 08, 2016 at 12:51 PM

    This is the case of Material determination(substitution) in Sales & Distribution.

    Add comment
    10|10000 characters needed characters exceeded

    • Radheshyam P wrote:

      This is the case of Material determination(substitution) in Sales & Distribution.

      I feel this is rather the case of a super dumb unreasonable requirement.

      "For safer side", seriously? What's so safe about it? Is 3 a magic number? Why not create 1003 material numbers then? To be even safer.

      You can totally procure the same exact material number from any number of vendors. The business will run even "smoother" and, you know, Simpler.

  • Posted on Jul 09, 2016 at 03:59 AM

    Hi Swathi,

    The standard Stock reports MMBE and MB52 are straight forward. You get stock for what you provide in selection screen.

    From your comments it appears that the materials in question are alternate materials in BOM and if that is the case it is a valid scenario. Reason can be many like price, quality and availability from vendor.

    However, your exact requirement cannot be met via standard reports. Best Standard Option would be to use MB52 report and filter it by using Material Type and Material Group in the scope of list and select No zero Stock Lines. Something like this.

    Regards,

    Niranjan


    pastedImage_5.png (24.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 10, 2016 at 03:02 PM

    Hi All,

    What I can understand from Swathi's question is - those 3 are different materials indeed BUT one can substitute the other in Production. So.. when Material A is not in stock, they want the system to suggest the stock of Material B and C and thereby they can use the available ones in Production.

    Is it right Swathi?

    If so, go for a custom report with these 3 Material codes in discussion with the Abaper !

    Regards,

    NR

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 11, 2016 at 03:05 PM

    Hi Swathi,

    Logically there is no need to keep multiple material codes in system. However, if you want to continue with this process I would suggest you to keep the materials in separate logical storage locations.

    Mat 1 -- Sloc1

    Mat 2 -- Sloc 2

    Similarly.

    So if user have used all the stock of Mat1 from SLoc1 he may swtich to Mat2 of Sloc2 .

    Rgds,

    Add comment
    10|10000 characters needed characters exceeded