Urgent help needed!

[Former Member]

hi

I have a scenario in which i want user is not able to submit data between some period of time.This time will not be static but every day some have to put this time.

I thought to call two BAPI :one to get time and other to insert.

Which brought perfomance issue to me.Is there some other way out to solve this problem,like storing data into the KMC database and then accessing data or some other ?

Please help.

Regards

Nidhideep

[former_member182294 · Accepted solution]

Hi Nidhideep,

You can use J2EE DB for this purpose by creating tables using Java Dictionary.

Follow this steps:

> Create tables using Java Dictionary and deploy.

> Write custom logic to read and write into these custom tables.

> Integrate your logic with UI.

As the tables are part of local J2EE engine, it gives you the best performance.

Check the following tutorial to learn about using Java Dictionary.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/4d/a018b505747b47a22cd7d2e446df88/frameset.htm">Java Dictionary</a>

Regards

Abhilash

[Former Member · Accepted solution]

hi

Abhilas thanks for the response.I am able to create table in SAP DB and able to store data .But now how to access that data using WEbdynpro and this webdynpro application is accessing a BAPI to put data into the R/3.How to do that?

Regards

Nidhideep

[Former Member · Accepted solution]

Hi Nidhideep,

Your first question was not very clear.

Anyway for accessing the db check the following

Regards, Anilkumar

[former_member182294 · Accepted solution]

Hi,

In the current scenario you are using ARFC model to create or read data to/from SAP R/3. Now you have created tables in J2EE engine, so you dont need ARFC model.

Now do the following:

- Write custom Java logic to read and write tables using JDBC or Open SQL/J.

- Use Java Bean Model instead of ARFC model to use the java logic in your

Web Dynpro application.

Regards

Abhilash