Skip to Content
avatar image
Former Member

You cannot delete layout set if used as default for users and/or Business Partners.

Hello,

I am attempting to delete some old layouts from the system however I am getting this error message. You cannot delete layout set if used as default for users and/or Business Partners.I need to find out what Business partners and or users these are defaulted to. I am not having any luck getting this information out of SAP in the form of a query. Other threads referenced a query, however, those tables are not present in SAP 9.2. Can anyone let me know what tables this information resides in now?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 04, 2017 at 02:30 PM

    SELECT T0."DoumntDode", T0."UserId", T1.U_NAME, T0."CardCode", T3."CardName", T0."DfltReport" ,T2."DocName", T0."DfltSeq", T0.TYPE

    from RDFL T0

    LEFT JOIN OUSR T1 ON T0."UserId" = T1.USERID

    LEFT JOIN RDOC T2 ON T0."DfltReport" = T2."DocCode"

    LEFT JOIN OCRD T3 ON T0."CardCode" = T3."CardCode"

    Add comment
    10|10000 characters needed characters exceeded