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,