topic Insert Records in Application Development and Automation Discussions

Insert Records

Former Member — Wed, 23 Jul 2008 07:34:29 GMT

I added one field to standard internal table using append structure.

How enter data to that fields?

Please tell me.

Thanks.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:35:34 GMT

Hi,

Is it Standard Table or INternal table?

Thanks,

Sriram POnna.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:40:00 GMT

Hi Sriram,

Thanks for your answer.

Here insert records into standard table.

Please tell me.

Thanks.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:40:30 GMT

You don't add fields using APPEND, you update the internal table adding the current line you issued the APPEND command, with the given table structure/fields.

If you want to add a field, one way to do it is through TABLE MAINTENANCE.

Now, if you meant you want to modify data in your internal table, let's say, for a specific field, you have to use the MODIFY command, like the following:

MODIFY [internal_table] INDEX sy-tabix (in case you are in a loop - that is going to modify the current line being looped) FROM [work_area_variable] TRANSPORTING [list of specific fields you want to modify].

If you want to update the given line with all the work area's contents, you can omit the TRANSPORTING clause.

Hope this helps.

Avraham

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:41:16 GMT

you need to write small update program for this.

Amit.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:53:15 GMT

Hi Amit

Thanks for your answer.

SCARR table in am inserted PHONE field using append structure.

After i wrote Program like this.

SCARR-CARRID = 'AA'.

SCARR-PHONE = '2233865'.

INSERT SCARR.

But its not adding the records to standard table.

Please tell me.

Thanks.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 07:57:32 GMT

Use Modify statement.

MODIFY SCARR.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 08:02:38 GMT

If you want to insert the scarr structure values to your table, add

APPEND scarr TO table_name to your program. But only if scarr is your work area and not your table.

Regards

Avraham

Re: Insert Records

vinod_vemuru2 — Wed, 23 Jul 2008 08:13:21 GMT

Hi Sri,

If ur phone number field is same for all records then just one statement will do the trick.

UPDATE scarr SET phone = 'ur phone number'.

If the number is different then u have to follow this logic.

SELECT * INTO TABLE i_scarr FROm scarr.

LOOP AT i_scarr INTO wa_scarr.

Get the phone number based on ur conditions.

wa_scarr-phone = 'Ur phone no.'

MODIFY i_scarr FROM wa_scarr TRANSPORTING phone.

ENDLOOP.

MODIFY scarr FROM TABLE i_scarr.

This will modify the whole table with the respective phone number.

Thanks,

Vinod.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 09:17:51 GMT

Hi Vinod,

Thanks for your answer. My problem solved.

Thanks allot.

Re: Insert Records

Former Member — Wed, 23 Jul 2008 12:47:21 GMT

Use Modify or Update statements.