SAP selling price records data model

[#1]

First of all, I apologize if this question has been asked before. I used the search tool but could not find anything corresponding to what I'd like to do.

I was asked to develop an application on pricing records in SAP. I am familiar with KONH, KONP, KONM, etc, but I have a problem with the data model I need to use.

In my company, the prices can be at the customer level, the payor level, or the customer group level. End users would like to be able to select any customer and see the prices for the customer, the payor, and also the customer group.

They would also like to be able to select any article and see all the prices for this article.

I can't find how I should develop my data model. Do you have any advice that would put me in the right direction?

Thanks in advance.     

[#2]

I forgot some details... here are the tables that I have:

- Customer:

     %CustomerKey,

     %PayorKey,

     CustomerName,

     etc

- Product

     %ProductKey,

     ProductDescription,

     etc

- Net Prices

     %ConditionNumber,

     %VariableKey (which is a concatenation of %ProductKey and %CustomerKey or %PayorKey),

     Table (which indicates if a record is at the customer level or payor level)

     StartDate,

     EndDate,

     etc

What I'm having trouble with is finding the data model where users are able to select a customer and see the records on customer level and payor level, or select a product and see all the records attached to it.

[#3 · Accepted solution]

In case anyone is ever interested, I found the solution. I did something like this:

[CustomerLevel]:

LOAD

    %SalesOrg_Key,

    %Customer_Key,

    %Payor_Key,

    %CustomerGroup_Key,

    %ConditionNum,

    %MaterialNumber_Key,

     ...

FROM Conditions.QVD(qvd)

WHERE [Cond_Table]='901' //This only selects the records at customer level

[PayorLevel]:

NoConcatenate LOAD

    %SalesOrg_Key,

    %Customer_Key,

    %Payor_Key,

    %CustomerGroup_Key,

    %ConditionNum,

    %MaterialNumber_Key,

     ...

FROM Conditions.QVD(qvd)

WHERE [Cond_Table]='902' //This only selects the records at payor level

Left Join([PayorLevel])

LOAD

    %Customer_Key,

    %Payor_Key

FROM Customers.QVD(qvd);

NetPrices:

LOAD * Resident [CustomerLevel];

Concatenate LOAD * Resident [PayorLevel];