topic Re: How to transfer data between two tables in Application Development and Automation Discussions

How to transfer data between two tables

Former Member — Tue, 14 Nov 2006 05:47:55 GMT

Hi friends i have got a new problem actually i'm a fresher in this SAP so i have a doubt in SAP Smart Forms the problem is like this

I have a data element common in both of the tables BSEG and KNA1 and the common data element is KUNNR so i want to transfer all the data in the table BSEG to KNA1 of the same data element(KUNNR) in which there is data regarding customer information so i want to transfer the single customer data into another table KNA1 and i want to display the data in the output plz any one can help me.

Re: How to transfer data between two tables

Former Member — Tue, 14 Nov 2006 06:14:57 GMT

check table BSID/BSAD for Customer Open/Cleared items.Dont try to make use of BSEG table.

first u must me clear abt what are u doing ? u cannt Transfer data b/w tables like as u said. But u have to make use loop/endloop after getting the relavent data from the table.

check Tcode F.27

Regards

Prabhu

Re: How to transfer data between two tables

anversha_s — Tue, 14 Nov 2006 06:14:58 GMT

hi.

the below metjhod u can adopt.

select data from 1st zable to internal table.

2)insert data from internal table to 2nd ztable simple.

data:begin of itab occurs 0.

include structure ztable_structure1.

data:end of itab.

select * from ztable into table itab.

modify ztable1 FROM TABLE itab.

3 ) ike that u can catch date from other table.

4) if any condition is there u can check it in the internal table.

Rgds

Anver

if hlped pls mark points