Idoc views updation, Workflow, Performance tuning techniques!

[former_member498903]

Hello,

Greetings for the Day!

Currently my client is facing following issues and they seek an help/attention to these issues. Following is the current landscape of an client.

Sector – Mining

SAP NW MDM 7.1 SP 09

SAP ECC EHP 5

SAP PI 7.0

List of Issues:

1. Classification (CLFMAS idoc) and Quality (MATQM idoc) views tries to update before MATMAS idoc updates and creates the material in ECC table.
2. At workflow level, how to assign incoming record approval request, put them in mask like functionality and approve them as bulk records.
3. Performance tuning techniques.

Issue description:

1. Classification (CLFMAS idoc) and Quality (MATQM idoc) views tries to update before MATMAS idoc updates and creates the material in a table.

Currently, client’s MATMAS idoc updates Basic data1 and Basic data2 along with other views and material gets updated in ECC table, but whenever record has classification and quality view to update via CLFMAS and MATQM idoc, these 2 idocs tries to search the material ECC table before respective MATMAS to update the table. As it does not have the basic data created for the material entire idoc fails. Kindly suggest the solution as in how we can align the process where classification and quality view will get update only after the basic data views gets updated to material master. Is there any way we can make views to be updated sequentially?

1. At workflow level, how to assign incoming record approval request, put them in mask like functionality and approve them as bulk records.

Currently, super users are configured within the system, they have 2 roles assigned to their ID’s, 1.custodian and 2.steward. In custodian role user assigns the MDM material number and check other relevant assignment to record creation request, user approves the material request and the request goes to steward role. As the 1 user has 2 roles, same user need not to checks everything again in steward role, hence user wants whatever request comes at steward user inbox, he shall be able to create one single group for those 20-30 records and on one single click entire materials shall be approved and disappear out of his workflow level. Is there any way by which it can be achieved.

1. Performance tuning techniques.

Currently, client MDM system response time is very very slow, after a single click of action it takes long time to reflect the action within MDM. Material database is almost around 2.5 lakh records, standard structure has been used, not a complex landscape structure. Both ECC and MDM server is on single hardware, only the logical separate DB. Kindly suggest performance techniques if any.

Kindly suggest !

Regards,

Neil

[former_member498903]

Hello Experts,

Greetings for the day!

kindly guide me on the above issue, I consider there would be some solution on these issues.

Thanks in Advance!

Regards,

Neil

[former_member226173]

Hi Niel,

Kindly try the below options

-> Performance tuning techniques.

SAP Recommendation is to put the application ,server and Database in different Boxes . I am not sure how you managed to install both MDM and ECC in the same box but that is a big NO NO .

Make sure there is enough hardware support for a separate MDM box.

-> Classification (CLFMAS idoc) and Quality (MATQM idoc) views tries to update before MATMAS idoc updates and creates the material in a table.

MDM only sends out an XML file , so you definitely need a middle ware (PI) to do the conversion.

You can use PI logic ( ccBPM) to sent the IDOC is the necessary sequence .

Else you can maintain this logic in the Processing code of ECC system .

PS : The PI option is more recommended.

Regards,

Vag VIgnesh Shenoy