Skip to Content
Author's profile photo Former Member

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

Assigned tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Prasad Patil
      Prasad Patil

      Hi

      Thanks a lot for providing such a nice and very informative document.

      Regards

      Prasad Patil

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you, hope you find it useful and easy to follow

      Author's profile photo Mohamed El Attary
      Mohamed El Attary

      Very good document.. detailed and descriptive.

      Regards

      Mohamed ElAttary.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you

      Author's profile photo Former Member
      Former Member

      Good one Abdullah 🙂

      Author's profile photo Gabor Szarka
      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

      Author's profile photo Former Member
      Former Member
      Blog 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.

      Author's profile photo Mukthar Ali Ahamed N
      Mukthar Ali Ahamed N

      Nice document..thanks for sharing

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you

      Author's profile photo Former Member
      Former Member

      useful document  thanks to share

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you

      Author's profile photo CMA Ramesh Kolluru
      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