Logical Database and Logical Thing

[Former Member]

Hi,

i want to access KONV which is cluster table and the field is KWERT.

The thing is that i want to access it by taking customers from KNVV and giving it to VBRK (SALES Table). Now in VBRK i want to have a selection on FKDAT to get a list of Customers stored in the field called KUNAG.

on VBRK-KUNAG basis i want to access the table KONV-KWERT.

If i am doing queries then the System stops responding cuz it has got alot of overhead. So i tried to use Logical Database called VFV.

If this is the best solution means using LDB then how to use it, can anyone help me with this. I tried it by Function module but it is showing all data without considering selection criteria.

If anyone can help me then plz do answer or refer me to any web site so that i can figure this thing out. If anyione has got a good book on that then plz feel free to mail me.

Thanks,

Muhammad Usman Malik

ABAP Consultant

Siemens

[email protected]

+92-333-2700972

[Former Member]

in your report attribute ( menu goto--->attribute) one field you can see logical database. there you have to define your ldb.

after that the tables which are used by ldb you have to specify like

nodes : vbrk, konv...like that.

for fetching data you have to use get or get late ...

just check whether you have done all those or not?

regards

shiba dutta

[Former Member]

nope i want to do Dynamic Selection not through defining LDB because in Selection criteria i want to have Billing dates.

[Former Member]

whenever you are running the program you can find after execution button you have dynamic selection button from there you can find billing document header data in a tree structure. there you can find billing data if you click that it will give an option for billing date in selection-screen .

regards

shiba dutta

[Former Member]

Thanks Shibba that was very helpful, i applied that but the system overhead was so much.

can u help me with Dynamic selection code.

I used FREE_SELECTION_INIT, FREE_SELECTION_DIALOG and then FREE_SELECTIONS_RANGE_2_WHERE to get ther Selections in one table.

if u want me to send u the code then i can do that cuz i am getting so much mad that this work is not done yet.

The Scenario here is that we want to take BILLED Customers and VKORG as Industrial Billing Customer and then taking VBRK and giving all these Customers and then taking selection on FKDAT range.

Now after that the data should be collected from KONV-KWERT and i want to perform some calculation over it. I am using VFV (Logical Database) to perform this thing because i know that it would be very fast then applying my own queries.

If you can mail me any book on Logical Database and Dynamic selection then it will be very Helpful.

Thanks once again for being such helpful.

Muhammad Usman Malik

SAP Consultant

[email protected]

+92-333-2700972

[Former Member]

sorry i cannot use external mails in my workplace. please go through this.

<a href="http://help.sap.com/saphelp_46c/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm">http://help.sap.com/saphelp_46c/helpdata/en/9f/db9b5e35c111d1829f0000e829fbfe/content.htm</a>

regards

shiba dutta

[RaymondGiuseppi]

As KONV is a cluster table, the only existning index is the index from the cluster table KOCLU.

MANDT

KNUMV

PAGENO

So if you don't have KNUMV you will read the whole cluster table....

Regards.

[RaymondGiuseppi]

So use VBRK-KNUMV and not KUNAG.

Regards.

[Former Member]

Well thanks alot Shiba and Raymond. I got it through Dynamic Selection finally.

If any of u want the code then let me know i will mail u folks thanks....

Best Regards,

Usman Malik

[Former Member]

hi ,

can you please send me the code

[email protected]

thnx a lot