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...
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
STRAVELAG that make up the view