Technical name: 0RT_C31_Q0003
Use
Analysis of the buying behavior of known customers (who buys what?).
Filter
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_CUSTTYP (Customer Identification) |
1 = (known customer) |
Free Characteristics
InfoObject |
Description |
0PLANT__0SALESORG |
Sales organization |
0PLANT__0DISTR_CHAN |
Distribution channel |
0PLANT |
Plant |
0CALMONTH |
Calendar Year/Month |
0CALDAY |
Calendar Day |
0CONSUMER__0BP_MAR_STA |
Marital Status |
0AGE_RANGE |
Age range |
0AGE |
Age (in years) |
0CONSUMER__0POSTAL_CD |
Postal Code |
0CONSUMER |
Consumer |
0CONSUMER__0GENDER |
Gender |
0MATERIAL__0MATL_GROUP |
Merchandise category |
0MATERIAL |
Material |
Rows
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0CALWEEK |
Calendar Year/Week |
Columns
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_SALRESA |
Sales Quantity (Sales Unit) |
0RT_POSSAL |
Sales |
0RT_C30_CK001 |
Sales Margin |
0RT_PRIREDR |
Price Reduction PLU |
0RT_SALSLPU |
Sales / Cost Value |
Formulas:
Sales Margin = 100 *
( Sales (POS Receipts) – Sales at Cost Value (POS Receipts) ) / Sales (POS Receipts)