Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Not what you were looking for? View more on this topic or Ask a question