140 likes | 359 Views
SAP TERP10 Preparation Practice 1 Dr. Gábor Pauler, Associate Professor, Private Entrepeneur Tax Reg. No.: 63673852-3-22 Bank account: 50400113-11065546 Location: 1st Széchenyi str. 7666 Pogány, Hungary Tel: +36-309-015-488 E-mail: pauler@t-online.hu. Content of the Practice.
E N D
SAP TERP10 Preparation Practice 1 Dr. Gábor Pauler, Associate Professor, Private Entrepeneur Tax Reg. No.: 63673852-3-22 Bank account: 50400113-11065546 Location: 1st Széchenyi str. 7666 Pogány, Hungary Tel: +36-309-015-488 E-mail: pauler@t-online.hu
Content of the Practice • 1.Introduction • 1.8.SAP GUI • 1.8.1.Main screen launching transactions • 1.8.2.Navigation, searching for transactions • 1.8.3.Quick links to transactions • 1.8.4.Data entry in transactions, searching field values • 1.8.5.Output tables of transactions • 1.8.6.Printing outputs • 1.8.7.Customization • 1.8.8.Help • Home Assignment 1: Export ALV Grid to Excel • References • Object Symbols • GUI Symbols
1.8.SAP GUI: 1.8.1.Main screen, launching transactions • 1.8.1.Main screen: top left you can see the Command line for running transactions by code • Transactions can also be launched from SAP Menu (SAP menü) in a module-based hierarchy, or you can pull them into the Favorites Folder (Kedvencek mappa). However as there are 1000s of transactions, the codes of most important ones you should memorize: 1.8.1.1.General: • SE93:codes of valid trabsactions • SM50:list of server processes • ST22:Short Dumps(Hibaüzenetek) 1.8.1.2.Handling users: • SU01:Create/Modify/Delete • SU02:Roles(Szerep):built from: • SU03:Profiles(Profil):built from: • PFCG:Authorizations(Jogosultság): • They are built from: • SU21:Authorization Objects (Jogo- • sultsági objektumok): they give per- • mission to users to do something • SU53:Authorization error messages • SU56:List of authorizations ordered to current user 1.8.1.3.Customizing (Testreszabás): • SPRO:All customization settings 1.8.1.4.ABAP development: • SA38:Launch ABAP programs • SE80:ABAP Developer Workbench • SE37:Searching Function Modules • SE11:Structure of database tables • SE16:Content of database tables • SE03:Task(Rdsz.frissítés)list built from: • SE01:Change Request(Rdsz.változta- • tási kérelem) objects SE93 Click Click • Transaction codes are not case sensitive • 1.8.1.5:Transactions can be run: from command line with Switches(Kapcsoló) combined: • /oTransactID:running new transaction in new Modus (Képernyő) (default setting) • /nTransactID:in same modus, closing last • There are general navigation buttons to shift among Dialog-step screens(Dialóguslépés): • :Back to last screen • :Return to main screen • :Run program, :Abort transaction
1.8.SAP GUI: 1.8.2.Navigation, searching transactions Click • 1.8.2.Navigate&Search: there are other navigation buttons for handling longer screens/documents: • :Save, :Print • , , , :Prev./Next/First/Last page • , :Search text/Next occourence • :Open new modus (in case of you want to check earlier transactions without abort!) • :View, :Modify, :Create • Text clipboard: Ctrl-C:copy,Ctrl-V:past Ctrl-Y:copy text falling in rectangular marquee • If we opoened a bounch of moduses and it is hard tofollow in which server>mandant>transaction> dialog screen>subscreen/panel/tab we are: • Status Row (Státuszsor) shows some data • Clicking button ( ) there you can get more • In Extras|Settings|Technical names (Kiegé-szítések|Beállítások|Műszaki nevek) menu: show transaction codes in SAP Menu • In System|Status (Rendszer|Státusz) menu you can get more detailed status report • If you do not know where is a transaction in SAP menu you can search in the following ways: • From running SAP GUI: • SE93:Transaction maintenance, or • SAP Menu selected, Search button Click Click Click Click Click Click Click
1.8.SAP GUI: 1.8.3.Quick links on transactions • If you do not have working SAP GUI nearby: http://www.tudasmorzsak.hu/components/com_joomlawiki/index.php/Tranzakci%C3%B3s_k%C3%B3dok • 1.8.3.Quick links for frequently used transactions: • 1.8.3.1.You can put it into favourites folder: • Manual creation: Favorites|RightClick |Insert transaction(Kedvencek|Jobbkatt|Tranzakció beillesztése) popup menu • Automatic creation: SAP Menu| Transaction| RightClick|Add to favorites(SAP menü|Tranzak-ció|Jobbkatt|Felvétel a favoritokhoz) • 1.8.3.2.You can prepare desktop shortcut: • 1.8.3.2.1.Manual creation: Windows desktop| RightClick |New|SAPGUI shortcut|Paramor ( ) button: you can give all settings manually: • System name • SystemID • SAP-GUI parameters: eg. /n, /o • Mandant • User • Password • Language: Language of GUI • Type: Transaction • Command: transaction code • Title: the title of shortcut • 1.8.3.2.2.Automatic: SAP menu| Transaction| RightClick|Create shortcut(SAP menü|Tranzak-ció| Jobbkatt|Shortcut létrehozása): it creates from actually running transaction Right Click Click Click Click Click Click Click Click Click Click Click Right Click
Content of the Practice • 1.Introduction • 1.8.SAP GUI • 1.8.1.Main screen launching transactions • 1.8.2.Navigation, searching for transactions • 1.8.3.Quick links to transactions • 1.8.4.Data entry in transactions, searching field values • 1.8.5.Output tables of transactions • 1.8.6.Printing outputs • 1.8.7.Customization • 1.8.8.Help • Home Assignment 1: Export ALV Grid to Excel • References • Object Symbols • GUI Symbols
1.8.SAP GUI: 1.8.4.Data entry in transactions, searching field values • 1.8.4.How to enter data in a transaction? Eg. We would like to search the table con-taining raw materials and see its contents: • SE16:launch this to see table contents • It asks for table name, but it’s unknown • Click on Lokup/Control table(kinéze-gető/ellenőrző tábla) button ( ), or press F4: it will pop up list of possible values, or if there are many of them, it shows a searching dialog • Give here the known part of the name with * wildcards, eg.: MA* (as we are looking for some „Materials” table) • ( ):you can give here additional search values and match relations: <=,>=, <> • ( ):start searching, see match list • This can be sorted ( , ), text-search-ed ( , ), and if you found something (eg. MARA:raw materials), you can see it with ( ) and select with ( ) • As there are many records in the table, it shows a search dialog for its primary key(eg.MATNR:MaterialID) where you can select values again with ( ), you can give multiple filter values with ( ), and additional filter relations with ( ) • Output list width: max. number of columns in output table • Max.number of matches: at large tab-les, search results can be also large, resulting long download time, therefore we limit results to a sample of first 300 • ( ): display output table Click Click Click Click Clickt Click Click Click Click
1.8.SAP GUI: 1.8.5.Output tables of transactions Click • 1.8.5.Handling output tables of transactions • By default, output tables are shown in SE16-style Data Browser (Adatmeg-jelenítő), which is an old and obsolete character-based table • You can step on records with ( , ) sort them with ( , ),select/deselect them with( , ), see which database table fields they are from with ( ), and see detailed record content with ( ) • Control table button shows other tables referenced by Foreign keys (Idegen kulcs) of the current table • At SE16 main screen, select Tablena-me field and press ( ) User parame-ters button, • Then in Data Browser tab| Output list panel, check in ALV-Grid (ALV-rács), re-run the transaction and you will see a more modern, Excel-like of graphic type data browser with extra functions: • You can define complex filter ( ) • You can aggregate table fields ( ) • You can format graphic printing ( ) • Export table in XML file ( ) • Export table into Excel/Word ( ) • Send table by E-mail ( ) • Change table field layout ( ). This can be saved with ( ), and the tab-le will open using it. You can load previously saved layout with ( ) Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click Click
1.8.SAP GUI: 1.8.6.Printing, 1.8.7.Customization, 1.8.8.Helps • 1.8.6.Printing output tables: • At the data browser press • Print( ) button for Print screen list panel: • Printer:Local/Network/PDF file • Copies:n • Pages: From - To • Properties button: properties of the printable document in Spool (Nyomtatási lista): this is an area in server memory where documents are waiting to be printed and can be viewed/edited/deleted by System menu|Own spool request: • Name, Title, Authorization, • Immediate printing, Delete after printing • 1.8.7.SAP R/3 Customization (Testreszabás): • System settings( )button|Options menu: • Local Data tab: remember the last values entered in a given field or not • Expert tab| Check Show technical names(Mutassa műszaki neveket): in lookup /control tables it will show BOTH text description and primary key code of items: the latter is unique and independent from the actual language of GUI! • SPRO: this is the transaction handles all SAP customization settings in a complex hierarchy similar to SAP menu: in nearly the same structure (SAP IMG) you can find settings of the given country, company,etc. You should have SAP_ALL rights to modify • 1.8.8.SAP GUI Helps: • 1.8.8.1.Local helps: • F1 hotkey anywhere: general transaction-level help • F4 or ( ) button on data field: list of possible values in the field • Here RightClick|Tecnical info menu or Technical info( ) button will show the data source tables of the selectable values of field • General web-help: http://help.sap.com/ (business processes, transactions, dialogs) • 1.8.8.2.Remote helps: • DEF:Note: downloadable service packages: http://service.sap.com/notes accessible only with buying extra Service Market Place (SMP) authorization. Searchable for: • HIER: Suite>Module>Application Area (almodul)>Transaction>Dialog>Error • DEF:Message: sysadmins error message towards SAP based on the same hierarchy Click Click
Content of the Practice • 1.Introduction • 1.8.SAP GUI • 1.8.1.Main screen launching transactions • 1.8.2.Navigation, searching for transactions • 1.8.3.Quick links to transactions • 1.8.4.Data entry in transactions, searching field values • 1.8.5.Output tables of transactions • 1.8.6.Printing outputs • 1.8.7.Customization • 1.8.8.Help • Home Assignment 1: Export ALV Grid to Excel • References • Object Symbols • GUI Symbols
Home Assignment 1: Export ALV Grid to Excel • Export into MS Excel: • From SAP IDES Mandant 912: • Table MARA:raw materials: • Only within first 200 records • Where name of the data recorder was Diehl (ERNAM = DIEHL) (5 points) • Solution: HomeAssign1Solution.xls
References • http://www.sap-img.com/abap.htm • http://erpgenie.com/ • http://help.sap.com/search/sap_trex.jsp • http://sap.ittoolbox.com/groups/technical-functional/sap-abap/
Object Symbols Partner (Partner) Anyag (Material) Sarzs (Batch) Bevitt anyag (Partner material) Készlet (Inventory) Raktár (Deposit) Gyári szám (Serial number) Darabjegyzék (Bill of materials) Szortiment (Sortiment) Anyagmeghatá-rozás (Material Identification) Árazás (Pricing) Engedmény (Allowance) Fizetési mód (Payment Method) Számla (Invoice) Bizonylat (Voucher) Értékesítés támogatás (Sales Promotion) Direkt mail (Direct mail) Ajánlat (Offer) Árazás (Pricing) Rendelés (Order) Validáció (Validation) Szerződés (Contract) Szállítás (Transport) Hitel (Credit) Ütemezés (Scheduling) Szerviz (Service) Vevőszolgálat (Customer Service) Kattintás (Click) Dupla kattintás (Double Click) Adatbevitel (Write) Csak olvasható (Read Only) • Cég (Company) • Gyár (Plant) • Értékesítési szervezet (Sales Department) • Üzletkötő csoport (Sales Representative Group) • Értékesítési integráció (Sales Integration) • Csatorna (Channel) • Földrajzi hely (Geographic Location) • Kiszállítási hely (Delivery Location) • Szállítási mód (Transportation Mode) • Rakodási pont (Loading Point) • Árucsoport (Product Group) • Értékesítési terület (Sales Area) Click Right Click
GUI Symbols • To make GUI usage descriptions more short and straightforward, we will use standardized denotions of GUI controls, which can be nested into each other: • DEF:-definition, • PRC:-process, • ALT:-alternatives, • CYC:-cycle, • -follows, • -(dis)advantage, • Aaa|Bbb|-Menu/Submenu, • SCR:-Screen, • FRM:-Frame, • ID-UniqueID, • BTN:-Button, • TXB:-Textbox, • DDN:-Dropdown, • TAB:-Page tab, • CHK:-Checkbox (any of them can be checked) • RAD:-Radiobox (one can be checked only), • LIN:-Tableline, • KEY:-Hotkey, • WRN:-Warning box • ERR:-Errorbox