imp faqs

[Former Member]

1 can somebody plz give me a code of call transaction method used in bdc where we can capture the errors . plz specify how to collect & see the errors and how to delete them .

2 if i want to add new font in the SMARTSTYLE which is not

existing.what is the procedure

3 could u pls explain what is the exact diff betwn select single * and select up to 1 rows.

4 what event is trigger before initialisation.

5 how many primary keys at the max can we define in a table .

[Former Member · Accepted solution]

The event load-of-program is executed before initialization.

Rob

[Former Member · Accepted solution]

Rob,

Forgot about that. Nice catch.

[Former Member · Accepted solution]

Well I think it's almost never used (except for maybe interviews or exams).

Rob

[Former Member]

Hi,

If your question has been answered, please close the thread and reward points if found helpful.

Regards,

Tanveer.

[Former Member]

hi Rohit

u can check these below links

http://www.sap-img.com/abap/abap-interview-question.htm

http://www.sap-img.com/abap/answers-to-some-abap-interview-questions.htm

http://sap.ittoolbox.com/documents/document.asp?i=3240

http://www.techinterviews.com/?p=198

http://www.fundoosite.com/interview-questions/type.asp?iType=72

http://www.sapassist.com/documents/document.asp?i=3240

http://www.ittestpapers.com/interviewquestions/abap1.htm

http://projectmanagement.ittoolbox.com/groups/groups.asp?v=sap-career&m=8&y=2004

http://www.exforsys.com/index.php?option=content&task=view&id=189

http://www.techinterviews.com/?p=184

2.go with smartstyles tcode then define one style name go with create then define the properties as per ur requirement

3.When you say SELECT SINGLE, it means that you are expecting only one row to be present in the database for the condition you're going to specify in the WHERE clause. so that means, you will have to specify the primary key in your WHERE clause. Otherwise you get a warning.

SELECT UP TO 1 ROWS is used in cases where you just want to make sure that there is at least one entry in the database table which satisfies your WHERE clause. Generally, it is meant to be used for existence-check. You may not want to really use the values returned by the SELECT statement in this case (thought this may not necessarily be so).

4.load of program

5. only one

if u find helpful plz award some points

Regards

naveen

[Former Member]

4 what event is trigger before initialisation

I know of no event that ABAP developers have access to in a standard report prior to initialization.

[Former Member]

Hi Rohit,

5.I guess you can primary keys equal to the number of fields in your table.

4. "Initialisation" is the first event trigerred in a report.

3. "select * "will select all the rows in the table matching the given condition.

The 'SELECT .... UP TO 1 ROWS' statement is subtly different. The database selects all of the relevant records that are defined by the WHERE clause, applies any aggregate, ordering or grouping functions to them and then returns the first record of the result set.

Regards,

Tanveer.

Please reward points if found helpful.

[Former Member]

Hi Rohit,

To capture the errors from BDC call transaction method, please use the following code:

CALL TRANSACTION c_season_code_create USING T_BDCDATA_ALL

MODE V_MODE

UPDATE C_UPDATE

MESSAGES INTO T_MSGCOLL.

READ TABLE T_MSGCOLL INTO S_MSGCOLL

WITH KEY MSGTYP = 'E'.

IF SY-SUBRC = 0.

write your perform statement here in which way you want.

ENFIF.

I do not know the answered for 2 3 4 &5.

shylesh

[Former Member]

3 could u pls explain what is the exact diff betwn select single * and select up to 1 rows.

Other than the syntax, there is no difference.

5 how many primary keys at the max can we define in a table .

A database table can only have 1 primary key. It can have numerous indexes, foreign keys, etc. That is dependent on your database system. Ask your DBAs for more infoprmation there.