Skip to Content
avatar image
Former Member

Design Help

Hi All,

Here is the business req.

A material sold under a SalesOrg falls under one Mat Group. The same material sold under different salesOrg falls under a different Mat Group.

The customer that bought this Material under a particular SalesOrg provides two kinds of contacts.

1 Notification Contact and

2 Courtesy Contact.

Point to remeber is a combination of MatGroup and Customer can have only one Notification contact, but many courtesy contacts.

Now, the business user wants to see data like below.

Material Customer MatGroup ContactID ContactType

**************************************************************

M001 C001 MG001 Con001 Notification

M001 C001 MG001 Con002 Courtesy

M001 C001 MG001 Con003 Courtesy

M001 C001 MG001 Con004 Courtesy

M002 C001 MG001 Con001 Notification

M003 C001 MG002 Con005 Notification

M003 C001 MG002 Con006 Courtesy

Please let me know how I can design this?

Thanks,

Pradeep

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Aug 20, 2007 at 07:51 PM

    Before designing, let us know what you have as Master data and transactional data.

    I am hopping that you should have...

    Material, Material Group as master data in 0MATERIAL and

    Customer, Contract ID and Contract Type as Master data in 0CUSTOMER or in transactional data. And also let's us know what the user wants to drill down and navigate report. If that is the case then you don't really need to worry except loading data to the cube and create a report just like the one you have above. If that is not the case, then we need to see how we can achieve your reporting needs.

    thanks.

    Wond

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      rather it would be determined by combination of Material and the SalesOrg.

      contct is determind by combination of customer and material group

      what combination makes what? Do you have a mapping table or a business rule that would dteremine the Mat group/contact?

      If you have some look up or logic you may have to compound these to the main IO.

      compound Mat group to material and have sales org as an attri - so all the combinations will be unique. and the same applies to contact ID too.

      If this is a constantly changing combination with time, I think you need to look into a virtual char for the determination on the fly. Or realign data in the cube when a change in the mapping occurs.

  • avatar image
    Former Member
    Aug 28, 2007 at 07:59 PM

    Hi,

    I am trying to load the contact id to the Infocube from the master data.

    In my master data I have customer and MatGroup and contact id.

    In the cube I have Customer and MatGroup. How do I get the contact id into the cube comparing Customer in masterdata table and cube and also comparing Matgroup in cube with Matgroup in master data table.

    Appreciate your help.

    Thanks,

    Pradeep

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 29, 2007 at 03:38 PM

    Any help please?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2007 at 11:31 PM

    any help please?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 06, 2007 at 11:35 PM

    Design a ODS and keep Matl, customer,contract ID as key fields.

    Ravi Thothadri

    Add comment
    10|10000 characters needed characters exceeded