topic Re: Insert a row in table in Application Development and Automation Discussions

Insert a row in table

Former Member — Wed, 26 Jul 2006 14:45:30 GMT

Hi All,

I am very new to ABAP. I have created a new table with fields 1. Client type mandt 2.Emp_Name 3. Emp_id.

I need to create a report to upload a set of values to this table.

My report is like this.

REPORT ZJAITESTREPORT .

DATA : begin of z_jai,

client like zjaitable-client,

Emp_Name like zjaitable-emp_name,

Emp_Id like zjaitable-emp_id,

end of z_jai.

z_jai-client = '501'.

z_jai-Emp_Name = 'Mani'.

z_jai-Emp_Id = '0001'.

insert zjaitable from z_jai.

commit work.

But the code is not working. Can any one tell me where I am going wrong?

Thanks & Regards,

Jai Shankar.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:48:00 GMT

Hello Jai,

REPORT ZJAITESTREPORT .

DATA : begin of z_jai,

client like zjaitable-client,

Emp_Name like zjaitable-emp_name,

Emp_Id like zjaitable-emp_id,

end of z_jai.

z_jai-client = '501'.

z_jai-Emp_Name = 'Mani'.

z_jai-Emp_Id = '0001'.

insert zjaitable from z_jai.

commit work.

If ur code change this part alone

insert zjaitable VAlues z_jai.

If useful reward.

Vasanth

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:49:16 GMT

Hi Jai,

REPORT ZJAITESTREPORT .

DATA : begin of z_jai.

include structure zjaitable .

end of z_jai.

z_jai-Emp_Name = 'Mani'.

z_jai-Emp_Id = '0001'.

insert zjaitable from z_jai.

commit work.

Try this way andsee if it works .

Regards,

Varun .

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:51:45 GMT

Hi,

REPORT ZJAITESTREPORT .

DATA : begin of z_jai,

Emp_Name like zjaitable-emp_name,

Emp_Id like zjaitable-emp_id,

end of z_jai.

z_jai-Emp_Name = 'Mani'.

z_jai-Emp_Id = '0001'.

insert into zjaitable values z_jai.

commit work.

Best regards,

Prashant

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:51:57 GMT

Hi Vasanth,

I tried that. It gives me an error unable to interpret "values".

Regards,

Jai Shankar.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:54:52 GMT

Create an internal table ITAB for the structure z_jai.

Use following statement:

INSERT zjaitable FROM TABLE ITAB.

At the mean time go to SE11 and try adding contents to the table manually (Utilities->Table Contents->Create Entries). If it is working fine then the above should work.

Thanks

Inder

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:55:32 GMT

Hello,

Jai,

Sorry .There is a mistake the my prevous syntax.

write: like this.

INSERT INTO ZTABLE VALUE ZSTRUCTURE

vasanth

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:55:36 GMT

Hi Vasanth,

Sorry. I missed "INTO" in that statement. Now I executed it. Still not successful.

Regards,

Jai Shankar.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:55:36 GMT

Hi,

Declare the Internal table properly.


REPORT zjaitestreport .
DATA : BEGIN OF z_jai <b>OCCURS 0</b>,
       client LIKE zjaitable-client,
       emp_name LIKE zjaitable-emp_name,
       emp_id LIKE zjaitable-emp_id,
       END OF z_jai.


z_jai-client = '501'.
z_jai-emp_name = 'Mani'.
z_jai-emp_id = '0001'.

<b>APPEND z_jai.</b>

INSERT zjaitable <b>FROM TABLE z_jai</b>.
COMMIT WORK.

Read the F1 help for INSERT statement for more Info.

Regards,

AS.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:57:06 GMT

Hellp Jai,

Check the key fields.

Change the employee name and Employee ID and Try.

Vasanth

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 14:58:53 GMT

z_jai-client = '501'.

z_jai-Emp_Name = 'Mani'.

z_jai-Emp_Id = '0001'.

INSERT INTO zjaitable VALUES z_jai.

And remove the COMMIT WORK. SAP's Logic Unit of Work concept will perform a Commit Work at the conclusion of the program. You (usually) do not want to perform one earlier. This allows for restarting an update program with data that has not been partially changed by a previous failed execution.

Don't forget the points.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 15:33:44 GMT

Jai,

Have you completed your task?

If so, please close the thread and reward points accordingly.

If not, plz provide more details of the current error.

Re: Insert a row in table

Former Member — Wed, 26 Jul 2006 15:48:53 GMT

Hi All,

Thanks a lot for ur help.

Regards,

Jai Shankar.