OINV -SLPCODE

[vinayak_chavan]

how can i access OINV SLPCODE (sales employee name ) in query ?.

thanking you

vinayak chavan

[jitin_chawla · Accepted solution]

Hi,

You need to join the document table with the OSLP table to get the name of the same employee as the same is stored in the OSLP table.

Check this :

select t2.slpname, t1.docnum

from oinv t1

inner join oslp t2 on t1.slpcode=t2.slpcode

Kind Regards,

Jitin

SAP Business One Forum Team

[vasileiosfasolis]

hi

try

select t2.slpname from oinv t1 inner join oslp t2 on t1.slpcode=t2.slpcode