Skip to Content
author's profile photo
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Posted on May 04, 2011 at 02:54 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 06:01 AM

    That will do. Bala, thanks!

    Add comment
    10|10000 characters needed characters exceeded