Logical data base and work process

[Former Member]

I have some questions on the above topics.

if some have an answer, let me know .

1. How many logical data bases can we use in our

report program

2. How to design our own selection screen when

using

logical database

3. How mnay update workprocesses can u have.

Thanks in advance.

Regards,

Roberts.K

[Former Member]

Hello Roberts,

I see that you have registered on SDN just today. Welcome here.

Coming to your questions,

1. A report program can have only one logical database associated with it. That would have to be specified in the Report Attributes.

2. Refer to this link. http://help.sap.com/saphelp_erp2004/helpdata/en/41/7af4daa79e11d1950f0000e82de14a/content.htm

3. That is purely a hardware-configuration issue.

Regards,

Anand Mandalika.

[Former Member]

Hai anand,

Thank you for the information you have provided, i have one more doubt where to find insurance limit for a customer .

Regards,

Roberts.k

[Former Member]

Hi,

The transaction is XD03. Go to this transaction and go to the option Company code Data. You will find a tab there called Insurance.

If you want to know where it's stored on the database, then it is in the table KNB1, in the field VLIBB.

Regards,

Anand Mandalika.

[Former Member]

Hi anand,

Great , i managed to find out the field , but you gave me the transaction also and my job easier, i have few more doubts if you know let me know,

they are : 1. how to find out open purchase order line items.

2. list of outbound deliveries including handling units which are not marked as a handed over to carrie

3. list of outbound deliveries lines which are not picked completely.

4. all FI invoice processed in a batch, how to identify as FI invoices .

for all the above if u have any tables or transactions let me know.

thanks in advance.

Regards,

Roberts.K

[Former Member]

Hi Roberts,

I'd have loved to give you all the answers, but it's getting really late in the day for me and I shall let you know of a very powerful and oft-ignored method to find the required information. Go to the Initial screen of SAP - The Easy Access Menu. Display the SAP Menu and under that you can navigate to the required transactions easily.

Hope you'll find that useful.

Regards,

Anand Mandalika.

[Former Member]

Hi anand,

Thank you for the reply, i will try that and will come back to you, in the mean time if you find some answers let me know.

Thanks ,

Regards,

Roberts.K

[Former Member]

Welcome to the forum!

In response to question 1:

You can designate only 1 LDB on the Attribute screen of the program. You can however, also invoke a LDB program using Function Module LDB_PROCESS. There is some good documentation associated with it.

In response to question 2:

If you specify a LDB on your program attributes, the LDB will present a selection screen. Any parameters/select options that you specify in your program are added to the selection screen that the LDB presents. If you use the Function Module mentioned above, then you alone will control the selection screen and have to pass selection information to the function module.

In response to question 3:

I am not quite sure what you mean by this one, but if some of the other SDNers have answered your question, then no need to clarify for me.

[Former Member]

Hi Charles,

Thank you for the information, it is really helpful.

Regards,

Roberts.K