How to Dynamically Load Multiple Files from SAP NetWeaver Application Server (Unix)

  • by Thiagu Bala, Aster Logic, Inc., President
  • May 25, 2011
Save time and avoid risks by using this ABAP program and process chains to load multiple flat file data into SAP NetWeaver BW. The code provided is for a Unix environment.
Key Concept
All the data stored in SAP NetWeaver BW is not necessarily sourced from SAP ERP Central Component (SAP ECC). Therefore, you might need to report on data from other systems, which could be provided as flat files. You also might have a need to automate the file loading process.

In a typical SAP NetWeaver BW implementation there is almost always a need to load flat file (PC) data into SAP NetWeaver BW InfoCubes, DataStore objects (DSOs), or master data objects. If the requirement is to load one file from the source, you can hardcode the file name. If the file name has a date prefix, the file name can be dynamically populated in the InfoPackage routine. However, this method allows you to load only one file at a time. If you need to load multiple files (e.g., one transaction file for each company code) and the number of files you need to load changes for every load, then it becomes difficult to automate the process.

I’ll explain how you can create an ABAP program along with two process chains (control chain and load chain) to automate the loading process. This method avoids the risks that modifying the SAP namespace presents to an SAP landscape and software life cycle. Let’s consider an example that loads multiple files to an InfoCube. In my example, I’ll be getting sales data for multiple company codes (T001, T002, and T003). Each company code has its own file.

Note
This program and example are applicable only to SAP NetWeaver BW installed on a Unix environment, not for a Microsoft Windows environment. The code uses Unix commands. If you are using a Windows environment you would have to tweak the code, but the rest of the process is still the same.

Thiagu Bala

Thiagu Bala is the owner of Aster Logic, Inc., and is an SAP-certified consultant in SAP BW 2.0, 3.0, and 3.5, SAP NetWeaver 7.0, SEM-BPS/CPM, Integrated Planning (IP), SAP BusinessObjects, and Crystal Reports. He has more than 13 years of experience in SAP specializing in BI, IP, SAP BusinessObjects, and SAP BusinessObjects Planning and Consolidation. You can check his profile on http://www.linkedin.com/in/thiagubala.

 

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.