Entering content frame

Query Sales (Article Categories) Locate the document in its SAP Library structure

Technical name: 0RT_C01_Q0007

Use

This Query provides an overview of the sales of individual article categories.

Rows

InfoObject

Description of the InfoObject (also restrictions or calculation formulas)

0MATERIAL__0MATL_CAT

Article Category

Columns

InfoObject

Description of the InfoObject (also restrictions or calculation formulas)

0CPBAINSABU

Sales / BUn

0CPBAINSAPV

Sales / Cost Value

0RTBAINSASV

Sales / Retail Value

0RTBAINSAST

Sales / Retail Value with Tax

0RT_C01_CK006

Margin – Sales at Retail Value (see formulas)

0RT_C01_CK007

Margin – Sales at Retail Value with Tax (see formulas)

Formulas:

The Margin key figure is calculated from the sales (or promotion sales), cost and retail value (with or without tax):

Margin with Tax =

100 ´ (Sales in Retail Value with Tax – Sales in Cost Value)

¸ Sales in Retail Value with Tax

Leaving content frame