topic Re: appending table - in Application Development and Automation Discussions

appending table -

Former Member — Tue, 07 Oct 2008 08:48:24 GMT

FORM sub_get_kna1_1 .

IF t_vbak IS NOT INITIAL.

SELECT kunnr "Ship to party

name1 " Customer name

ort01 "City

pstlz "Postal Code

regio "Region

FROM kna1

APPENDING TABLE t_kna1

FOR ALL ENTRIES IN t_vbak

WHERE kunnr = t_vbak-kunnr.

ENDIF.

1) in the above code what do the key words appending table stand for ? t_kna1 is an internal table which already has some data.

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:50:47 GMT

Well..

In this statement the new entries fetched through this SELECT statement will be appended to the t_kna1 table in addition to existing entries.

If the 'appending table ' is not given the previous entries will be deleted and the new entries alone will be there in t_kna1.

Note - The structure should be same to avoid dumping

Cheers,

Kothand

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:51:06 GMT

well the selected information is beeing appended to table t_kna1 as a new record.

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:51:32 GMT

few more records are appended to table T_KNA1 when the conditions in the select query are satisfied.

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:51:41 GMT

I think the appending statement means, it will append to exisitng t_kna1 data, it will not over write

Regards

Madhan

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:52:45 GMT

your question itself has the answer..!

t_kna1 is table which already has data and they are appending the additional data with this select query.

means: t_kna1 will have previous data + current select query data.

use F1 option in APPENDING TABLE. u'l get better understanding.

regards,

padma.

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:53:18 GMT

hi sushanth singh

appending keywords used to insert a new records along with the already existing records..

whereas into table keyword is overwrite the existing records

Regards

Selva

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:53:44 GMT

Hi Sushanth,

Appending means that the entries will be appended to the existing entries in the itab t_kna1.

regards,

Advait

Re: appending table -

Former Member — Tue, 07 Oct 2008 08:54:46 GMT

Good

Appending table statement use to append the data in the after the last line of the internal table, if the internal table having 5 lines of data than it will start appending the new records from the 6th line.

Check the below line for futher clarification on APPEND.

http://help.sap.com/saphelp_nw70/helpdata/EN/fc/eb36c8358411d1829f0000e829fbfe/content.htm

Thanks

mrutyun^

Re: appending table -

prince_isaac — Tue, 07 Oct 2008 09:15:07 GMT

This message was moderated.