SELECT SINGLE STATEMENT NOT FETCHING ANY DATA EVEN REQUIRED DATA AVAILABLE IN DATA BASE TABLE

[former_member584050]

DEAR EXPERTS,

SELECT SINGLE STATEMENT NOT FETCHING ANY DATA EVEN REQUIRED DATA AVAILABLE IN DATA BASE TABLE.

COULD YOU PLEASE SUGGEST

TABLES KNB1.
TYPES : BEGIN OF TY_KNB1,
        BUKRS TYPE KNB1-BUKRS,
        KUNNR TYPE KNB1-KUNNR,
        AKONT TYPE KNB1-AKONT,
        END OF TY_KNB1.
 DATA WA_KNB1 TYPE TY_KNB1.
 SELECT SINGLE BUKRS KUNNR AKONT FROM KNB1 INTO WA_KNB1 WHERE BUKRS = '5000' AND KUNNR = '0000000024'.
  WRITE :/ WA_KNB1-BUKRS, WA_KNB1-KUNNR,WA_KNB1-AKONT.
  ULINE.
 SELECT BUKRS KUNNR AKONT FROM KNB1 INTO WA_KNB1 UP TO 1 ROWS WHERE KUNNR = '00000000224'.
     ENDSELECT.
    WRITE :/ WA_KNB1-BUKRS, WA_KNB1-KUNNR,WA_KNB1-AKONT.

[former_member584050]

DEAR EXPERTS,

SELECT SINGLE STATEMENT NOT FETCHING ANY DATA EVEN REQUIRED DATA AVAILABLE IN DATA BASE TABLE.

COULD YOU PLEASE SUGGEST

TABLES KNB1.
TYPES : BEGIN OF TY_KNB1,
        BUKRS TYPE KNB1-BUKRS,
        KUNNR TYPE KNB1-KUNNR,
        AKONT TYPE KNB1-AKONT,
        END OF TY_KNB1.
 DATA WA_KNB1 TYPE TY_KNB1.
 SELECT SINGLE BUKRS KUNNR AKONT FROM KNB1 INTO WA_KNB1 WHERE BUKRS = '5000' AND KUNNR = '0000000024'.
  WRITE :/ WA_KNB1-BUKRS, WA_KNB1-KUNNR,WA_KNB1-AKONT.
  ULINE.
 SELECT BUKRS KUNNR AKONT FROM KNB1 INTO WA_KNB1 UP TO 1 ROWS WHERE KUNNR = '00000000224'.
     ENDSELECT.
    WRITE :/ WA_KNB1-BUKRS, WA_KNB1-KUNNR,WA_KNB1-AKONT.

[Sandra_Rossi]

Please avoid using ALL letters in upper case.

It's just that the line does not exist in the table.

I see that you entered '00000000224' that is 11 characters long but the table column is maximum 10 characters long!