Common SAP BW Transactions
Important Transaction Codes For BW
Data Warehousing
Naming Convention in SAP BW
Differences Between BW and BI Versions
FAQS
BW Query Performance
SAP BW Interview Questions 1
SAP BW Interview Questions 2
Questions Answers on SAP BW
Daily Tasks in Support Role and Infopackage Failures
----------------
Tickets and Authorization in SAP Business Warehouse
Major Difference between SAP BI 7.0 and SAP BW 3.5
11/16/08
11/13/08
SMART FORMS
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 user 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 passes 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 support 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 passes form content from R/3 to an external product without passing any layout information about the Smart Form.
Advantages of SAP Smart Forms:
SAP Smart Forms have the following advantages:
1. The adaption of forms is supported 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 user 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. User-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 supported 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)
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 support 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 tablePages and windows
Global settings :
Form interfaceVariable name Type assignment Reference type
ITAB1 TYPE Table Structure
Global definitionsVariable 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 : IDWTCERTSTYLEF
For Quantity or Amout you can used this variable &GS_ITAB-AMOUNT(12.2)&
5. Calling SMARTFORMS from your ABAP program
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 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.
f) Unlike sapscripts (RSTXSCRP), you cannot upload/download 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 download smartforms into Local PC in a XML format. In the same way you can upload this XML format into Smartform. From the smartform editor itself you can call download option, if you are working in CRM 3.0 environment.
In R3 also, you can download into XML format. However, it's not sure about uploading. 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 -> Download form). It will create a XML file and save it in the hard disk.
For others, if you want to download/upload 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.
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.
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.
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 user 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 user_exception macro (syntax: user_exception ).
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
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 joins 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 passed 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
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.
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 Administrator 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 download smartform in PDF format.
Please do the following:
1. Print the smartform to the spool.
2. Note the spool number.
3. Download 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 "Terms 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 terms & 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 "Terms & Conditions" information.
Anyone have a clue how to force this out?
Easy - page FRONT lists page CONTACTS as next page and CONTACTS lists FRONT as next page. Since CONTACTS does not contain a MAIN window, it will print the contacts 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 CONTACTS 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.
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 support and which SAP support 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 pass 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 supported 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 support 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 support the printing of barcodes.
- Secondly, you can buy software that you can upload 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 support 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 user 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.
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 user 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 passes 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 support 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 passes form content from R/3 to an external product without passing any layout information about the Smart Form.
Advantages of SAP Smart Forms:
SAP Smart Forms have the following advantages:
1. The adaption of forms is supported 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 user 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. User-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 supported 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)
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 support 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 tablePages 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
Global settings :
Form interfaceVariable name Type assignment Reference type
ITAB1 TYPE Table Structure
Global definitionsVariable 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 : IDWTCERTSTYLEF
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 pass 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.
* Passing 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 =
* USER_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
USER_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.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.
f) Unlike sapscripts (RSTXSCRP), you cannot upload/download 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 download smartforms into Local PC in a XML format. In the same way you can upload this XML format into Smartform. From the smartform editor itself you can call download option, if you are working in CRM 3.0 environment.
In R3 also, you can download into XML format. However, it's not sure about uploading. 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 -> Download form). It will create a XML file and save it in the hard disk.
For others, if you want to download/upload 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.
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.
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.
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 user 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 user_exception macro (syntax: user_exception ).
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
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 joins 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 passed 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
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.
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 Administrator 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 download smartform in PDF format.
Please do the following:
1. Print the smartform to the spool.
2. Note the spool number.
3. Download 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 "Terms 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 terms & 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 "Terms & Conditions" information.
Anyone have a clue how to force this out?
Easy - page FRONT lists page CONTACTS as next page and CONTACTS lists FRONT as next page. Since CONTACTS does not contain a MAIN window, it will print the contacts 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 CONTACTS 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.
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 support and which SAP support 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 pass 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 supported 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 support 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 support the printing of barcodes.
- Secondly, you can buy software that you can upload 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 support 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 user 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.
ABAP
SMART FORMS
Presentation on IDOC , ALE , EDI
Download a nice presentaion from this link given below.
http://www.slideshare.net/shesagiri/ale-idoc-edi/
This is a very nice presentation available on net.
Phases of a SAP Project (ASAP)
Phase I: Project Preparation
- Decision makers define clearly Project objectives and an effective decision making process.
- Define Project organization and Roles.
- Implementation scope is finalized
- System Landscape and technical requirements are finalized
- Infrastructure (Hardware/Interfaces)
- High level Strategies for client
- Archiving strategy
- Issues of Data bases
- Other issues like
- Unanticipated tasks
- Normal tasks that can not be completed
- External factors that need to be dealt with
- Scope of R/3 implementation is defined.
- Business blue print is created.o Tools used for this is ASAP Implementation assistant
- Question and Answer Data
- Base (Q&A dB) Business Process Master List (BPML)
- R/3 Structure
- Modules Business Navigator and External Modeling tools?
- Project Management (Activities like…)
- Conducting Status Meeting for Project Meeting
- Conducting Steering committee meetings
- Addresses the issues like Organizational Change Management
- Other Activities Like
- Project Team Training
- Developing the system environmento Defining Org Structure
- Define Business Process
Phase III: Realization Phase
- Configuring the R/3 System
- Defining the Authorizations in R/3
- Defining the work flow
- Creating Use Documentation
- System manager procedures
- Developing the System Test plans
- Define the Service level Commitment
- Establishing the System Administration function
- Setting up the Quality Assurance environment
Phase IV: Testing and Final Preparation
- Testing, user Training, System management and Cutover activities
- Test Plan has the activities of:
- Testing the conversion procedures and programs
- Total Interface programso Volume and Stress testing
- Final User acceptance testingo Developing a Final Go-Live strategy
- Redirection to Go-Live? Preparation of End-user documentation
- Training for the End Users
- Technical environment installation on Production system and testing
- Transfer of Legacy data and preparation plan for Go-Live
Phase V: GO-Live Phase
- Production support facilities are carried out
- Validations of Business process and their configuration
- Follow up training for End Users
- Sign–Off.
~~~~~
11 ways to be a happy employee
Can you recollect a day where you woke up at 5:00 am, got ready quickly and waited to do something exciting? Was it your college annual day function? Or a competitive exam? Or maybe a first date? Maybe it was your wedding day. Is it Monday morning to work? If the answer is the last, surely you are a happy employee.
Though the above occasions may not have a lot in common, excitement and motivation can be attributed to almost all of them. However, at the workplace, it is almost impossible to find both or any one of these attributes daily. But, being happy or unhappy is always in our hands. That's the choice we make and we are the creators of the outcome by our actions. Let's look at what might make an employee unhappy.
. Unfair rewards and recognition
. Office politics
. Un-cooperative team
. Unreasonable boss
. Insufficient compensation
. Constant threat to job security
. Lack of responsibility in the current job
. No clear career path
. Seating location
. Lack of basic facilities at workplace
And the list goes on and on. Some of these things may not really propel an employee to quit, but it might lead to negative energy which leads to low productivity. When an employee is under-productive he or she will be the first target when companies look for opportunities to give pink slips.
As mentioned earlier, being happy is always in your hands. A happy employee is more productive and gives more than an unhappy employee. So let's look at some ways to up the happiness factor.
1. Plan your week on Sunday night
Look at your work calendar and plan your week on Sunday night or Monday morning. This would include important meetings, deliverables, a brief summary of things that are pending from last week and any tasks to be achieved during the week. Though this might look like a time management tip, at the end of the week, on Friday night when you re-visit what you have achieved over the last five days, the satisfaction is immense.
2. Undertake activities that you are passionate about even though it might not be in your job profile
Start an initiative that you would love to do irrespective of whether it is required for you to do or not.
. Send a daily newsletter to your team on the topics that most of them will be interested.
. Do a presentation on the topic that you are passionate about.
. Organise a small sports event for your team.
. Call everyone in your team for a team coffee, breakfast or lunch break
. Appreciate colleagues in your team or in a cross-functional team who did a great job
. Write a poem on your team's achievements
. Arrange a potluck lunch
3. Do not indulge in the blame game
If something goes wrong do not blame others blindly. If you commit a mistake, do not hesitate to accept it. As Gauthama Buddha said, there are three things we can't hide for long: the sun, earth and the truth. Accepting your mistake gracefully will only make you look like a true professional and also give you the satisfaction of not cheating.
4. Communicate more often in person
Utilise all the opportunities where you can speak to an individual in person rather than e-mail or phone. But be aware of the other person's time and availability. Listening to a positive answer from a person will give you more happiness than if it is done over the phone or via e-mail.
5. Know what is happening at your workplace
Will this make a person happy? Truly, yes! Imagine a cricket team that doesn't know how many runs to score to win a match? More than losing the game, the player will never be interested or motivated to play well.
Attend all meetings that are addressed by the CEO to your immediate manager to know what is going to happen around you. It could be the company's growth plan or your department's next big project. Jack Welch mentions in his book Winning "every employee, not just the senior people, should know how a company is doing."
You will also get an extra edge if you are in a position to answer queries raised by your peers or juniors. This is not just for the good reasons, but bad reasons as well. You do not want to be the last employee to know if your company is laying off employees (in the worst case, if you are the one who is on that list).
6. Participate in organisation-level activities
This could be as simple as spending one weekend for a corporate social responsibility activity or attending a recruitment drive to help your HR team or arranging a technical/sports event at the organisational level. Most of these events will be successful as people do come on their own to contribute.
7. Have a hobby that keeps you busy and happy
Many people say their hobby is watching TV or listening to music or reading the newspaper. These aren't hobbies, they are just ways of passing the time. Some hobbies are evergreen and will keep you evergreen as well: dancing, painting, writing short stories, poems, blogs and sharing your experiences.
8. Take up a spor
While choosing a sport make sure that there is physical activity. There is the danger of becoming addicted to sports where there is less physical activity (like computer games, chess, cards etc). Physical activity keeps a person healthy and happy. If you pick up one sport well, you can represent your organisation in corporate sports event too.
9. Keep yourself away from office politics
Politics, as a practice, whatever its profession, has always been the systematic organization of hatreds. -- Henry Brooks Adams
Politics is everywhere and the office is no exception. Playing politics might be beneficial but only for the short term. So the best thing to do is play fair.
10. Wish and smile
More often than not, there are fair chances that the other person will smile back. This could be your security guard at the gate, your receptionist, your office boy, your CEO or your manager -- never forget to wish them and smile.
11. Volunteer for some activity
"The value of a man resides in what he gives and not in what he is capable of receiving." - Albert Einstein
Do at least one activity without expecting anything in return. There is no set frequency for this. This could be once in a day or once in a week or thrice in a week. It could be as simple as making tea at the office for your colleague, helping a colleague who is working in another department by using your skills, dropping your colleague at his door step in your car, going to your manager or colleague to ask if there is any help you can extend, contributing to technical or knowledge management communities in your organisation etc.
~~~~~
11/2/08
Swami Vivekananda quotes
“Take up one idea. Make that one idea your life - think of it, dream of it, live on that idea. Let the brain, muscles, nerves, every part of your body, be full of that idea, and just leave every other idea alone. This is the way to success, that is way great spiritual giants are produced.”
-------
“We are responsible for what we are, and whatever we wish ourselves to be, we have the power to make ourselves. If what we are now has been the result of our own past actions, it certainly follows that whatever we wish to be in future can be produced by our present actions; so we have to know how to act.”
-------
"All differences in this world are of degree, and not of kind, because oneness is the secret of everything."
-------
"All the powers in the universe are already ours. It is we who have put our hands before our eyes and cry that it is dark. "
-------
"As different streams having different sources all mingle their waters in the sea, so different tendencies, various though they appear, crooked or straight, all lead to God. "
-------
"Condemn none: if you can stretch out a helping hand, do so. If you cannot, fold your hands, bless your brothers, and let them go their own way. "
-------
"External nature is only internal nature writ large."
-------
"GOD is to be worshipped as the one beloved, dearer than everything in this and next life.
If faith in ourselves had been more extensively taught and practiced, I am sure a very large portion of the evils and miseries that we have would have vanished."
-------
If money help a man to do good to others, it is of some value; but if not, it is simply a mass of evil, and the sooner it is got rid of, the better. "
-------
"In one word, this ideal is that you are divine. "
-------
"Never think there is anything impossible for the soul. It is the greatest heresy to think so. If there is sin, this is the only sin; to say that you are weak, or others are weak."
-------
"Our duty is to encourage every one in his struggle to live up to his own highest idea, and strive at the same time to make the ideal as near as possible to the Truth."
-------
"Take up one idea. Make that one idea your life - think of it, dream of it, live on idea. Let the brain, muscles, nerves, every part of your body, be full of that idea, and just leave every other idea alone. This is the way to success."
-------
"That man has reached immortality who is disturbed by nothing material."
-------
"The moment I have realized God sitting in the temple of every human body, the moment I stand in reverence before every human being and see God in him - that moment I am free from bondage, everything that binds vanishes, and I am free."
-------
"The more we come out and do good to others, the more our hearts will be purified, and God will be in them."
-------
"The Vedanta recognizes no sin it only recognizes error. And the greatest error, says the Vedanta is to say that you are weak, that you are a sinner, a miserable creature, and that you have no power and you cannot do this and that. "
-------
"The will is not free - it is a phenomenon bound by cause and effect - but there is something behind the will which is free. "
-------
"The world is the great gymnasium where we come to make ourselves strong. "
-------
"Truth can be stated in a thousand different ways, yet each one can be true. "
-------
"We are what our thoughts have made us; so take care about what you think. Words are secondary. Thoughts live; they travel far. "
-------
"When an idea exclusively occupies the mind, it is transformed into an actual physical or mental state."
-------
"Where can we go to find God if we cannot see Him in our own hearts and in every living being.
You cannot believe in God until you believe in yourself. "
-------
"You have to grow from the inside out. None can teach you, none can make you spiritual. There is no other teacher but your own soul."
-------
10/22/08
Process Chain Creation using SAP BW 3.5
Process chains are used extensively in SAP Business Warehousing for executing loads, running reports etc. sequentially or parallel.
There can be number of steps with in a process chain. You can also decide what has to be done incase a particular step fails. In case of failure you can decide to sent notification email to concern person who can correct the issue.
In this section we will see how to create a process chain using SAP BW 3.5. Using this process chain we will load data in Infocube.
1) Execute transaction RSPC
2) Press 'Create', enter 'Name' and 'Description' of the process chain, press 'Continue'
3) First step in the process chain will be a 'Start' step, press 'Create' to create a process variants
4) Enter 'Name' and 'Description' of the process variant
5) 'Save' process variant and go back, 'Change selections' is used to schedule the process chain, we will revisit this again later
6) Press 'Continue'
7) Select the InfoPackage which is used to load data in Infocube, drag InfoPackage to right panel
8) Select the process variants as InfoPackage using fucntion key F4
9) Select the InfoPackage ZAAA and press 'Continue'
10) Following steps will be added in the process chain
11) Join 'Start' step with step 'Indexes' by selecting 'Start' step and
8) Select the process variants as InfoPackage using fucntion key F4
9) Select the InfoPackage ZAAA and press 'Continue'
10) Following steps will be added in the process chain
11) Join 'Start' step with step 'Indexes' by selecting 'Start' step and dragging the line to 'Indexes'
12) Go back to 'Start' step and right click to 'Maintain Variant'
13) Select 'Immediate' to schedule the process chain immediately
14) 'Check' the process chain and 'Activate' the process chain
15) Execute the process chain, enter the server name in the following screen
16) Process chain will start executing, to check the status, Press
17) Select 'Yesterday and Today' to check the status of the process chain
18) Following screen shows that load is still not completed
19) Once completed, the status will appear as follows,
12) Go back to 'Start' step and right click to 'Maintain Variant'
13) Select 'Immediate' to schedule the process chain immediately
14) 'Check' the process chain and 'Activate' the process chain
15) Execute the process chain, enter the server name in the following screen
16) Process chain will start executing, to check the status, Press
17) Select 'Yesterday and Today' to check the status of the process chain
18) Following screen shows that load is still not completed
19) Once completed, the status will appear as follows,
incase there is any failure, the status will appear as cancelled
Open Hub Service using SAP BI 7.0
Open Hub Destination functionality is used to distribute data from SAP BI to other non-SAP data systems. In earlier version, it was part of InfoSpoke but in SAP BI 7.0 this can be used independently.
In this section, we will see, how data is extracted from SAP BI InfoCube to a .csv file on a desktop.
1) Execute transaction RSA1, Press 'Open Hub Destination'
4) Go to 'Destination' tab, enter Destination Type as 'File type'. In this example, we will be exporting data in a .csv file, select Directory to 'Desktop'
5) Go to 'Fields Def.' tab, select the InfoObjects you would like to have in your exported file
6) Activate the Open Hub Destination by pressing 'Activate' button
7) Select the Open Hub Destination and right click to 'Create Transformation'
8) Enter source of transformation as InfoCube
9) Accept the proposed mapping and activate
10) Create Data Transfer Process for transfering data from InfoCube to Desktop as .csv file
11) Enter source of DTP as InfoCube
12) Activate DTP and Execute, Data will be exported to .csv file which will be stored at desktop
13) Press 'Yes' to check the status of request monitor
14) Data is exported as the monitor status is green
15) Check the exported file at desktop
In this section, we will see, how data is extracted from SAP BI InfoCube to a .csv file on a desktop.
1) Execute transaction RSA1, Press 'Open Hub Destination'
2) Select InfoArea and right click to 'Create Open Hub Destination
3) Enter Name and Description
4) Go to 'Destination' tab, enter Destination Type as 'File type'. In this example, we will be exporting data in a .csv file, select Directory to 'Desktop'
5) Go to 'Fields Def.' tab, select the InfoObjects you would like to have in your exported file
6) Activate the Open Hub Destination by pressing 'Activate' button
7) Select the Open Hub Destination and right click to 'Create Transformation'
8) Enter source of transformation as InfoCube
9) Accept the proposed mapping and activate
10) Create Data Transfer Process for transfering data from InfoCube to Desktop as .csv file
11) Enter source of DTP as InfoCube
12) Activate DTP and Execute, Data will be exported to .csv file which will be stored at desktop
13) Press 'Yes' to check the status of request monitor
14) Data is exported as the monitor status is green
15) Check the exported file at desktop
Open Hub Service using SAP BW 3.5
Open Hub Service functionality in SAP BW is mainly used with InfoSpoke.
InfoSpoke is an object for exporting data. InfoSpoke is defined using a data source (from which data is extracted), extraction mode and destination (where data will be stored).In this section, we will see, how data is extracted from SAP BW InfoCube to a .csv file on a desktop.
1) Execute transaction RSA1, 'Tools' -> Open Hub Service -> Edit InfoSpoke
2) Enter name of InfoSpoke and press 'Create'
3) Enter short description and select the Data Source as 'InfoCube'
4) Select Extraction Mode as 'Full'
5) Go to 'Destination' tab, enter short description. In this example, we will be exporting data in a .csv file, select the 'File' and chose 'Directory'
6) Go to 'InfoObjects' tab, select the InfoObjects you would like to have in your exported file
7) Go to 'Selection' tab, enter if you want a particular selection criteria, in this example there is no selection used.
8) Activate the InfoSpoke by pressing 'Activate' button
9) After activation, source structure will appear as follows
10) Go back and display the InfoSpoke, press 'Dialog' button
11) Data will be exported to .csv file which will be stored at desktop
12) Go to InfoSpoke Monitor to check status of export
13) Data is exported as the monitor status is green
14) Check the exported file at desktop
InfoSpoke is an object for exporting data. InfoSpoke is defined using a data source (from which data is extracted), extraction mode and destination (where data will be stored).In this section, we will see, how data is extracted from SAP BW InfoCube to a .csv file on a desktop.
1) Execute transaction RSA1, 'Tools' -> Open Hub Service -> Edit InfoSpoke
2) Enter name of InfoSpoke and press 'Create'
3) Enter short description and select the Data Source as 'InfoCube'
4) Select Extraction Mode as 'Full'
5) Go to 'Destination' tab, enter short description. In this example, we will be exporting data in a .csv file, select the 'File' and chose 'Directory'
6) Go to 'InfoObjects' tab, select the InfoObjects you would like to have in your exported file
7) Go to 'Selection' tab, enter if you want a particular selection criteria, in this example there is no selection used.
8) Activate the InfoSpoke by pressing 'Activate' button
9) After activation, source structure will appear as follows
10) Go back and display the InfoSpoke, press 'Dialog' button
11) Data will be exported to .csv file which will be stored at desktop
12) Go to InfoSpoke Monitor to check status of export
13) Data is exported as the monitor status is green
14) Check the exported file at desktop 
Open Hub Service using SAP BW 3.5 & BI 7.0
Open Hub Service functionality in SAP BW 3.5 is mainly used with InfoSpoke.
InfoSpoke is an object for exporting data. InfoSpoke is defined using a data source (from which data is extracted), extraction mode and destination (where data will be stored).
Open Hub Service functionality is used to distribute data from SAP BI to other non-SAP data systems. In earlier version, it was part of InfoSpoke but in SAP BI 7.0 this can be used independently.
As there is a significance difference between SAP BW 3.5 and SAP BI 7.0, we are providing here steps of Open Hub Service creation process for both the versions.
Open Hub Service using SAP BW 3.5
Open Hub Service using SAP BI 7.0
InfoSpoke is an object for exporting data. InfoSpoke is defined using a data source (from which data is extracted), extraction mode and destination (where data will be stored).
Open Hub Service functionality is used to distribute data from SAP BI to other non-SAP data systems. In earlier version, it was part of InfoSpoke but in SAP BI 7.0 this can be used independently.
As there is a significance difference between SAP BW 3.5 and SAP BI 7.0, we are providing here steps of Open Hub Service creation process for both the versions.
Open Hub Service using SAP BW 3.5
Open Hub Service using SAP BI 7.0
10/20/08
Infocube Creation Step 4 using SAP BI 7.0
In this section, we will see how to define Data Transfer Process and load data in InfoCube using SAP BI 7.0. Data Transfer Process makes the transfer processes in the data warehousing layer more transparent.28) Now define, Data Transfer Process as shown
29) Enter the source of DTP
30) Activate the DTP after maintaing the required settings
31) Create a InfoPackage by right clicking the DataSource
32) Execute the InfoPackage to load data into PSA
33) Check the data load in PSA by double clicking the DataSource
34) Execute the DTP
35) Check the data in InfoCube
29) Enter the source of DTP
30) Activate the DTP after maintaing the required settings
31) Create a InfoPackage by right clicking the DataSource
32) Execute the InfoPackage to load data into PSA
33) Check the data load in PSA by double clicking the DataSource
34) Execute the DTP
35) Check the data in InfoCube
Subscribe to:
Posts (Atom)
