Skip to Content
avatar image
Former Member

Customer material info record - one to many connection

Hi friends.

I want to post one customer material to much more than one SAP material number (one to many) and get an error message.

can I adjust system to allow one to many connection?

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 12, 2008 at 04:33 AM

    My understanding of your requirement is as under, which I am elustrating with an example:

    Customer A - Material A - Customer Material code Z

    Customer A - Material B - Customer Material code Z

    Customer A - Material C - Customer Material code Z

    The above is not allowed in Standard SAP. It is one to one relationship and does not allows one to many.

    Regards,

    Rajesh Banka

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 11, 2008 at 11:38 AM

    Your query is not clear could you please mention it clearly?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      With standard transaction code VD51 it is not possible.

      You may try to clone the program-table that belongs to VD51, and you can try to add an additional field division as primary key.

      In this case, the materials 123, 456 and 789 should belong to different division.

      Then you can have the same customer-material number for these material numbers.

      But I think unless there is a very real need for this, business wont go for this option.

      In our business we added specification and revision fields by copying the standard VD52 table and added some customized codes to our Z-transaction code.

      Regards

  • avatar image
    Former Member
    Sep 11, 2008 at 06:21 PM

    Hi

    This is 100% impossible. There should be atleast a little difference.

    Thanks,

    Ravi

    Add comment
    10|10000 characters needed characters exceeded