topic Re: SQL error:field is unknown in Application Development and Automation Discussions

SQL error:field is unknown

Former Member — Mon, 11 Jan 2021 02:19:40 GMT

Hi, the coding is as blew: and there's an error happening.

Field"LDT_VAL-MATNR" is unknown. It is neither in one of the specified tables nor defined by a "Data" statement.

How to deal with it?

Thanks!

Types:
  Begin of GTS_VAL,
    MATNR TYPE MARA-MATNR,
  End of GTS_VAL.
  GTT_VAL Type table of GTS_VAL.

Data LDT_VAL type GTT_VAL.

Select ~
for all entries in LDT_VAL
Where MSEG-MATNR = @LDT_VAL-MATNR

Re: SQL error:field is unknown

joltdx — Mon, 11 Jan 2021 04:54:15 GMT

Hi!

You need to escape LDT_VAL everywhere, so change to this:

for all entries in @LDT_VAL

Next, you need to use the ~ to indicate fields from specific tables (or table aliases). In this example, change to:

Where MSEG~MATNR = @LDT_VAL-MATNR

Re: SQL error:field is unknown

Sandra_Rossi — Mon, 11 Jan 2021 06:12:57 GMT

Your syntax is completely wrong. One possibility:

SELECT * FROM MSEG
INTO TABLE @DATA(ITAB)
FOR ALL ENTRIES IN @LDT_VAL
WHERE MATNR = @LDT_VAL-MATNR.

(but instead of *, specify the columns you really need)