Entering content frame

Query Consumer Attributes Locate the document in its SAP Library structure

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)

 

 

 

 

Leaving content frame