Create transaction for report.

[Former Member]

Dear Gurus,

I have this interesting topic. Could anyone help me.Firstly , I am not an ABAPer , I am a Business Analyst so please don't answer something so "ABAP".

Ok this is my case : We built a "report" in SAP , that only take out the data from some tables, and as you know you cannot input or edit anything in this report.

But now our business want to edit directly in this report and next time when they run this report with the same indicators, system will show all the information ( the information from tables and information that they edit).I am thinking that we can assign a number to this report so when they run the report and after edit they can save with a number .Next time they only need to input that number.

Could anyone advise me if we can do that and if yes how can we ? and if not , could you show me some other ways ?

Thanks and Best Regards,

Huong

[Former Member]

Dear Gurus,

I have this interesting topic. Could anyone help me.Firstly , I am not an ABAPer , I am a Business Analyst so please don't answer something so "ABAP".

Ok this is my case : We built a "report" in SAP , that only take out the data from some tables, and as you know you cannot input or edit anything in this report.

But now our business want to edit directly in this report and next time when they run this report with the same indicators, system will show all the information ( the information from tables and information that they edit).I am thinking that we can assign a number to this report so when they run the report and after edit they can save with a number .Next time they only need to input that number.

Could anyone advise me if we can do that and if yes how can we ? and if not , could you show me some other ways ?

Thanks and Best Regards,

Huong

[Former Member]

Hi Huong Vuong,

I under your requirement, but my doubt is after report is displayed user wants to be edit any data.

In such cases that user has to perform some action then only what ever the row/column data edited by

him its saving in respective tables and info types.

That report we can build it .No issues from ABAP Side.

Please correct if my under stand is wrong.

Thanks & Regards,

Srini.

[Former Member]

Dear Srinivasarao Bandaru ,

Yes, after running the report ,user can directly edit data in that screen then save it to a document number.Then we can have a report to show all data of those document numbers.Could you please tell me about the solution .

Thanks,

Huong

[ivan_shadrin]

In my opinion, you have the following options:

1. ABAP (sorry 😉 ). Because if you want to update the data, you must write some code for that.

2. Exporting to Excel and saving into business workplace (SBWP).

Let's take a closer look at the second option.

1. User runs the report and gets some output in the form of the ALV table.

Let's consider for example the report BALVSD02_GRID.

2. There is a button "Local file" on the tollbar of ALV grid. If it is not true for your report, you should ask your ABAPers to add this button - it is simple.

3. User exports the contents of the report into an .XLS file. Afther that he or she can edit the data.

4. After that user can run the transaction SBWP. The most simple way to do it is to press the button in the initial SAP Easy access screen.

5. The user can create his own folder in private or public area and import the excel file into that folder. If he wants, he can give permissions to other user for access to this file. There are a plenty other possiblities.

6. Later he can find this document and open, edit it as he wants.

[Former Member]

Dear Ivan Shadrin ,

Sorry for this late reply.Thank you for your solution .

For changing it to ALV table we can edit the data but my requirement is that we can save it to a document number in SAP then we run a report with those document numbers and system can show all the information.

Could you please advise ?

Thanks and Best Regards,

Huong

[Jelena_Perfiljeva]

There is no solution that does not involve ABAP or some third-party tool (like Winshuttle) or extracting and storing data externally, as already suggested.

[Former Member]

Dear Perfiljeva,

After all of your suguestion , the solution is to use ABAP code.So the next question is how can we use ABAP in this case ?

Thanks,

Huong

[Former Member]

Hi Huong

ABAP is used to solve the technical issue.

As the Functional Business Analyst, you would advise business of this. You can mock up the screen and describe the flow of the process they are to follow (In consultation with an ABAP programmer would be advisable).

The ABAP developer performs the task of developing the requirement.

As you're not an ABAPer your time is best served defining the requirement that is possible. Let the ABAPer deal with making it happen

Regards

Arden

[Jelena_Perfiljeva]

Huong Vuong wrote:

Dear Perfiljeva,

After all of your suguestion , the solution is to use ABAP code.So the next question is how can we use ABAP in this case ? 

I'm confused - have you never implemented a single ABAP report in your organization? Do you have no process to gather the requirements, write up a specification and hire a qualified ABAPer to implement? Why does this require assistance from a global forum?

[Former Member]

What he said.....

[Former Member]

Business analyst want to make something ABAP without helping from internal ABAP for impression.

Thank you all.I contact our internal ABAP!

[Former Member]

Give him this link:

Then sit back and wait for programs that will consume your server.....

[matt]

Your BA sounds like the kind of person who would build a house without hiring an architect, and then wonder why a year later he's sitting in a ruin.

[Former Member]

This message was moderated.

[matt]

The answer that was posted here has been removed on the grounds that it advocates updating standard SAP tables directly which is almost universally a profoundly bad idea.