Posts

Showing posts with the label ABAP

ABAP FM FIN_AP_AR_ADD_BANK for FK02

Image
Finding ways to add/insert Vendor Master Bank Details using BAPI OR FM? I've been scratching my head for quite sometime looking and finding BAPI for Vendor Master Bank Details. Glad able to find the Function Module. FM - FIN_AP_AR_ADD_BANK TCODE - FK02 TABLE - LFBK Here's the code snippet. DATA: Bank_Data  type LFBK. Clear: Bank_Data . Bank_Data-lifnr   = lv_Lifnr. Bank_Data-banks = lv_Country. Bank_Data-bankl = lv_Bankl. Bank_Data-bankn = lv_Bankn. Bank_Data-koinh = lv_AcctHolder. Bank_Data-bvtyp = lv_Bvtyp. CALL FUNCTION 'FIN_AP_AR_ADD_BANK'      EXPORTING          i_koart                    = 'K'          i_bankdata              =  Bank_Data   *         I_CONFI...

SAP ABAP Listbox error in VRM_SET_VALUES

Image
Problems: The selected item in Listbox were automatically added on the Listbox whenever you re-execute the program. See image below. You know you code it correctly and still wondering how it acted differently? The problem is in the key field. It should be in CAPITAL LETTERS. Then, how about the blank entry in Listbox? Just add OBLIGATORY on the parameter statements. Happy Abaping!

BAdI for Interest Rate Calculation in Treasury Management

Image
SAP Treasury Management How to change the Interest Rate in Tx FINT ? To achieved this we need to implement  BAdI ZFI_INT_CUS01 using the method Int_Change_Items. Let's say the requirement specified to change the Interest Rates based on the document type. If BLART equal to 'MD', interest rate would be '10'. If it's 'DA', interest rate would be '6'. We will be dealing with the following transaction, implementation and interface. 1) SE19 - BAdI 2) FI_INT_CUS01 - Definition 3) Method - IF_EX_FI_INT_CUS01~INT_CHANGE_ITEMS 4) Interface - INT_CHANGE_ITEMS Here is the code snippet to change the interest rate. */------------------------------------------------------------------------ method IF_EX_FI_INT_CUS01~INT_CHANGE_ITEMS . */------------------------------------------------------------------------ *break-point. Data: wa_Items Type intit_extf. Loop at ct_items into wa_Items.      if wa_Items-blart eq 'MD'.       ...

SAP ABAP: Smartforms/SAPscript formatting

Image
SAP Smartforms/SAPscript Smartforms Formatting Following are the few useful formatting options: Offset: N left-most characters of the symbol value will not be displayed. If symbol has the value 123456789, the following will be displayed: &symbol& -> 123456789 &symbol+3& -> 456789 &symbol+7& -> 89 &symbol+12& -> &symbol+0& -> 123456789   Output Length To define how many character positions should be copied from the value. If symbol has the value 123456789. &symbol(3)& -> 123 &symbol(7)& -> 1234567  The SYST-UNAME field contains the logon name of a user called Einstein. The Dictionary entry for this field contains an output length of 12. &SYST-UNAME&… -> Einstein… &SYST-UNAME(9)&… -> Einstein … &SYST-UNAME(*)&… -> Einstein … Omitting the Leading Sign The S option can be used to ensure that the value is formatted without the sign. The ITCD...

SAP ABAP: How to deactivate number range buffering in Payment Orders?

Image
A client ask why there's a gap in Payment Orders numbering and want to have no gaps. Solution:  The number range buffering was activated for Payment Orders object. We need to deactivate the number range buffering using the Tx SNRO. Step 1. Execute Tx SNRO. Step 2. On the object field, enter FI_PYORD and click the Change button.   Step 3. It will display the No. Range Object and shows the numbers in buffer. Step 4. Click on Edit menu -> Set-up buffering -> No buffering. Step 5. Click Save button. Caution: When you deactivate buffering, it will warn you the disadvantage effect on the performance. Good luck! Happy Abaping. Mabuhay, Philippines!

So what do you really want in life, Hunting Pokemon or hunting skills?

Image
With the advent of video games, MMORG(Massively Multiplayer Online Role-playing Games) and now AR( Augmented Reality ) for which Pokémon Go has raise the bar as far as video gaming is concerned. Adults and children were extremely devoting their time to learn new skills and to be the best on every games they want. Sounds so great but then, what about the skills they needed to learn to help them as they struggle in this circle of life? Not unless if you want to have a career path in playing games for the sake of money, just like those DOTA players gunning to win the prestigious prize the highest ever in computer games. "Dota 2 breaks its own record for biggest prize pool in e-sports" . Or maybe follow this guy who quits his job to play Pokemon GO full time ? But then, what if you want to learn skills in Information Technology aside from the one you've learned in schools? Sometimes you need to splash a certain amount of money just to have those basic skills or to be...

SAP ABAP: Capturing CHECK BOX event in FM REUSE_ALV_GRID_DISPLAY / Cell Editing

Image
Requirement: Show total number of rows selected as message whenever a user     click on a check box column in REUSE_ALV_GRID_DISPLAY. To accomplish this, we have to use EVENTS in REUSE_ALV_GRID_DISPLAY to capture changes made by the user. In data declaration: Data: gt_events  TYPE slis_t_event,         wa_events  TYPE slis_alv_event. */------------------------------------------------------------------------  FORM display_alv_report. */------------------------------------------------------------------------ gd_repid = sy-repid. Refresh: gt_events. wa_events-name = 'CALLER_EXIT'. wa_events-form = 'CALLER_EXIT'. APPEND wa_events TO gt_events. wa_events-name = 'DATA_CHANGED'. wa_events-form = 'DATA_CHANGED'. APPEND wa_events TO gt_events. CALL FUNCTION 'REUSE_ALV_GRID_DISPLAY'      EXPORTING           i_callback_program   ...

SAP ABAP How to create double rule line in Smartforms print output using table line?

Image
Working with SAP ABAP has been great and challenging. The euphoric feeling when the end user start using your program and they were awed by the output far beyond their imagination. But sometimes, all those great achievements just turn into dust when they want a simple request, from their point of view, just a very simple request, and yet you could not deliver it. Take for example the "Double Rule" in accounting reports, most specifically, the Financials Reports. FI Functional and end-user pushes that report should show the double rule line. In order to satisfy their needs, I just put '=' after printing the grand total. Though it's okey for them, but on my part I still feel uneasy for not able to deliver what they want. The very simple request were unattainable! After experimenting Smartforms, table lines and Smartstyle, Gotcha! I was able to find the solution or trick to able to show "double rule" in printing reports. Here is my simple solut...

ABAP 2nd ALV Grid display nothing

Image
You want to display all the corresponding entries of that particular row by using Function 'REUSE_ALV_GRID_DISPLAY' but it display an empty ALV. Based on my experience, the main ALV had a custom layout being used. Workaround is, you just add the i_default with a value of space on its exporting parameter. Solution: Just add the i_default parameter with a space value. Call Function 'REUSE_ALV_GRID_DISPLAY'        Exporting                 i_default                = ' '   - add this parameter.     Mabuhay, Philippines!

SAP ABAP: Using BTE in FB02 or FB03 to reflect changes made on FI document to Custom table

Image
Requirements: Need to update custom table field when changes made on FI Document number. We can use the BTE(Business Transaction Events) to capture changes made on a particular FI Doc. Please follow these steps. 1) Execute Tx FIBF. Click on Menu-Evironment. 2). Select "Info system(P/S)".   3). On the Publish & Subscribe Interfaces, just press the execute button. 4). Upon executing, it will list all existing P&S BTE. From the list, we will going to use the 00001110 - CHANGE DOCUMENT. This BTE will be fired up once the SAVE button is clicked. Double click the CHANGE DOCUMENT. 5). On the Interface Detail, click on the Sample function module button. 6). It will proceed to Transaction Function Builder. 7). Copy the function module to custom function. 8). Select function group. 9). On the function module source code, we could see the interface IMPORTING and the TABLES. 10). See sample codes to update custom table sgtext. From the interfa...