Skip to Content

Restrict items display in Sap business one

Hello guys..

I have a peculiar request from one of my clients.

Is it possible to restrict the list of items based on user?

For example.. I have 3 group of items..

Item group A with item code series A0001

Item group B with item code series B0001

Item group C with item code series C0001

If an user A raise a purchase order.. In row level only item with series A0001 should display...

But currently the system is displaying all the items available in the SAP.

Is it possible to restrict the item list based on users?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 13 at 06:51 AM

    Hi,

    Yes possible by,

    1. Create new user defined (UserCode) field for item group

    2. Add user code in this UDF field for each item group

    3. Run below query and save it under query manager.

    SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0 INNER JOIN OITB T1 ON T0.[ItmsGrpCod] = T1.[ItmsGrpCod] WHERE T1.[U_UserCode] IN ( SELECT INTERNAL_K FROM OUSR T0 WHERE INTERNAL_K = $[User])

    4. Assign query created step 3 into Purchase order item no from user defined values setup.

    5. Click user defined icon to get only items related to assigned item group with user code.

    Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

    • Thanks for your prompt response.

      If I have 3 Logistics users.

      One Log user will use Item code series A0001

      Second Log user will use Item code series B0001

      Third Log user will use Iteem code series C0001

      how to arrive this scenario using your above solution?

  • Jan 19 at 08:41 AM

    Dear Deepak Ramesan,

    You can use below solution, you can set series for the Item master data and in user setup create UDF and Put that series code or Series Name in that UDF.

    On base of that create FMS on item code field to fetch item code which are assigned in User Setup window as below:

    Select ItemCode, ItemName from OITM where Series = (Select U_itemSeries from OUSR Where INTERNAL_K=$[OPOR.UserSign]

    You can modify above as require.

    Hope this will resolved your issue.

    Best Regards,

    Sandesh Shinde

    Add comment
    10|10000 characters needed characters exceeded