Example: Generic Variant Definition
In this example, a variant is defined for a BW selection screen that can then be used to personalize the variables 0DISCHAN
, 0DIVISIO
, 0I_CALMO
, 0P_SLSOF
and 0SALEORG
that
are defined in the query. The time variable 0I_CALMO
is filled using the function module SMO2_VARIANT_DATE_CONVERSION
(interval extending across the last 12 months). The system takes the selection values for the other variables from CRM Middleware
subscriptions that already exist for the users. The definition could thereby look as follows:
Selection |
Publication |
Replication Object |
Criteria Field |
Type |
Sign |
Opt. |
From |
To |
User Exit |
|---|---|---|---|---|---|---|---|---|---|
0DISCHAN |
Customer & Prospects (by Sales Org. + Distr. Channel) |
CAPGEN_OBJ_WRITE |
VTWEG |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
0DIVISION |
Customer & Prospects (by Sales Org. + Distr. Channel) |
CAPGEN_OBJ_WRITE |
SPART |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
0I_CALMO |
N/A |
N/A |
N/A |
I |
I |
BT |
0CALMONTH-11 |
0CALMONTH |
SMO2_VARIANT_CONVERSION |
0P_SLSOF |
Opportunities (by Sales Office + Sales Group) |
OPP_WRITE |
VKBUR |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
0SALEORG |
Customer & Prospects (by Sales Org. + Distr. Channel) |
CAPGEN_OBJ_WRITE |
VKORG |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
The prerequisite for this mechanism is a technical understanding of how the CRM Middleware criteria and the variables defined in BW are related. In the example, the BW variables 0DISCHAN
, 0DIVISIO
, and 0SALEORG
correspond
to the CRM Middleware criteria fields of the replication object CAPGEN_OBJECT_WRITE
of the respective publication Customer & Prospects
. Provided the corresponding subscriptions exist, the Preview
for July
2001 would lead to a screen like the following:
Selection Name |
Type |
+/- Sign |
Option |
Value from |
Value to |
|---|---|---|---|---|---|
0DISCHAN |
I |
I |
EQ |
W7 |
N/A |
0DIVISION |
I |
I |
EQ |
S9 |
N/A |
0I_CALMO |
I |
I |
BT |
08/2000 |
07/2001 |
0P_SLSOF |
I |
I |
EQ |
VB01 |
N/A |
0SALEORG |
I |
I |
EQ |
VO12 |
N/A |