Entering content frame

Query Consumer/Article Locate the document in its SAP Library structure

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)

 

 

 

Leaving content frame