SAP Query: Mass Display of Product Cost Estimates with Itemization

Note: To understand this article you must be familiar with SAP Product Costing and SAP Queries (SQVI/SQ01)

The Cost Accountant usually creates Product Standard Cost Estimates for next year in the annual budget, this estimate is based on

1. Different product components (BOM)
2. Production processes (Routing)
3. Overhead allocated

Now imagine the time and effort needed to review the cost estimates for hundreds of products one by one

The below query will save a lot of time and help the user easily spot any wrong cost components

Steps

1. Trx SQ02: Create InfoSet

InfoSet for the Query joining 2 tables: KEKO (Cost Estimate Header), and CKIS (Cost Itemization)

    A. Create InfoSet

   B. Choose “table join” and the table “KEKO”

    C. Insert table CKIS

D. Click “Back” to go to field selection screen

E. Select the fields you want in the query from the 2 tables

>NOTE: You can display some table records in SE16N to decide what fields you want in the query

F. Save and click “Back”, system will issue this message, hit “Yes” to generate the InfoSet 

G. Assign the InfoSet to one or more User Groups to be used in queries

2. Trx SQ01: Create the Query

A. Click and select the user group

B. Enter Query name and “Create”

C. Choose the InfoSet

D. Enter Query description and Save

 E.Setup the Query Layout and selection screen, insert the query name and click “InfoSet query”

F. Check the “Output” for field to see in the report and “Selection” for fields to be in the selection screen, save when done

3. Trx SQ01: Select the Query and Execute

> Note: this Query can be easily assigned to a transaction code later, check this great guideAssign transaction code to SAP Query (created via SQ01)

The final layout is like this

Share you comments, questions and Insights!

Cheers,

Abdullah Galal