Determining RFM from Sales Order Data by Calendar Year/Month from R/3 SD
Determining RFM from Sales Order Data by Calendar Year/Month from R/3 SD
Technical name: 0SD_C05_RFM_Q01
Based on the InfoCube:
0SD_C05 Quotations / Orders
Use
This query is used for data collection during the segmentation of business partners as part of
RFM analysis. This query and the query Determining RFM from Sales Order Data with Exact Date from R/3 SD are available when you create an RFM segmentation model as a proposal for determining R, F, and M using data from R/3 SD.The distinction between SD data with exact date and SD data to the month is necessary because the date is included by default in SD content but it is not filled by update rule. If, however, you have activated the date update, it is mandatory that you use the query with exact date instead of the query to the month.
If you use this query to the month, the first day of the calendar month and year is taken for determining the recency value. Each calendar month with a day in the period that has been set to be read is read completely.
Example
Settings in the RFM segmentation model:
With the query using the exact date, the period 15.10.2000 through 15.10.2001 is read. With the query to the month, the period 10.2000 through 10.2001 is read, using 1.10.2000 through 1.10.2001 as the recency date.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DOC_CATEG |
Sales document type (= C) |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0CALMONTH |
Calendar year/month (variable 0I_CALMO) |
|
0SOLD_TO_0BPARTNER |
Business partner number of the sold-to party |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DOCUMENTS |
Number of documents |
|
0NET_VAL_S |
Net value of statistical currency |
|
0COST_VAL_S |
Statistical allocation value |