D&B Rationalization Business Partner (CRM) 

Technical name: 0SAL_MC01_Q0001

Based on MultiProvider: 0SAL_MC01 (Sales Analysis)

Use

This query is used for the D&B Marketing Exploration Scenario (CRM). This query delivers the data that you send to D&B for rationalization. For rationalization purposes, a unique D-U-N-S number is assigned to every business partner for. The query extracts information about the revenue obtained with your existing business partners. The revenue is used as a measure of the value of the business partner to your company. The revenue affects the extent to which D&B tries to assign a D-U-N-S number to the business partner.

If you only want to send business partners from a specific country to be rationalized, you can choose the country required using a variable.

Filter

InfoObject	Description of InfoObject (with Restriction or Calculation Formula)
0COUNTRY variable 0S_CBPAR	Sold-to country

Rows

InfoObject	Description of InfoObject (with Restriction or Calculation Formula)
0CRM_SOLDTO	0CRM_SOLDTO

Columns

InfoObject	Description of InfoObject (with Restriction or Calculation Formula)
0SAL_MC01_CK001	CRM sales revenue