Survey data extract from SRM to non-SAP BI system (OBIEE)
I’ve been researching this for a while now and I’ve seen no actual description on how to extract the survey form data from SRM to an external Business Intelligence system.
We have managed to do this internaly with help from this community so I wanted to share this back with you.
From my point of view there are some generic steps and some particular ones for doing this:
1. Go to RSA5 and find your relevant data source (in the particular case we are talking about it is 0WS_DATA_1_C)
2. Go to RSO2 and in Transactional data put in this source. Then click display
3. From the Datasource menu on the bar click test extraction
4. In the new screen click the Extraction button
By doing this you get all the data entered for all the surveys in the system.
In order to filter that data, go to the table TUWS_TAROBJ_ATTR with the field ATTR_VALUE (this field contains the PO or Confirmation number in SRM) and take the TAROBJ value.
This TAROBJ is you filter in the Extraction done from the 0WS_DATA_1_C and you get the data for one survey. (the results you get there are based on your survey customizing. The survey we are using is fairly simple: two questions and one comment. I’m not sure what happens if the complexity is higher)