We have two generic datasources populating one custom cube in BI. The first datasrce has fields like batch no., date, client, version,qty, etc. The second datasource has fields like batch no., client, version and zvendor. This datasource would populate only an additional field zvendor. This field can be populated when the batch no, client, version against that zvendor is same as the batch no., client & version from the first datasource.
So zvendor field from the second datasource can be populated in the cube using a routine in the transformation.
How will the routine look like? Can someone with ABAP expertise post this routine for us? Thank you in advance...