answer this q's plz

[Former Member]

Hi i have soe intervw q's..plz answer..marks wud be given for the right answers..not for the links..no links.plz...

1...i have 2 int table..int1 and int2..int1 has 1000 records..and fields r A B C

int2 has 0 records..and has fields B & C..

now i have to move 1000 record from int1 to int2..move corresponding fields stmnt is nt the right answer..wen it comes to performance..plz can anybody suggest me the right answer.

2. I hv 2 fields in my flat file..ex.

1 abhishek

2 anand

3 savitha..

after i upload this to database using bdc..i want the data in the form of

0001 ABHISHEK

0002 ANAND

0003 SAVITHA..all incaps...

hw can i do this?

3...hw to find the idoc form the data..ex.if i enter mat nr..i should get idoc list for that particluar no..hw is dat..not by we02 or we05..i need the right answer?

4.can we use open dataset for presentation server as it is used only for application s/v....if nt y?

5.i created an idoc..changed it and after an hour i deleted it..so will dat idoc still exist?

6.wats the diff b/w rstxldmc and directly inserting logo using insert command..any diff.

7...hw can i have 2 diff blocks in a single report using ALv?

plz guys no lonks...

waiting for ur reply and to give points.

regards

Toufeeqh

[Former Member]

hi

1...i have 2 int table..int1 and int2..int1 has 1000 records..and fields r A B C

int2 has 0 records..and has fields B & C..

now i have to move 1000 record from int1 to int2..move corresponding fields stmnt is nt the right answer..wen it comes to performance..plz can anybody suggest me the right answer.

loop at itab1.

itab2-b = itab1-b.

itab2-c = itab1-c.

append itab2.

clear itab2.

endloop.

2. I hv 2 fields in my flat file..ex.

1 abhishek

2 anand

3 savitha..

after i upload this to database using bdc..i want the data in the form of

0001 ABHISHEK

0002 ANAND

0003 SAVITHA..all incaps...

hw can i do this?

if you have the field in database table as NUMC type and LENGTH 4 then it will be automatically taken care.

3...hw to find the idoc form the data..ex.if i enter mat nr..i should get idoc list for that particluar no..hw is dat..not by we02 or we05..i need the right answer?

Find the related message type and IDOC type for materials from EDMSG and EDBAS tables and from the EDID4 table enter these message and idoc types.

or see the related segment of that Idoc in which the material number is there and accordingly find those idocs

4.can we use open dataset for presentation server as it is used only for application s/v....if nt y?

No they are used only for Application Server processing only not for presentation server ..

5.i created an idoc..changed it and after an hour i deleted it..so will dat idoc still exist?

I am not sure, but I hope that IDOC number still exit but with a deletion indicator marked.

6.wats the diff b/w rstxldmc and directly inserting logo using insert command..any diff.

You can't insert the logo using the INSERT command

have to use the program RSTXLDMC to convert the logo to tiff fiel and then it is included in script with INCLUDE ststament.

7...hw can i have 2 diff blocks in a single report using ALv?

You can design a ALV Block list to have to diff blocks in the ALV output.

<b>Reward points for useful Answers</b>

Regards

Anji

[Former Member]

Hi Anji,

Thnx for ur reply..bt ur answers were not too clear..i mean..

1.i said the same answer..but he said there is a stndard stmt for this.query..so do u know dat..

2. BDC..

hw can we change the case of a character..from lower to uppercase...

3. do u know the t.code for idoc filtering..

can u be more specific..plz marks wud def be given..