Scenario: Send the output of a query to a table
We have n number of ways to send the output of a query to a table. I would like to demonstrate the use of APD to achieve this scenario.
Step 1: Identify the Query and the fields to be send
The Fields selected is:
Step 2: Create a Transactional ODS with the Fields in the Query
Step 3: Go to Analysis Process Designer (Tcode — RSANWB)
Step 4: Create. Select Generic Application from the list
Step 5: Drag the Query object from the Data Sources to the design area. Double click and assign the query which has to be used.
Step 6: Drag the Filter object from the Transformations to the design area
Step 7: Drag the ODS object from Data Targets. Double click and assign the Transactional ODS created to store the Query Output.
Step 8: link the objects. Select the query object and draw an arrow line towards the filter object. From the filter object draw a second arrow line towards the target ODS.
Step 9: Double click on the second line drawn from filter towards the ODS. This will open a window which shows the field assignment options
Step 10: Click on each field methods and select the respective fields from the query. Do this for all the fields in the mapping assignments.
Step 11: Save the Application. Give the technical name for the Application.
Step 12: Activate. Now the APD is ready to execute. Right click on the APD created under the generic group and select Execute.
Step 13: Verify the ODS for Data.
Reference: help.sap.com Analysis Process Designer