. Error: Status of email is "In transit"

Please refer to the following links. They helped me clear out the errors.

1. https://www.sdn.sap.com/irj/scn/thread?threadID=1369013

2. http://sap.ittoolbox.com/groups/technical-functional/sap-basis/email-status-in-transit-2043554

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content

. How to Configure email in SAP

Use:

If you want to distribute business intelligence content using e-mail, you have to set up the mail server in the SAP Web Application Server.

Procedure:

1. In the BW system, choose the transaction SAPconnect: Administration (system status) (transaction SCOT).

2. Check the status of the node SMTP (Simple Mail Transfer Protocol):

3. The node SMTP does not exist:

4. To create the node, in the menu, choose Node ® Create. Specify a node ID and a description.

5. The node SMTP is not active:

6. To activate the node, in the menu, choose Node ® Change. Select the field Node in Operation.

7. In the menu, choose Node ® Change. The screen SAPconnect: General Node Data opens. Ensure that the following values are defined:

8. Mail Host: for example, mailto.wdf.sap.corp (localhost is generally not a valid mail host because both a mail server and SAP Application Server are generally not installed on a PC at the same time)

a. Mail Port: Standard value for SMTP is 25

b. Code page: Standard values are 1100 or 1140

c. Supported address types

9. Select the Internet field and choose Setup. The screen SAPconnect: Address Type for Node opens. Enter * in the address area.

10. To maintain the standard domain, in the menu, choose Settings ® Default Domain and enter the appropriate value (for example, sap.com for e-mail addresses, such as @sap.com).

See also:

SAPconnect (BC-SRV-COM)

Monitoring the Sending of E-mails

Error: Status of the messages is showing as "In transit"

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content

-104: DBM command impossible at this time

Reason for error:

You have attempted to execute a database management statement. You cannot execute this statement if another database statement is already running.

Solution:

Execute the statement later.


# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.

. Configuring the Sender RFC Adapter / How to Register Server Program ID

So here we go, basically we have to configure 2 things:

a) RFC destination
b) RFC channel in the XI directory

RFC destination:
1. To create the RFC go to TCODE: SM59
2. Create new destination of type T (TCP/IP)
3. Select Registered Server Program option before writing your program ID
4. Write you program ID (remember it's case-sensitive)
5. In the gateway host and gateway service write the values of your "Application system" - business system (not the XI server)


6. No configuration in the J2EE administrator nessecary

Now we can proceed to RFC channel configuration:
1. Enter your Application Server
2. Your Application Server Service
3. Enter your Program ID from the RFC destination



Now you can test the RFC destination in SM59 to see if it works.

Also check notes : 353597 & 63930
Further Reading:
1. RFC Processing with the RFC Adapter - help.sap.com
2. Configuring the Sender RFC Adapter - help.sap.com

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.

. How to Raise an Event from Unix / How to trigger an Event in SAP

An SAP event is a "flag" that is created in SAP (SM62). This event (or flag) can be triggered (from a Unix job to an incoming file), causing a job to execute in the background. This event (or flag) can be triggered within R/3 or can be done at the Unix level.

* First, create an event in SM62. It’s easy - just create it under "user event names" and "maintain". You’ll find the create option from there.

* Once created go to SM36 and create the job. Put in the job name you want to call it - fill in the ABAP/4 program you’ll want executed, but under "START DATE" select option AFTER EVENT. Then plug in your SAP event name you created. Fill in the remaining information on this screen and save.

* Once saved, an entry is put in table BTCEVTJOB. The entry is the name of the event you raised. This is the system’s way of keeping track of which jobs are in the queue waiting for an event to occur.

* Now, once the event is triggered this newly created job will execute. The event can be triggered via sap (SM64) or at the Unix level.


SM64 is pretty self-explanatory. To get the event triggered from Unix:

* Log into the adm user id at the Unix level and go to directory /usr/sap/SYS/exe/run (there is an alias called 'cdexe' that will get you there)

* From there look for an executable called sapevt. Open another Unix window cause now you are going to need to cut and paste.

* At the other sap window switch user to the adm user and go to the /usr/sap/SYS/profile directory ('cdpro' is the alias)

* Do an "ll | more" and look for the instance profile name (the sapevt executable will want this!) Example: _DVEBMGS00_

* Go back to the sapevt window and enter this command to get the event to raise:
sapevt -t pf= nr=

* Example: sapevt roberts_test -t pf=/usr/sap/SYS/profile/
_DVEBMGS00_ nr=00

* This will raise the event, and cause the job scheduled within SAP to execute.

* Once the job has executed the SAP event that was in the table BTCEVTJOB will disappear.

*Another table, TABTCO, will now have an entry in it with the SAP job that was executed. Once you’ve found that job name in this table you can double click on its entry and see that it was executed via an event.

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.

. What is an Index / Creating an Index in SAP

You can search a table for data records that satisfy certain search criteria faster using an index.

An index can be considered a copy of a database table that has been reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example using a binary search. The index also contains a pointer to the corresponding record of the actual table so that the fields not contained in the index can also be read.

The primary index is distinguished from the secondary indexes of a table. The primary index contains the key fields of the table and a pointer to the non-key fields of the table. The primary index is created automatically when the table is created in the database.

Table SCOUNTER in the flight model contains the assignment of the carrier counters to airports. The primary index on this table therefore consists of the key fields of the table and a pointer to the original data records.

You can also create further indexes on a table in the ABAP Dictionary. These are called secondary indexes. This is necessary if the table is frequently accessed in a way that does not take advantage of the sorting of the primary index for the access. Different indexes on the same table are distinguished with a three-place index identifier.

All the counters of carriers at a certain airport are often searched for flight bookings. The airport ID is used to search for counters for such an access. Sorting the primary index is of no use in speeding up this access. Since table SCOUNTER has a large number of entries, a secondary index on the field AIRPORT (ID of the airport) must be created to support access using the airport ID.

The optimizer of the database system decides whether an index should be used for a concrete table access (see How to Check if an Index is Used?). This means that an index might only result in a gain in performance for certain database systems. You can therefore define the database systems on which an index should be created when you define the index in the ABAP Dictionary (see Creating Secondary Indexes.)

All the indexes existing in the ABAP Dictionary for a table are normally created in the database when the table is created if this was not excluded in the index definition for this database system.

If the index fields have key function, that is if they already uniquely identify each record of the table, an index can be defined as a unique index.

See also: What to Keep in Mind when Creating Secondary Indexes

Other Reference Links:

http://www.sap-img.com/business/what-is-meant-by-primary-index-and-secondary-index.htm

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/how-to-create-index-in-abap-dictionary-in-sap-1089196

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.

. SAP events transaction code

All the SAP events are mentioned in the transaction Code SM64.

# Please spare some time to put a comment, if this post was relevant for you or not. It helps me post better content.