Excel to SAP

  Define Accounts for Bank Charges (Vendors) Financial Accounting (New) → Accounts receivables and Accounts Payables → Business Transactions → Outgoing Payments → Outgoing Payments Global Settings → Define Accounts for Bank Charges (Vendors) T Code OBXK Double click on BSP Assign Bank charges GLs and press save   Entry View In F-53 Please watch this video for more understanding. Thank You ***********************************************************************

Enter Transaction code  AJAB in SAP command box and press enter  First execute in Test Run Click on Yes Press back and execute the program in background  Please watch this video for more understanding. ***********************************************************************************

  Enter Transaction Code  F-28 in SAP command box.  Press enter Enter all the above details and Click on Process Open Item Click on Partial Payment Tab Enter Partial amount and Click on Simulate Check the entry view and press save. Please watch the below video and share your feedback also. ***********************************************************************************

  To Change the Number and Date format enter Transaction Code   SU3 in SAP command box. press enter You Can also change the Date and Number format here Select Time format from this default tab After making the changes press save and login once again to see the changes. Please watch this video and share your feedback please. ***********************************************************************************

  Enter Transaction Code  SPRO in SAP command Press enter Click on Set Decimal Places for Currencies Click on New Entries Enter Currency and Decimal Places and press save. Please Go through this video and share your valuable feedback. ***********************************************************************************

  Step – 1 Select the date(s), Step – 2 Click Data tab, Text-to-Columns Step – 3 Which brings up the Text-to-Columns wizard Step – 4 Even though the dates are fixed width, in this case you can simply click "Next" twice. In step 3 of wizard Select Date, YMD: Step – 5  See the result below:- Please watch this video and share your feedback ***********************************************************************************

  Enter T Code à FV75 in SAP command box Press Enter Enter : Customer Code Document Date Reference Posting Date Amount Business Section Business Place GL Code Amount Text Profit Center Then Click on Simulate Click on Post to park the invoice Please watch this video and share your feedback also. ***********************************************************************************

Enter transaction code ABMA in the command box Then press enter Maintain all the required information and press enter Then click on line item and Press Save Please watch this video and share your feedback also. _______________________________________________________________________    

 Objective - By this blog one can easily create the Profit center in SAP (ECC and S4HANA) Enter Transaction code KE51 in the SAP Command Field In the next screen, enter the controlling area in which the Profit Center is to be created In the next screen, enter a unique Id for the Profit Center In the next screen, enter the Following ·         Name of the profit center ·         Short description of the profit center ·         Person responsible for the profit center ·         Profit center group for which the profit center belongs to Press 'Save' button, for saving the profit center from the SAP Standard Toolbar The Profit center is saved in the inactive mode click ok  and  Press the 'Activation' Button for the activation of the profit center from the Application Toolbar Check the Status bar for the status of creation of profit center. Here is the Video from Youtube Channel. Please watch and share the feedback. ********************************************************

  The MS Excel's insert column option is disabled, after right clicking. I have tried using Excel options, but it's not working. How do I enable it? Here is the solution. Follow these steps: 1. Close all open Excel windows 2. In Windows Explorer, go to directory  %appdata%\Microsoft\Excel 3. Rename the file:  Excel15.xlb --> Excel15.old Please share feedback also. Thank You ********************End of this blog****************************