Skip to Content

Mass Display of Cost Estimates with Itemization

It’s very important to review all cost estimates, this can be done one by one through CK13n, but in most projects this is not possible due to the number of materials costed, the below query will display all the cost estimates (saved, marked, released) with itemization.

STEPS:

  1. Trx SQ02: Create InfoSet for the Query joining 2 tables: KEKO (Cost Estimate Header), and CKIS (Cost Itemization)

     A. Create InfoSet

/wp-content/uploads/2016/08/1_1024732.jpg

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

/wp-content/uploads/2016/08/2_1024754.jpg

     C. Insert table CKIS

/wp-content/uploads/2016/08/3_1024755.jpg

/wp-content/uploads/2016/08/4_1024756.jpg

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

/wp-content/uploads/2016/08/5_1024757.jpg

/wp-content/uploads/2016/08/6_1024758.jpg

     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

/wp-content/uploads/2016/08/10_1024762.jpg

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

/wp-content/uploads/2016/08/11_1024805.jpg

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

/wp-content/uploads/2016/08/12_1024806.jpg

     2. Trx SQ01: Create the Query

     A. Click and select the user group

/wp-content/uploads/2016/08/13_1024838.jpg

     B. Enter Query name and “Create”

/wp-content/uploads/2016/08/14_1024826.jpg

     C. Choose the InfoSet

/wp-content/uploads/2016/08/15_1024827.jpg

     D. Enter Query description and Save

/wp-content/uploads/2016/08/17_1024828.jpg

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

/wp-content/uploads/2016/08/18_1024832.jpg

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

/wp-content/uploads/2016/08/19_1024831.jpg

     3. Trx SQ01: Select the Query and Execute

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

The final layout is like this

/wp-content/uploads/2016/08/20_1024834.jpg

Looking forward to your questions, comments, and inputs

12 Comments
You must be Logged on to comment or reply to a post.