Extract data out of 2 database tables

[Former Member]

i have table 1 with values cost center = 100...500, and sub-cost-centers for Cost center

i have table 2 with values Business area assigned to Costcenters

now i want tof ind this data

Business area cost center sub-cost-center

a1...........................100..............100-11

a1...........................101..............100-12

a1...........................102..............100-13

a1...........................103..............100-14

a2...........................100..............100-11

a2...........................101..............100-21

a2...........................102..............100-22

a2...........................103..............100-23

what do i do?

i am in bi 7

i want to extract this information out in Excel

[garry_a · Accepted solution]

Hi ,

Create a view (SE11) in SAP R3 based on these two tables.In the table join condition put the coste center as a condition so that the Coste cenet which is matching the relevent data will be extracted. Now create a data source(RSO2) based on this view.

You will get the data records as per you requirement,

Amol