Start of Content Area

Query D&B Customer Revenue Analysis  Locate the document in its SAP Library structure

Technical name: 0SD_C03_DB_Q0003

Based on InfoCube 0SD_C03

Use

This query enables you to segment your market to allow you to analyze your customer profile. The option of segmenting customers by SIC code, sales, legal form, location and company family allows you to look at your existing customer base and potential target groups from different perspectives.

Free Characteristics

InfoObject

Description

0SOLD_TO__0DBCTRYCOD

D&B country

0SOLD_TO__0DBGUDUNS

D&B GU: D-U-N-S number

0SOLD_TO__0DBLGLSTAT

D&B legal form

Rows

InfoObject

Description of the InfoObject (or Restriction or Calculation Formula)

0SOLD_TO__0DB87SIC1

D&B US 1987 SIC Code (hierarchy)

Columns

Info Object

Description of the InfoObject (or Restriction or Calculation Formula)

0SD_C03_RK003

Revenue (restricted key figure)

Report/Report Interface

Query

Description

0SD_C03_DB_Q0010

D&B Customer Details

 

 

End of Content Area