Is there a way to find out which PLD is tied to which BP code

[Former Member]

Hi, is there a way to find out which PLD is tied to which BP code?

Maybe in the DB table that stores the PLD?

Thanks.

[kvbalakumar · Accepted solution]

Hi Joyce,

Try this query

Select
                T1.Name [Document], 
                T2.DocName [Layout], 
                Case
                                When  T0.CardCode in (Select CardCode from OCRD)
                                Then T0.CardCode
                                Else ''/* will be blank when not assign to a specific BP*/
                                End [Business Partner],
                Case
                                When USERID in (Select Internal_K from OUSR)
                                Then (Select U_Name FROM OUSR Where Internal_K = T0.UserId)
                                Else ''/* Will be blank when not assign to a specific user*/
                                End [User]
           from

                RDFL T0 
                inner Join
                RTYP T1 on 
                DoumntDode = Code
                inner join
                RDOC T2 on
                T2.DocCode = T0.DfltReport

Regards,

Bala

Edited by: Balakumar Viswanathan on May 4, 2011 8:27 AM

[Former Member]

That will do. Bala, thanks!