Ansicht
Dokumentation
CRM_MKTG_001 - Define BI Parameter ID for Top n Lists
Fill RESBD Structure from EBP Component Structure rdisp/max_wprun_time - Maximum work process run timeThis documentation is copyright by SAP AG.
The BI parameter ID that you create in this activity describes:
- Which BI report
- In which BI system
- With which parameters
is to be executed in order to determine the best-selling products (or, for example, those products with a turnover above a certain figure) for a given target group.
When maintaining top n lists, you then enter this BI parameter ID in the parameter of the relevant partner product range rule.
Once you have entered the relevant RFC destination and report ID, you can then enter values for the variables, activate/deactivate predefined conditions, and enter new conditions.
Conditions:
A condition describes a filter for a key figure, that is, the report is instructed to return only those products which meet the condition. A typical condition could for example be "Turnover > $500" or (typically for a top n scenario) "Turnover TC 10". TC stands for "top count" and means that the 10 products with the highest turnover are to be sought. You can also specify more than one filter for a key figure, or combine filters for different key figures, for example "Sales quantity TC 5" and "Turnover > $500".
Variables:
Variables enable you to control the way in which the key figures are calculated so that only a certain number of the total sales items are totaled. Typically, these will be time variables. For example, the variable "0CALDAY BT 01.01.2005 - 31.12.2005" would ensure that only turnover from the year 2005 is taken into account. To differentiate between sales made from different online stores, another important variable could be the sales office. If, for example, you run both a CD shop (sales office 1000) and a book shop (sales office 2000) and want a product proposal for your CD shop only, then only sales office 1000 would be relevant. You would enter sales office 1000 as a variable in the BI parameter ID "Sales office = 1000" and assign this BI parameter ID to the top n list (to the PPR item) for the CD shop. The variables themselves (in other words, the fields that can be filtered) must be predefined in the report (performed in the BI).
The report is structured such that it has variable values as input and can therefore generate any type of "statement". However, the aim of the BI parameter ID is to obtain from the BI a list of products for a given target group. To do so, you need to specify where (in other words, in which variables for the report) the business partners/target group should be inserted and what (the product GUID) is to be returned. This data is entered in the fields Business Partner Variable and Business Object: Product. These fields specify in technical terms in which field this program should write the business partner numbers, and which field should be returned.
Since the sales figures for a given target group can change regularly, to ensure the product lists are up to date, they need to be generated at regular intervals. When editing top n lists, you can then schedule background job(s) for generating top n lists from the BI at the appropriate intervals. For example, for one target group you may wish to run the report (that is, generate a new list) weekly, and for another target group, daily.
- You have a relevant Business Information Warehouse report, that is, one that can determine sales
both per business partner and per product. SAP delivers the report 0CRM_C03_Q0002 and, as of CRM 4.0 SP04, the reports 0CSAL_C03_Q0101 and 0CSAL_C03_Q0102.
NOTE: If using CRM Release 3.0 with BI Release 2.1C (up to and including SP10), you will need to create your own report. For more information, see SAP Note 437048.
- To work with the reports 0CSAL_C03_Q0101 and 0CSAL_C03_Q0102 you need SAP BI 3.30. For more information on this, see SAP Note 645751.
- Your Business Information Warehouse and CRM systems are connected. For more information, in the IMG choose Basis -> Distribution (ALE) -> Sending and Receiving Systems -> Systems in Network -> Define Target Systems for RFC Calls.
An example of a BI parameter ID for the above-mentioned CD shop could be as follows:
BI parameter ID: TOP10_CD_UMS_1Q
Description: Top 10 CDs by sales in 1st quarter
RFC Destination: QB5
BI report: I_ZCRMTOPN/ZCRMTOPN Top n report
Business partner: 0BPARTNER_VAR
Product: 0CRM_PROD
Conditions:
Turnover TC 10
Variables:
0CALDAY BT 01.01.2001 31.03.2001
0SALESOFF EQ 1000
BAL Application Log Documentation General Material Data
This documentation is copyright by SAP AG.
Length: 5425 Date: 20240523 Time: 165054 sap01-206 ( 120 ms )