Skip to Content
author's profile photo Former Member
Former Member

meaning case of SELECT please

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 04:46 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 04:49 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 08, 2008 at 05:38 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.