SAPLab-SAP Tips! ABAP Tips! http://www.saplab.net SAP ABAP User! Sun, 18 Mar 2012 23:45:45 +0000 en hourly 1 http://wordpress.org/?v=3.3.1 SAPLabhttp://feedburner.google.com SAP ABAP Tips: A new tool for ABAP developers: OpenSQL Editor http://feedproxy.google.com/~r/SAPLab/~3/c5mgMhgvD1M/ http://www.saplab.net/sap-abap-tips-a-new-tool-for-abap-developers-opensql-editor/#comments Wed, 29 Feb 2012 16:26:00 +0000 Jack http://www.saplab.net/?p=180 A lot of people have asked if there is a transaction or report in SAP, where developers could execute SQL queries. The answer was always a no. A new report had to be developed for each query which took a lot of time away. Now there is a tool that fills this gap: the OpenSQL Editor of Hovitaga.

 

Simply start the transaction and you can immediately execute any SELECT statement. The results of the query are displayed in an ALV grid or an ALV tree. The SELECT command can be as complex as you wish: you can create subqueries, any number of inner and outer joins, group functions etc. There is  even a Join Assistant that actually offers you the tables which can be joined to the tables already in the query, and even generates the code for it.

 

Every limitation of SE11 and SE16 are gone: select from multiple tables, use any logical condition in the WHERE clause. No need to transport anything like with SAP Query.

 

With setting up a sophisticated authorization system, it is even possible to execute UPDATE and DELETE commands which allows really easy mass data modification. However this is not recommended in a productive system.

You can type your command into the command editor in the middle part of the screen. It supports syntax highlighting, code completion and the pretty printer. The navigation tree is on the left side where you can see all your currently used commands as well as the ones saved to a repository. The list of tables used in the query is on the right side. The most important features you can use there is the Join Assistant and the Field Selector Wizard. There are many more shortcuts to standard SAP transactions related to the listed tables. The results of the query are displayed at the bottom part of the screen after executing the command.

 

This tool helps developers and consultants to develop, test and optimize SQL statements and it’s a great tool for ad-hoc reporting. Check out www.hovitaga.com and download a free version here: www.hovitaga.com/try.

Related Posts

]]> http://www.saplab.net/sap-abap-tips-a-new-tool-for-abap-developers-opensql-editor/feed/ 0 http://www.saplab.net/sap-abap-tips-a-new-tool-for-abap-developers-opensql-editor/ SAP PO Reservation Call funtion http://feedproxy.google.com/~r/SAPLab/~3/EVgQ4kUdL9U/ http://www.saplab.net/sap-po-reservation-call-funtion/#comments Wed, 30 Nov 2011 11:40:30 +0000 Jack http://www.saplab.net/?p=175 CALL FUNCTION ‘MB_READ_RESERVATION_POS_WA’
EXPORTING
rsnum    = rm07m-rsnum
rspos    = rm07m-rspos
shkzg    = shkzg
bwart    = xrkpf-bwart
kzneb    = rm07m-kzneb
TABLES
i_iooper = oper_tab
seqtab   = xrbefu.

Related tables: RESB,RKPF

 

Related Posts

]]> http://www.saplab.net/sap-po-reservation-call-funtion/feed/ 0 http://www.saplab.net/sap-po-reservation-call-funtion/ SAP Tips: Retrieve Deleted Programs in SAP http://feedproxy.google.com/~r/SAPLab/~3/BBtDYGs01IM/ http://www.saplab.net/sap-tips-retrieve-deleted-programs-in-sap/#comments Tue, 29 Nov 2011 11:38:10 +0000 Jack http://www.saplab.net/?p=173 SAP has a limited provision for retrieving deleted programs. Let us have a look into the steps for the retrieval.

 

 

OPTION 1:

1. Check in table VRSD if there is an entry with OBJTYPE = ‘REPS’ and OBJNAME = name of the deleted program.

 

Retrieve Deleted ProgramsRetrieve Deleted Programs

2. If yes, then create a new program in SE80 / SE38 with the exact same name as the deleted one.
3. Click on Utilities – > Version – > Version Management.
4. Click on the earlier version of your program and click display.
Your earlier program will get displayed, just copy – paste to the existing program.

via ABAP Tutorials

Related Posts

]]> http://www.saplab.net/sap-tips-retrieve-deleted-programs-in-sap/feed/ 0 http://www.saplab.net/sap-tips-retrieve-deleted-programs-in-sap/ SAP ABAP Programs for Beginners http://feedproxy.google.com/~r/SAPLab/~3/lIHSprESxSw/ http://www.saplab.net/sap-abap-programs-for-beginners/#comments Tue, 29 Nov 2011 11:00:56 +0000 Jack http://www.saplab.net/?p=171 The code book contain the beginners level programs for new ABAPers. The book covers almost every basic aspect that a programer in this domain should know.

 

Code Book

 

Some of the programs that the book covers are:

  • How to define types and data objects
  • A Few Simple Examples
  • Working with database tables and internal tables
  • Designing a report
  • Three approaches to define data objects
  • Complex Non-Elementary Types and Data Objects
  • Type-Specific Output Options
  • External flow of control (events)
  • Using internal tables as snapshots of database tables
  • Working with get events
  • Dynamic sort command with several sort criteria
  • Working with Field Symbols
  • Transferring data to a file
  • Reading data from a file

 

Download Link: ABAP Code Book

via ABAP Tutorials

Related Posts

]]> http://www.saplab.net/sap-abap-programs-for-beginners/feed/ 0 http://www.saplab.net/sap-abap-programs-for-beginners/ SAP ABAP Pending Purchase Recquisition (PR) Report http://feedproxy.google.com/~r/SAPLab/~3/87reZEj61zs/ http://www.saplab.net/sap-abap-pending-purchase-recquisition-pr-report/#comments Fri, 25 Nov 2011 16:54:12 +0000 Jack http://www.saplab.net/?p=168 This sample report shows the basic structure for getting the report for the Pending Purchase Requisition based on various selection options on screen.

The report loops throgh the required Tables of Purchase Requisition and based on the data entered on screen, displays the desired data. The report is to be modified/tweaked as per the custom need.

purchase_requisition

 

The basic purpose of the report is to develop a pragmatical flow of the language, the way normally ABAP programs are written.

Download Source Code : Z_PENDING_PRS_REPORT

Via http://www.abap-tutorials.com/2011/10/30/abap-pending-purchase-recquisition-pr-report/

Related Posts

]]> http://www.saplab.net/sap-abap-pending-purchase-recquisition-pr-report/feed/ 2 http://www.saplab.net/sap-abap-pending-purchase-recquisition-pr-report/ [Share]Upload / Download Data from SAP Tables http://feedproxy.google.com/~r/SAPLab/~3/tHyRgZ2f7G4/ http://www.saplab.net/shareupload-download-data-from-sap-tables/#comments Thu, 30 Jun 2011 17:32:09 +0000 Jack http://www.saplab.net/?p=165 There have been some cases where we, as an ABAP programmer, want to take SAP table data backup. Specially for the case where Basis Team refuses to get it back-up and restore the data for us.

There have been some codes available on net where data is backed-up but not restored back to SAP.

It is basically Dynamic table export / import facility.

 

There are some restrictions for using the code:

* – Table definition MUST exist on target system for import.

* – Entire table is exported / imported.

* – Must be WIN95/98 WIN-NT long filenames.

 

Download code : Upload/Download Program

via ABAP Tutorials

Related Posts

]]> http://www.saplab.net/shareupload-download-data-from-sap-tables/feed/ 0 http://www.saplab.net/shareupload-download-data-from-sap-tables/ SAP ABAP Tips-How to Debug Pop-up window http://feedproxy.google.com/~r/SAPLab/~3/Hgpsk5pxmyI/ http://www.saplab.net/sap-abap-tips-how-to-debug-pop-up-window/#comments Sun, 16 Jan 2011 19:12:02 +0000 Jack http://www.saplab.net/?p=159 The okcode field is deactivated when a modal window (the technical name of popup windows) is displayed, so it seems impossible to enter the debugger (using /H okcode).

In common dialogs, the okcode field is available:

But it is not available in modal windows (we see it but we can’t enter anything in it):

The solution is to create on the frontend a SAPGUI shortcut (file with extension .SAP), of type System Command and command /H, and drag and drop it from Windows desktop to the SAP modal window. The creation of SAPGUI shortcuts is explained here: SAPGUI shortcuts.

For official information, see Note 118184 – SAPshortcut – debugger start

via SAP wiki

Related Posts

]]> http://www.saplab.net/sap-abap-tips-how-to-debug-pop-up-window/feed/ 0 http://www.saplab.net/sap-abap-tips-how-to-debug-pop-up-window/ ABAP get STAD data log Syntax http://feedproxy.google.com/~r/SAPLab/~3/u1es1BaR6hM/ http://www.saplab.net/abap-get-stad-data-log-syntax/#comments Sun, 16 Jan 2011 19:07:05 +0000 Jack http://www.saplab.net/?p=156 ABAP get (read) STAD data log Syntax

SWNC_STAD_READ_STATRECS

SAPWL_READ_STATISTIC_FILES

Related Posts

]]> http://www.saplab.net/abap-get-stad-data-log-syntax/feed/ 0 http://www.saplab.net/abap-get-stad-data-log-syntax/ SAP FI Month End Closing Processes Guide http://feedproxy.google.com/~r/SAPLab/~3/_-w-tzs6cKw/ http://www.saplab.net/sap-fi-month-end-closing-processes-guide/#comments Sun, 16 Jan 2011 11:10:39 +0000 Jack http://www.saplab.net/?p=144 Month-End Closing in SAP comprises activities involved in closing a posting period. This document contains several steps and transactions used within the Month-End Closing process for a specific company. After a brief introduction a detailed explanation of the transactions in the main part of the documentation follows. Find below a list of transaction processes covered in this guide;

  • Payroll

    • Transaction F-02 (Payroll Expenses Input)

  • Revision of Material

    • Transaction KKAO (Calculate Work in Process: Collective Processing), Transaction KKS1 (Variance Calculation: Collective Processing), Transaction CO88 (PO Settlement: Collective Processing), Transaction KO8G (Settlement of Internal Orders)

  • Adjustment and Process Maintenance

    • Transaction F.50 (Profit and Loss Adjustment), Transaction F.5D (Calculate Balance Sheet Adjustment), Transaction F.5E (Post Balance Sheet Adjustment), Transaction F.05 (Foreign Currency Valuation)

  • Expenses Allocation

    • Transaction KSV5 (Allocations Distribution)

  • Scrap and Material Valuations

    • Transaction S_ALR_87012284 (Scrap Reclassification), Transaction ZCOPC (Balance Sheet Valuation), Transaction MB51 (Report of Monthly Scrap), Transaction KB51 (MAT & QUA Maintenance), Transaction KEU2 (Cycle Maintenance)

  • Maintenance

    • Transaction KB51 (MAT & QUA Maintenance) , Transaction KEU2 (Cycle Maintenance)

  • Sales & Cost of Sales
  • Personnel Expenses

    • Transaction KSA3 (Social Benefits Actual Accrual), Transaction KO8G (Actual Settlement of Internal Orders)

  • Fixed Assets

    • Transaction AFAR (Recalculate Depreciation), Transaction RAANALYZE01 (Determine Locked CC and IO), Transaction AFAB (Posting Depreciation), Transaction ASKB (Periodic Asset Posting)

  • CO-PA Assessment

    • Transaction KEU5 (Run Assessment Cycles)

  • Variances Calculation

    • Transaction KSS1 (Variances Calculation for Cost Centers), Transaction KSS2 (Actual Fix/Variable Cost Splitting), Transaction KALC (Reconciliation FI-CO)

  • P & L Report

    • Transaction KE30 (Export of P&L Report)

  • Balance Statement
  • P&L Forecast

Month End Closing Process Sample Guide in SAP FI

via sapdocs.info

Related Posts

]]> http://www.saplab.net/sap-fi-month-end-closing-processes-guide/feed/ 0 http://www.saplab.net/sap-fi-month-end-closing-processes-guide/ ABAP Transaction Codes ( ABAP TCODE) http://feedproxy.google.com/~r/SAPLab/~3/OQ4b3uRR_Q0/ http://www.saplab.net/abap-transaction-codes-abap-tcode/#comments Sun, 16 Jan 2011 01:01:55 +0000 Jack http://www.saplab.net/?p=139 USMM Pressing F8 will display all hotpacks applied. SEARCH_SAP_MENU Show the menu path to use to execute a given tcode. You can search by transaction code or menu text. DI02 ABAP/4 Repository Information System: Tables. LSMW Legacy System Migration Workbench. An addon available from SAP that can make data converstion a lot easier. Thanks to Serge Desland for this one. OSS1 SAP Online Service System OY19 Compare Tables SM13 Update monitor. Will show update tasks status. Very useful to determine why an update failed. S001 ABAP Development Workbench S001 ABAP/4 Development Weorkbench. S002 System Administration. SA38 Execute a program. SCAT Computer Aided Test Tool SCU0 Compare Tables SE01 Old Transport & Corrections screen SE03 Groups together most of the tools that you need for doing transports. In total, more than 20 tools can be reached from this one transaction. SE09 Workbench Organizer SE10 New Transport & Correction screen SE11 ABAP/4 Dictionary Maintenance SE12 ABAP/4 Dictionary Display SE13 Maintain Technical Settings (Tables) SE12 Dictionary: Initial Screen – enter object name. SE13 Access tables in ABAP/4 Dictionary. SE14 Utilities for Dictionary Tables SE15 ABAP/4 Repository Information System SE16 Data Browser: Initial Screen. SE16N Table Browser (the N stands for New, it replaces SE16). Provided by Smijo Mathew. SE17 General Table Display SE24 Class Builder SE30 ABAP/4 Runtime Analysis SE32 ABAP/4 Text Element Maintenance SE35 ABAP/4 Dialog Modules SE36 ABAP/4: Logical Databases SE37 ABAP/4 Function Modules SE38 ABAP Editor SE39 Splitscreen Editor: Program Compare SE41 Menu Painter SE43 Maintain Area Menu SE48 Show program call hierarchy. Very useful to see the overall structure of a program. Thanks to Isabelle Arickx for this tcode. SE49 Table manipulation. Show what tables are behind a transaction code. Thanks to Isabelle Arickx for this tcode. SE51 Screen Painter: Initial Screen. SE54 Generate View Maintenance Module SE61 R/3 Documentation SE62 Industry utilities SE63 Translation SE64 Terminology SE65 R/3 document. short text statistics SE66 R/3 Documentation Statistics (Test!) SE68 Translation Administration SE71 SAPscript layout set SE71 SAPScript Layouts Create/Change SE72 SAPscript styles SE73 SAPscript font maintenance (revised) SE74 SAPscript format conversion SE75 SAPscript Settings SE76 SAPscript Translation Layout Sets SE77 SAPscript Translation Styles SE80 ABAP/4 Development Workbench SE81 SAP Application Hierarchy SE82 Customer Application Hierarchy SE83 Reuse Library. Provided by Smiho Mathew. SE84 ABAP/4 Repository Information System SE85 ABAP/4 Dictionary Information System SE86 ABAP/4 Repository Information System SE87 Data Modeler Information System SE88 Development Coordination Info System SE91 Maintain Messages SE92 Maintain system log messages SE93 Maintain Transaction. SEARCH_SAP_MENU From the SAP Easy Access screen, type it in the command field and you will be able to search the standard SAP menu for transaction codes / keywords. It will return the nodes to follow for you. SEU Object Browser SHD0 Transaction variant maintenance SM04 Overview of Users (cancel/delete sessions) SM12 Lock table entries (unlock locked tables) SM21 View the system log, very useful when you get a short dump. Provides much more info than short dump SM30 Maintain Table Views. SM31 Table Maintenance SM32 Table maintenance SM35 View Batch Input Sessions SM37 View background jobs SM50 Process Overview. SM51 Delete jobs from system (BDC) SM62 Display/Maintain events in SAP, also use function BP_EVENT_RAISE SMEN Display the menu path to get to a transaction SMOD/CMOD Transactions for processing/editing/activating new customer enhancements. SNRO Object browser for number range maintenance. SPRO Start SAP IMG (Implementation Guide). SQ00 ABAP/4 Query: Start Queries SQ01 ABAP/4 Query: Maintain Queries SQ02 ABAP/4 Query: Maintain Funct. Areas SQ03 ABAP/4 Query: Maintain User Groups SQ07 ABAP/4 Query: Language Comparison ST05 Trace SQL Database Requests. ST22 ABAP Dump analysis SU53 Display Authorization Values for User. WEDI EDI Menu. IDOC and EDI base. WE02 Display an IDOC WE07 IDOC Statistics

via sapdocs.info

Related Posts

]]> http://www.saplab.net/abap-transaction-codes-abap-tcode/feed/ 0 http://www.saplab.net/abap-transaction-codes-abap-tcode/