Data from tables to BW

[Former Member]

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 %

😎 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,

[Former Member · Accepted solution]

Hi

You can get all the master data from tables like MARA, MARC, MVKE, T001, T001W, etc. But the fields like proft, etc you have to calculate them in BI using some data as base. This is not simple as you have mentioned here. You have to create a cube in BW which will hold all the transaction data on which you can calculate)

tax %

rebate amount

Net value

Freight amount

cost

profit %

sales adjustments

gross value

If you are SD consultant then get in touch with your BW consultant for this requirement.

Regards

Yatin Thakkar