cancel
Showing results for 
Search instead for 
Did you mean: 

creating Logical Database

Former Member
0 Kudos

hi,

i need to display Outstanding Liability GRNs in my report. for that report, i have created a Logical Database.

The structure of ldb is,

BSIS>Bkpf->Bseg--->Rseg

My Input fields

GL Account

Plant

Fiscal Year

Grn Date

Now my problem is,

Time taken to give the output is very high(Nearly 450 seconds for 1 month duration)

Is there any alter way to create the Logical database using some other tables?

In logical Database can i create Internal tables?

Thanks,

Neptune.M

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

You can use logical databases instead of views since it helps in modularization...

andreas_mann3
Active Contributor
0 Kudos

Hi,

1) i think 450 sec for complete bsis (1 month ) isn't so bad

2) Did you compare your results with LDB SDF ?

regards Andreas

Former Member
0 Kudos

hi Mann,

Thanks for your reply.

In fbl3n report , they used sdf ldb.

In fbl3n , output will come with 2 seconds only.

Former Member
0 Kudos

Hi !

Try to create a databse-view with your needed tables and fields using the SE11.

Then change your programm to use this view instead the logical database.

That may be faster...

Regards

Rainer

P.S. Points would be nice if it helps you...

former_member188685
Active Contributor
0 Kudos

Hi,

you can create the view or index to make it faster

regards

vijay

Message was edited by: Vijay Babu Dudla