Skip to Content
0
Former Member
Nov 25, 2009 at 11:03 AM

Data from tables to BW

32 Views

Dear experts,

I have a requirement to fetch the below mentioned data from R/3 which enables to send to BW.

Require your help in letting me know from which tables and fields i can get this data.I would require to get these data for each Materials at company code level for a given period.

1) company code

2) customer code

3) material code

4)quantity

5)currency

6)Basic price

7) tax %

8) rebate amount

9) Net value

10) Freight amount

11) cost

12) profit %

12) sales adjustments

13) gross value

FYI, all these data are required for profitability reports

Appreciate your help in advance.

Regards,