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..?