Categories Uncategorized A new kid(BAdI) in town July 8, 2005 | 15 Views | Former Member Retagging required dirk herzog share share tweet share like 0 Follow During the migration process problems have been reported for this blog. The blog content may look corrupt due to not supported HTML code on this platform. Please adjust the blog content manually before moving it to an official community. Alert Moderator To report this post you need to login first. 5 Replies 5 Comments You must be Logged on to comment or reply to a post. Former Member July 8, 2005 at 5:43 am OK, now I am happier!! Thanks Dirk!! And thanks for the great info!! I’ve passed it along to our BW guys! like (0) Former Member July 12, 2005 at 12:03 am Good one..Thanks for coming out Dirk. Anil like (0) Former Member October 24, 2006 at 3:39 am I had problems with the article rendering. I cleaned this up a bit. I believe the following should work. Could you confirm whether this functionality works in the web interface in both the HTML and Excel view? Or is it just related to the transaction you mentioned in the article. Thanks. The idea is to enter only Sales, Avg. Price and Rebates % and letthe system calculate the rest. Combine it with an XML based GUI andyou have a nice planning tool. But as always there are things youwould like to do a bit different. So what do you do today? Implementa BAdI.Our current problem looked a bit different. We had lots of differentversions in the columns and wanted to set the columns with actualvalues not ready for input.The BAdI definition is called UPX_LAYOUT_RENDER and it has lots ofmethods you can play with. I only used one so I will show you asample implementation of one of the methods, ADOPT_PLAN_DATA. ADOPT_PLAN_DATA is used to change the planning data before it entersthe layout. But be aware that all the formulas you have created areapplied after the change of the data so don’t be surprised if yousee different values.While I_AREA, I_PLEVEL and I_LAYOUT are more or less self explainingfor everybody with BPS knowledge here is some information about theother parameters:IT_HEAD is a table that contains the characteristics and values thatare place in the header of the planning layout.IT_COL contains the characteristics and values for each column.Often the key figures are placed here; in this case the charactervalue is the key figure name.XT_ROW contains the values of the characteristics for each row. Youcan add rows or change the sorting here. I would not recommendchanging the values completely or adding different characteristicshere.XT_DATA contains the values in the cells. This table contains fourfields, ROW, COL (for the row and column index, also key fields inXT_ROW and IT_COL), VALUE and INPUT. INPUT lets you mark a tablethat is not ready for input.XT_FUNC contains the results of key figures calculated by functionmodules. Since we don’t use this feature I don’t know any details.XT_TEXT lets you change the contents of text value cells. So my goal was to set the field INPUT in XT_DATA for all cells thatcontain the values ‘ACT’ in the field 0VERSION. So this is thecoding: IF_EX_UPX_LAYOUT_RENDER~ADOPT_PLAN_DATA . check i_area = ‘MYAREA’.* Step 1: If 0VERSION = ACT set INPUT = 0 field-symbols:<f_value> type any. data: ld_data type UPC_YS_API_DATA, ld_ row type UPC_YS_API_ROW.* Check all cells LOOP AT XT_DATA INTO ld_data.* 0VERSION is in the row, so look at the row values READ TABLE XT_ROW INTO ld_row WITH KEY row = ld_data-row chanm = ‘0VERSION’. CHECK sy-subrc = 0. IF ld_row-chavlext = ‘ACT’. ld_data -input = ‘0’. modify xt_data from ld_data. ENDIF. ENDLOOP. That’s all. With the possibility to change the data this method is aquite powerful addition to the tool. If this isn’t enough you havethe chance to manipulate the values in the methodsADOPT_XML_DOCUMENT or ADOPT_HTML_DOCUMENT. Both of them are quitedifficult to figure out if you don’t know ABAP XML handling indetail so you’re warned.My personal recommendation would be to not even use the extendedplanning layouts if you don’t do it in the CRM context. There aresome restrictions like not being able to sort the columns the wayyou like that make it a bit hard to use. But if you need to use itthis BAdI gives you a nice way to extend the planning much betterthan you can do it in standard BPS layouts.May the ABAP be with you Dirk P.S.: This blog was written in Word and it’s ok for me so pleaseforgive me any formatting problems. like (0) Former Member Post authorOctober 24, 2006 at 6:34 am Hello Ross,you’re right, the rendering looks awful. But to your question. This BAdI is only available for the sales planning, not for standard planning (Web and Excel). Best regardsDirk like (0) Former Member June 17, 2013 at 6:58 am Hello Dirk, Unable to see any content or info in the blog. It only gives the below message. “During the migration process problems have been reported for this blog. The blog content may look corrupt due to not supported HTML code on this platform. Please adjust the blog content manually before moving it to an official community.“ Can you please repost this blog? Regards, Nageswara like (0) Leave a Reply Cancel replyYou must be logged in to post a comment.