Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to transfer data between two tables

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

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

anversha_s
Active Contributor
0 Kudos

hi.

the below metjhod u can adopt.

1)

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