Skip to Content

SalesPersonCode -> Name

Hello all!

I cannot find a clue how to resolve the vBP.SalesPersonCode property into the name it belongs to. Where can I find the table with all SlpCodes and their names? Is this information able to be accessed by a SAPbobsCOM-Object?

Thnx in advance!

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Aug 19, 2004 at 10:57 AM

    Salesperson codes are held on OSLP. I dont think there is a specific business object for them, but you could use a recordset to access it.

    The following SQL shows how to link the tables:-

    SELECT T0.CardCode, T0.SlpCode, T1.SlpName FROM OCRD T0 INNER JOIN OSLP T1 ON T0.SlpCode = T1.SlpCode

    John.

    Add comment
    10|10000 characters needed characters exceeded