There are two structures in R/3. Structure 1 has fields batch no,date,qty. Structure 2 has fields batch no,customer.
I have to extract values for all fields from struct 1 and value for customer for each record of structure 1 where structure1.batch no.=structure 2.batch no.
I cant enhance the datasource based on structure 1 with a append field customer.
I want to handle this in the transformations when populating the cube. how do i do this?