can we split database as per Business partner property like NORTH , WEST

[Former Member]

Dear all,

we want to separates users from database means ,

the north region sales executive does not able to read and update sales order as well as business partner of other region.

can we do ? if yes then how?

Thanking you,

Ganesh Mahajan

[Former Member · Accepted solution]

Dear Ganesh,

Do you mean you need to give different users with different authorizations in the same database or you want split it to more dbs?

Thanks,

Gordon

[Former Member · Accepted solution]

Dear sir,

thanks for reply . we want to do this on one database . but other users like north region users do not able to read west region sales order as well as all database which according to related with north.

above is just example it's apply on all modules . like production order etc etc....

Thanking you

Ganesh Mahajan

[Former Member]

Hello,

You should try data ownership Authorization for such type of configuration.

here you set Full Authorization,Read Only and No Authorization for your department employee.

Thanks

Manvendra Singh Niranjan

[Former Member]

Hi,

Restricting sales order can be done by document ownership settings.

Regards

Ravindran Srinivasan

[Former Member]

I agree with Ravindran. Document ownership authorization and exception is the way to go.

[former_member206488]

Hi Mahajan,

you cannot set " north region sales executive does not able to read and update sales order as well as business partner of other region" in sap based on business partner property.

you can try by define authorization for users not able to update sales order.

thanks,

neetu