Skip to Content
0
Former Member
Nov 02, 2005 at 05:19 PM

Create Extractor

28 Views

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,