Hi, I am required to write a report that will display the cost of equipment of a certain equipment type. The cost required is from all the orders created for the equipment between the specified period. In IW33 you can obtain the costs from the (Actual/planned) button on the costs tab. You can also get the cost element and the cost element text from this screen. Now, my problem is that I don't know where to get that information from to write the report. The report in IW33 was done in report writer. Please help ASAP.
One of the many things you don't get taught on your ABAP courses, is how to find the data. The basic methods, applicable on most occassions, are:
F1 help on the field, and then to the technical information. Where this gives a structure rather than a table, look at the data element of the field, and see where that is used. Often the name of the structure can give hints to the name of the field.
Use SQL trace to see which tables were hit, and in which order. Use the Run Time Analyser for the same purpose.
Use Debug, with judicious use of watchpoints and breakpoints. (Once a report has run, use the debug menu to examine System Area ITAB - this will tell you the active internal tables, you can then run the report again, and set watchpoints on those internal tables.
Things are more complex with Report Writer reports, but the principals remain the same.
Dig Deeper on SAP MDM software
Related Q&A from Matthew Billingham
An SAP user is trying to run a report in an SAP ALV Grid online and wants to know how to get the data in the report to appear along with the header. Continue Reading
An SAP user needs to transfer customer purchase order spreadsheet data to SAP VA01 to create a new sales order. Continue Reading
An SAP user needs information on how to change the password on several SAP user accounts from a central location. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.