cancel
Showing results for 
Search instead for 
Did you mean: 

how to extract two field from two diff table

Former Member
0 Kudos

Experts,

As per my client requirement inthe report they need two diff fields from two diff tables,

like DMBTR from BSIK and DMBTR from BSID,

Can any one plz guide me how to proceed, coz m very new to our BW.

thanx in advance

srujan

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

"As per my client requirement inthe report they need two diff fields from two diff tables,like DMBTR from BSIK and DMBTR from BSID".

couldn't get you properly.,

but you can fetch field's from different database tables

Suppose you want to load a DSO3 with fields A,B <b>C</b> and D

and you already have two DSO's having field

DSO1--->A ,B and D

DSO2--->A, <b>C</b> , E, ....

map DSO1 with DSO3

map A to both A and C in the transformation and write a routine to fetch the values of '<b>C</b>' corresponding to the values of 'A' from the database table

cheers

Sunil

Former Member
0 Kudos

Create views for those two tables and create datasorce manullay using Tcode RSO2 there u select from views.

Former Member
0 Kudos

HI sunil!

well, that is in report reqrmnt, but can u plz tell me how to generate datasourses (ofi_ar_4,0fi_ap_4)from bsik/bsak,bsid/bsad tables,

n

if it is already there can anyone plz give me the link,

thanks

srujan

Answers (1)

Answers (1)

Former Member
0 Kudos

You need to create a view across the two tables, try searching forum on how to create view / table joins.

Best Regs

Peter