How to Set Up ODP
Last updated
Last updated
Step1. Creating RFC Destination
Tcode : SM59 , Create RFC Destination with connection type
Step2: Activate the Datasource
Any SAP extractor that is whitelisted by SAP for ODP framework can be used to extract data from and expose that data as an OData service for consumption. And for extractors that are delta capable can extract delta data as part of ODP framework and make it available for any external system as an OData service for consumption is icing on the cake.
List of steps to be performed to make this possible can be broadly classified as
Extractor setup
Enabling ODP
OData Service generation
This step is typical SAP BW extractor enabling step.
Go to transaction RSA5, expand sub tree and find extractor (in this example 0FI_GL_10)
To make sure extractor is active and to view the fields of extractor go to transaction RSA6, expand subtree and find the extractor
To perform a test run, go to transaction RSA3 and type in extractor name (in this example 0FI_GL_10) and click on Extraction button
Click on ALV Grid button to view the data.
Most of the extractor have ODP enabled. This can be verified by checking the ODP icon in RSA5/6 which indicates if the extractor is whitelisted by SAP or not
Furthermore, open the contents of table ROOSATTR to verify if there is an entry in the table for extractor and EXPOSE_EXTERNAL indicator is set.
Additional information
In case, a standard extractor is not available in ROOSATTR table then implement latest version of SAP note 2232584 and run program BS_ANLY_DS_RELEASE_ODP to update the whitelist extractors into ROOSATTR table.
RODPS_OS_EXPOSE: Report to release customer-defined extractors for ODP.
BS_ANLY_DS_RELEASE_ODP: Report to release standard extractors for ODP.
