Skip to Content

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

To report this post you need to login first.

12 Comments

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

  1. Gabor Szarka

    Hi Abdullah,

    I have sucessfully created this query in our environment.

    However, comparing results with CK13N data, only Total figures match. A summary by cost elements results in differences. I invest

    Comparison_2016-09-06_092101.pngOne of the differences comes from the fact that SFG is not broken down by components and items. In our environment, CE 884000 is a SFG which can only be broken down correctly if I enter this into selection screen, but if FG (which contains SFG) is selected, only Total displayed.

    Do you know which table should I use to “explode” costed multi-level BoM – so the full itemization is retrieved,

    Thanks,

    Gábor

    (0) 
    1. Abdullah Galal Post author

      Hello Gabor,

      We show the material type, review the semi-finished items first then the finished ones.

      The full BOM explosion can be seen by single material in CS13, not sure if there’s a way to see it in mass through SAP query.

      (0) 
  2. CMA Ramesh Kolluru

    Nice innovation Abdullah Galal! Thanks for sharing.

    I’ve not explored but below reports can also be tried.
    S_ALR_87099932 – Variances Between Costing Runs
    S_ALR_87099930 – Analyze Costing Run
    S_ALR_87099931 – Analyze Costing Run

    (0) 

Leave a Reply