Start of Content Area

Query Department Sales by Customer: Unassigned Product Hierarchies  Locate the document in its SAP Library structure

Technical name: 0LOM_C04_Q0002

Use

The query "Department Sales by Customer: Unassigned Product Hierarchies" provides information on the sales made by a customer while shopping. You can use the query to establish whether the articles purchased by the customer are assigned to a product group.

Only customers who have not yet been identified (for example, by a customer card) are displayed. This may be the case if a customer has already received a customer card, but it has not yet been identified in the system.

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Calendar Year/Month

0CALMONTH restricted by the selection variable ‘0CMONTH’ (current calendar month)

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Product Hierarchy

0PROD_HIER restricted to the value ‘#’ (Unassigned)

0BP_ID_NUM

0BP_ID_NUM

0BP_ID_TYPE

0BP_ID_TYPE

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

Sales (POS Receipt)

0RT_POSSAL

 

 

 

End of Content Area