Question { 4691 }

what is result set of an inner join at database level ?

Answer

if we use inner join it shows the data from parent table
which has data in child table.

Question { 5739 }

How to get the no of records using select statement?

Answer

data: wa_t001 type t001,
t_t001 type table of t001.

select * into table t_t001 from t001.

loop at t_t001 into wa_t001.
write: no.of records sy-tabix.
endloop.

Question { 3720 }

Landscape of your company and what are their names?

Answer

the system set up maintained at client space is known as
landscape.

we use 3 system landscape
1.production where consultatants are involved
2.testing where tester involved
3.production it is connected to enduser

Question { HP, 5467 }

There is a file in application server. How can you upload it
and separate it as per different fields?

Answer

open dataset p_file for input in textmode encoding default.
if sy-subrc = 0.
do.
read dataset p_file into w_rec.
if sy-subrc = 0.
split w_rec at ',' into wa_final-fld1
wa_final-fld2
.
.
.

append wa_final to i_final.
else.
exit.
enddo.