Where do find the data I need for my report?

Where do find the data I need for my report?

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.


    Requires Free Membership to View

    When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.

    Hannah Smalltree, Editorial Director

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.


This was first published in April 2002

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.