How to Set Up ODP

1. Create RFC Destination

   Tcode : SM59 , Create RFC Destination with connection type.

   

2. Activate the Datasource.

   Any SAP extractor that is whitelisted by SAP for ODP framework can be used to extract data and expose that data as an OData service for consumption.

   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.

   The steps to perform this can be broadly classified as:

   1. Extractor setup

   2. Enabling ODP

   3. OData Service generation

3. Extractor setup. This step is typical SAP BW extractor enabling step.

4. Activate Extractor.

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

   

5. Validate Extractor

   To ensure extractor is active and to view the extractor fields go to transaction RSA6, expand subtree and find the extractor.

   

6. Test Extractor

   To perform a test run, go to transaction RSA3 and type in extractor name (in this example 0FI_GL_10) and click the Extraction button.

   

   Click the ALV Grid button to view the data.

7. Enabling ODP

   Most of the extractor have ODP enabled. This can be verified by checking the ODP icon in RSA5/6 which indicates whether the extractor is whitelisted by SAP.

   

   Additionally, open the contents of the ROOSATTR table to verify if there is an entry for extractor and if the EXPOSE_EXTERNAL indicator is set.

Additional information

If a standard extractor is not available in ROOSATTR table, implement the latest version of SAP note 2232584 and run program BS_ANLY_DS_RELEASE_ODP to update the whitelist extractors in the 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.