SAP scripts Tips and Tricks SAP scripts is the standard SAP form design tools for to developed customized form printing format such as purchase orders, invoices, checks, labels. With the combination of third party barcode software (barcode.dll) or printer with bardimm, you can print barcode directly using SAP scripts. SAP Scripts Reference Books SAPscript Made Easy 4.6 ABAP Certification Books ABAP Programming: A Guide to the Certification Course Introduction SAPScript Transaction codes Commands Reading Text in SAPScripts Boxes/Lines/Shading Printer commands in SAPScripts Different font on the same line Print Footer notes only on the last page Orientations in SAPSCRIPT Protect...Endprotect Retrieving data without modifying the original called program SAPscripts How to calculate Totals and Subtotals Conversion Developing SAPScript in different languages Useful Program Tools How to convert Sapscript spools request to PDF? How to graphics (IMAGE) to your Sapscript? Import/Export SapScript form from PC file Common Problems Picture doesn't show in Print Preview Delete Load program for SAPScript Barcodes Details information about SAP Barcodes SapScripts FAQ SapScript Question
Questions on PO SapScripts MEDRUCK A Sample SAP Scripts Reports SAP ABAP Forum at the convenient of your mail box Exchange ABAP related problems/solutions, program, tips, ideas with other ABAP peers from around the globe. Note: An Auto Free ABAP Tips Windows Help File will be send to you upon ing. SAP ABAP Forum for ABAP Professional
enter email ad
Quick Links ABAP Tips and Tricks Main Menu Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Functional, Basis and ABAP Programming Reference Books
SAPScript Transaction codes SE71 - Form painter SE72 - Style maintenance SE78 - SapScript Graphics Management SO10 - Create standard text module
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Reading Text in SAP Scripts If you only need to output the text, you don't need to used READ_TEXT like in an ABAP program, just use the INCLUDE command in SAP Script. It will read the text and output it to your form. The Syntax is like this: /: INCLUDE &T166K-TXNAM& OBJECT &T166K-TDOBJECT& ID &T166K-TDID& LANGUAGE &EKKO-SPRAS& Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Scripts Boxes/Lines/Shading Setting default parameters for a box: You can use the POSITION and SIZE commands to set default parmeters for a box. Instead of: /: BOX XPOS '11.21' MM YPOS '5.31' MM HEIGHT '10' MM WIDTH '20' MM INTENSITY 10 FRAME 0 TW You can write: /: POSITION XORIGIN '11.21' YORIGIN '5.31' MM /: SIZE HEIGHT '2' MM WIDTH '76' MM /: BOX FRAME 10 TW INTENSITY 10
This can be useful if you gave several boxes that share the same parameters. If you want to set the position relatively to the window use POSITION WINDOW to set the position to the top/left start of the window. Then use POSITION to set the current position relatively to the start of the Window. Note that you uses "+" or "-" in the ORIGIN position to the set the position relatively. /: POSITION WINDOW /: POSITION XORIGIN '+5' MM YORIGIN '+10' MM the position is now 5 MM from the left and 10 MM from the top of the window NOTE: After using the position command you can move the current position realtively to the last used position /: POSITION XORIGIN '+10' MM YORIGIN '+20' MM Now the position will be X = 15 and Y = 30 Drawing a line. You can draw a line by setting the Height or Weidth to 0 and add a frane. E.g. a horizontal line: /: SIZE HEIGHT '0' MM WIDTH '200' MM /: BOX FRAME 10 TW XPOS '11.21' MM YPOS '14.81' MM INTENSITY 100 Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
SAP Printer commands in SAPScripts The command line in the editor must be as follows: /: PRINT-CONTROL xxxxx
or /: PRINT-CONTROL 'xxxxx' where xxxxx stands for the five-character name of the print control. Example: /: PRINT-CONTROL ZM100 The complete printer command normally resides in the print control. If characters belonging to the print command follow after the print control in the text (only useful for the HPL2 printer driver for PCL-5 printers), the text line following after the PRINT-CONTROL command should begin with an equals sign (=) in the format column. Example: /: PRINT-CONTROL SES = *c5G If you do not use the equals sign, a space character is inserted between the print control SES and the character *c5G. Refer to OSS note 5996 - How can SAPscript include printer commands? Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Different font on the same line You can have different font on the same line by defining a character format. For example B for bold text and U for Underline. In your SAPScript apply like this :
Underline Text Bold Text
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Print Footer notes only on the last page Command to used in your sapscripts :/: IF &NEXTPAGE& EQ 0 whatever footer you want. /: ENDIF Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Orientations in SAPSCRIPT -----Original Message----Subject: Orientations in SAPSCRIPT From: Ashwini Jaokar Hi, I have 2 pages for a Form in SAPscript . Can I have 2 different Orientations for 2 pages Ie Can I assign Page1 as Portrait & page2 as Landscape ??? If so , How ????
Thanks in Advance. Ashwini Jaokar. -----Reply Message----Subject: Re: Orientations in SAPSCRIPT From: jmersinger Ashwini, Not that I know of in the same layoutset...what you can do is create two layoutsets...one portrait, one landscape...then in the print program call each one individually. jjm -----Reply Message----Subject: RE: Orientations in SAPSCRIPT From: Ralph Klassen Each form may only have a single orientation but you can create two forms and include them in the same spool output. In your ABAP program: 1. call function 'OPEN_FORM', don't a value in 'FORM' 2. call function 'START_FORM', include parameter 'FORM' ing the name of your first form 3. call function 'WRITE_FORM' as normal to output each element 4. call function 'END_FORM' 5. call function 'START_FORM', include parameter 'FORM' ing the name of your second form 6. call function 'WRITE_FORM' as normal to output each element 7. call function 'END_FORM' 8. call function 'CLOSE_FORM' Repeat the 'START_FORM' ... 'END_FORM' sequence as required. I have not tried using page numbers with this technique, I suspect that each form will
restart at 1. Regards, Ralph Klassen Sylogist -----End of Reply Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Protect...Endprotect -----Original Message----Subject: Protect...Endprotect Hi, Can anyone share what's a PROTECT...ENDPROTECT in SAPScript form? Thanks. -----Reply Message----Subject: RE: Protect...Endprotect hello! While using Scripts, if u don't want to break a paragraph text which aparts to another page i.e. if u wanna display the paragraph with out breaking in between two pages, u have to use protect...endprotect. all the best! regards -----End of Message-----
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Retrieving data without modifying the original called program * * Retrieving data without modifying the original called program * * Put this script code in your sapscripts * /: PERFORM GET_BARCODE IN PROGRAM ZSCRIPTPERFORM * /: USING &PAGE& * /: USING &NEXTPAGE& * /: CHANGING &BARCODE& * /: ENDPERFORM * / &BARCODE& * * Submitted by : SAP Basis, ABAP Programming and Other IMG Stuff * http://www.sap-img.com * REPORT ZSCRIPTPERFORM. FORM GET_BARCODE TABLES
IN_PAR STRUCTURE ITCSY OUT_PAR STRUCTURE ITCSY.
DATA: PAGNUM LIKE SY-TABIX, "page number NEXTPAGE LIKE SY-TABIX. "number of next page READ TABLE IN_PAR WITH KEY 'PAGE'. CHECK SY-SUBRC = 0. PAGNUM = IN_PAR-VALUE. READ TABLE IN_PAR WITH KEY 'NEXTPAGE'. CHECK SY-SUBRC = 0. NEXTPAGE = IN_PAR-VALUE. READ TABLE OUT_PAR WITH KEY 'BARCODE'. CHECK SY-SUBRC = 0. IF PAGNUM = 1. OUT_PAR-VALUE = '|'. "First page ELSE. OUT_PAR-VALUE = '||'. "Next page ENDIF. IF NEXTPAGE = 0. OUT_PAR-VALUE+2 = 'L'. "Flag: last page ENDIF.
MODIFY OUT_PAR INDEX SY-TABIX. ENDFORM. *-- End of Program
SAPscripts How to calculate Totals and Subtotals I have some doubs in BDC and SMART FORMS. I want to change the material number using the transaction code MM02 through BDC. In scripts and smartforms how to calculate totals and subtotals? To calculate totals and sub totals in sap scripts you have to use subroutines. Say if you have to add the unit price (KOMVD-KBERT) then in the main window whereever tat value is picked write this routine /: DEFINE &TOT_PRICE& /: PERFORM F_GET_PRICE IN PROGRAM <subroutine prog name> /:USING &KOMVD-KBERT& /:CHANGING &TOT_PRICE& /:ENDPERFORM Then write the variable where ever you want it to be printed (mostly it will be in footer window) Then create subroutine pool program and you have to write the code. FORM F_GET_PRICE tables int_cond structure itcsy outt_cond structure itcsy. data : value type kbert. statics value1 type kbert. Read int_cond table index 1. value = int_cond-value. value1 = value1 + value. Read outt_cond table index 1. outt_cond-value = value1. Modify outt_cond index 1. ENDFORM.
I have given a rough outline, please be aware of the variable conversions as Int_condvalue and outt_cond-value are characters. SAPscripts Tips by: Raj
Fast Links: Get help for your ABAP problems Do you have a ABAP Question? SAP Books SAP Certification, Functional, Basis istration and ABAP Programming Reference Books SAP Scripts Tips SAP Sapscripts Tips and Tricks Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
SAPScripts - Developing SAPScript in different languages Developing SAPScript in different languages You can goto transaction SE63 and translate the scripts into different languages.
In SE63, click Translation -> Long Texts -> Sapscripts -> Forms Those language you can convert to have already been pre-installed in the system. SE63 is the best way to translate since it offers check options. However, it does not mean that it is 100% full proof that everything is correct. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Certification, Functional, System istration and ABAP Programming Reference Books
How to convert Sapscript spools request to PDF? SAP have created a standard program RSTXPDFT4 to convert your Sapscripts spools into a PDF format. Specify the spool number and you will be able to the sapscripts spool into your local harddisk. It look exactly like what you see during a spool display. Please note that it is not restricted to sapsciprts spool only. Any reports in the spool can be converted using the program 'RSTXPDFT4'. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Certification, Functional, System istration and ABAP Programming Reference Books
How to graphics (IMAGE) to your Sapscript? Command in your Sapscript /: INCLUDE Z_YOUR_LOGO OBJECT TEXT ID ST LANGUAGE E These are the steps to be followed for ing graphics in R/3 system 1. First save the file as BMP 2. Open the BMP file in IMaging (Goto -> Programs -> Accessories -> Imaging) and make it Zoom as 100% and save as *.TIFF 3. Open SE38 and execute program RSTXLDMC 4. Give your TIFF file path name 5. Select Bcol (for Color) 6. TEXT ID will be ZHEX-MACRO-*. 7. Inplace of * write your own logo name (ZCOMPANYLOGO) 8. Execute the program 9. Now Goto SE71 create your ZFORM 10. Create logo window 11. Goto text element of logo window or In 4.6x :1. Goto SE71 Change the mode to GRAPHICAL 2. Choose the Graph Tabstrips 3. Now type in some name for the LOGO WINDOW 4. Press the IMPORT BUTTON and then IMPORT the BMP file from your DESKTOP 5. The code will be written automatically. You just need to drag and drop wherever you want the graphics to be. Please note that in 4.6c onwards, you can also used Windows Bitmap file ( .BMP). Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.
SAP Certification, Functional, Basis istration and ABAP Programming Reference Books
Import/Export SapScript form from PC file How do you backup sapscript layout sets? Can you and ? How? Use ABAP program: RSTXSCRP It will and your sapscripts as a text file in your local harddisk. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Functional, Basis and ABAP Programming Reference Books
Picture doesn't show in Print Preview You have ed the picture as .TIF in Sap using ABAP RSTXLDMC and have also add the statement /: INCLUDE ZHEX-SAMPLE-PICTURE OBJECT TEXT ID ST LANGUAGE EN in your SapScript but the problem is that in print preview it's not displaying the picture. It is normal that the picture doesn't show in print preview and you will be able to see the object only after printing.
Don't let this bother you as long as the picture is shown on the hardcopy printout. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Functional, Basis and ABAP Programming Reference Books
Delete Load program for SAPScript Occassionally, when you make frequent changes to your SAPScript, the system can get out of sync. When you view the form, the old data get display without your changes. This can be fixed by deleting the SAPScript LOAD with program RSTXDELL. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
Details information about SAP Barcodes A barcode solution consists of the following: - a barcode printer - a barcode reader - a mobile data collection application/program A barcode label is a special symbology to represent human readable information such as a material number or batch number in machine readable format. There are different symbologies for different applications and different industries. Luckily, you need not worry to much about that as the logistics supply chain has mostly standardized on 3 of 9 and 128 barcode symbologies - which all barcode readers and which SAP natively in it's printing protocols. You can print barcodes from SAP by modifying an existing output form.
Behind every output form is a print program that collects all the data and then it to the form. The form contains the layout as well as the font, line and paragraph formats. These forms are designed using SAPScript (a very easy but frustratingly simplistic form format language) or SmartForms that is more of a graphical form design tool. Barcodes are nothing more than a font definition and is part of the style sheet associated with a particular SAPScript form. The most important aspect is to place a parameter in the line of the form that points to the data element that you want to represent as barcode on the form, i.e. material number. Next you need to set the font for that parameter value to one of the ed barcode symbologies. The next part of the equation can be a bit tricky as you will need to get a printer to print that barcode font. Regular laser printers does not normally print barcode fonts, only specialized industrial printers that is specifically designed to that protocol and that uses specialized label media and heat transfer (resin) ribbon to create the sharp image required for barcodes. Not to fear though, there are two ways to get around this: - You can have your IT department do some research most laser printers can accept a font cartridge/dimm chip (similar to computer memory), called a BarDIMM that will allow a laser printer to the printing of barcodes. - Secondly, you can buy software that you can in your SAP print Server that will convert the barcode symbology as an image that will print on a regular laser printer. I found that this option results in less sharper barcodes. This option is really if you need to convert a large quantity of printers (>10) to barcodes. Now you have a barcode printed - what next? Well there are two options, depending on your business requirements: - You can use an existing SAP transaction on a regular workstation and get a barcode wedge reader to hook up between the keyboard and the PC. These wedge readers comes in a wand or scanner format. There are even wireless wedge scanners available that allows you to roam a few yards from the workstation to scan a label. This approach is mostly used where you want to prevent human errors in typing in long material, batch or serial numbers in receiving or issuing of material. The problem is that it's just replacing the keyboard input and you are basically locked down in one location and have to bring all the material to that location to process. - Another solution is to use SAPConsole transactions or write your own ABAP Dialog programs that will fit onto a barcode enabled wireless handheld terminal and that will follow the business logic as executed on the shop floor. These programs are highly complex exercises in industrial engineering and ergonomics because of the limited screen sizes and limited ability to accept keyboard input. The is instructed step-by-step and only scan and push F-keys to interact with the SAP system. Scan, scan, beep, beep, enter - highly automated.
Content Author: Ravikumar Kandikonda Do you have a ABAP Question? Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
SAP Certification, Functional, Basis istration and ABAP Programming Reference Books All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SapScript Question 1) How do you backup script layout sets? 2) What type of variables normally used in script to o/p data? 3) How do you use tabsets in layouts? 1) Use this Std program RSTXSCRP. 1) First Export to Presentation file(.doc). 2) Whenever you need that Export into SAP. 2) Normally we call them as Program symbols. Those are defined in Driver program. We can use in Script as for exp. &itab-matnr& Other variables ---System symbols : ex &page& ---Std symbols : ---Text symbols :We define them in script editor itself. Ex : /: Define &mysymbol& = 'XX' 3) We can control the tab feed in a paragraph with tab positions. The tab stops us define in the paragraph format replace the tab spacing we defined in the header data of the form. However, this depends on the extent to which we have defined tab stops in the paragraph format. If there are fewer tabs in the paragraph formats than in the header data, the tab stops of the header data are used for the rest of the line.
SAPscripts Tips by : Venkat O Q: We get the total number of pages as expected by using 'SAPSCRIPTFORMPAGES' in a duplex layout. In our case duplex case is always ' & Conditions'. We do not want the number of pages as in duplex printing. What is the best possible solution? A: On the & Conditions page, Change the Page counter mode to 'HOLD' to keep the page counter from incrementing when you print the Term & Conditions. Q: Can I Print a logo on an Invoice? A: Save a Logo using Paintshop Pro or Corel Draw as Tiff file. Use RSTXLDMC to convert the logo to standard text in SapScript. When the program is executed, the path and file name have to be correctly specified. Process could be like the following: Run RSTXLDMC Enter file name C:\MAIL\COMPLOGO.TIF Resolution for Tiff file Absolute X-position Absolute Y-position Absolute positioning Reserved height Shift to right UOM = CM Text title Line width for text = 132 Text name ZHEX-MACRO-COMPLOGO Text ID ST Text language = E Postscript scaling Width & Height according to PS scaling Number of Tiff gray levels (2,4,9) 2 Then Create a new window 'COMP' with attributes; Window COMP description Company Logo Window type CONST Left margin 7.00 CH window width 10.00 CH Upper margin LN window height 8.00 LN Finally in the text element , mention /: INCLUDE 'ZHEX-MACRO-COMPLOGO' OBJECT TEXT ID ST LANGUAGE 'E'. Please note that if object name is not indicated as 'ZHEX...', the logo may not be printed!
You will not be able to see the logo in a test print. The same will be printed in actual printout. If you are using two logos in the same layout, the names of the logos should be unique. Say 'ZHEX-MACRO-LOGO1' and 'ZHEX-MACRO-LOGO2'. Else all the information will be overwritten. If the logo is not EXACTLY TIFF 6.0, the same will not be printed. See OSS notes 5995, 18045, 39031 for some inputs. SAPscripts Tips by : Shivanand Patlolla
Fast Links: Get help for your ABAP problems Do you have a ABAP Question? SAP Books SAP Certification, Functional, Basis istration and ABAP Programming Reference Books SAP Scripts Tips SAP Sapscripts Tips and Tricks Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Questions on PO SapScripts MEDRUCK 1. When do you modified MEDRUCK? ( IF I SAID I HAVE WORKED ON SCRIPTS).
Generally, we modify existing sap scripts provided by SAP rather than creating one. Unless you have to do something new for your client like Labels or Packaging card, etc., MEDRUCK is the form for PO. 2. I want to know the procedure to create a purchase order using MEDRUCK. You don't create a PO using MEDRUCK. MEDRUCK is the form used to print a PO that has been created. 3. What are the usual changes to be done on MEDRUCK? Goto SE71, there is an option in Utilities as COPY ffrom Source client (000). Copy the from MEDRUCK into a Zname form. The common changes wud b inserting a logo, using Std text for and Conditions, alignment of windows as per client requirement, get xtra data if client is asking for somethign more. 4. How can I access my data from DB to SCRIPTS? There are structures used in Scripts which hold the data entered by the . These structures are used to get data from Database. 5. Please send me the one examples in full length. Look at MEDRUCK form and it would have a print program. you can find in tcode NACE. SAPscripts Tips by : Raj
Fast Links: Other SapScipts Question SapScript Question Get help for your ABAP problems Do you have a ABAP Question? SAP Books SAP Certification, Functional, Basis istration and ABAP Programming Reference Books SAP Scripts Tips SAP Sapscripts Tips and Tricks
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
A Sample SAP Scripts Reports Author: Mona CALL FUNCTION 'OPEN_FORM' * EXPORTING * APPLICATION = 'TX' * ARCHIVE_INDEX = * ARCHIVE_PARAMS = * DEVICE = 'PRINTER' * DIALOG = 'X' * FORM = 'ZSCRIPT1' * LANGUAGE = SY-LANGU * OPTIONS = * MAIL_SENDER = * MAIL_RECIPIENT = * MAIL_APPL_OBJECT = * RAW_DATA_INTERFACE = '*' * SPONUMIV = * IMPORTING * LANGUAGE = * NEW_ARCHIVE_PARAMS = * RESULT = EXCEPTIONS CANCELED = 1 DEVICE = 2 FORM = 3 OPTIONS = 4 UNCLOSED = 5 MAIL_OPTIONS = 6 ARCHIVE_ERROR = 7 INVALID_FAX_NUMBER = 8 MORE_PARAMS_NEEDED_IN_BATCH = 9 SPOOL_ERROR = 10 CODEPAGE = 11 OTHERS = 12 . IF SY-SUBRC <> 0. MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF.
CALL FUNCTION 'START_FORM' EXPORTING * ARCHIVE_INDEX = FORM = 'ZFORM1' * LANGUAGE = ' ' * STARTPAGE = 'X' PROGRAM = 'ZSCRIPT1' * MAIL_APPL_OBJECT = * IMPORTING * LANGUAGE = * EXCEPTIONS * FORM = 1 * FORMAT = 2 * UNENDED = 3 * UNOPENED = 4 * UNUSED = 5 * SPOOL_ERROR = 6 * CODEPAGE = 7 * OTHERS = 8 . IF SY-SUBRC <> 0. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. CALL FUNCTION 'WRITE_FORM' EXPORTING * ELEMENT * FUNCTION * TYPE WINDOW * IMPORTING * PENDING_LINES EXCEPTIONS ELEMENT FUNCTION TYPE UNOPENED UNSTARTED WINDOW BAD_PAGEFORMAT_FOR_PRINT SPOOL_ERROR OTHERS . IF SY-SUBRC <> 0. write:/ 'ERROR IN HEADER'.
= ' ' = 'SET' = 'BODY' = 'HEADER' = = = = = = = = = =
1 2 3 4 5 6 7 8 9
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. CALL FUNCTION 'WRITE_FORM' EXPORTING * ELEMENT * FUNCTION
= ' ' = 'SET'
*
TYPE WINDOW * IMPORTING * PENDING_LINES EXCEPTIONS ELEMENT FUNCTION TYPE UNOPENED UNSTARTED WINDOW BAD_PAGEFORMAT_FOR_PRINT SPOOL_ERROR OTHERS . IF SY-SUBRC <> 0. write:/ 'ERROR IN HEADER'.
= 'BODY' = 'MAIN' = = = = = = = = = =
1 2 3 4 5 6 7 8 9
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. CALL FUNCTION 'WRITE_FORM' EXPORTING * ELEMENT * FUNCTION * TYPE WINDOW * IMPORTING * PENDING_LINES EXCEPTIONS ELEMENT FUNCTION TYPE UNOPENED UNSTARTED WINDOW BAD_PAGEFORMAT_FOR_PRINT SPOOL_ERROR OTHERS . IF SY-SUBRC <> 0. write:/ 'ERROR IN HEADER'.
= ' ' = 'SET' = 'BODY' = 'FOOTER' = = = = = = = = = =
1 2 3 4 5 6 7 8 9
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. CALL FUNCTION 'END_FORM' * IMPORTING * RESULT * EXCEPTIONS * UNOPENED * BAD_PAGEFORMAT_FOR_PRINT * SPOOL_ERROR * CODEPAGE
= = = = =
1 2 3 4
*
OTHERS
= 5 .
CALL FUNCTION 'CLOSE_FORM' * IMPORTING * RESULT * RDI_RESULT * TABLES * OTFDATA * EXCEPTIONS * UNOPENED * BAD_PAGEFORMAT_FOR_PRINT * SEND_ERROR * SPOOL_ERROR * CODEPAGE * OTHERS .
= = = = = = = = =
1 2 3 4 5 6
Can you explain the difference between 1.open_form and Start form 2.end_form and Close_form. whether all 4 modules are required in the driver pgm . Open_form => It assign the form and printer, It should be first. Start_form => It start Writing mode. You can use write_form in loop to write more than one lines befor End_form. End_form => It end writing mode of current page and will require to start again through Start_form. Close_form=> it end the Form. After this you can not start again for created file. Rajiv singh. Fast Links: Get help for your ABAP problems Do you have a ABAP Question? ABAP Books ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books
SAP Scripts Tips SAP Sapscripts Tips and Tricks Best regards, SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Smart Forms Goodies Stuff Practical and helpful SAP SMARTFORMS Stuff to assist those who seek to know more about the SAP Smartforms. Companies use SAP Smartforms for form printing such as checks, labels and barcode. SAP Smartforms Reference Books SAP Smart Forms Introduction Introduction to SAP SmartForms Advantages of SAP Smart Forms A Simple Smartform Tutorial SAPscripts and SmartForms Difference with SMARTFORMS vs. SapScript FAQ on Migrating SAPscript to SmartForms Conversion of SAPSCRIPT to SMARTFORMS General SmartForms System Fields Example Forms Available in Standard SAP R/3 A Sample Program Calling Smartforms Smart Forms FAQ Smart forms Frequently Asked Questions Smartforms FAQ Part Two Display a contents of a table on SmartForm with LOOP Barcodes Details information about SAP Barcodes
SAP ABAP Forum at the convenient of your mail box Exchange ABAP related problems/solutions, program, tips, ideas with other ABAP peers from around the globe. Note: An Auto Free ABAP Tips Windows Help File will be send to you upon ing. SAP ABAP Forum for ABAP Professional
enter email ad
Quick Links ABAP Tips and Tricks Main Menu Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
Introduction to SAP SmartForms What is SAP Smart Forms? SAP Smart Forms is introduced in SAP Basis Release 4.6C as the tool for creating and maintaining forms. SAP Smart Forms allow you to execute simple modifications to the form and in the form logic by using simple graphical tools; in 90% of all cases, this won't include any programming effort. Thus, a power without any programming knowledge can configure forms with data from an SAP System for the relevant business processes. To print a form, you need a program for data retrieval and a Smart Form that contains the entire from logic. As data retrieval and form logic are separated, you must only adapt the Smart Form if changes to the form logic are necessary. The application program es the data via a function module interface to the Smart Form. When activating the
Smart Form, the system automatically generates a function module. At runtime, the system processes this function module. You can insert static and dynamic tables. This includes line feeds in individual table cells, triggering events for table headings and subtotals, and sorting data before output. You can check individual nodes as well as the entire form and find any existing errors in the tree structure. The data flow analysis checks whether all fields (variables) have a defined value at the moment they are displayed. SAP Smart Forms allow you to include graphics, which you can display either as part of the form or as background graphics. You use background graphics to copy the layout of an existing (scanned) form or to lend forms a company-specific look. During printout, you can suppress the background graphic, if desired. SAP Smart Forms also postage optimizing. Also read SAP Note No. 168368 - Smart Forms: New form tool in Release 4.6C What Transaction to start SAP Smart Forms? Execute transaction SMARTFORMS to start SAP Smart Forms. Key Benefits of SAP Smart Forms: SAP Smart Forms allows you to reduce considerably the implementation costs of mySAP.com solutions since forms can be adjusted in minimum time. You design a form using the graphical Form Painter and the graphical Table Painter. The form logic is represented by a hierarchy structure (tree structure) that consists of individual nodes, such as nodes for global settings, nodes for texts, nodes for output tables, or nodes for graphics. To make changes, use Drag & Drop, Copy & Paste, and select different attributes. These actions do not include writing of coding lines or using a Script language. Using your form description maintained in the Form Builder, Smart Forms generates a function module that encapsulates layout, content and form logic. So you do not need a group of function modules to print a form, but only one. For Web publishing, the system provides a generated XML output of the processed form. Smart Forms provides a data stream called XML for Smart Forms (XSF) to allow the use of 3rd party printing tools. XSF es form content from R/3 to an external product without ing any layout information about the Smart Form.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Certification, ABAP Programming, Functional and Basis Component Reference Books
Advantages of SAP Smart Forms SAP Smart Forms have the following advantages: 1. The adaption of forms is ed to a large extent by graphic tools for layout and logic, so that no programming knowledge is necessary (at least 90% of all adjustments). Therefore, power forms can also make configurations for your business processes with data from an SAP system. Consultants are only required in special cases. 2. Displaying table structures (dynamic framing of texts) 3. Output of background graphics, for form design in particular the use of templates which were scanned. 4. Colored output of texts 5. -friendly and integrated Form Painter for the graphical design of forms 6. Graphical Table Painter for drawing tables 7. Reusing Font and paragraph formats in forms (Smart Styles) 8. Data interface in XML format (XML for Smart Forms, in short XSF) 9. Form translation is ed by standard translation tools 10. Flexible reuse of text modules
11. HTML output of forms (Basis release 6.10) 12. Interactive Web forms with input fields, pushbuttons, radio buttons, etc. (Basis-Release 6.10) Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Functional, Basis istration and ABAP Programming Reference Books Contributed by : SAP ABAP/4 Programming, Basis istration, Configuration Hints and Tips
A Simple Smartform Tutorial SAP Smartforms can be used for creating and maintaining forms for mass printing in SAP Systems. The output medium for Smartforms printer, fax, e-mail, or the Internet (by using the generated XML output). According to SAP, you need neither have any programming knowledge nor use a Script language to adapt standard forms. However, basic ABAP programming skills are required only in special cases (for example, to call a function module you created or for complex and extensive conditions). 1. Create a new smartforms Transaction code SMARTFORMS Create new smartforms call ZSMART
2. Define looping process for internal table Pages and windows First Page -> Header Window (Cursor at First Page then click Edit -> Node -> Create) Here, you can specify your title and page numbering &SFSY-PAGE& (Page 1) of &SFSY-FORMPAGES(Z4.0)& (Total Page) Main windows -> TABLE -> DATA In the Loop section, tick Internal table and fill in ITAB1 (table in ABAP SMARTFORM calling function) INTO ITAB2 3. Define table in smartforms Global settings : Form interface Variable name Type assignment Reference type ITAB1 TYPE Table Structure Global definitions Variable name Type assignment Reference type ITAB2 TYPE Table Structure 4. To display the data in the form Make used of the Table Painter and declare the Line Type in Tabstrips Table e.g. HD_GEN for printing header details, IT_GEN for printing data details. You have to specify the Line Type in your Text elements in the Tabstrips Output options. Tick the New Line and specify the Line Type for outputting the data. Declare your output fields in Text elements Tabstrips - Output Options For different fonts use this Style : IDWTCERTSTYLE For Quantity or Amout you can used this variable &GS_ITAB-AMOUNT(12.2)& 5. Calling SMARTFORMS from your ABAP program REPORT ZSMARTFORM. * Calling SMARTFORMS from your ABAP program. * Collecting all the table data in your program, and once to SMARTFORMS * SMARTFORMS * Declare your table type in :* Global Settings -> Form Interface * Global Definintions -> Global Data * Main Window -> Table -> DATA * * Written by : SAP Hints and Tips on Configuration and ABAP/4 Programming * http://sapr3.tripod.com
* TABLES: MKPF. DATA: FM_NAME TYPE RS38L_FNAM. DATA: BEGIN OF INT_MKPF OCCURS 0. INCLUDE STRUCTURE MKPF. DATA: END OF INT_MKPF. SELECT-OPTIONS S_MBLNR FOR MKPF-MBLNR MEMORY ID 001. SELECT * FROM MKPF WHERE MBLNR IN S_MBLNR. MOVE-CORRESPONDING MKPF TO INT_MKPF. APPEND INT_MKPF. ENDSELECT. * At the end of your program. * ing data to SMARTFORMS call function 'SSF_FUNCTION_MODULE_NAME' exporting formname = 'ZSMARTFORM' * VARIANT ='' * DIRECT_CALL ='' IMPORTING FM_NAME = FM_NAME EXCEPTIONS NO_FORM =1 NO_FUNCTION_MODULE =2 OTHERS = 3. if sy-subrc <> 0. WRITE: / 'ERROR 1'. * MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO * WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. endif. call function FM_NAME * EXPORTING * ARCHIVE_INDEX = * ARCHIVE_INDEX_TAB = * ARCHIVE_PARAMETERS = * CONTROL_PARAMETERS =
* MAIL_APPL_OBJ = * MAIL_RECIPIENT = * MAIL_SENDER = * OUTPUT_OPTIONS = * _SETTINGS = 'X' * IMPORTING * DOCUMENT_OUTPUT_INFO = * JOB_OUTPUT_INFO = * JOB_OUTPUT_OPTIONS = TABLES GS_MKPF = INT_MKPF EXCEPTIONS FORMATTING_ERROR =1 INTERNAL_ERROR =2 SEND_ERROR =3 _CANCELED =4 OTHERS = 5. if sy-subrc <> 0. MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. endif.
Additional Fonts for your SMARTFORMS You can create additional fonts and style with transaction SMARTSTYLES This can then be define in the paragraph and character formats, which you can then be assign to texts and fields in the Smart Form. The character formats includes effects such as superscript, subscript, barcode and font attributes.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.
SAP Functional, Basis istration and ABAP Programming Reference Books
Difference with SMARTFORMS vs. SapScript(SE71) The Following are the differences :a) Multiple page formats are possible in smartforms which is not the case in SAPScripts b) It is possible to have a smartform without a main window . c) Labels cannot be created in smartforms. d) Routines can be written in smartforms tool. e) Smartforms generates a function module when activated. Contributed by : SAP ABAP/4 Programming, Basis istration, Configuration Hints and Tips
f) Unlike sapscripts (RSTXSCRP), you cannot / Smartform to your local harddisk. It was said that it was provided in CRM 3.0 version, but not available in R/3. You can smartforms into Local PC in a XML format. In the same way you can this XML format into Smartform. From the smartform editor itself you can call option, if you are working in CRM 3.0 environment. In R3 also, you can into XML format. However, it's not sure about ing. Refer to the program 'SF_XSF_DEMO'. In 4.7 Enterprise, other have seen this utlity which is completey missing in 4.6c. There is functionality to downlaod a complete form or only a particular node. (Utilities -> form). It will create a XML file and save it in the hard disk. For others, if you want to / the Smartforms source, you will need the help from the Basis people. What you can do is to create a Transport and then FTP down to your local harddisk. When you need the Smartform source in another system, you have FTP up the Smartforms file back to the SAP server. Finally, the
Basis team, will tp it into your system. g) The protect and endprotect command in sapscript doesn't work with smartforms. For example on a invoice: First data of position no 80. is printed on page one, other data of position no 80 is printed on page 2. And there's nothing you can do about it. Actually, there is something you can do about it. By using a folder node and checking the 'protect' checkbox, everything in that folder will be page protected. Last review : 30 August 2003 Do you have a ABAP Question? Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
FAQ on Migrating SAPscript to SmartForms Is it possible to migrate a SAPscript form to a Smart Form? Smart Forms provides a migration tool for this purpose which migrates layout and texts of a SAPscript form to a Smart Form. It does not migrate SAPscript form logic of the print program. Using Smart Forms, this logic is described by the tree structure of the Form Builder. The effort involved in migrating it depends on the complexity of the print program. Which Basis Release do I need to use SAP Smart Forms? SAP Smart Forms is available as of R/3 Basis Release 4.6C. I have heard that Smart Forms replaces SAPscript. What does "replace" mean? It does not mean that SAPscript is removed from the Basis shipment. Even as of Basis Release 4.6C, SAPscript remains part of the SAP standard and there are no plans to remove it. Since Smart Forms is currently, and will continue to be, the tool for form maintenance for mySAP.com solutions, our further development efforts will focus on Smart Forms, not on SAPscript.
Do we have to migrate all SAPscript forms to Smart Forms? There is no point in migrating all SAPscript forms already in use. Since SAPscript can still be used and will be available in the future, there is no need to. If you plan to migrate a SAPscript form, it is recommended that you check whether benefit is worth the effort involved. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
Conversion of SAPSCRIPT to SMARTFORMS SAP provides a conversion for SAPscript documents to SMARTforms. This is basically a function module, called FB_MIGRATE_FORM. You can start this function module by hand (via SE37), or create a small ABAP which migrates all SAPscript forms automatically. You can also do this one-by-one in transaction SMARTFORMS, under Utilities -> Migrate SAPscript form. You could also write a small batch program calling transaction SMARTFORMS and running the migration tool. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of
www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
SmartForms System Fields Within a form you can use the field string SFSY with its system fields. During form processing the system replaces these fields with the corresponding values. The field values come from the SAP System or are results of the processing. System fields of Smart Forms &SFSY-DATE& Displays the date. You determine the display format in the master record. &SFSY-TIME& Displays the time of day in the form HH:MM:SS. &SFSY-PAGE& Inserts the number of the current print page into the text. You determine the format of the page number (for example, Arabic, numeric) in the page node. &SFSY-FORMPAGES& Displays the total number of pages for the currently processed form. This allows you to include texts such as'Page x of y' into your output. &SFSY-JOBPAGES& Contains the total page number of all forms in the currently processed print request. &SFSY-WINDOWNAME& Contains the name of the current window (string in the Window field) &SFSY-PAGENAME& Contains the name of the current page (string in the Page field) &SFSY-PAGEBREAK& Is set to 'X' after a page break (either automatic [Page 7] or command-controlled [Page 46]) &SFSY-MAINEND& Is set as soon as processing of the main window on the current page ends
&SFSY-EXCEPTION& Contains the name of the raised exception. You must trigger your own exceptions, which you defined in the form interface, using the _exception macro (syntax: _exception <exception name >). Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
Example Forms Available in Standard SAP R/3 SF_EXAMPLE_01 Simple example; invoice with table output of flight booking for one customer SF_EXAMPLE_02 Similar to SF_EXAMPLE_01 but with subtotals SF_EXAMPLE_03 Similar to SF_EXAMPLE_02, whereby several customers are selected in the application program; the form is called for each customer and all form outputs are included in an output request Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
A Sample Program Calling Smartforms
With Compliments by: Ambekar, Abhijeet You should use 'SSF_FUNCTION_MODULE_NAME' & call function fm_name in your program & not others. *&---------------------------------------------------------------------* *& Report ZTACA_DRIVER_SMARTFORM * *& * *&---------------------------------------------------------------------* *& * *& * *&---------------------------------------------------------------------* REPORT
ZTACA_DRIVER_SMARTFORM
.
Tables : sflight. Data : fm_name TYPE rs38l_fnam. *data : Begin of it_flttab occurs 0, * carrid type sflight-carrid, * connid type sflight-connid, * fldate type sflight-fldate, * seatsmax type sflight-seatsmax, * seatsocc type sflight-seatsocc, * End of it_flttab. data : it_flttab like table of sflight. Data : g_salary type i . * it_flttab type standard table of ty_flt. g_salary = 1000. select carrid connid fldate seatsmax seatsocc from sflight into corresponding fields of table it_flttab. CALL FUNCTION 'SSF_FUNCTION_MODULE_NAME' EXPORTING formname = 'ZTACA_SMFORM2' * VARIANT = ' ' * DIRECT_CALL = ' ' IMPORTING FM_NAME = fm_name EXCEPTIONS NO_FORM = 1 NO_FUNCTION_MODULE = 2 OTHERS = 3 . IF sy-subrc <> 0. MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF. call function fm_name Exporting
salary = g_salary TABLES it_flttab = it_flttab EXCEPTIONS FORMATTING_ERROR INTERNAL_ERROR SEND_ERROR _CANCELED OTHERS
= = = = =
1 2 3 4 5
.
IF SY-SUBRC <> 0. MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4. ENDIF.
Fast Links: Get help for your ABAP problems Do you have a ABAP Question? ABAP Books ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books
ABAP Tips ABAP Forum for Discussion and Samples Program Codes for Abapers Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP ABAP Programming, Functional and Basis Component Reference Books
Smart forms Frequently Asked Questions Forcing a page break within table loop Create a loop around the table. Put a Command node before the table in the loop that
forces a NEWPAGE on whatever condition you want. Then only loop through a subset of the internal table (based on the conditions in the Command node) of the elements in the Table node. Font style and Font size Goto Transaction SMARTSTYLES. There you can create Paragraph formats etc just like in sapscript. Then in your window under OUTPUT OPTIONS you include this SMARTSTYLE and use the Paragraph and character formats. Line in Smartform Either you can use a window that takes up the width of your page and only has a height of 1 mm. Then you put a frame around it (in window output options). Thus you have drawn a box but it looks like a line. Or you can just draw "__" accross the page and play with the fonts so that it s each UNDER_SCORE. Difference between 'forminterface' and 'global definitions' in global settings of smart forms The Difference is as follows. To put it very simply: Form Interface is where you declare what must be ed in and out of the smartform (in from the print program to the smartform and out from the smartform to the print program). Global defs. is where you declare data to be used within the smartform on a global scope. ie: anything you declare here can be used in any other node in the form. Smartforms function module name Once you have activated the smartform, go to the environment -> function module name. There you can get the name of funtion module name. The key thing is the program that calls it. for instance, the invoice SMARTFORM LB_BIL_INVOICE is ran by the program RLB_INVOICE.
This program uses another FM to determine the name of the FM to use itself. The key thing is that when it calls this FM (using a variable to store the actual name), that the parameters match the paramters in your smartform. Another thing to note is that the FM name will change wherever the SF is transported to. So you need to use the FM to determine the name of the SF. Here is the code that can be use to determine the internal name of the function module: Code: if sf_label(1) <> '/'. " need to resolve by name move sf_label to externalname. call function 'SSF_FUNCTION_MODULE_NAME' exporting formname = externalname importing fm_name = internalname exceptions no_form =1 no_function_module = 2 others = 3. if sy-subrc <> 0. message 'e427'. endif. move internalname to sf_label. endif. It checks to see if the sf_label starts with a '/', which is how the internal names start. if it does, the name has already been converted. If not, it calls the FM and converts the name. You would then CALL FUNCTION sf_label. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Certification, ABAP Programming, Functional and Basis Component Reference Books
Smartforms FAQ Part Two Smartforms output difference Problem with Smartforms: in a certain form for two differently configured printers, there seem to be a difference in the output of characters per inch (the distance between characters which gives a layout problem - text in two lines instead of one. It happens when the two printers having different Printer Controls' if you go to SPAD Menu (Spool Menu) you can see the difference in the Printer Control and if you make the Printer control setting for both the printers as same. then it will be ok. and also u have to check what is the device type used for both the output devices. SmartForms Output to PDF There is a way to smartform in PDF format. Please do the following: 1. Print the smartform to the spool. 2. Note the spool number. 3. a PDF file (Acrobat Reader) version of the spool by running Program RSTXPDFT4 and entering the noted spool number. SmartForm Doublesided printing question Your customer wants your PO SmartForm to be able to print " and Conditinos" on the back side of each page. They don't want to purchase pre-printed forms with the company's logo on the front and & conditions on the back. Now this presents an interesting problem. Has anyone else ever had a request like this? If for example there was a 3 page PO to be printed, they want 3 pieces of paper, the front side of each to containe the PO information (page 1, 2, and 3) and the back side of each piece of paper to containg the static " & Conditions" information. Anyone have a clue how to force this out? Easy - page FRONT lists page S as next page and S lists FRONT as next page. Since S does not contain a MAIN window, it will print the s info and then continue on to FRONT for the rest of the main items. Additionally, set print mode on FRONT to D (duplex) and set S to 'blank' (for both resource name and print mode - this is the only way to get to the back of the page). Transport Smart Forms
How does one transport SMARTFORM? SE01? How do you make sure that both, the SMARTFORM & it's function module gets transported? Or does the FM with same name gets generated automatically in the transported client? A smartform is transported no differently than any other object. if it is assigned to a development class that is atteched to a transport layer, it will be transported. The definition is transported, and when called, the function module is regenerated. This leads to an interetsing situation. On the new machine, it is very likely the function module name will be different than the name on the source system. Make sure, before you call the function module, you resolve the external name to the internal name using the 'SSF_FUNCTION_MODULE_NAME' function module. Typically, generate the SF, then use the pattern to being in the interface. Then change the call function to use the name you get back from the above function module. Smartforms: protect lines in main window. How to protect lines in the main window from splitting between pages? It was easy with SAPscript, but how to do it with SF's. For 4.7 version if you are using tables, there are two options for protection against line break: - You can protect a line type against page break. - You can protect several table lines against page break for output in the main area. Protection against page break for line types - Double-click on your table node and choose the Table tab page. - Switch to the detail view by choosing the Details pushbutton. - Set the Protection against page break checkbox in the table for the relevant line type. Table lines that use this line type are output on one page. Protection against page break for several table lines - Expand the main area of your table node in the navigation tree. - Insert a file node for the table lines to be protected in the main area. - If you have already created table lines in the main area, you can put the lines that you want to protect again page break under the file using Drag&Drop. Otherwise, create the table lines as subnodes of the file. - Choose the Output Options tab page of the file node and set the Page Protection option. All table lines that are in the file with the Page Protection option set are output on one page. In 4.6, Alternatively in a paragraph format use the Page protection attribute to determine whether or not to display a paragraph completely on one page. Mark it if you want to avoid that a paragraph is split up by a page break. If on the current page (only in the main window) there is not enough space left for the paragraph, the entire paragraph appears on the next page.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Display a contents of a table on SmartForm with LOOP There's a DDIC Table called "Ugyfel" containing 5 rows. I'd like simply to display all the rows on a SF's Main window. Please follow this process to display the value from your table "Ugyfel" 1. Go with a transaction code : smartforms 2. Enter the form name like : ysmart_forms1 3. Create 4. Enter the Description for the form 5. From the left side window there will be a form interface to provide table ..... 6. Go for tables option 7. ugyfel like ugyfel(ref.type) 8. Pages and window---> page1---> main window 9. Go to the form painter adjust the main window. 10. Select main window and right click --> go for create loop 11. Name: loop1, desc: display loop. 12. Internal table ktab into ktab. 13. select loop right click -> create a text 14. name : text1, desc: display text. 15. Go to change editor. 16. Write the mater what ever you want and if you want to display data from the table write the table fields as follows: &ktab-
&
&ktab-
&
save & activate then execute ,, scripts will generate a function module like : '/ibcdw/sf0000031' copy this function module and call in executable program... For that 1. go with abap editor se38.
2. 3. 4. 5. 6. 7.
table: ugyfel. parameters: test like ugyfel-
. data itab like ugyfel occurs 0 with header line. select * from ugyfel into table itab where field1 = test1. call function '/ibcdw/sf0000031' tables ktab = itab.
Save and activate the program ( ^f 3). Now run the program ( f 8) ALL THE BEST. SmartForm Tips by : Maheshkumar Gattu
Fast Links: Get help for your ABAP problems Do you have a ABAP Question? ABAP Books ABAP Certification, BAPI, Java, Web Programming, Smart Forms, Sapscripts Reference Books ABAP Programming Tips ABAP Forum for Discussion and Samples Program Codes for Abapers Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Find the list of SAP Transaction codes Where I can find the list of transaction codes and their usage, I heard that there is some table which contains all the transaction codes with their descriptions.
Listed here are the various ways you can find the list of transaction codes and their usage: Use transaction SE11 - ABAP Dictionary: Fill in the Database table name and click the Display button. - TSTC table will contain all the Tcodes and - TSTCT table will contain all the Tcodes with Texts. Once you entered the screen, click in Top Menu - Utilities - Table contents - Display If you want to display all the transaction code (total - 57,048) you have to change the Fields: Maximum number of hits to 99999 (default 500). or Simply goto transaction SM01, although this tcode is to Lock/Unlock any transaction code, you can also view all the tcode available in the R/3 system from here. or Goto transaction SE93 There are two ways where you can find the list of transaction codes in SE93. Method 1: You must be familiar with the starting characters strings for each of the R/3 application modules. Assuming you know that most Materials Management transaction codes start with MM. In the Fields: Transaction code, type in MM* and press the function key F4 The list of transaction code starting with MM will be displayed. Method 2: On the Top Menu, click Utilities - Find - Execute and the first 500 transaction will be display. If want to display all the tcodes, make sure you ed to change the Fields: Maximum no. of hits right at the bottom of the screen. Related Topics: To get the associated data element descriptions of all the fields in a table How to get the field descriptions of a table?
Find Related Application Transaction code using Text search Search for SAP Basis Transaction codes A simple method of changing the SAP Tcode Title Changing the Title of SAP Transaction SAP Books SAP Certification, ABAP Programming, Functional and Basis Component Reference Books
How to get the field descriptions of a table? I need to get the associated data element descriptions of all the fields in a table. I think there's a way to do that using the SELECT statement. Can you please give me in detail, the various steps and methods to find the corresponding SAP tables and fields for a particular transaction code, for example (CS03). Do the following 2 steps. Then create your ABAP program accordingly with the SELECT statement. 1. From table DD03L, give your tablename and get all of its field names and corresponding data element names. 2. From table DD03T, get the description of each data element you have got in step 1. Then Use Function Module DDIF_FIELDINFO_GET The sample program will look like this: REPORT ZTABLEFIELDNAME. TABLES: DFIES, X030L. DATA: BEGIN OF INTTAB OCCURS 100. INCLUDE STRUCTURE DFIES. DATA: END OF INTTAB. PARAMETERS: TABLENM TYPE DDOBJNAME DEFAULT 'MSEG', FIELDNM TYPE DFIES-FIELDNAME DEFAULT 'MENGE'. call function 'DDIF_FIELDINFO_GET' exporting tabname = TABLENM FIELDNAME = FIELDNM
* * * * * * * *
LANGU LFIELDNAME ALL_TYPES IMPORTING X030L_WA DDOBJTYPE DFIES_WA LINES_DESCR TABLES DFIES_TAB FIXED_VALUES EXCEPTIONS NOT_FOUND INTERNAL_ERROR OTHERS
= SY-LANGU = ' ' = ' ' = WATAB = = = = INTTAB = = 1 = 2 = 3.
if sy-subrc <> 0. WRITE:/ 'Field name not found'. endif. LOOP AT INTTAB. WRITE:/ INTTAB-TABNAME, INTTAB-FIELDNAME, INTTAB-FIELDTEXT. ENDLOOP. *** End of Program
OR Step 1. Run the transaction and click on System -> Status. Note the program name shown under the transaction code. Step 2. Run SE49 and enter the program name you identified in step 1 (SAPLCSDI) and then press enter. This will identify the tables used, however, as you want to know the fields used as well then you may have to resort to looking at the actual code (get a developer involved if you're not one) using transaction SE80. In this case the transaction CS03 is assigned to a screen with a function group so it's a slightly tricker process, hence the need for a developers service. For all the tables, descriptions and fields you can refer to these tables: DD02L : ALL SAP TABLE NAMES DD02T : DESCRIPTION OF TABLE NAMES DD03L : FIELDS IN A TABLE. Related Links: Find Related Application Transaction code using Text search HYPERLINK "http://www.sap-img.com/bc032.htm" Search for SAP Basis Transaction
codes A simple method of changing the SAP Tcode Title HYPERLINK "http://www.sap-img.com/basis/changing-the-title-of-saptransaction.htm" \t "_top" Changing the Title of SAP Transaction Get help for your ABAP problems HYPERLINK "http://www.sap-img.com/abap/abap-question.htm" \t "_top" Do you have a ABAP Question? INCLUDEPICTURE "https://image.staticox.com/?url=http%3A%2F%2Frcm-images.amazon.com%2Fimages%2FG%2F01%2Frcm%2F468x60.gif" \* MERGEFORMATINET
HYPERLINK "http://www.sap-img.com/sap-books.htm" \t "_top" SAP Certification, Functional, Basis istration and ABAP Programming Reference Books Best regards, SAP Basis, ABAP Programming and Other IMG Stuff HYPERLINK "http://www.sap-img.com/index.htm" \t "_top" http://www.sapimg.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Basis istration, Functional and ABAP Programming Reference Books
Search for SAP Transaction codes You can access all the transaction codes by using the transaction code 'SDMO'. This is the transaction code for the Dynamic Menu. Based on your search string, you can get all related transaction codes for all the SAP application modules. For e.g. the Search text for returns the following results: ---------------------------------------------------------|Tcode|Transaktionstext | ---------------------------------------------------------|ADOK |AM: System istration Guide | |BALE |Area Menu for istration | |BDMO |ALE CCMS Group istration | |CATSX|Time Sheet .: Initial Screen | |CICY |CTI istration | |CJV6 |Maintenance: Version istration | |CN84 |PS: Archiving project - . | |COA4 |PP: Archiving order - istration | |CS|Content Server istration | |FC_BW| Workbench | |FDTA |TemSe/REGUT Data istration | |FDTT |Treasury Data Medium istration | |FO86 |Change active .contract fees | |FO8E |Create .contract event | |FO8F |Change .contract event | |FO8G |Display .contract event | |FO8H |.costs acct sttlmnt simulation | |FOART|REsearch: istration Web- | |HRCMP|Compensation istration | |HRCMP|Budget istration: Display | |HRCMP|Budget istration: Change | |IM_AR|. of App. Request Archives | |KA18 |Archive : assess., distr., ... | |KE72 |Archive istration: Line Items | |KE73 |Archive istration: Totals Recs | |KPRO |KPRO istration | |OAAD |ArchiveLink istration Documents | |OG00 |Personnel istration Customizing | |OG01 |Personnel istration Customizing | |OMSM |CS MM Set Up istrative Data | |OOCM_|Compensation istration Settings | |OOML |Room istration Mail Connection | |OOPC |istration: Personnel No. Check | |OY22 |Create sub Customizing | |OYEA |IDoc istration | |PA97 |Compensation istration - matrix |
|PA98 |Compensation istration |PA99 |Compensation . - Release Report |PACA |PF istration |PAT1 |Personnel istration infosystem |PC00_|CBS survey salary istrations |PC00_|Tax Certificates - istration 16 |PP26 |Plan Scenario istration |PP2D |ister Payroll Results |PSO5 |PD: istration Tools |PUCA |PC istration for PF |PVSEA|ister Search Engine |QD25 |Archiving Notifications: . |S002 |Menu istration |SA02 |Academic title (cent. addr. .) |SA04 |Name prefixes (centr. addr. .) |SA05 |Name suffix (centr. addr. .) |SA07 |Address groups (centr. addr. .) |SA08 |Person groups (centr. addr. .) |SA09 |Internat. versions address . |SA10 |Address . communication type |SARA |Archive istration |SBPT |istration Process Technology |SCC4 |Client istration |SCON |SAPconnect - istration |SCOT |SAPconnect - istration |SCUA |Central istration |SCUM |Central istration |SE78 |SAPscript: Graphics istration |SECST|istration of Secure Memory |SENG |istration of External Indexes |SENGE|Explorer Index istration |SIAC1|Web Object istration |SLICE|ister SAP Licenses |SLWA |Translation Environment istratn |SM14 |Update Program istration |SP12 |TemSe istration |SPAD |Spool istration |SPAT |Spool istration (Test) |SPHA |Telephony istration |SPHB |SAPphone: System istration |SSAA |System istration Assistant |SSCA |Appointment Calendar: istration |SSCA1|Appointment calendar: istration |SSO2 |Workplace Single Sign-On . |SSO2_|Workplace istration SSO2 Ticket |STMA |Proposal Pool istration |SURAD|Survey istration |SURL_|Personalization for URL Gen. . |SUUMD|Display istration |SWDC |Workflow Definition: istration |SWEAD|Event Queue istration |SWEQA|Event Queue istration |SWEQA|Queue Maintenance |SWIA |Selection rep. for work items() |SWRK |istrtation using work areas |SWUF |istration of Runtime System
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | |
|SWUL |Customizing: Process | |SWUX |SAPforms istration | |SYSAD|System istration: Task List | |S_ALR|IMG Activity: CIC_V_CCMCTI | |S_ALR|IMG Activity: SIMG_EURO_ | |S_BCE|IMG-Aktivität: BCDIGSI_ | |S_PH0|InfoSet Query: istration | |S_PH0|InfoSet Query: istration | |S_PH0|InfoSet Query: istration | |S_PH0|InfoSet Query: istration | |S_PH0|InfoSet Query: istration | |TBD0 |Datafeed: ster Archives | |TBD3 |Datafeed: Market data istration | |TBD6 |Datafeed: Log file istration | |WE46 |IDoc istration | |WORKI|istrtation using work areas | ----------------------------------------------------------
Do you have a SAP Basis Question?
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Changing the Title of SAP Transaction Sometimes, internal or customer might request you to change the Title of the SAP Transaction code to a more meaningful one and SAP allows this to be done painlessly. The steps to change the Title of any SAP transaction code are as follows: First, goto tcode SE63 On the top left Menu of the screen - Click Translation - Short texts - Transactions For example, assuming you want to change the title of the tcode FB01 from Post Document to Post Document for G/L. On the first screen, fill in the following
information: Transaction code - FB01 Source Language - English Target Languate - English To change the Title, click the Edit button On the second line, type in the Title (For e.g. Post Document for G/L) you want for the transaction code Click the Save button Now, called up the transaction code /nFB01 again and you should be able to view the new Title. Please note that it works for most of the Transaction code except for those new Enjoy transaction code in 4.6x. Related Topics: To get the associated data element descriptions of all the fields in a table How to get the field descriptions of a table? Various ways of Getting the list of R/3 transaction codes Find the list of SAP Transaction codes Find Related Application Transaction code using Text search Search for SAP Basis Transaction codes Get help for your SAP Basis problem Do you have a SAP Basis Question?
SAP R/3 Books List (ABAP, Basis, Functional) Press Ctrl+D to bookmark this page. SAP Training CD ROMs HYPERLINK "http://www.sap-img.com/sap-training-cd.htm" \t "_blank" Computer Based Training on SAP Functional, Basis istration and ABAP/4 Programming Understanding SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0672328224/sapinformation0e" \t "_blank"
Sams Teach Yourself SAP in 24 Hours (2nd Edition) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0131860852/sapinformation0e" \t "_blank" SAP R/3 for Everyone : Step-by-Step Instructions, Practical Advice, and Other Tips and Tricks for Working with SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761519041/sapinformation0e" \t "_blank" Getting Started With Sap R/3 (Prima Techs Sap Book Series) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761529136/sapinformation0e" \t "_blank" Anticipating Change: Secrets Behind the SAP Empire HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1885587694/sapinformation0e" \t "_blank" Experience SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201675293/sapinformation0e" \t "_blank" Flying Start SAP(R) R/3(R): A Guide to Get You Up and Running HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1575790297/sapinformation0e" \t "_blank" The Whirlwind Series of SAP: In the Path of the Whirlwind: An Apprentice Guide to SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471249920/sapinformation0e" \t "_blank" SAP: An Executive's Comprehensive Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201715120/sapinformation0e" \t "_blank" SAP(R) Process, Analyze and Understand SAP(R) Processes with Knowledge Maps HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0789713519/sapinformation0e" \t "_blank" Special Edition Using Sap R/3: The Most Complete Reference (Special Edition Using SAP R/3) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540433546/sapinformation0e" \t "_blank" Xylem Structure and the Ascent of Sap HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0071347852/sapinformation0e" \t "_blank" SAP: Inside the Secret Software Power HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B00005Q8OO/sapinformation0e" \t "_blank" SAP: Inside the Secret Sortware Power [: ADOBE READER] HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0375727779/sapinformation0e" \t "_blank" Sap Rising Implementing SAP HYPERLINK
"http://www.amazon.com/exec/obidos/ASIN/3540668632/sapinformation0e" \t "_blank" Sap R/3 Implementation: Methods and Tools HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0672317761/sapinformation0e" \t "_blank" Implementing SAP R/3: The Guide for Business and Technology Managers (Other Programming) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B0001AV2YM/sapinformation0e" \t "_blank" Implementing SAP R/3: The Guide for Business and Technology Managers [: ADOBE READER] HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0789728753/sapinformation0e" \t "_blank" SAP Planning: Best Practices in Implementation HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1578700639/sapinformation0e" \t "_blank" SAP(R) R/3 Implementation Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201398249/sapinformation0e" \t "_blank" Successful SAP R/3 Implementation: Practical Management of ERP Projects HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201924706/sapinformation0e" \t "_blank" SAP(R) R/3(R) Process Oriented Implementation: Iterative Process Prototyping HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/013889213X/sapinformation0e" \t "_blank" Implementing Sap R/3 : How to Introduce a Large System into a Large Organization, 2nd Edition HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540002537/sapinformation0e" \t "_blank" Enterprise Management with SAP SEM / Business Analytics HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0072400897/sapinformation0e" \t "_blank" Why ERP? A Primer on SAP Implementation HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738421456/sapinformation0e" \t "_blank" Implementing SAP R/3 on OS/400 (IBM Redbooks) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1575790300/sapinformation0e" \t "_blank" Capturing the whirlwind : your field guide for a successful SAP implementation HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471388246/sapinformation0e" \t "_blank" Getting Maximum Value from SAP R/3 Dynamic, Accelerated SAP Implementation HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201674831/sapinformation0e" \t "_blank"
Dynamic Implementation of SAP(R) R/3(R) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0079137563/sapinformation0e" \t "_blank" Asap Implementation at the Speed of Business: Implementation at the Speed of Business (Sap) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0595233988/sapinformation0e" \t "_blank" Implementing Sap With an Asap Methodology Focus HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570347/sapinformation0e" \t "_blank" Preconfigured Client Made Easy 4.6C SAP Business HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1575791250/sapinformation0e" \t "_blank" SAP Blue Book, A Concise Business Guide to the World of SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0135211476/sapinformation0e" \t "_blank" Sap R/3 Business Blueprint: Understanding the Business Process Reference Model HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761520252/sapinformation0e" \t "_blank" What Every Business Needs to Know About SAP (Prima Tech's SAP Book Series) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130260754/sapinformation0e" \t "_blank" SAP R/3 Business Blueprint - The Complete Video Course ing SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290159/sapinformation0e" \t "_blank" SAP Service and HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B0000C1KJD/sapinformation0e" \t "_blank" SAP Service und [: ADOBE READER] HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761517502/sapinformation0e" \t "_blank" ing Sap R/3 SAP Quick Reference HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1852337753/sapinformation0e" \t "_blank" Common Sap R/3 Functions Manual (Springer Professional Computing) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0965563332/sapinformation0e" \t "_blank" Instant Access: SAP, Reference Card of R/3
SAP Career HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0965662136/sapinformation0e" \t "_blank" Five Steps to an Sap Career: Your Guide to Getting into Sap SAP Consultant HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1575791501/sapinformation0e" \t "_blank" SAP Consultant Handbook HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761518843/sapinformation0e" \t "_blank" Becoming an SAP Consultant SAP Data Migration Tools HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290280/sapinformation0e" \t "_blank" Migrating Your SAP Data HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570045/sapinformation0e" \t "_blank" Data Transfer Made Easy 4.0B/4.5x HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/020167517X/sapinformation0e" \t "_blank" Testing SAP(R) R/3(R) Systems: Using the Computer Aided Test Tool SAP Reporting Tools HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570681/sapinformation0e" \t "_blank" SAP R/3 Reporting Made Easy, 4.6C:Fundamentals and Development Tools HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570657/sapinformation0e" \t "_blank" Reporting Made Easy Guidebook series, Release 4.0B HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570673/sapinformation0e" \t "_blank" SAP R/3 Reporting Made Easy: 4.6C SET HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130226157/sapinformation0e" \t "_blank" SAP R/3 Reporting & eBusiness Intelligence HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738402281/sapinformation0e" \t "_blank" Afp Printing for Sap Using R/3 and R/2 Internet Technology of SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471418307/sapinformation0e" \t "_blank" The E-Business Workplace: Discovering the Power of Enterprise Portals
HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1931841152/sapinformation0e" \t "_blank" Roap to mySAP.com HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201721929/sapinformation0e" \t "_blank" mySAP.com Industry Solutions: New Strategies for Success with SAP's Industry Business Units HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130226157/sapinformation0e" \t "_blank" SAP R/3 Reporting & eBusiness Intelligence HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201343037/sapinformation0e" \t "_blank" The SAP R/3 on the Internet HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570886/sapinformation0e" \t "_blank" Online Store Made Easy 4.6B ¿ Accelerated Internet Selling HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471392081/sapinformation0e" \t "_blank" E-Business and ERP: Transforming the Enterprise SAP Workflow HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/159229006X/sapinformation0e" \t "_blank" Practical Workflow for SAP - Effective Business Processes using SAP's WebFlow Engine HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540404031/sapinformation0e" \t "_blank" Workflow Management With Sap Webflow: A Practical Manual HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3528057653/sapinformation0e" \t "_blank" Optimising Business Performance With Standard Software Systems: How to Reorganise Workflows by Chance of Implementing New Erp-Systems (Sap, Baan, Peoplesoft, Navision ...) or New Releases ABAP Certification HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0970655401/sapinformation0e" \t "_blank" ABAP Programming: A Guide to the Certification Course SAP ABAP/4 HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761513922/sapinformation0e" \t "_blank" Introduction to ABAP/4 Programming for SAP, Revised and Expanded Edition HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/078211881X/sapinformation0e" \t "_blank" Developing Sap's R/3 Applications With Abap/4
HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201675153/sapinformation0e" \t "_blank" ABAP/4, Second Edition: Programming the SAP(R) R/3(R) System HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290396/sapinformation0e" \t "_blank" The Official ABAP Reference Advanced ABAP Programming HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761517987/sapinformation0e" \t "_blank" Advanced ABAP Programming for SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290302/sapinformation0e" \t "_blank" Enhancing the Quality of ABAP Development HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290345/sapinformation0e" \t "_blank" SAP Interface Programming ABAP Data Dictionary and Quick Reference HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540647856/sapinformation0e" \t "_blank" Software Development for Sap R/3: Data Dictionary, Abap/4, Interfaces HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0759659125/sapinformation0e" \t "_blank" Sap Abap Command Reference HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0971883203/sapinformation0e" \t "_blank" ABAP Language Quick-Reference SAP ABAP Objects HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201750805/sapinformation0e" \t "_blank" ABAP Objects: Introduction to Programming SAP Applications with CDROM HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290116/sapinformation0e" \t "_blank" ABAP Objects Reference Book SAPscripts HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570142/sapinformation0e" \t "_blank" SAPscript Made Easy 4.6 Smartforms HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290108/sapinformation0e" \t "_blank"
SAP Smart Forms SAP BAPI HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3528056940/sapinformation0e" \t "_blank" SAP R/3 Interfacing Using BAPIs; A Practical Guide to Working within the SAP Business Framework with CDROM SAP JAVA HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B000AY3KVC/sapinformation0e" \t "_blank" The ABAP Developer's Guide to Java (SAP Press) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1590596250/sapinformation0e" \t "_blank" Foundations of Java for ABAP Programmers (Foundations) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1590590988/sapinformation0e" \t "_blank" Enterprise Java for SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290205/sapinformation0e" \t "_blank" JAVA Programming With the SAP Web Application Server (Hardcover) SAP Visual Basic HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1861002785/sapinformation0e" \t "_blank" Professional Visual Basic SAP R/3 Programming HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0972041109/sapinformation0e" \t "_blank" SAP R/3 Data Integration Techniques using ABAP/4 and Visual Basic SAP Web Programming HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290132/sapinformation0e" \t "_blank" Web Programming with the SAP Web Application Server SAP NetWeaver HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0764568833/sapinformation0e" \t "_blank" SAP NetWeaver For Dummies HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B0002F1BRO/sapinformation0e" \t "_blank" SAP NetWeaver TM For Dummies [: ADOBE READER] HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290418/sapinformation0e" \t "_blank"
SAP NetWeaver Roap SAP Financial ing HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0782125972/sapinformation0e" \t "_blank" Configuring SAP R/3 FI/CO: The Essential Resource for Configuring the Financial and Controlling Modules HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201675307/sapinformation0e" \t "_blank" SAP(R) R/3(R) Financial ing: Making It Work For Your Business HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471179965/sapinformation0e" \t "_blank" Using Sap R/3 Fi: Beyond Business Process Reengineering HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0324149778/sapinformation0e" \t "_blank" ing Information Systems with SAP CD-ROM, Third Edition SAP Controlling HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471397008/sapinformation0e" \t "_blank" The 123s of ABC in SAP: Using SAP R/3 to Activity-Based Costing HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B000063KSJ/sapinformation0e" \t "_blank" The 123s of ABC in SAP: Using SAP R/3 to Activity-Based Costing [: ADOBE READER] SAP BW Certification HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471236349/sapinformation0e" \t "_blank" SAP BW Certification: A Business Information Warehouse Study Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B000092Q2B/sapinformation0e" \t "_blank" SAP BW Certification: A Business Information Warehouse Study Guide [: ADOBE READER] SAP Business Information Warehouse HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0595340792/sapinformation0e" \t "_blank" SAP and BW Data Warehousing: How to Plan and Implement HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290175/sapinformation0e" \t "_blank" SAP BW Professional HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761523359/sapinformation0e" \t "_blank" Business Information Warehouse for SAP
HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201703661/sapinformation0e" \t "_blank" SAP BW: A Step by Step Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0471219711/sapinformation0e" \t "_blank" Mastering the SAP Business Information Warehouse HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B00007GWW7/sapinformation0e" \t "_blank" Mastering the SAP Business Information Warehouse [: ADOBE READER] HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570665/sapinformation0e" \t "_blank" SAP BW Reporting Made Easy, 2.0B/2.1C HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3528056746/sapinformation0e" \t "_blank" Corporate Information With Sap-Eis: Building a Data Warehouse and a Mis - Application With in Sight HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B0007MYREQ/sapinformation0e" \t "_blank" SAP and BW Data Warehousing [: ADOBE READER] SAP Supply Chain Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130853402/sapinformation0e" \t "_blank" SAP R/3 Business Blueprint: Understanding Enterprise Supply Chain Management (2nd Edition) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540669523/sapinformation0e" \t "_blank" Supply Chain Management Based on SAP Systems SAP Materials Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0975305263/sapinformation0e" \t "_blank" SAP MM Certification and Interview Questions: SAP MM Interview Questions, Answers, and Explanations HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0965563324/sapinformation0e" \t "_blank" Instant Access: Sap Reference for Materials Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0789715023/sapinformation0e" \t "_blank" istering Sap R/3 : Mm-Materials Managment Modules SAP MM Paper HYPERLINK "http://www.sap-img.com/shop/sap-mm-inventory-managementoverview.htm" \t "_blank" SAP MM Inventory Management Overview
HYPERLINK "http://www.sap-img.com/shop/sap-mm-inventory-management-andphysical-inventory-configurations.htm" \t "_blank" A Step by Step Guide to the SAP MM Inventory Management Configurations SAP Sales and Distribution HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0072124040/sapinformation0e" \t "_blank" Implementing SAP Sales and Distribution HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/352805770X/sapinformation0e" \t "_blank" Sales and Distribution With Sap: Making Sap Sd Work for Your Business HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0965563316/sapinformation0e" \t "_blank" Instant Access: SAP, Reference for Sales and Distribution HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201715155/sapinformation0e" \t "_blank" SAP Processes: Sales and Customer Service (With CD-ROM) SAP Customer Relationship Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290299/sapinformation0e" \t "_blank" mySAP CRM: The Offcial Guide to SAP CRM Release 4.0 SAP Production Planning HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0789722747/sapinformation0e" \t "_blank" istering SAP R/3: The Production and Planning Modules SAP PP Paper HYPERLINK "http://www.sap-img.com/shop/sap-pp-production-shop-floor-controlconfigurations.htm" \t "_blank" A Step by Step Guide to the SAP PP Production Shop Floor Control Configurations SAP APO HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540225617/sapinformation0e" \t "_blank" Real Optimization with SAP APO HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0958179107/sapinformation0e" \t "_blank" The SAP APO Knowledge Book - Supply and Demand Planning HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290124/sapinformation0e" \t "_blank" SAP APO System istration SAP Plant Maintenance
HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201675323/sapinformation0e" \t "_blank" SAP(R) R/3(R) Plant Maintenance: Making It Work for Your Business HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0595325750/sapinformation0e" \t "_blank" Enterprise Asset Management : Configuring and istering SAP R/3 Plant Maintenance SAP Service Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540669833/sapinformation0e" \t "_blank" Inter-Organizational Cooperation With Sap Systems: Perspectives on Logistics and Service Management (Sap Excellence) SAP Quality Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201675315/sapinformation0e" \t "_blank" SAP(R) R/3(R) Quality Management: Making It Work for Your Business SAP Project Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201398354/sapinformation0e" \t "_blank" Project Management with SAP(R) R/3(R) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0072122544/sapinformation0e" \t "_blank" SAP Consulting and Project Management (Book/CD-ROM package) SAP Human Resource HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0975305255/sapinformation0e" \t "_blank" Mysap HR Interview Questions, Answers, and Explanations: SAP HR Certification Review HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290213/sapinformation0e" \t "_blank" mySAP HR: Technical Principles and Programming HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290248/sapinformation0e" \t "_blank" HR Personnel Planning and Development Using SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0789717565/sapinformation0e" \t "_blank" istering SAP R/3: HR - Human Resources Module HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570983/sapinformation0e" \t "_blank" SAP Employee Self-Service, Installation Guide, Release 4.5 HYPERLINK
"http://www.amazon.com/exec/obidos/ASIN/0965662128/sapinformation0e" \t "_blank" Sap Documentation and Training Development Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1930521022/sapinformation0e" \t "_blank" SAP End Training Plan SAP Certification for MM, SD, PP, FI, CO HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0071341617/sapinformation0e" \t "_blank" Sap R/3 Certification Exam Guide SAP Travel Management HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/B00007FYU3/sapinformation0e" \t "_blank" Business Process Redesign in Travel Management in an SAP R/3 Upgrade Project [: PDF] SAP Retail Industry HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3540671994/sapinformation0e" \t "_blank" Retail Information Systems Based on SAP Products SAP Basis istration HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0970890214/sapinformation0e" \t "_blank" SAP Basis istration for Windows HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0782124267/sapinformation0e" \t "_blank" SAP R/3 System istration : The Official SAP Guide HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1893570444/sapinformation0e" \t "_blank" System istration Made Easy, 4.6C/D HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761518878/sapinformation0e" \t "_blank" Basis istration for SAP HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201924692/sapinformation0e" \t "_blank" SAP(R) R/3(R) istration HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0071354131/sapinformation0e" \t "_blank" SAP R/3 's Handbook HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0764503758/sapinformation0e" \t "_blank" SAP R/3 istration For Dummies
SAP Electronic Data Interchange HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0761534318/sapinformation0e" \t "_blank" ALE, EDI, and IDoc Technologies for SAP SAP Transport HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0782125646/sapinformation0e" \t "_blank" Sap R/3 Change and Transport Management: The Official Sap Guide (Official Sap Guide) SAP Archiving HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290086/sapinformation0e" \t "_blank" Archiving your SAP Data HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/3528057998/sapinformation0e" \t "_blank" Efficient SAP R/3-Data Archiving : How to Handle Large Data Volumes SAP Authorizations HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/189357024X/sapinformation0e" \t "_blank" R/3 Authorization Made Easy 4.6A/B HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290167/sapinformation0e" \t "_blank" SAP Authorization System: Design and Implementation of Authorization concepts for SAP R/3 and SAP Enterprise Portals SAP Security HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201734974/sapinformation0e" \t "_blank" Security and Data Protection for SAP Systems SAP Operating System and Performance Fine Tuning HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290221/sapinformation0e" \t "_blank" SAP Performance Optimization Guide , Third Edition HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290264/sapinformation0e" \t "_blank" SAP System Landscape Optimization HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130280844/sapinformation0e" \t "_blank" SAP Hardware Solutions : Servers, Storage and Networks for mySAP.com HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0079136478/sapinformation0e" \t "_blank" Network Resource Planning For SAP R/3, BAAN IV, and PeopleSoft: A Guide to Planning
Enterprise Applications SAP Oracle HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/156592696X/sapinformation0e" \t "_blank" Oracle SAP istration (O'Reilly Oracle) HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201596229/sapinformation0e" \t "_blank" SAP R/3 and Oracle: Backup & Recovery SAP Mircosoft HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130198471/sapinformation0e" \t "_blank" Implementing Sap R/3 Using Microsoft Cluster Server HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/1592290051/sapinformation0e" \t "_blank" SAP Database istration with Microsoft SQL Server 2000 HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0201398370/sapinformation0e" \t "_blank" SAP(R) R/3(R) and Windows NT HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738412015/sapinformation0e" \t "_blank" Optimizing IBM Netfinity Servers for Sap R/3 and Windows Nt HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738415960/sapinformation0e" \t "_blank" Backup Solutions for Sap R/3 4.5B on Netfinity Servers Running Windows Nt SAP AIX HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738422894/sapinformation0e" \t "_blank" A Holistic Approach to a Reliable Infrastructure for Sap R/3 on Aix SAP Linux HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738426539/sapinformation0e" \t "_blank" Sap on DB2 Udb for Os/390 and Z/OS: Implementing Application Servers on Linux for Zseries SAP DB2 HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738412961/sapinformation0e" \t "_blank" Database istration Experiences: Sap R/3 on DB2 for Os/390 HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738415766/sapinformation0e" \t "_blank" Sap R/3 on DB2 Udb for Os/390: Application Servers on Os/390
HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738417181/sapinformation0e" \t "_blank" Sap R/3 on DB2 for Os/390: Database Availability Considerations HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738414999/sapinformation0e" \t "_blank" Sap R/3 on DB2 for Os/390: Implementing With Aix or Windows Nt Applications Servers HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738414425/sapinformation0e" \t "_blank" Sap R/3 on DB2 for Os/390: Disaster Recovery HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738403164/sapinformation0e" \t "_blank" High Availability Considerations: Sap R/3 on DB2 for OS HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130824267/sapinformation0e" \t "_blank" DB2 Universal Database and SAP R/3 Version 4 HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738423203/sapinformation0e" \t "_blank" Sap on DB2 for Z/OS and Os/390 DB2 System Cloning SAP Tivoli HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0738414506/sapinformation0e" \t "_blank" Using Tivoli to Manage a Large-Scale Sap R/3 Environment HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130150371/sapinformation0e" \t "_blank" Managing SAP R/3 with Tivoli SAP Informix HYPERLINK "http://www.amazon.com/exec/obidos/ASIN/0130225541/sapinformation0e" \t "_blank" SAP R/3 for the Informix DBA Search HYPERLINK "http://www.amazon.com/exec/obidos/external-search? tag=sapinformation0e&keyword=sap&mode=books" \t "_blank" www.amazon.com for more SAP books SAP Basis, ABAP Programming and Other IMG Stuff HYPERLINK "http://www.sap-img.com/index.htm" \t "_top" http://www.sapimg.com
SAP Certification, Functional, System istration and ABAP Programming Reference Books Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Easy to (SAP Transaction Codes) Content Author: Anand Author email:
[email protected] SPRO MM01 MM02 MM03 MMS1 MMS2 MMS3 MB1C MMPI MMBE MM60 XD01 XD02 XD03 VA01 VA02 VA03 VA11 VA12 VA13 VA21 VA22 VA23 VD02 VD03 VD04 VD06 VK11 VK0A VOK0 VOR1 VOR2
DEFINE ITEM CATEGORY CREATE MATERIAL MODIFY MATERIAL DISPLAY MATERIAL CREATE MATERIAL MASTER CHANGE MATERIAL MASTER DISPLAY MATERIAL MASTER MAINTAIN STOCK INITIALISE PERIOD FOR MASTER MATERIAL RECORDFROM CO CODE CREATE STOCK MATERIAL LIST CREATE CUSTOMER MODIFY CUSTOMER DISPLAY CUSTOMER CREATE ORDER CHANGE ORDER DISPLAY ORDER CREATE INQUIRY CHANGE INQUIRY DISPLAY INQUIRY CREATE QUOTATION CHANGE QUOTATION DISPLAY QUOTATION CHANGE SALES PROSPECT DISPLAY SALES PROSPECT DISPLAY CHANGES FLAG FOR DELETION MAINTAINING PRICING ASSIGN G/L GENERAL PRICING DEF COMMON DIST CHANEL DEF COMMON DIV
VOV6 VOV8 VOFA V129 V149 CA01 CA02 CA03 CS01 CS02 CS03 OVK1 OVK3 OVK4 OVR6 OVS9 OVRA OVRF OVXC OVX6 OVLK OVSG OVLH OVXM OVXJ OMS2 OVLP OX10 O/S2 O/S1 OBB8 OKKP VB01 VB02 VB03 VB31 VB32 VB33 VB21 VB22 VB23 VB25 VB35 VKA4 VKA5 VKA6 VC/1 VC/2 VDH2 VF01 VF02 VF03 VF07 VF11 VFX3 VFRB VF04
DEFINE SCHEDULE LINES DEFINE SALES DOC TYPE CREATE/OR CHANGE BILLING TYPES CONFIGURATION DEFINE INCOMPLETENESS SCHEMAS FOR FOREIGN TRADE ASSIGN INCOMPLETENESS SCHEMAS FOR COUNTRY CODE CREATE ROUTING EDIT ROUTING DISPLAY ROUTING CREATE BOM CHANGE BOM DISPLAY BOM DEFINE TAX DET RULES DEF TAX REL OF MASTER RECORDS CUSTOMER TAXES DEF TAX REL OF MASTER RECORDS MATERIAL TAXES DEF LEGAL STATUSES DEF CUSTOMER GRP MAINT STATISTICS GRPS FOR CUSTOMERS MAINT STATISTICS GRPS FOR MATERIAL ASSIGN SHIIPING POINT TO PLANT ASSIGN PLANT TO S.O AND DIST CHANEL DEFINE DELIVERY TYPE DEFINE INCO DEFINE ROUTES ASSIGN SALES OFF TO SALES AREA ASSIGN SALES GRP TO SALES OFFICE MATERAIL UPDATE DEFINE ITEM CATEGORY FOR DELIVERY ASSIGN DEL PLANTS FOR TAX DET DEFINE SERIAL NO PROFILE DEFINE CENTRAL CONTROL PARAMETERS FOR SR NO DEFINE OF PAYMENT ACTIVATION OF COMPONENETS CREATE REBATE AGGREMENTS CHANGE REBATE AGREMENT DISPLAY REBATE AGGREMENT CREATE PROMOTION CHANGE PROMOTION DISPLAY PROMOTION CREATE SALES DEAL CHANGE SALES DEAL DISPLAY SALES DEAL LIST OF SALES DEAL PROMOTION LIST CREATE ARCHIVE ISTRATION DEL ARCHIVE ISTRATION RELOAD ARCHIVE ISTRATION CUSTOMER LIST CREATE SALES SUMMARY DISPLAY CUSTOMER HIERARCHY CREATE PROFORMA INVOICE CHANGE PROFORMAINVOICE DISPLAYPROFORMA INVOICE DISPLAY FROM ARCHIVE CANCEL BILL BLOCKED BILLING DOC RETRO BILLING MAINTAIN BILL DUE LIST
VF06 VF21 VF22 VF23 VF44 VF45 VF46 VF31 VFP1 VARR VL01N VL02N VL03N V/08 V/30 FD32 /NSM12 SM30 ND59 VB0F
BACKGROUND PROCESSING CREATE INVOICE LIST CHANGE INVOICE LIST DISPLAY INVOICE LIST MAINT REVENUE LIST REVENUE REPORTS MAINT CANCELLATION LIST ISSUE BILLING DOC SET BILLING DATE ARCHIVE DOCUMENTS CREATE DELIVERY TO CHANGE DELIVERY WHICH IS ALREADY CREATED DISPLAY DELIVERY TO CHANGE CONDITION (PR PROCEDURE) DEFINE PRINT PARAMETERS SETTING CREDIT LIMIT FOR CUSTOMER TO REMOVE LOCK ENTRY LIST CUSTOMER MATERIAL INFO UPDATE BILL DOC
Related Topics: To get the associated data element descriptions of all the fields in a table How to get the field descriptions of a table? Find Related Application Transaction code using Text search Search for SAP Basis Transaction codes A simple method of changing the SAP Tcode Title Changing the Title of SAP Transaction SAP Books SAP Certification, ABAP Programming, Functional and Basis Component Reference Books
Basic Knowledge and System Navigation Question How to close a window? If we want to stop a transaction in the middle, Right click on the end button (X) on the top right corner of the window. Then select "stop transaction". As we dont have STOP icon as we have in WINDOWS, this will help in the same way. Its a very small tip, but will help a lot. With Compliment by: Bhaskar
Name two ways to start a transaction. - Dynamic Menu - Command Field Why do you create -specific parameters? They supply defaults to R/3 fields. If a field is indicated, the system automatically fills in default value. Depending on the field definition, the entry can also be replaced with a value entered by the . (Concept of PARAMETER ID) Name the three different kinds of messages in the R/3 system. What is the difference between them? A message can have five different types. These message types have the following effects during list processing: A (=Abend): The system displays a message of this message type in a dialog window. After the confirms the message using ENTER, the system terminates the entire transaction (for example SE38). E (=Error) or W (=Warning): The system displays a message of this message type in the status line. After the chooses ENTER, the system acts as follows: While creating the basic list, the system terminates the report. While creating a secondary list, the system terminates the corresponding processing block and keeps displaying the previous list level. I (=Information): The system displays a message of this message type in a dialog window. After the chooses ENTER , the system resumes processing at the current program position. S (=Success): The system displays a message of this message type on the output screen in the status line of the currently created list. What is a data dictionary or repository? Central catalog that contains the descriptions of an organization's data and provides information about the relationships between the data and its use in programs and screens. The data descriptions in a Data Dictionary is also called metadata, i.e., data that describes other data. The ABAP/4 Dictionary stores system-wide data definitions. When you create a new data definition, the Dictionary tool does all the processing necessary to create the definition. You can use the Dictionary tool to look up the "definition" of objects in your R/3 System. What is a matchcode? Comparsion key. A matchcode allows you to locate the key of a particular database
record (e.g. number) by entering any field value contained in the record. The system then displays a list of records matching the specifications. If you want an end to see a specific menu after logging on the R/3 system, how could you do that? maintenance transactions allow the system to create and maintain master records. This includes the generation and assignment of authorizations and authorization profiles. With Compliment by: Rohan Related Links: HYPERLINK "http://www.sap-img.com/abap/more-than-100-abap-interviewfaqs.htm" \t "_top" More than 100 ABAP Interview faq's HYPERLINK "http://www.sapimg.com/abap/more-than-100-abap-interview-faqs.htm" \t "_top" SAP Books HYPERLINK "http://www.sap-img.com/sap-books.htm" \t "_top" SAP Certification, ABAP Programming, Functional and Basis Component Reference Books INCLUDEPICTURE "https://image.staticox.com/?url=http%3A%2F%2Frcm-images.amazon.com%2Fimages%2FG%2F01%2Frcm%2F468x60.gif" \* MERGEFORMATINET
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff HYPERLINK "http://www.sap-img.com/index.htm" \t "_top" http://www.sapimg.com All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Certification, Functional, Basis istration and ABAP Programming Reference Books
SAP BW FAQ BW Query Performance Question: 1. What kind of tools are available to monitor the overall Query Performance? Answers: o BW Statistics o BW Workload Analysis in ST03N (Use Export Mode!) o Content of Table RSDDSTAT Question: 2. Do I have to do something to enable such tools? Answer: o Yes, you need to turn on the BW Statistics: RSA1, choose Tools -> BW statistics for InfoCubes (Choose OLAP and WHM for your relevant Cubes) Question: 3. What kind of tools are available to analyse a specific query in detail? Answers: o Transaction RSRT o Transaction RSRTRACE Question: 4. Do I have a overall query performance problem? Answers: o Use ST03N -> BW System load values to recognize the problem. Use the number given in table 'Reporting - InfoCubes:Share of total time (s)' to check if one of the columns %OLAP, %DB, %Frontend shows a high number in all InfoCubes.
o You need to run ST03N in expert mode to get these values Question: 5. What can I do if the database proportion is high for all queries? Answers: Check: o If the database statistic strategy is set up properly for your DB platform (above all for the BW specific tables) o If database parameter set up accords with SAP Notes and SAP Services (EarlyWatch) o If Buffers, I/O, U, memory on the database server are exhausted? o If Cube compression is used regularly o If Database partitioning is used (not available on all DB platforms) Question: 6. What can I do if the OLAP proportion is high for all queries? Answers: Check: o If the Us on the application server are exhausted o If the SAP R/3 memory set up is done properly (use TX ST02 to find bottlenecks) o If the read mode of the queries is unfavourable (RSRREPDIR, RSDDSTAT, Customizing default) Question: 7. What can I do if the client proportion is high for all queries? Answer: o Check whether most of your clients are connected via a WAN Connection and the amount of data which is transferred is rather high. Question: 8. Where can I get specific runtime information for one query? Answers: o Again you can use ST03N -> BW System Load o Depending on the time frame you select, you get historical data or current data. o To get to a specific query you need to drill down using the InfoCube name o Use Aggregation Query to get more runtime information about a single query. Use tab All data to get to the details. (DB, OLAP, and Frontend time, plus Select/ Transferred records,
plus number of cells and formats) Question: 9. What kind of query performance problems can I recognize using ST03N values for a specific query? Answers: (Use Details to get the runtime segments) o High Database Runtime o High OLAP Runtime o High Frontend Runtime Question: 10. What can I do if a query has a high database runtime? Answers: o Check if an aggregate is suitable (use All data to get values "selected records to transferred records", a high number here would be an indicator for query performance improvement using an aggregate) o Check if database statistics are update to data for the Cube/Aggregate, use TX RSRV output (use database check for statistics and indexes) o Check if the read mode of the query is unfavourable - Recommended (H) Question: 11. What can I do if a query has a high OLAP runtime? Answers: o Check if a high number of Cells transferred to the OLAP (use "All data" to get value "No. of Cells") o Use RSRT technical Information to check if any extra OLAP-processing is necessary (Stock Query, Exception Aggregation, Calc. before Aggregation, Virtual Char. Key Figures, Attributes in Calculated Key Figs, Time-dependent Currency Translation) together with a high number of records transferred. o Check if a exit Usage is involved in the OLAP runtime? o Check if large hierarchies are used and the entry hierarchy level is as deep as possible. This limits the levels of the hierarchy that must be processed. Use SE16 on the inclusion tables and use the List of Value feature on the column successor and predecessor to see which entry level of the hierarchy is used. - Check if a proper index on the inclusion table exist Question:
12. What can I do if a query has a high frontend runtime? Answers: o Check if a very high number of cells and formattings are transferred to the Frontend ( use "All data" to get value "No. of Cells") which cause high network and frontend (processing) runtime. o Check if frontend PC are within the recommendation (RAM, U Mhz) o Check if the bandwidth for WAN connection is sufficient Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com
Mini SAP System Requirement and How to Get it Mini SAP System Requirement The system Requirements are : General Requirements Operating System: Windows 2000 (Service Pack2 or higher); Windows XP (Home or Professional); Windows NT Linux Internet Explorer 5.01 or higher At least 192 MB RAM (recommended to have 256 MB of RAM) At least 512 MB paging file At least 3.2 GB disk space (recommended to have 6 GB hard disk drive space) (120 MB DB software, 2.9 GB SAP data, 100 MB SAP GUI + temporary free space for the installation) The file C:\WINNT\system32\drivers\etc\services (Windows 2000) or C:\Windows\system\32\drivers\etc\services (Windows XP) must not include an entry for port 3600. A possible entry can be excluded by using the symbol '#'. No SAPDB must be installed on your PC. The hostname of the PC must not be longer than 13 characters. The Network must be configured for installation and the MS Loopback Adapter must be configured when you start the system without a network connection!
Special Requirements for Installations on Windows XP In the file C:\Windows\system\32\drivers\etc\hosts the current IP address and the host name must be defined as
Open the network connectivity definition with start->control ->network connections for defining the network connection. Select ->extended-> allow other s in network. Activate new configurations. Select remote desktop within extended configuration menu. ********* How to get Mini SAP? In order to get the free Mini SAP, you need to buy the following book where in you will get two CD's of SAP WAS 6.10 (Web Application Server) which can be installed in your system and practice ABAP programming etc... ******* You can get your MiniSAP with the book :ABAP Objects: An introduction to Programming SAP Applications by Horst Keller, Sascha Kruger. SAP Press. ISBN 0-201-75080-5. It comes with 2 cds (Mini Basis SAP kernel + database). It also includes the SQL server. or ABAP Objects Reference Book H. Keller, J. Jacobitz SAP PRESS 1100 S., 2003, geb., mit 2 CDs 129,95 Euro, ISBN 1-59229-011-6 lieferbar The first complete language reference book for ABAP! This book represents the first complete and systematic language reference book for ABAP Objects. Organized according to subject areas, the book offers a description of all statements used for developing programs and classes in ABAP and ABAP Objects (including the current release, 6.20). Therefore, not only will you quickly find explanations and examples of the command you are looking for, you will also get a complete overview of all relevant contexts of use. Changes introduced between releases 6.10 and 6.20 are highlighted. Each subject area starts with an introduction to the concepts associated with it. Notes on possible error
messages and practical recommendations make this an extremely useful manual, further enhanced with a detailed glossary covering all the key used in the book. Special bonus! Includes SAP Web AS 6.10 on two CDs. ************** Alternatively, if you are a customer of SAP and have an OSS -id, then you can also buy the Minisap software directly from the Sap service market. https://www010.sap-ag.de/knowledgecat Search for "MiniSAP Basis 4.6D November 2000 (English)" (Item nbr. : 50043446). Minisap contains only SAP BASIS where you can do your ABAP. It will costs you 25 EURO. ************** SAP Reference Books SAP Certification, Basis istration, Functional and ABAP Programming Reference Books Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP BW Tips and Business Information Warehouse Discussion Forum SAP Business Information Warehouse (BW) is SAP´s Data Warehouse solution. It has been specially developed to allow you to gather and analyze all kinds of statistical information in the best possible way. The SAP Business Information Warehouse (SAP BW) is a core element of mySAP.com. SAP BW is an enterprise-wide information hub that enables data analysis from R/3 and other business application, including external data sources such as databases and the Internet. SAP BW also offers easy integration with other mySAP solutions, such as
mySAP Supply Chain Management (mySAP SCM), mySAP Strategic Enterprise Management (mySAP SEM), and mySAP Customer Relationship Management (mySAP CRM). SAP BW is a comprehensive end-to-end data warehouse solution with optimized structures for reporting and analysis. To help knowledge workers quickly mine an enterprise’s business data, SAP BW is equipped with preconfigured information models and reports, as well as automatic data extraction and loading methods. With an easy-to-use Microsoft Excel-based interface, you can create, format, and analyze reports, and publish those reports to the web. Built for high performance, SAP BW resides on its own dedicated server. Online Transaction Processing (OLTP) and reporting activities are therefore separated, and system performance is not compromised. If you have any SAP Business Information Warehouse queries, please feel free to raise it in the SAP BW Forum. Share a SAP BW Tips with the Business Information Warehouse community by Submitting a SAP BW Tips. All submissions will be recognized along with the tip. Introduction SAP BW Certification Books The Three Layers of SAP SAP BW Certification: A Business Information BW Warehouse Study Guide [: ADOBE Data Warehouse READER] Business Information Warehouse SAP BW Reference Books Use of manual security SAP BW: A Step by Step Guide profiles with BW Mastering the SAP Business Information Warehouse Comparison [: ADOBE READER] Main Advantages of BW 3.0 over 2.1 SAP Training CBT Pros and Cons of Web Computer Based Training on SAP Functional, Basis against BEX istration and ABAP/4 Programming Data ing Data load in BW Difference in number of data records
Infocube Infocube Compression How to Compress InfoCube Data Cube to Cube Load
BW Tables General R/3 Source Table.field - How Huge Performance Problems on SAP BW 3.10 To Find How to build an extractor? The query could not be saved due to a problem in transport Reporting ODS infosource not showing up
BW versus R/3 Reporting Errors Error in transport BW ERROR : replicate data Query View Workbook from source system Stop a scheduled infopacket BEX Query Authorizations SAP BW Frequently Asked SAPConsole Question Delete unwanted Objects in QA system SAP BW FAQ LO Cockpit Step By Step SAP BW Interview Questions 1 SAP BW Interview Questions 2 My SAP BW Certification Experience SAP Business Information Warehouse Forum at the convenient of your mail box Exchange SAP BW problems/solutions, tips, ideas with other SAP BW peers from around the globe. SAP BW Forum for BW Professional
enter email ad
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Certification, Functional, Basis istration and ABAP Programming Reference Books
The Three Layers of SAP BW SAP BW has three layers:
Business Explorer: As the top layer in the SAP BW architecture, the Business
Explorer (BEx) serves as the reporting environment (presentation and analysis) for end s. It consists of the BEx Analyzer, BEx Browser, BEx Web, and BEx Map for analysis and reporting activities.
Business Information Warehouse Server: The SAP BW server, as the middle layer, has two primary roles: • Data warehouse management and istration: These tasks are handled by the production data extractor (a set of programs for the extraction of data from R/3 OLTP applications such as logistics, and controlling), the staging engine, and the Workbench. • Data storage and representation: These tasks are handled by the InfoCubes in conjunction with the data manager, Metadata repository, and Operational Data Store (ODS).
Source Systems: The source systems, as the bottom layer, serve as the data sources for raw business data. SAP BW s various data sources: • R/3 Systems as of Release 3.1H (with Business Content) and R/3 Systems prior to Release 3.1H (SAP BW regards them as external systems) • Non-SAP systems or external systems • mySAP.com components (such as mySAP SCM, mySAP SEM, mySAP CRM, or R/3 components) or another SAP BW system.
Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
SAP Data Warehouse -----Original Message----Subject: Data Warehouse We have large amounts of historical sales data stored on our legacy system (i.e. multiple files with 1 million+ records). Today the s use custom written programs and the Focus query tool to generate sales'ish type of reports. We are wanting that existing legacy system to go away and need to find a home for the data and the functionality to access and report on that data. What options does SAP afford for data warehousing? How does it affect the response of the SAP database server? We are thinking of moving the data onto a scaleable NT server with
large amounts of disk (10gb +) and using PC tools to access the data. In this environment, our production SAP machine would perform weekly data transfers to this historical sales reporting system. Has anybody implemented a similar solution or have any ideas on a good attack method to solve this issue? Thanks in advance. -----Reply Message----Subject: RE: Data Warehouse Hi, You may want to look at SAP's Business Information Warehouse. This is their answer to data warehousing. I saw a presentation on this last October at the SAP Technical Education Conference and it looked pretty slick. BIW runs on its own server to relieve the main database from query and report processing. It accepts data from many different types of systems and has a detailed istration piece to determine data source and age. Although the Information System may be around for sometime it sounded like SAP is moving towards the Business Information Warehouse as a reporting solution. -----End of Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
SAP Business Information Warehouse -----Original Message----Subject: Business Information Warehouse Ever heard about apples and oranges. SAP/R3 is an OLTP system where as BIW is an OLAP system. LIS reports can not provide the functionality provided by BIW. -----Reply Message-----
Subject: Business Information Warehouse Hello, The following information is for you to get more clarity on the subject: SAP R/3 LIS (Logistic Information System) consist of infostructures (which are representation of reporting requirements). So whenever any event (goods reciept, invoice reciept etc. ) takes place in SAP R/3 module, if relevant to the infostructure, an corresponding entry is made in the infostructures. Thus infostructures form the database part of the datawarehouse. For reporting the data (based on OLAP features such drill-down, abc, graphics etc.), you can use SAP R/3 standard analysis (or flexible analysis) or Business Warehouse (which is excel based) or Business Objects (which is third party product but can interface with SAP R/3 infostructures using BAPI calls). In short, the infostructures (which are part of SAP R/3 LIS) form the data basis for reporting with BW. Regards -----End of Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
Use of manual security profiles with SAP BW -----Original Message----Subject: Use of manual security profiles with BW? (Business Information Warehouse) Our company is currently on version 3.1H and will be moving to 4.6B late summer 2000. Currently all of our R/3 security profiles were created manually. We are also in the stage of developing and going live with the add-on system of Business Warehouse (BW). For consistency, we have wish to use manual profiles within the BW system and later convert all of our manual security profiles (R/3 and BW) to profile generated ones. Is there anyone else that can shed any light on this situation? (Success
or problems with using manual security profiles with BW?) Any would be greatly appreciated. Thank you, -----Reply Message----Subject: Use of manual security profiles with BW? (Business Information Warehouse) Hi , You are going to have fun doing this upgrade. The 4.6b system is a completely different beast than the 3.1h system. You will probably find a lot of areas where you have to extend you manually created profiles to cover new authorisation objects (but then you can have this at any level). In 4.6b you really have to use the profile generator, but at least there is a utility to allow you to pick up your manually created profile and have it converted to an activity group for you. This will give you a running start in this area, but you will still have a lot of work to do. The fact that you did not use PG at 3.1h will not matter as it changed at 4.5 too and the old activity groups need the same type of conversion (we are going through that bit right now). Hope this helps -----End of Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
Main advantages of BW 3.0 over 2.1C Here's a brief list, without detailed explanations :- XML for reading and writing metadata and data. - Web application designer: graphically design and publish web reports and web applications. - Open Hub Service for distributing data to other tables/systems on a schedule.
It s selection, projection, and aggregation. Integrated into the BW monitor. - Process Chains and graphical scheduler for automating complex processes. s branching, condition testing, etc. Enables you to schedule all functions in a graphical, drag-and-drop fashion, including extracts, index drops and rebuilds, activating data, compressing, rolling up to aggregates, etc. - Transactional ODS objects with read/write API. - Transfer rules for hierarchies. - Subtree insert and subtree update for hierarchies. - Active attributes on hierarchies (sign flip, etc.) - Load, stage, and merge master data to ODS. - DB Connect Service allows BW to extract data from any DBMS ed by SAP R/3. - Formula editor in transfer and update rules to avoid ABAP coding. - Toolbox of standard transformations such as substring, look up data in a table, concatenate, offset and length, arithmetic operations, etc. - Parallel loading into a single ODS object. - Secondary index maintenance for ODS objects built in to BW Workbench. - Multiprovider: Use ODS objects, master data, and cubes in a multicube (now called multiprovider.) - New InfoSet Concept: tabular data together and make it available for reporting. You can ODS objects, master data tables, etc. - Archiving: Built-in tools to archive data on a schedule using selection criteria. Integrated into BW monitor; archived data deleted from InfoCubes and corresponding aggregates. for re-loading data from archives as necessary. - BW Monitor includes all activities of process chains, open hub service, and archiving. - Use multiple hierarchies in a BW query. - Use a mix of hierarchies and characteristics on rows or columns in a BW query. - Use restricted key figures in a calculated key figure. - Generate static, offline web reports. - BEx Cell Editor: In queries with two structures, you can now reference cells at the intersections of rows and columns. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
Pros and Cons of Web against BEX
1. Web reporting is faster then Excel, there is less overhead in executing Web reporting as opposed to Excel. (Whitepaper on SAP about this.) 2. There is not anymore work in formatting or creation of templates then in comparison to workbooks. 3. Query creation is the same as in BEX, so there is no new knowledge there. 4. Yes, knowledge of HTML is needed, but if you use the standard CSS templates, you really don't need to know them unless you want to change them. But, if you can write queries or code ABAP, you can definitely learn basic HTML and CSS to customize reporting. Its not that hard. 5. The learning curve for NEW s in Web Reporting vs.. BEX is actually considerably lower. Most people are very familiar with using a web browser, and IMOE I have found they pick up usage of web reporting much quicker then trying to teach them BEX. 6. Note, if you have a large base which is already power Excel/BEx s, then they might be more reluctant to switch, though they would have no problem learning quickly the web reporting. Their downside would be that the behavior is not like Excel, which is a learned behavior, though the functionality is the same. 7. Publishing of queries and reports is done (or can be) via a role template which can be published on the web to provide common access to reports and queries. 8. Your implementation team (or at least one person on there) could be designated to picking up learning creation of web templates. (Its not hard, really.) Depending on organization size you may not need an additional person. 9. Publishing can be as easy a link on an existing intranet, or if you are using Portals already, integration with Portals is straightforward and you should have the knowledge base for doing so w/ your Portals group. 10. Query functionality is EXACTLY THE SAME with BEX and Web reporting, they both use query analyzer. The only difference is in presentation and output. 11. With Web reporting, you have (I think) greater control over presentation (combination of reports, charts, etc...) then w/ BEX. 12. You can provide the ability for "Printer friendly" versions of web reports, you can also provide the ability to easily pull the results into Excel in standard format or CSV format. 13. Finally, I think you have the ability to open up reporting and information consumption to a wider audience then in sticking w/ just BEx. (It definitely has its place in the organization.) Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
Data load in SAP BW What is the strategy to load for example 500,000 entries in BW (material master, transactional data)? How to separate this entries in small packages and transfer it to BW in automatic? Is there some strategy for that? Is there some configuration for that? See OSS note 411464 (example concerning Info Structures from purchasing documents) to create smaller jobs in order to integrate a large amount of data. For example, if you wish to split your 500,000 entries in five intervals: - Create 5 variants in RMCENEAU for each interval - Create 5 jobs (SM36) that execute RMCENEAU for each variant - Schedule your jobs - You can then see the result in RSA3
Loading Data From a Data Target Can you please guide me for carrying out his activity with some important steps? I am having few request with the without data mart status. How can I use only them & create a export datasource? Can you please tell me how my data mechanism will work after the loading? Follow these steps: 1. Select Source data target( in u r case X) , in the context menu click on Create Export Datasources. DataSource ( InfoSource) with name 8(name of datatarget) will be generated. 2. In Modelling menu click on Source Systems, Select the logical Source System of your BW server, in the context menu click on Replicate DataSource.
3. In the DataModelling click on Infosources and search for infosource 8(name of datatarget). If not found in the search refresh it. Still not find then from DataModelling click on Infosources, in right side window again select Infosources, in the context menu click on insert Lost Nodes. Now search you will definately found. 4. No goto Receiving DataTargets ( in your case Y1,Y2,Y3) create update rules. In the next screen select Infocube radio button and enter name of Source Datatarget (in u r case X). click Next screen Button ( Shift F7), here select Addition radio button, then select Source keyfield radio button and map the keyfields form Source cube to target cube. 5. In the DataModelling click on Infosources select infoSource which u replicated earlier and create infopackage to load data.. SAP BW Tips by: Srinivas
Fast Links: Get help for your SAP BW problems Do you have a SAP BW Question? SAP Books SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books SAP Business Warehouse Tips SAP BW Tips and Business Information Warehouse Discussion Forum Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
Difference in number of data records -----Original Message----Subject: Difference in number of data records Hello, I have ed data from R/3 to BW (Controlling Datasources). The problem is that when i use the extractor checker (rsa3) in R/3 for a specific datasource (0CO_OM_OPA_1) it shows me that there are 1600 records. When i load this datasource in BW it shows me that there are 400.000 records. I'm ing data to "PSA only". Any ideas why this is happening ? Thanks -----Reply Message----Subject: RE: Difference in number of data records Check the 'data recs/call' and 'number of extract calls' parameters in RSA3. Most likely the actual extract is only making one call with a larger data rec/call number. The extraction process will collect data records with the same key so less data has to be transferred to the BW. When you run RSA3 you are probably getting similar records (that would normally collect) in different data packets thereby creating more records. Try running RSA3 with a much higher (2000) recs/call for several calls. Regards, -----End of Message Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
SAP R/3 Source Table.field - How To Find?
-----Original Message----Subject: R/3 Source Table.field - How To Find? What is the quickest way to find the R/3 source table and field name for a field appearing on the BW InfoSource? -----Reply Message----Subject: RE: R/3 Source Table.field - How To Find? Hi, With some ABAP-knowledge you can find some info: 1, Start ST05 (SQL-trace) in R/3 2, Start RSA3 in R/3 just for some records 3, After RSA3 finishes, stop SQL-trace in ST05 4, Analyze SQL-statements in ST05 You can find the tables - but this process doesn't help e.g for the LO-cockpit datasources. Hope this helps, -----End of Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
SAP BW versus R/3 Reporting -----Original Message----Subject: BW versus R/3 Reporting Dear All, Would it be sufficient just to Web-enable R/3 Reports ? Why does one need to implement BW ? What are the major benefits of reporting with BW over R/3 ?
Thanking you, -----Reply Message----Subject: RE: BW versus R/3 Reporting There are quite a few companies that share your thought but R/3 was designed as a OLTP system and not an analytical and reporting system. In fact depending on you needs you can even get away with a reporting instance (quite easy with Sun or EMC storage) Yes you can run as many reports as you need from R/3 and web enable them but consider these factors. 1: Performance -- heavy reporting along with regular OLTP transactions can produce a lot of load both on the R/3 and the database (u, memory, disks, etc). Just take a look at the load put on your system during a month end, quarter end, or year end -- now imagine that occurring even more frequently. 2: Data analysis -- BW uses a Data Ware house and OLAP concepts for storing and analyzing data. Where R/3 was designed for transaction processing. With a lot of work you can get the same analysis out of R/3 but most likely would be easier from a BW. Regards, -----Reply Message----Subject: RE: BW versus R/3 Reporting Major benefits of BW include: 1) By offloading ad-hoc and long running queries from production R/3 system to BW system, overall system performance should improve on R/3. 2) Another key performance benefit with BW is the database design. It is designed specifically for query processing, not data updating and OLTP. Within BW, the data structures are designed differently and are much better suited for reporting than R/3 data structures. For example, BW utilizes star schema design which includes fact and dimension tables with bit-mapped indexes. Other important factors include the built-in for aggregates, database partitioning, more efficient ABAP code by utilizing TRFC processing versus IDOC. 3) Better front-end reporting within BW. Although the BW excel front-end has it's problems, it provides more flexibility and analysis capability than the R/3 reporting screens. 4) BW has ability to pull data from other SAP or non-SAP sources into a
consolidated cube. In summary, BW provides much better performance and stronger data analysis capabilities than R/3. -----End of Message----Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
Error in transport After creating a query in BEX, you try and save the query, it gives you the following popup message: "The query could not be saved due to a problem in transport". Steps to correct the problem: 1. Within strator Workbench click on the Transport Connection tab in the Navigation Window on the left hand side. 2. Select the Request BEx button on the toolbar. 3. Create a transport. 4. Try to change the query again. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books
SAP BW ERROR : replicate data from source system
BW 2.1C OS WINT4 The RFC is working fine and you are trying to replicate data from source system (4.0B), while doing this you got an error an ABAP dump, in this dump the Exception Condition are "CNTL_ERROR" raised Take a look at OSS notes 158985 and 316243. Depending on what patch level, GUI, or Kernel you are on. Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm
SAP BW Interview Questions 1. How much time does it take to extract 1 million of records from an infocube? 2. How much does it take to load (before question extract) 1 million of records to an infocube? 3. What are the four ASAP Methodologies? 4. How do you measure the size of infocube? 5. Difference between infocube and ODS? 6. Difference between display attributes and navigational attributes? Kiran 1. Ans. This depends,if you have complex coding in update rules it will take longer time,orelse it will take less than 30 mins. 3. Ans: Project plan Requirements gathering Gap Analysis
Project Realization 4. Ans: In no of records 5. Ans: Infocube is structured as star schema(extended) where in a fact table is surrounded by different dim table which connects to sids. And the data wise, you will have aggregated data in the cubes. ODS is a flat structure(flat table) with no star schema concept and which will have granular data(detailed level). 6. Ans: Display attribute is one which is used only for display purpose in the report.Where as navigational attribute is used for drilling down in the report.We don't need to maintain Nav attribute in the cube as a characteristic(that is the advantage) to drill down. Ravi Q1. SOME DATA IS ED TWICE INTO INFOCUBE. HOW TO CORRECT IT? Ans: But how is it possible?.If you load it manually twice, then you can delete it by request. Q2. CAN U ADD A NEW FIELD AT THE ODS LEVEL? Sure you can.ODS is nothing but a table. Q3. CAN NUMBER OF DATASOURCE HAS ONE INFOSOURCE? Yes ofcourse.For example, for loading text and hierarchies we use different data sources but the same infosource. Q4. BRIEF THE DATAFLOW IN BW. Data flows from transactional system to analytical system(BW).DS on the transactional system needs to be replicated on BW side and attached to infosource and update rules respectively. Q5. CURRENCY CONVERSIONS CAN BE WRITTEN IN UPDATE RULES. WHY NOT IN TRANSFER RULES? Q6. WHAT IS PROCEDURE TO UPDATE DATA INTO DATA TARGETS? Full and delta. Q7. AS WE USE Sbwnn,SBiw1,sbiw2 for delta update in LIS THEN WHAT IS THE PROCEDURE IN LO-COCKPIT? No lis in lo cockpit.We will have data sources and can be maintained(append fields).Refer
white paper on LO-Cokpit extractions. Q8. SIGNIFICANCE OF ODS. It holds granular data. Q9. WHERE THE PSA DATA IS STORED? In PSA table. Q10.WHAT IS DATA SIZE? The volume of data one data target holds(in no.of records) Q11. DIFFERENT TYPES OF INFOCUBES. Basic,Virtual(remote,sap remote and multi) Q12. INFOSET QUERY. Can be made of ODSs and objects Q13. IF THERE ARE 2 DATASOURCES HOW MANY TRANSFER STRUCTURES ARE THERE. In R/3 or in BW??.2 in R/3 and 2 in BW Q14. ROUTINES? Exist In the info object,transfer routines,update routines and start routine Q15. BRIEF SOME STRUCTURES USED IN BEX. Rows and Columns,you can create structures. Q16. WHAT ARE THE DIFFERENT VARIABLES USED IN BEX? Variable with default entry Replacement path SAP exit Customer exit Authorization Q17. HOW MANY LEVELS YOU CAN GO IN REPORTING? You can drill down to any level you want using Nav attributes and jump targets Q18. WHAT ARE INDEXES? Indexes are data base indexes,which help in retrieving data fastly. Q19. DIFFERENCE BETWEEN 2.1 AND 3.X VERSIONS. Help!!!!!!!!!!!!!!!!!!!Refer documentation Q20. IS IT NESSESARY TO INITIALIZE EACH TIME THE DELTA UPDATE IS USED.
Nope Q21. WHAT IS THE SIGNIFICANCE OF KPI'S? KPI’s indicate the performance of a company.These are key figures Q22. AFTER THE DATA EXTRACTION WHAT IS THE IMAGE POSITION. After image(correct me if I am wrong) Q23. REPORTING AND RESTRICTIONS. Help!!!!!!!!!!!!!!!!!!!Refer documentation Q24. TOOLS USED FOR PERFORMANCE TUNING. ST*,Number ranges,delete indexes before load ..etc Q25. PROCESS CHAINS: IF U ARE USED USING IT THEN HOW WILL U SCHEDULING DATA DAILY. There should be some tool to run the job daily(SM37 jobs) Q26. AUTHORIZATIONS. Profile generator Q27. WEB REPORTING. What are you expecting?? Q28. CAN CHARECTERSTIC CAN BE INFOPROVIDER ,INFOOBJECT CAN BE INFOPROVIDER. Of course Q29. PROCEDURES OF REPORTING ON MULTICUBES. Refer help.What are you expecting??.Multicube works on Union condition Q30. EXPLAIN TRANPORTATION OF OBJECTS? Dev---àQ and Dev-------àP Questions: Raghav Answers: Ravi
Fast Links: A Personal BW Certification Experience My SAP BW Certification Experience
Get help for your SAP BW problems Do you have a SAP BW Question? SAP Books SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books SAP BW Tips SAP BW Tips and Business Information Warehouse Discussion Forum Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
SAP BW Interview Questions 2 1) What is process chain? How many types are there? How many we use in real time scenario? Can we define interdependent processes with tasks like data loading, cube compression, index maintenance, master data & ods activation in the best possible performance & data integrity. 2) What is data integrityand how can we achieve this? 3) What is index maintenance and what is the purpose to use this in real time? 4) When and why use infocube compression in real time? 5) What is mean by data modelling and what will the consultant do in data modelling? 6) How can enhance business content and what for purpose we enhance business content (becausing we can activate business content) 7) What is fine-tuning and how many types are there and what for purpose we done tuning in real time. tuning can only be done for infocube partitions and creating aggregates or any other? 8) What is mean by multiprovider and what purpose we use multiprovider? 9) What is scheduled and monitored data loads and for what purpose? Ans # 1: Process chains exists in Work Bench. Using these we can automate ETTL processes. These allows BW guys to schedule all activities and monitor (T Code: RSPC).
Ans # 2: Data Integrity is about eliminating duplicate entries in the database and achieve normalization. Ans # 4: InfoCube compression creates new cube by eliminating duplicates. Compressed infocubes require less storage space and are faster for retrieval of information. Here the catch is .. Once you compress, you can't alter the InfoCube. You are safe as long as you don't have any error in modeling. This compression can be done through Process Chain and also manually. SAP BW Tips by: Anand. Ans#3 Indexing is a process where the data is stored by indexing it. Eg: A phone book... When we write somebodys number we write it as Prasads number would be in "P" and Rajesh's number would be in "R"... The phone book process is indexing.. similarly the storing of data by creating indexes is called indexing. Ans#5 Datamodeling is a process where you collect the facts..the attributes associated to facts.. navigation atributes etc.. and after you collect all these you need to decide which one you ill be using. This process of collection is done by interviewing the end s, the power s, the share holders etc.. it is generally done by the Team Lead, Project Manager or sometimes a Sr. Consultant (4-5 yrs of exp) So if you are new you dont have to worry about it....But do that it is a imp aspect of any datawarehousing soln.. so make sure that you have read datamodeling before attending any interview or even starting to work.... Ans#6 We can enhance the Business Content bby adding fields to it. Since BC is delivered by SAP Inc it may not contain all the infoobjects, infocubes etc that you want to use according to your company's data model... eg: you have a customer infocube(In BC) but your company uses a attribute for say..apt number... then instead of constructing the whole infocube you can add the above field to the existing BC infocube and get going... Ans#7 Tuning is the most imp process in BW..Tuning is done the increase efficiency.... that means lowering time for loading data in cube.. lowering time for accessing a query.. lowering time for doing a drill down etc.. fine tuning=lowering time(for everything possible)...tuning can be done by many things not only by partitions and aggregates there are various things you can do... for eg: compression, etc.. Ans#8 Multiprovider can combine various infoproviders for reporting purposes.. like you can
combine 4-5 infocubes or 2-3 infocubes and 2-3 ODS or IC, ODS and Master data.. etc.. you can refer to help.sap.com for more info... Ans#9 Scheduled data load means you have scheduled the loading of data for some particular date and time you can do it in scheduler tab if infoobject... and monitored means you are monitoring that particular data load or some other loads by using transaction RSMON. SAP BW Tips by: Nikhil
Fast Links: Get help for your SAP BW problems Do you have a SAP BW Question? SAP Books SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books SAP BW Tips SAP BW Tips and Business Information Warehouse Discussion Forum Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.
My SAP BW Certification Experience These are some questions which I ed after completing my certification. In certification 3 hrs is very sufficient and more time we will spend for understanding questions than writing answers.
1) Project Implementation (4 Questions): 1. What are the activities will be done during Realisation Phase. a. BW Dev system Installation will be done during this period. True or False b. Basis help is highly required during this phase. True or false. Like this 5 choice below each questions and each choice carries mark as we have to speciy true or false. 2. In which Phase Data source will be determined. a. During Realisation phase all team memebers will be discussing abt the datasource that need to be used to fit the Requiremnet. (True or False). b. Same question asked as Design Phase. (II). Data Modelling (8 Questions): SAP Data Modelling Book is sufficient for this. Nothing reqd more than that. 1. To which kind of Data Target compression is done. (this Q has one answer). 2. What are the ways to improve data Loading performance. a. Line item Dimension b. Creating Indexes to ODS. c. Adding a primary key to ODS d. Fact table smaller than dimension table e. Dimension Table smaller than fact table. LIKE THIS 8 QUESTIONS. In this part all the questions were bit confusing. Each question we have to read twice and answer. Here Lot of scenarios given and asking how we will design. Whether as ODS, Infoobject and Cube, Navigational attr. (III) Warehouse Management. (24 Questions)
Very Easy. All the questions are very straight forward. Basic BW questions. 1. What are the data traget that can be used for a Multi providers. Give five choices we have to choose the correct ones. 2. Aggregates can be done for ODS? True or false. (IV) Reporting: (24 Questions)] Here also questions are easy. More questions on style sheets. 1. What is the extension for saving style sheets. a. .CSS ext b. .TXT ext Like this 5 choices were Given. 2. What are the functions in Reporting Agent? a. Printing b. Saving workbooks. Also some questions on Workbooks. In reporting they gave some scenarios and we have to choose which option is correct for creating reports. Like, we have to create as Restricted Key fig or Cal Key Gig or as Replacement Path variable. Forgot the scenarios. Each questions are like a paragraph so it was tough to questions. (V) Extractions. Here I had one question from LO and 1 question from CO-PA and 0 questions from LIS. More questions on Generic extractor, Delta type and more questions on S-API. 1. Will S-API sends delta records to BW. True or False. 2. S-API needs to be installed in both BW and R/3 System?
5 choices we have to choose it. 3. In CO-PA when we create a datasources which is created automatically. a. One table and 2 structures. b. Two table and two structure. c. Two tale and one structure. Like this 5 choces. We have to think and write but they are easy. (VI). Authorisation. All the four quesions are with Scenarios. 1. Is the Authorisation S_RS_COMP sufficient for an to create Reports. 5 choices and every choices carries marks. Just like Project implementation. 2. What are the authorisation need to be given for a Key s. I hope this will give some idea. I am posting this so any one can make use of it. All the Best. It will be very easy be cool and relaxed. Cheers! SAP BW Tips by : Bhuvana
Fast Links: Interview Questions on BW SAP BW Interview Questions 1 Get help for your SAP BW problems Do you have a SAP BW Question? SAP Books SAP Business Warehouse, Functional, Basis istration and ABAP Programming Reference Books SAP BW Tips
SAP BW Tips and Business Information Warehouse Discussion Forum Best regards, SAP Basis, ABAP Programming and Other IMG Stuff http://www.sap-img.com/index.htm All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved. All product names are trademarks of their respective companies. The site www.sap-img.com is in no way d with SAP AG. Every effort is made to ensure the content integrity. Information used on this site is at your own risk. The content on this site may not be reproduced or redistributed without the express written permission of www.sap-img.com or the content authors.