Monday, March 24, 2008
SAP TRANSACTION CODES
ME21 - create purchase order
ME22 - change purchase order
ME51N - Create a Purchase Requisition
ME52N - Change a Purchase Requisition
ME53N - Delete a Purchase Requisition
ME54 - Individual Release of a Purchase Requisition
ME55 - Collective Release of a Purchase Requisition
MIGO - Receive Goods/Services
DEVELOPING:
S001 Abap Workbench
SE09 Workbenche organizer (Transports)
SE11 ABAP/4 Dictionary
SE16 Data browser
SE24 Class builder
SE30 ABAP Runtime
SE32 ABAP/4 Text Element Maintenance
SE35 ABAP/4 Dialog Modules Maintenance
SE36 Logical DatabasesSE37 Function builder
SE38 ABAP/4 EditorSE39 Program Comparison
SE41 Menu Painter
SE43 Area Menu editor
SE48 Call hierarchy
SE49 Program analysis: Table Manipulation
SE51 Screen Painter: Initial Screen.
SE55 Table maintenance dialog
SE80 Repository browser
SE91 Message Classes
SE93 Maintain transaction
SHDB Batch input recorder
SM30 Maintain table views
SM35 Monitor batch input
ST22 Short dump analysis
MONITORING:
ST05 SQL Trace
ST07 Application monitor3.System
SM04 User overview ( Possible to end sessions)
SM12 Table lock Entries
SM21 System log for viewing dumps
SM36 Define background jobs
SM37 View background jobs
SM50 Process Overview
SU53 Display Authorization Values for User
SLG1 View application log
SLG2 Delete application log
SPAD Output devices
SP01 See spool
SAP SCRIPTS:
SE71 Form painter
SE72 Style maintenance
SE73 SAPscript font maintenance.
SE74 SAPscript format conversion
SE75 SAPscript Settings
SE76 SAPscript Form Translation
SE77 SAPscript Style Conversion
SE78 SapScript Graphics Management
SO10 Create standard text module
WORKFLOW:
SWDM Workflow explorer
SWDD Workflow builder
SWUS Start workflow - Test enviromnent
SWU0 Simulate event
SBWP Business workplace
PFTC_INS Create Task/Task group
PFTC_CHG Change Task/Task group
SWUD Dagnosis
SWI1 Work item selection
ENHANCEMENTS & MODIFICATIONS:
CMOD Enhancementprojects
SMOD List SAP enhancements to use in
CMODSHD0 Transaction variant maintenance
ABAP IMG TCODES:
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)
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).
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.
SE49 Table manipulation. Show what tables are behind a transaction code.
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
SE82 Customer Application Hierarchy
SE83 Reuse Library.
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
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
BP_EVENT_RAISESMEN 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
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
WEDI EDI Menu. IDOC and EDI base.
WE02 Display an IDOC
WE07 IDOC Statistics
SAP TABLES
VBBE Sales Requirements: Individual Records
VBEH Schedule line history
VBEP Sales Document: Schedule Line Data
VBFA Sales Document Flow
VBLB Sales document: Release order data
KONV Conditions for Transaction Data
KONP Conditions for Items
LIKP Delivery Header Data
LIPS Delivery: Item data
VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBLK SD Document: Delivery Note Header
VBPA Sales Document: Partner
VBRK Billing: Header Data
VBRP Billing: Item Data
VBUK Sales Document: Header Status and Administrative Data
VBUP Sales Document: Item Status
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)
VEPVG Delivery Due Index
MATERIAL MANAGEMENT TABLES:
MBEW Material ValuationMKPF Header- Material Document
MSEG Document Segment- Material
MVER Material Consumption
MVKE Sales Data for materials
EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
MARA General Material Data
MARC Plant Data for Material
MARD Storage Location Data for Material
MAST Material to BOM Link
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
ABAP FAQS WITH ANSWERS
YES. eg:- ITAB LIKE SPFLI.here we are referening to a data object(SPFLI) not data element.What are the different types of data dictionary objects? tables,structures, views, domains, data elements, lock objects, Match codeobjects.
2. What should be the approach for writing a BDC program?
STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internaltable CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATATRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPEi)call transaction(Write the program explicity)ii) create sessions (sessions are created and processed.if successdata will transfer).
3. What are the problems in processing batch input sessions and Howis batch input process different from processing online?
PROBLEMS:i) If the user forgets to opt for keep session then the session willbe automatically removed from the session queue(log remains).However if session is processed we may delete it manually.
ii)if session processing fails data will not be transferred to SAPdatabase table.
4. What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups anddefined their structure, you can fill the extract dataset using thefollowing statements: EXTRACT. When the first EXTRACT statementoccurs in a program, the system creates the extract dataset and addsthe first extract record to it. In each subsequent EXTRACTstatement, the new extract record is added to the dataset EXTRACTHEADER. When you extract the data, the record is filled with thecurrent values of the corresponding fields. As soon as the systemhas processed the first EXTRACT statement for a field group , thestructure of the corresponding extract record in the extract datasetis fixed. You can no longer insert new fields into the field groupsand HEADER. If you try to modify one of the field groups afterwardsand use it in another EXTRACT statement, a runtime error occurs. Byprocessing EXTRACT statements several times using different fieldgroups, you fill the extract dataset with records of differentlength and structure. Since you can modify field groups dynamicallyup to their first usage in an EXTRACT statement, extract datasetsprovide the advantage that you need not determine the structure atthe beginning of the program.
5. Can a transparent table exist in data dictionary but not in thedata base physically?
NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE BOTH IN THEDICTIONARY AS WELL AS IN THE DATABASE,EXACTLY WITH THE SAME DATA ANDFIELDS.
6. What is the step by step process to create a table in datadictionary?
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a tablefield).
step 3: creating tables(SE11).
7. What is the typical structure of an ABAP/4 program?
HEADER ,BODY,FOOTER.
8. A situation: An ABAP program creates a batch input session. Weneed to submit the program and the batch session in back ground. Howto do it?
go to SM36 and create background job by giving job name, job classand job steps (JOB SCHEDULING)
9. What are the domains and data elements?
DOMAINS : FORMAL DEFINITION OF THE DATA TYPES.THEY SET ATTRIBUTESSUCH AS DATA TYPE,LENGTH,RANGE.
DATA ELEMENT : A FIELD IN R/3 SYSTEMIS A DATA ELEMENT.
10. What is the alternative to batch input session?
Call transaction.
11. What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal tableand database table. Data along with the action is stored in sessionie data for screen fields, to which screen it is passed, programname behind it, and how next screen is processed.
12. What is the advantage of structures? How do you use them in theABAP programs?
Adv:- GLOBAL EXISTANCE(these could be used by any other programwithout creating it again).
13. How many types of tables exists and what are they in datadictionary?
4 types of tables
i)Transparent tables - Exists with the same structure both indictionary as well as in database exactly with the same data andfields. Both Opensql and Nativesql can be used.
ii)Pool tables &iii)Cluster tables - These are logical tables that are arranged asrecords of transparent tables. one cannot use native sql on thesetables (only open sql).They are not managable directly usingdatabase system tools.
iv)Internal tables - .?
SAP SCRIPTS & SMARTFORMS FAQS
2.What are the components/elements in sap script ?
3.Can you create a script with out a main window ?
4.How many main windows can be created for a script ?
5.How can we use tables in sap scripts?
6.How to print a logo in a sap script?
7.When we need to modify standard scripts(eg:medruck) given by sap?
8.What is the use of transaction code NACE in sap scripts?
9.what is the table name that will contain all the script form names and print program names?
10.Can you assign your own form to a standard print program? how?
11.What is the use of PROTECT & ENDPROTECT?
12.How to add extra functionality to a standard print program with out touching the print program?
13.what is sub routine pool in sap script? when it is used?
14.How to read text in sapscripts?
15.What is the transaction code for logo uploading?
16.what is the difference between paragraph & character format?
17.How to use a sapscript for multiple languages ? (english,germany etc)
18.How to download/upload sapscripts from & to your PC ?
19.What is the difference between scripts & smart forms?
20.What is the standard program used for uploading the logo to script?
21.How can you send forms from one client to other?
22.what does open_form, write_form, close_form do?
23.How to convert a sapscript to smart form?
24.How to send a smartform result through mail?
25.how to select desired paper size in sapscript?
PERFORMANCE TUNING FAQS
2.What are steps you follow to improve the performance of a report ?
3.what is the role of secondary index in performance?
4.what is the role of ST05 in performance tuning?
5.what is the role of extended syntax check in performance tuning?
6.will join conditions in sql queries affect perfomance? how?
7.will sorted internal tables help in performance?
8.will where conditions in a sql query help improve performance?
9.does select single *.. / select * .. affect performance ? how?
BDC & LSMW FAQS
2.What is call transaction method ? what is the syntax/procedure?
3.What is session method and what is the syntax/procedure?
4.Difference between call transaction & session method?
5.which of these methods can be best used in background process?
6.What is direct input method?
7.How LSMW is advantageous than normal BDC?
8.what are the steps in lsmw?
9.IN LSMW can you use BAPI, ?
10.Can you call a bdc from a report program?
11.what is the difference between synchronus & asynchronus methods?
12.call transaction uses synchronus or synchronus method?
13.session method uses synchronus or synchronus method?
14.What is bapi?
15.how bapi is different from call transaction/session?
16.what r the advantages of bapi?
17.for uploading master data(ex:customer data) into sap, which methods you prefer? call transaction/session/lsmw/bapi? why?
18.tell any 2 standard bapi function modules used for uploading sales order data?
INTERNAL TABLE FAQS
2.how many type of internal tables are there?
3.what is the difference between hashed & sorted internal tables?
4.what is the difference between standard and sorted internal tables? (in performance wise)
5.Difference between internal table and a dictionary table?
6.can you create an internal table dynamically?(at run time)
7.what is the use of select for all entries in an internal table?
8.when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal table. What will be the result? (2nd internal table contains records).
9.in a loop of an internal table, what is the use of at first & at last statements?
10.What is the use of at new statement?
11.what is the difference between at first & at new statements?
12.what is a binary search ? and how it is useful in a sorted internal table?
13.when do you need to create an internal table with header line ?and with out a header line?
14.what does it mean occurs 0 while creating an internal table?
15.what will happen if you don't give occurs clause while creating an internal table?
16.what is the difference between clear, delete & refresh with respect to an internal table?
ABAP REPORTS FAQS
2.what are types of reports?
3.difference bet'n simple and interactive reports?
4.what are the events in interactive reports?
5.what is the first event that will be triggered in a report?
6.what is the use of Initialization event? give one example.
7.what is the use of start-of-selection event?
8.what is the difference betn end-of-page and end-of-selection?
9.if you write a write statement after end-of-selection, will that be triggered?
10.how to create a button in selection screen?
11.how to add a gui status in a selection screen?
12.what is at-line-selection event?
13.How many secondary lists can be created in an interactive report?
14.how to create a check box/option button in a list?
15.can you call a bdc program from a report? how?
16.can you call a transaction from a report? how?
17.what are ALV reports? how they are different from normal reports?
18.what are the main events that are used in an ALV report?
19.what is the use of SLIS type pool in alv reports?
20.difference betn top-of-page and top-of-page during at-line-selection?
21.in an interactive report, after going to 5th list, can you come back to 2nd list? how?
REAL TIME FAQS
2.You are running a report. It is taking long time for execution. What steps will you do to reduce the execution time.
3.After running a BDC program in background, next day morning when you see the results, few records are not updated(error records). What will you do then?
4.You are given functional specs for a BDC program and you need to decide whether to write a method call transaction or a session. How u will decide?
5.What is the difference between report and script?
6.what are the differences between scripts & smart forms?
7.what are enhancements?
8.what are user-exits?
9.what is badi?
10.what is the difference between user-exit & BADIs?
11.what is the difference between user-exit & customer-exit?
12.how do you get functional specs when you are assigned some object? (specs through email..??)
13.How do you write technical specs?
14.How do you write UTP?(unit test plan)
SAP ABAP DATA DICTIONARY FAQ
SAP ABAP FAQ (Technical):
Data Dictonary:
1.What is data Dictionary ?
2.What is the difference between open sql & native sql ?
3.Difference between Pooled, cluster & transparent tables?
4.What is Primary key, foreign key ? what is primary index? secondary index?
5.how many indexes can be created for a table?
6.what is a value table?
7.what are the components of a table?
8.what is a domain?
9.what is a data element?
10.what is data class?
11.can you create a table with out a data element?
12.can you create a field with out a data element?
13.What approach you prefer for creating a table?
14.Give few names of cluster tables in sap?
15.Give few names of pooled tables in sap?
16.give few names of transparent tables?
17.what is a buffer and how many types?
18.what is table maintenance generator and how to create that? What is the transaction code?
19.How to add new fields to a standard sap table ?
20.How many types of table joins are there?
21.difference between inner join & outer join?
22.Difference between "select * from mara" and "select single * from mara"?
23.what is a match code ? Lock objects ?
24.what are views?
25.what are logical tables/database?
26.what is the difference bet'n table and a structure?
Sunday, March 23, 2008
SAP History
Systems, Applications, Products in data processing or SAP was originally introduced in the 1980’s as SAP R/2 which was a mainframe system that provided users with a soft-real-time business application that could be used with multiple currencies and languages. Later when client servers were introduced SAP brought out a server based version of their software called SAP R/3, henceforth referred to as SAP, which was launched in 1992. They also developed a graphical user interface or GUI to make it more user friendly and to move away from the mainframe style user interface. For the next 10 years SAP dominated the large business applications market. It was successful primarily because it was extremely flexible. Because SAP was a modular system meaning that the various functions provided by it could be purchased piecemeal it was an extremely versatile system. All a company needed to do was purchase the modules they wanted and customize the processes to match the company’s business model. SAP’s flexibility, while one of its greatest strengths is also one of its greatest weaknesses. We will now turn to the audit issues surrounding SAP.
REPUTATION:
SAP is the third-largest software company in the world. It ranks after Microsoft and Oracle in terms of market capitalization. SAP is the largest business application and Enterprise Resource Planning (ERP) solution software provider in terms of revenue.
PRODUCTS:
SAP's products focus on ERP, which it helped to pioneer. The company's main product is SAP R/3; the "R" stands for realtime data processing and the number 3 relates to a 3-tier architecture: database, application server and client (SAPgui). SAP R/3's predecessor was R/2 which ran on a Mainframe architecture.Other major product offerings include Advanced Planner and Optimizer (APO), Business Information Warehouse (BW), Customer Relationship Management (CRM), Supply Chain Management (SCM), Supplier Relationship Management (SRM), Human Resource Management Systems (HRMS), Product Lifecycle Management (PLM), Exchange Infrastructure (XI), Enterprise Portal (EP) and Knowledge Warehouse (KW).The APO name has been retired and rolled into SCM. The BW name (Business Warehouse) has now been rolled into the SAP NetWeaver BI (Business Intelligence) suite and functions as the reporting module.The company also offers a new technology platform, named SAP NetWeaver. While its original products are typically used by Fortune 500 companies, SAP is now also actively targeting small and medium sized enterprises (SME) with its SAP Business One and SAP All-in-One.Reportedly, there are over 100,800 SAP installations at more than 28,000 companies. SAP products are used by over 12 million people in more than 120 countries
IMPLEMENTATION:
SAP Implementation is the whole of processes that defines a complete method to implement SAP software in an organization. The SAP implementation method described in this entry is a generic method and not a specific implementation method as such. It is based on best practices and case studies from various literature sources and presents a collection of processes and products that make up a complete implementation method to allow any organization to plan and execute the implementation of SAP (ERP) software.