Query with logical DB KDF

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.