Hello Folks,
I have a big issue, I explain
I work on contract on CRM, on item level.
My scenario : A contract may be signed by a Sales Organisation let's say : SORG1, with the help let's say of SORG2 and SORG3.
they split the value of the contract 60% for SORG1 and 25% for SORG2 and 25 for SORG3
the reporting that my company need to see is :
The turnover by Sales Organisation
The BW Datasource 0CRM_SSALES_CONT_I extract contrats on item granularity.
it means : if on CRM there is 200 contracts, on BW I will get 200 records based on Contract number and Item.
but in my case, I need (contract,item)by S.ORG.
-
in standard datasource :
Contract : 5000150, item:100 : [all informations:S.org,..]
for my reports in need :
S.ORG : 5000150,100 : ....
: 5000151,100,....
and so on
My question : Do I need to Create a new datasource or using the standard can be enough ?
Thanks for all,