Showing posts from March, 2008

Step by step Create SAP LIS Report

T.code - :MC18 – create field catalog
1. Characteristic Catalog
Application-01-Sales and Distribution, 02-Purchasing, 03-Inventory Controlling, etc..
Catalog category 1. Characteristic catalog, 2. Key figures catalog 3. Date catalog Select characteristic catalog and enter, click on characteristic select the source table and it will be display the relevant source field and select the source field, copy + close, copy.
Save, similarly create key figures catalog

T.code : MC21 – create infostructure
Example –
Inforstructure : S789
Application – 01
Choose characteristic select the catalog, select the fields, copy + close Choose key figures catalog select the key figures ,copy + close, save and generate

T.code – MC24 – create updating
Infostructure : S789
Update group : 01- Sales document, delivery, billing document ,enter Select the key figures click on rules for key figures give suggest rules, copy save and generate Click on updating (activate updating) Select the …

Table Controls in ABAP Programs

To handle table controls in ABAP programs, you must declare a control in the declaration part of the program for each table control using the following statement:CONTROLS ctrl TYPE TABLEVIEW USING SCREEN scr.where ctrl is the name of the table control on a screen in the ABAP program. The control allows the ABAP program to read the attributes of the table control and to influence the control. The statement also declares a deep structure of name ctrl. The data type of the structure corresponds to the type CXTAB_CONTROL defined in the type group CXTAB in the ABAP Dictionary. At runtime the components of the structure contain the attributes of the table control. Several of the initial values are determined in the Screen Painter. The initial value for the control ctrl is taken from the screen which is determined using the addition USING.You can start a screen sequence from an ABAP program using REFRESH CONTROL ctrl FROM SCREEN can initialize a table control at any time with the ini…

ALV: How to merge two columns and show as single column

Question: Hi SAP team,
I have a requirement to show AMount and currency in a single column in a ALV output. Eg: '1000.00' and 'USD' in a single column '1000.00 USD'.

How I can achieve this ?

Thanks for your help,

Something like:
LOOP AT itab.
CONCATENATE itab-amount itab-currency INTO itab-combined.
MODIFY itab.
ENDLOOP.You will probably need to embellish just that concat command as all fields will be treated as TYPE C.
Then inhibit the display of the original fields ‘amount’ and ‘currency’ by setting NO_OUT=’X in the fieldcat loop (or other method).
There may be a FM to merge/format amounts and currency but I couldn’t find one on quick search.


The option 'USING EDIT MASK' from WRITE command is also available in ALV structure IT_FIELDCAT.
I have only used it in write and for simple stuff, but it may have some options for you.
Check '==conv' for output conversion routine...


Value Display with Currency/Quantity Unit

UseCertain values of output fields may refer to units (such as kilogram) or currencies (such as Euro). To display these values in the correct unit-specific format (with the correct number of digits after the comma, for example), you must assign these fields to a currency or unit. There are three ways how you can do this in the field catalog:Assign a value field to an associated currency or unit field Explicitly specify a currency or unit for the entire columnFormat the value field manually (see: Formatting Column Contents)Reference to a Currency or Unit FieldYou use fields CFIELDNAME and QFIELDNAME (see below) to assign value fields to a currency or unit field. This ensures that when totals are calculated for this column, these are displayed separately by unit. The field catalog also contains an entry for the unit field. If you do not want to display the unit as a column in the list and do not want to allow users to interactively show it as a column, you can mark the field catalog ent…

Key figure in CO-PA Assessment Cycle

Key figure in CO-PA Assessment Cycle - to be used as receiver tracing factor for variable portion cannot display

Solution :
Just run transaction code KEUG and it resolves the problem.

SAP R/3 Glossary

Information Technology has many key words and SAP R/3 has introduced many others. In order to understand even better this field you should keep in mind those terms.ALE (Application Link Enabling)
It provides integration for separate R/3 systems, keeping full interaction. This makes possible distributed enterprise applications.Application server
The application server is used to run the business application programs in the R/3 client/server concept. The application modules are loaded from the data base server to the application server as required. Thus the application server requires only storage capacity to accommodate UNIX, Swapping and the SAP runtime environment.Batch Input
A technique to input data safely. It ensures application data integrity for background interfaces. It pretends to be someone typing. See also direct input.CATT (Computer Aided Test Tool)
It allows you to combine and automate sequences of repeatable transactions in test procedures. CATT reduces the number of manual t…

SAP R/3 Programming

Indeed these powerful ABAP/4 functions are very interesting and can bring some advantages. Improve your home development easily. They belong to standard objects and should never be changed.Ws_upload
Transfer files from the frontend to the application server.Ws_download
Transfer files from the application server to the frontend.Ws_excel
Download files at the frontend in excel format.Bp_joblog_read
Fetch job log executions.Rs_send_mail_for_spoollist
Send message from ABAP/4 program to SAPoffice.Bp_event_raise
Trigger an event from ABAP/4 program.So_wind_spool_list
Browse printer spool numbers according to user informed.So_spool_read
Fetch printer spool according to the spool number informed.G_set_get_all_values
Fetch values from a set.Rzl_sleep
Hang the current application from 1 to 5 seconds.Rzl_submit
Submit a remote report.Ws_execute
Execute an external program on the presentation server.Ws_file_delete
Delete file at the frontend.Ws_volume_get
Get the label from a frontend device.Ws_msg
Create a di…

SAP R/3 Security

Simple changes can rise your system security. Usage of SAProuter is a good choice when correctly implemented. Login through SAP LogonPad (from version 3.0f onwards) improve the access control. SAP profile parameters shall also contain:Rdisp/gui_auto_logout = 1800
The user connection is closed after 30 minutes without usage.Login/fails_to_session_end = 3
After 3 wrong password the connection is automaticly closed.Login/fails_to_users_lock = 5
After 5 wrong password the user is locked.Login/min_password_lng = 6
Password length at least 6 characters.Login/password_expiration_time = 90
Password expires after 3 months.Note: I do not have to waste my time telling you to change all default passwords.
Make sure to have the master user SAP* in all clients otherwise anyone can log into your system. See Tips & Tricks.

SAP R/3 Troubleshooting

System gets stuck
It happens mostly when archive area is overloaded. Run the program brarchive with deletion option to release disk space.Short dump
Not always the problem is technical. Try to create all SAPoffice users through transaction SO32 (create all SAPoffice users) and review your application data carefully.Field exits are completely ignored
Make sure your SAP profile parameter contains the option abap/fieldexit = yes.Transaction SE16 (table contents) does not work properly
Make usage of the menu option to regenerate the display program. You can also try changing key words according to field names. Choose Option -> Parameters users.Rollback segments are too small
Before increasing up the rollback segment size you should verify your programs. Very often the problem belongs to them.Files for rollback segments are already enormous
Check the rollback segments configuration. It has to match the allocated area on tablespaces. Changes have to be done using Oracle tools.Extended help und…

SAP R/3 Enhancements

Some special features allow you wide modifications without changing standard SAP R/3 objects. Those techniques are not as widespread as they should be. In fact they are powerful tools.Field exit
After entering a value in a field, it can be checked through a field exit. The system makes the field value available to be checked and changed in an ABAP/4 function.User exit
Points previously set in the system that let you evaluate data. The fields available are also previously defined by SAP. All fields value available can be checked in an ABAP/4 program.Validation
It allows solid data entry regarding special rules. According to previous rules, the system can evaluate an entry and a message can appear on the user's terminal if a check statement is not met. A validation step contains prerequisite statement and check statement. Both of them are defined using Boolean Logic or calling an ABAP/4 form.Substitution
Fields contents can be changed using substitution. When data are being entered, the…

SAP R/3 Hints

Of course it does not guarantee a successful implementation. It is a great deal of summed up aid, though.Team integration has to be enhancedSet high standards of performance for implementation teamIT teams and users have to work closely during the implementationNew ways of thinking and acting must not be discardedDo not underestimate the user training needsProject management should be on the critical listThe nearest SAP branch should be your partnerConsultants are not always the key to succeedConsultants are a good source of knowledge. On the other hand, letting them make configuration changes the transfer of knowledge will be harmedForeign consultants usually do not know country-specific detailsDeepening your basis knowledge is always usefulAvoid changing standard R/3 objects as much as possibleAlways follow the SAP rules to give names to your own objectsEstablish SAP connection as soon as possibleExchange information with other companiesFocus on interfaces with non-R/3 applicationsP…

SAP Tips & Trick

mySAP Tips & TricksYou may have noticed that in ECC the services for object button (Generic Object Services - GOS) is missing from the sales order. This can be useful to find related IDOCS but was taken off in 4.7 due to performance reasons. If you set user profile/parameter SD_SWU_ACTIVE to X by going to SYSTEM-USERPRFOLE-OWNDATA the button will be available to you again.SAP R/3 Tips & Tricks Logging on without being authorized
Client 066 usually exists in a SAP system due to EarlyWatch services. Often this client does not have master users. If it is true, anyone can log into the system using the client 066, user SAP*, and password PASS. Enjoy yourself.Special copy and paste
Click on the area and press CTRL+Y. It allows you to copy many lines at once and paste them afterwards.Long messages on footer
Click on the message and hold the mouse button. After moving the mouse to the left side.Direct input logs
The transaction BMV0 (direct input logs) shows all direct input logs.Grap…