Field "A" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement.

[Former Member]

hi,

i need to display ZSHT - Handling/Throughput and ZSPC - Port Charges on the existing infoset using SQ02.

But, i got the error below :

Field "A" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement.

Here is the query when i double click the T685 in the Extras tab :

Select Single * from T685

where KVEWE = A

AND KAPPL = VBRK-KAPPL

AND KSCHL = ZSHT

And, am i doing the right thing ? What i am need to do in order to display this 2 fields ? create an additional

table or create additional fields ?

Any idea since i am a newbie on these stuff ?

Thanks

[paul_bakker2]

Hi,

You need to put single quotes on the 'A' and the 'ZSHT'.

cheers

Paul

[Former Member]

hi paul,

Then, i should add an additional table or additional fields for these ZSHT - Handling/Throughput and ZSPC - Port Charges on the existing infoset using SQ02 ? What i need to do ?

Thanks

[arindam_m]

Hi,

The value A and ZHST are characters so you need to put them in Quotes to indicate them as character strings.

Select Single * from T685

where KVEWE = 'A'

AND KAPPL = VBRK-KAPPL

AND KSCHL = 'ZSHT'.

Cheers,

Arindam

[custodio_deoliveira]

Either add single quotes or (better) create constants for these fields. And don't forget the INTO clause:

DATA ls_t685 TYPE t685.
 SELECT SINGLE * FROM t685
        INTO ls_t685
        WHERE kvewe = 'A'
        AND kappl = vbrk-kappl
        AND kschl = 'ZSHT'.
*****OR *****
 CONSTANTS:
   c_kvewe TYPE kvewe VALUE 'A',
   c_kschl TYPE kschl VALUE 'ZSHT'.
 SELECT SINGLE * FROM t685
        INTO ls_t685
        WHERE kvewe = c_kvewe 
        AND kappl = vbrk-kappl
AND kschl = c_kschl.

Cheers,

Custodio

[Former Member]

hi ,

Then, i should add an additional table or additional fields for these ZSHT - Handling/Throughput and ZSPC - Port Charges on the existing infoset using SQ02 ? What i need to do ?

Thanks