×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Fehlende Berichte

Fehlende Berichte

Fehlende Berichte

(OP)
Hey together,
I have a the following problem. In my company SAP is working for three months and there are needed some reports that have not be prepared, by the SAP team.
Now I'm searching for a way to get these reports without paying a lot of money for the SAP team to create these reports. Because all the data is available and it should be possible.
I thought about getting the detailed data out in form of spreadsheets and then creating the reports via makros.
Or I thought about a second Access or SQL-Sever database, which contains the newest data of the single accounts and so on. This databases would get their data also via Spreadsheets coming out of SAP and the reports then would be created from this databases.
Is there perhaps a better way to get data from SAP or to create Excel reports out of it?

I would be thankful for every tips or advices. Thanks,
Martin

RE: Fehlende Berichte

Your question is rather open ended, but here are some suggestions:

1.  If you are a programmer, you should be able to write custom programs in ABAP to get exactly what you want.
2.  Use SQ01 to create a SQL query report.  This may be shared between users.
3.  Use SQVI for a quick SQL query.  This usually can't be shared with other users, although there are ways...
4.  A 3rd party tool, WinShuttle can extract data from "screens" to produce an Excel spreadsheet.
5.  If you have it, use Crystal Reports to create the report.

I'm sure there are many more possibilities.

Deb

RE: Fehlende Berichte

(OP)
First of all thanks for your suggestions.
I'm normally programming in Visual Basic but probably I could learn something about ABAP.
But more interesting I find the things about Query reports. As a matter of fact I haven't got authorisation to create queries. But perhaps I can get it.
What can I do with this queries and how do I use them. Because I can't imagine using SQL in SAP because I don't know the structure of the database. So I don't know how the tables and columns are called and where the data, which I want, is stored.
Is there any documentary about using SQL in SAP?

RE: Fehlende Berichte

To find data in SAP isn't always easy.

Do you know how to use the ABAP Dictionary?  If not, you should take BC430.  Using this you can search for different tables.

If you can see the data in a field on the screen, (but not in a report) try putting your curson on the field, pressing F1 and then clicking the Technical Details button.  Sometimes this will give you the table and field name.  Other times it will be a structure.  If it is a structure, look at the data element or domain.  They may help you find the data you are looking for.  Remember the "Where Used" button.  It is very handy.

If you are not already a member, join the SAP Community Network.  I have found many answers there, especially the forum.

Do you have a some particular data in mind?

Deb

RE: Fehlende Berichte

(OP)
Thanks for your answer. I think that can really help me. And I'm already in two SAP forums but not in the SAP Community Network, I think. I will join it.

First of all I have no particular data in mind. There are a lot of reports and therefore a lot of different data needed.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close