Define value range against material Type

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Ganapathi

Thanks ,I tried the solution but the issue is the data is getting loaded to data manger ,How can i stop loading data to data manager if validation is false

[Former Member · Accepted solution]

Hi Sandeep,

Can you please let us know whether the data load is through Data Manager manually.

If yes, then as Ganapathi suggested, you will need to built up a validation with "Automatic Execution" set to "Error".

In this way, whenever the user will try to input the data, an error message will come and he/she will not be able to proceed further.

Second option is, you can run an assignment in which what you can do is add 1 before the material number if the material type is A and add 2 infront of material number if the material type is B. So automatically, your requirement will be achieved irrespective of  whatever number is populated by the user in the Material Number field.

Hope this helps.

Regards,

Rohini Joshi.

[Former Member · Accepted solution]

Hi Roshini

Thanks for the reply..

atleast can i  set range of values for material type like qualified range .It can automatically generate material number .Please let me know how to do this...

Regards

Sandeep

[Former Member · Accepted solution]

HI Sandeep,

I am saying to run assignment on the Material Number field.

Use the concatanate "&" operator to achieve this.

Suppose the two fields are:

Material Type  which is a look up I suppose and Material Number which is an input field,

then the assignment expression would be like:

If(Material Type[Record]=Material Type[A],"1"&Material Number,If(Material Type[Record]=Material Type[B],"2"&Material Number))

The above expression basically is if the material type is A, then concatenate 1 and the material number say 7734 else if material type is B then concatenate 2 and material number 7734

Result will be:

17734 and 27734 respectively.

Revert back for any queries.

Regards,

Rohini Joshi

[Former Member · Accepted solution]

Hi Rohini

I dont want to concatenate . Actually i have defined qualified value range in remote system for each material type.So when i upload file it has automatically generate material number according the value range provided against material type .

Please help me to do it

Regards

sandeep

[Former Member · Accepted solution]

Hi Sandeep,

I am with Ganapathi on this,it would solve to most extent.

For further you should specify when is the user importing through Data Manager,as an update activity or creation itself is through data Manager.

Please elaborate.

Thanks,

Ravi

[Former Member · Accepted solution]

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

[Former Member]

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-de54b3132...

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

Thanks and Regards,

Ankush Bhardwaj