Enhancements in R/3

Hi all,

I have a requirement, where i need to bring the values of KVGR4 from r/3 to Bw. Along with KVGR4 i also need to bring the employee id from PA0001 table.

The requirement is as follows:

KVGR4 from KNVV table

BEZEI = Description of KVGR4, from TVV4 table,

Based on these description, i need to find Employee Id for KVGR4 in PA0001 table and bring it into BW.

Can i go for generic extraction using view data source....?

Where i can join the tables KNVV , TVV4 and PA0001.

But i have a doubt, if i go with generic data source can i bring the exact Employee id for KVGR4..???

Or any other way of doing this..?

Thank You!!