Simple Program to Check Active Requests in ODSOs / ADSOs
In this document, we will create a program to check the whether an ODSO/ADSO is having an Active request or not. Scenario : We have BW data flow which loads data from the Source System to DSO and from DSO to further multiple targets, and at the end of the Process Chain the request should get deleted from the source. Here, we have a case if someone did an ad-hoc load from Source System to DSO and subsequently to targets, and forgot to delete the request from the DSO. This leads to duplicate data into Targets in next Process Chain run. Solution : To take care of the above case we can keep a checkpoint in the Process Chain which will monitor the request in DSO. If an existing request is found in DSO, then a notification can be displayed and we can go ahead and remove it manually. Case1 : When we have Extraction Layer as ODSO . As we all know SAP has given a Standard Function Module RSSM_ICUBE_REQUESTS_GET which can be used to get the DTP requests which are presen