10-07-2008 9:48 AM
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.
10-07-2008 9:51 AM
few more records are appended to table T_KNA1 when the conditions in the select query are satisfied.
10-07-2008 9:50 AM
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
10-07-2008 9:51 AM
well the selected information is beeing appended to table t_kna1 as a new record.
10-07-2008 9:51 AM
few more records are appended to table T_KNA1 when the conditions in the select query are satisfied.
10-07-2008 9:51 AM
Hi
I think the appending statement means, it will append to exisitng t_kna1 data, it will not over write
Regards
Madhan
10-07-2008 9:52 AM
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.
10-07-2008 9:53 AM
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
10-07-2008 9:53 AM
Hi Sushanth,
Appending means that the entries will be appended to the existing entries in the itab t_kna1.
regards,
Advait
10-07-2008 9:54 AM
Hi
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^
10-07-2008 10:15 AM