Technical name: 0RT_C30_Q0020
Use
Analysis of the POS receipts of known customers, that is to say, customers with their own entry in the consumer master (-> master data) and have verified their details at the POS through the use of a customer card. The analysis of consumer attributes is particularly important here.
Filter
InfoObject |
Description of the InfoObject (also restrictions or calculation formulas) |
0RT_CUSTTYP |
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 |
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_POSSAL |
Sales |
0RT_C30_CK001 |
Sales Margin |
0RT_NOSALRE |
Number of POS Receipts |
0RT_C30_CK002 |
Sales / POS Receipt |
0RT_NOMGRRE |
Number of Merchandise Categories |
0RT_NOARTRE |
Number of Articles |
0RT_SALSLPU |
Sales / Cost Value |
Formulas:
Sales/POS Receipts = Sales (POS Receipts) / Number of POS Receipts
Sales Margin = 100 * (Sales (POS Receipts) – Sales at Cost Value (POS Receipts)
) / Sales (POS Receipts)