Categories Uncategorized How to get selection criteria in Transformations routines? November 10, 2010 | 97 Views | Former Member Retagging required shlomi weiss2 share share tweet share Follow During simulation the system creates a +DTP_SIMULATION <em>that does not hold </em>that information.+ Alert Moderator To report this post you need to login first. 7 Replies 7 Comments You must be Logged on to comment or reply to a post. Kenneth Murray November 10, 2010 at 4:39 am Great information! Thanks for passing this on. Do you know if there is any SAP Documentation anywhere that might mention some of this kind of detail? Or how did you pick up on what was available? like (0) Former Member Post authorNovember 10, 2010 at 7:03 am Hi Kenneth, Thanks for your reply. I couldn’t find any SAP standard documentation on the subject.I searched Google and SDN and came across Michael Hoerisch’s blog which was very useful to start with, and I kept digging afterwards. Shlomi like (0) Martin Maruskin November 12, 2010 at 7:22 am Hi, SAP note where this functionality is mentioned is following:979607https://service.sap.com/sap/support/notes/979607 like (0) Kenneth Murray November 12, 2010 at 10:02 am Thanks for the info! Great that they have this functionality. They should really expose it as part of the documentation instead of burying it away in a tiny OSS Note. Thanks again! like (0) Former Member November 10, 2010 at 8:05 am Great information. Thanks. You can create several DTPs for the same transformation and use this functionality to code different transformation scenario based on a specific DTP you are running. You can even have a dynamic ABAP running based on a specific DTP. Great stuff! like (0) Shay Lemberger December 19, 2010 at 10:53 pm Hello Shlomo, The same method can be implemented on infopackage when you want to load data from the source system in addition to an existing delta or in case a delta mechanism cannot be created. For example: A daily load of data from a DS based on values (in this case a “0” or “1” boolean in an existing BW DSO ). In this case the range selection (“6” in Data selection Tab) in the infopackage page. When executing the infopackage, an internal table stores all records with “1” in DSO and they will be sent to source system for loading the appropriate records. Tha advantage in using this method is that the control DSO can be manipulated for your needs on daily basis. In the sample below the control DSO is :/BIC/AZIS_CONT00 The Code: data: l_idx like sy-tabix, lv_claim type /BIC/AZIS_CONT00-IS_CLAIM, it_claim TYPE STANDARD TABLE OF /BIC/AZIS_CONT00, wa_claim LIKE LINE OF it_claim, g_msg TYPE string. read table l_t_range with key fieldname = ‘CLAIM’. CLEAR l_t_range. SELECT IS_CLAIM FROM /BIC/AZIS_CONT00 INTO TABLE it_claimwhere /BIC/ZCM_FLAG = ‘1’. IF sy-subrc = 0. LOOP AT it_claim INTO wa_claim. l_t_range-sign = ‘I’. l_t_range-option = ‘EQ’. l_t_range-low = wa_claim-IS_CLAIM. APPEND l_t_range.* (Populating filter list) ENDLOOP.ELSE. g_msg = ‘No Claims Found’.MESSAGE g_msg TYPE ‘E’. endif. l_idx = sy-tabix.*….*modify l_t_range index l_idx. p_subrc = 0. Shay Lemberger like (0) Former Member August 22, 2012 at 3:51 pm I don’t know what the porblem is but I don’t see the content of this blog? Can someone please help? like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.