Top Ten Selling Configurations (Dealer Portal) 

Technical Name: 0AU_IS07_Q0105

Use

You can use this query to determine how many vehicles were sold which have the best-selling vehicle configurations, independently of the dealer and model. You use this query in the dealer portal for the automotive industry in the SAP Enterprise Portal for the role Automotive Channel Management: Dealer Manager.

Filters

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0AUV_IS07___F00059	VMS User
0AUV_IS07___F00061	Source system

Free Characteristics

InfoObject	Description
0AUV_IS07___F00024	Use
0AUV_IS07___F00073	Created on

Variables Used

Variable	Description
0P_DUSER	Dealer user
0P_DSYS	Source system

To be able to use this query you need to maintain the following settings for mandatory variables in the SAP Business Information Warehouse.

·        Variable 0P_PUSER

§         ...

                            a.      On the SAP Easy Access screen, choose Tools ® Administration ® User Maintenance ® Role Administration ® Roles.

                            b.      Enter the relevant role, for example, Dealer Manager (Automotive Industry).

                            c.      Click on Change Role.

                            d.      Choose the Personalization tab page.

                            e.      Choose the key CRM_ROLE_VARIABLE_SETTING by double clicking on it.

                              f.      Enter the variable in the dialog box.

                            g.      Save your entries.

·        Variable 0P_PSYS

§         ...

                            h.      Start transaction RSCRMSCEN.

                              i.      Enter the RFC destination for the SAP DIMP system from which the vehicles were loaded in SAP BW.

                              j.      In the column CRM Scenario, enter the value CONTENT.

                            k.      Save your entries.

 

Rows

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0AUV_IS07___F00003	Material
0AUV_IS07___F00043	Configuration Key
0AUV_IS07___F00031	Model
0AUV_IS07___F00033	Family
0AUV_IS07___F00029	Color
0AUV_IS07___F00030	Engine
0AUV_IS07___F00032	Engine
0AUV_IS07___F00034	Fixtures/fittings
0AUV_IS07___F00035	Gearcase
0AUV_IS07___F00036	Service
0AUV_IS07___F00037	Wheels
0AUV_IS07___F00038	Tyres
0AUV_IS07___F00039	Radio
0AUV_IS07___F00040	Seat

Columns

InfoObject	Description of the InfoObject (and Restriction or Calculation Formula)
0AUV_IS07___F00041	Quantity