Skip to Content
author's profile photo Former Member
Former Member

How can I make a quick Report without SE38 authorization?

Hi all,

I have to make a small report but customer does not give me a developer key nor SE38 access to write a short report.

What I need:

I have migrated 1,5 Mio Business Partner (are in table BUT000) and 1.499.970 contracts of these BUPA (are in table FKKVKP). The problem is that for any reason 30 BUPA do not have contract and I have to find out who are theses 30 BUPA.

I tried it with QUICK VIEWER: Declared both tables and made a key relation between BUT000-PARTNER and FKKVKP-GPART. Then it shows me the all records that are in both tables. But actually that does not help me, since I want to see those 30 that are NOT in FKKVKP.

So I was thinking run this report in the QUICK VIEWER and then take the file with all theses Partners and then go into SE16 of BUT000 and select in the selection screen of parameter PARTNER all <> those in the file. But, since we are talking about 1,5 Mio, I cannot download the file from QUICK VIEWER:

I need a good idea to find this f____g 30 Business Partner who have no contract.

Who has an idea?

t

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 08, 2007 at 12:50 AM

    Ok, have you tried to use SAP query yet? Create an infoset(you can put your own code in there) with tcode SQ02, then create a query in SQ01.

    Regards,

    Rich Heilman

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2007 at 03:47 AM

    Hi,

    you can make a quick report with the help of Tcode SQVI. it will b more helpful to u, without se38.

    regards

    Suvetha.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.