meaning case of SELECT please

[Former Member]

the meaning of:

SELECT SINGLE YYCTC into KNA1-YYCTC from KNA1 where KUNNR=KNA1-KUNNR.

KUNNR=KNA1-KUNNR is equal KNA1-KUNNR=KNA1-KUNNR ???

i don´t understand.

can you help me please.

Cordial greetings.

[Former Member]

You select a single yyctc from database table kna1 into the field yyctc of structure kna1 where the field kunnr of the database table kna1 is equal to the field kunnr of structure kna1

Yes, you could say in abap form kna1~kunnr = kna1-kunnr

Remember kna1 is refering to a database table and an structure at the same time

[Former Member]

There must be a WORK-AREA by the name kna1 declared by Tables statement. This work area is filled with certain values and is used to select data from DATABASE TABLE kna1.

[Former Member]

Lopez,

You can probably find somewhere prior to the select you find

  kna1-kunnr = it_emp-kunnr.
*
*
  SELECT SINGLE YYCTC into KNA1-YYCTC from KNA1 where KUNNR=KNA1-KUNNR

The code would work just fine and only update the YYCTC field in the KNA1 structure.