How to Set Up ODP

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

1. Extractor setup

2. Enabling ODP

3. OData Service generation

2.1. Extractor setup

This step is typical SAP BW extractor enabling step.

2.1.1 Activate Extractor

Go to transaction RSA5, expand sub tree and find extractor (in this example 0FI_GL_10)

2.2 Validate Extractor

To make sure extractor is active and to view the fields of extractor go to transaction RSA6, expand subtree and find the extractor

2.3 Test 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.

2.4 Enabling ODP

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.