selectreturn-valueconditional-statementsabap

Select with numc field condition returns no data


I want to extract some data from table view SACY_BOOK (which is one of those training tables always implemented in SAP) into my intern table wa_booking, filtered by a numc-field pa_anum. Here's what I got so far:

PARAMETERS pa_anum TYPE sacy_book-agencynum.

DATA wa_booking TYPE sacy_book.

START-OF-SELECTION.
  SELECT carrid connid fldate bookid name
    FROM sacy_book
    INTO CORRESPONDING FIELDS OF wa_booking
      WHERE agencynum = pa_anum.  **<-- this here be the problem **

    WRITE: / ... (I'll skip this part)
  ENDSELECT.

Code should work for everyone who has ABAP editor, since it only uses example tables supplied by SAP.

So, debugger shows me that if I choose some company with e.g. agencynum "00000108", this exact number is sent to pa_anum, with zeros in front and everything. Still, my sy-subrc variable gives back a 4, meaning that nothing which fits the condition was found. Hard to believe, since pa_anum gets its values from the same source...


Solution

  • The demo tables are delivered empty - on purpose, because why would you want demo data in your production environment that you won't ever need? Use the program SAPBC_DATA_GENERATOR to fill the tables SBOOK and STRAVELAG that make up the view SACY_BOOK.