![]() This will open a popup window that shows all related tables, foreign keys, cardinalities etc.Ĥ, We will also extract data from table MARA (Material master) because we need analytics with breakdown by Material Group, Material Type and Industry Sector. ![]() For this we can use the Field Selection Wizard feature:ģ, You can invoke a database schema map by selecting a table and pressing a button. We have two videos showing the whole process, and below you can find a long explanation with screenshots.ġ, First let’s start with a basic SQL query: we’ll select all records from table MARD (Storage Location Data for Material), which contains the unrestricted stock information for materials.Ģ, Next we filter the fields we want to extract, naturally not all are required. We will export material stock information from SAP using an SQL query. Let’s see how this works using a simple business example. The add-on perfectly complements our Data Unfolder, so using the two products together can supercharge your SAP data extraction processes, without actually changing them. The answer is of course yes! Incorporating an SAP add-on called STA Report Generator from our partner company STA Consulting, you can spare writing hundreds of program code lines. Wouldn’t it be possible to automate them all? You may notice that basically every step is the same, except for the data selection. Next, you have to implement the data selection using an OpenSQL query and finally, you have to implement the display functions and saving the results to a file. Technically the development follows the same pattern: you have to declare the types and variables you’ll use, then define the selection screen where you can filter the records. ![]() ![]() Usually these reports simply create plain text files on the SAP application server and are not used by the SAP end users. Often unloading data from SAP involves developing ABAP reports by the SAP IT department. ![]() Here we will explain how you can reduce both SAP development costs and time to deliver data extraction programs at the same time by using innovative SAP add-ons. Do you use ABAP reports to unload data from SAP to your big data or BI platforms? We have good news for you: you can keep this approach but cut report development time using a combination of two SAP add-ons. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |