topic Query with logical DB KDF in Application Development and Automation Discussions

Query with logical DB KDF

Former Member — Tue, 28 Dec 2004 12:30:56 GMT

How can I obtain the value of the field LFA1-EMNFR?

Re: Query with logical DB KDF

Former Member — Tue, 28 Dec 2004 13:05:41 GMT

Hi,

You could use the <b>GET LFA1</b> statement to evaluate LFA1-EMNFR. Try something like:

<b>

GET lfa1.

WRITE lfa1-emnfr.

</b>

The LDB driver program would automatically fill the work area of LFA1 and make it available for you in your program. You could then manipulate it as you need. Hope this helps.

Regards

Re: Query with logical DB KDF

Former Member — Wed, 29 Dec 2004 10:15:38 GMT

My problem is that I get always an empty field for EMNFR even if the table LFA1 has not initial values.

Re: Query with logical DB KDF

Former Member — Wed, 29 Dec 2004 14:39:02 GMT

Hi,

Could you please post the portion of code where you are evluating the contents of this field. Additionally, have you tried using a direct SELECT statement for the same selection criterion? And have you debugged the driver program to see if the value is being returned for the selection criterion passed to it.

Regards

Re: Query with logical DB KDF

Former Member — Wed, 29 Dec 2004 15:44:00 GMT

I'm trying to change a Query (SQ01) that uses an infoset that gets the data from a logical DB (KDF), I've included the field lfa1-emnfr in a field group (Vendor Master), but it's empty always, when I execute the query.