Service Call should not Access from various location

[Former Member]

Dear All,

     If one location creating new service call, it should not open or edit other location, but currently able to access or edit. . Can you please provide any query or stored procedure to stop accessing to other location...

Regards

Mohamed Yousuf Ali M I

[Former Member · Accepted solution]

Hi Nagarajan,

     Can you please help me..

[former_member197621 · Accepted solution]

Hi Yousuf,

For you requirement you have 2 solution,

1. Create Numbering series Branch wise and assign different Group then control it through Authorization.

2. You can control through Stored Procedure. Try this below stored procedure.

if @object_type ='191' and (@transaction_type ='A' or @transaction_type ='U')    
   begin
        if  exists(Select distinct 'Error' from OSCL C1 inner join OUSR C2 on c1.userSign2 = c2.userid
  inner join OUSR C3 on c3.Branch <> c2.Branch and c1.userSign = c3.USERID
  where C1.callid = @list_of_cols_val_tab_del)
          begin

  SET @error = 19100
  SET @error_message = 'You are not linked to this service call Branch...'

       end
end

[Former Member · Accepted solution]

Hi Prasana,

     Working on it Thank You

[kothandaraman_nagarajan]

Hi,

It may not be possible in standard SAP.

Thanks & Regards,

Nagarajan

[Former Member]

Dear Mohamed,

Using SP_TN may block user editing service call. However, I don't think you can prevent user to open the call if they are authorized user to create a service call.

Thanks,

Gordon

[Former Member]

Hi Gordon Du,

     Can you Please provide SP blocking user Editing Service Call??