Skip to Content
avatar image
Former Member

Define value range against material Type

HI All

I have a requirement .While loading data into MDM.

The material Number should start with 1 if material type is A

The material Number should start with 2 if material type is B....

and so on

If its wrong then it should not allow to upload

Can you please tell me how to do it ?

Regards

sandeep

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 13, 2012 at 11:59 AM

    Hi Sandeep,

    I understand that the data which you are trying to upload into MDM already has the Materials numbers and you want to check if the Material numbers start as per the Material type. i.e if Mat type is "A" then material number should start with one.

    One way to achieve this requirement is to have a workflow in place.

    for thiw you will need to write some validations and use a branch step in the workflow, and if the validation fails attach it to the stop step with roll back option.

    The expression should go something like... if(mat type A and left of mat num is 1 then true else false ) or If(maty type B and left of mat num is 2 then...........

    and workflow would be start-->branch-->stop

    --> Stop(2) (this should have roll back option set)

    Hope this helps.

    Rgds,

    Prasad

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI Sandeep,

      If you need to store Material Numbers in MDM system, then you would need to devise some other approach as suggested by Ganapathi or Rohini. By defining Qualified Range you will be able to store Material Number as "Key Mappings". And these keys will be generated only when you syndicate the records..

      So as a workaround solution(if you would like to implement it), what you can do is to upload your data without Material Numbers and trigger a workflow whenever a record is created(either manually or through Import of data). In workflow, it should syndicate the records to PI system along with Generated Key(basically Material Number). Then PI system should simply paste this file in Inbound port for automatic import of data and using some unique combination of fields(like Material description, Material Type etc) it will update the Material Number for all the records created recently.

      This will ensure that your Material Numbers are maintained based upon Material Types.

      Kindly check if this workaround suits you. Please let me know.

      Otherwise you would have to stick to any of the above suggested solutions i.e. using Validation or Assignments.

      Thanks and Regards,

      Ankush Bhardwaj

  • avatar image
    Former Member
    Sep 13, 2012 at 11:52 AM

    Hi Sandeep,

    Can you please let me know if you want to achieve this requirement using import of data?

    If so then you can achieve this functionality by setting Qualified Range in Remote System.

    You need to create remote system as Inbound/Outbound and have to specify Lookup field that needs to be checked for key generation and also the range for various lookup values.

    You can also check below link for more information:

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40155eaa-6437-2e10-afbc-de54b31329d9?QuickLink=index&overridelayout=true

    Kindly check this and let me know in case of any concerns.

    Thanks and Regards,

    Ankush Bhardwaj

    Add comment
    10|10000 characters needed characters exceeded