We can write a program in the infopackage in BW to pick up a certain file based on its name from the application server and load it. This is required if there are multiple files in the same folder and only a certain file needs to be loaded out of those. Suppose we have a scenario like this: Business uploads the files for multiple sales division in a folder in the application server - /usr/SAP/DEV/Reports/target_sales.csv.
A basic knowledge of open SQL is necessary to develop ABAP application in SAP HANA. ABAP programs can access SAP HANA database through available set of queries and operations that can be executed on existing data. This article will introduce you to classic ABAP programming and how it complements with Native HANA. Simple Database access via ABAP Open SQL Statement: DATA: wa TYPE scarr. SELECT-OPTIONS: carrier FOR wa-carrid. SELECT * FROM scarr INTO wa WHERE carrid IN carrier. WRITE: / wa-carrid. wa-carrname. ENDSELECT. This program will display Airline id and its name based on the user selection of Airline id. For example- LH Lufthansa ABAP Schema The SAP Netweaver AS ABAP stores all data in exactly one specific schema within the database catalog. This schema is also referred to as system schema or ABAP schema. In traditional ABAP development, schema is irrelevant. For SAP HANA, schema is relevant because: When tables are ...
Comments
Post a Comment