Known/Anonymous Customers (SAP Library - BW

Known/Anonymous Customers

Technical name: 0RT_C30_Q006

Use

This Query provides an overview of the relationship between anonymous customers and known customers.

Rows

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0PLANT	Site

Columns

InfoObject	Description of the InfoObject (also restrictions or calculation formulas)
0RT_POSSAL	Sales (POS Receipt)
0RT_NOSALRE	Number of POS Receipts
0RT_C30_RK001	Sales from Known Customers (see restrictions)
0RT_C30_RK002	Number of POS Receipts from Known Customers (see restrictions)
	Sales / POS Receipt Known Customers (see formulas)
	Sales / POS Receipt Anonymous Customers (see formulas)
	Number of POS Receipts from Anonymous Customers (see formulas)
	Sales from Anonymous Customers (see formulas)

Constraints:

Sales from Known Customers

Restriction of the Sales (POS receipt) key figure to the Known Customer value for POS Customer Code

Restriction of the Number of POS Receipts key figure to the Known Customer value for POS Customer Code

Formulas:

Sales/POS Receipts from Known Customers

Sales/POS Receipts from Known Customers =

Sales from Known Customers ¸ Number of POS Receipts from Known Customers

Sales/POS Receipts from Anonymous Customers =

Sales from Anonymous Customers ¸ Number of POS Receipts from Anonymous Customers

Number of POS Receipts from Anonymous Customers =

Number of POS Receipts – Number of POS Receipts from Known Customers

Sales from Anonymous Customers =

Sales – Sales from Known Customers