Skip to Content
0

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

Dec 01, 2017 at 09:50 PM

46

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Inga Babco Dec 04, 2017 at 02:30 PM
1

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"

Share
10 |10000 characters needed characters left characters exceeded