How to copy all fields of a row in a table to a temp-table?

[abhishek.shah]

HI,
How do we copy all the data in each of the field of one particular row in a temp table.
for eg.

DEFINE TEMP-TABLE LIKE project_master.
FIND FIRST WHERE project_id = "123"

Now I want all the information in all the fields of the record in project_master whose project_id = "123" into my TEMP-TABLE.
Thanks in advance.

 

[mjshinde]

DEFINE TEMP-TABLE tt_pj1_mstr LIKE pj1_mstr.

FOR EACH pj1_mstr WHERE pj1_code="20000001" NO-LOCK:
BUFFER-COPY pj1_mstr TO tt_pj1_mstr.
END.

FOR EACH tt_pj1_mstr NO-LOCK :
DISPLAY tt_pj1_mstr.pj1_code tt_pj1_mstr.pj1_desc .
END.