Skip to Content
0
Former Member
Nov 27, 2008 at 12:13 PM

Reporting on Product Category

86 Views

Hi,

I have the following requirement and need inputs what would be best way to do it.

I am extracting CRM data(Activities, Opportunities) at a certain Product category level (0CRM_PRHIER), where as data coming from R/3 (Sales) comes at material level (0MATERIAL). 0MATERIAL has PRODH1,PRODH2...PRODH10 as navigational attributes. CRM data created at certain product category level should have one of PRODH1, PRODH2 to PRODH10 values. In the final report end user wants to use Prod category level and calmonth as variables in the selection, in order to show the result data how can I map sales data with that of CRM data or is there any effective way to do it (May be at reporting).

Data from CRM will be as follows:

Opportunity Calmonth Prod.Category Value

1001 01/2008 P101 1000

1002 01/2008 P10 1250

Activity Calmonth Prod Category Number

1234 01/2008 P101 1

2345 01/2008 Q101113 3

R/3 data as follows:

Material P1 P2 P3 P4 P5 P6 P7 P8 P9 P10 Calmonth Qty Value

Q1234 P P1 P10 P101 P1011 P10111 P1011112 01/2008 100 5

Q2345 Q Q1 P10 P101 P1011 P10111 Q101113 01/2008 150 10

Q3456 R R1 P10 R101 R1021 R10231 Q101113 01/2008 50 20

When user inputs 01/2008 and P101 as selection ,report should show following

P101 01/2008 1000 1 2000

When user inputs 01/208 and Q101113 as selection,report should show following

Q101113 01/2008 0 3 2500

When user inputs 01/2008 and P10 as selection, report should show following

P10 01/2008 0 0 3000

Many thanks for your inputs.

SAM