Item Entry - SAP Documentation

Item Entry

Query Query: 0RPA_MC21_Q0002

This query displays the gross profit of every article sold in a store. Also you find the retail sales, cost, quantity sold, profit per unit and total gross profit.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
	Entry method	`0RPA_EMC`	Restriction to variable 0P_ENTRY
	Date	`0CALDAY`	Restriction to variable 0S_DATE
	Store	`0RT_LOCATIO`	Restriction to variable 0P_STORE
	Article	`0MATERIAL`	Restricted = exclude #

Free Characteristics
Object Type	Name	Technical Name
	Calendar Day	`0CALDAY`
	Entry Method	`0RPA_EMC`

Variables
Object Type	Name	Technical Name
	Entry method	`0P_ENTRY`
	Date	`0S_DATE`
	Store	`0P_STORE`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
	Store	`0RT_LOCATIO`	Restricted to the variable 0P_STORE
	Article	`0MATERIAL`
	Department	`0RPA_WGH2`

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
	Average Retail	`0RPA_C21_CK005`	0RPA_SAT/0BASE_QTY
	Base Sales Quantity	`0BASE_QTY`