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: 

Uploading ztable from selection screen

Former Member
0 Kudos

hello friends,

i have one simple requirment. when the user enter's the data in selection screen, i need to upload that data to corresponding ztable. pls help me

With Regards

MurugeshRajeev

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

first create a workarea with all the screen fields then u can move all the screen field variables into that workarea and use insert statement. u can use F1(help on Insert for various options) but in this case it is

INSERT INTO (dbtabname) VALUES wa.

Regards,

Pavani

9 REPLIES 9

Former Member
0 Kudos

Hi,

1.Create a TMG for that ztable.

2.Create a parameter Transaction from SE93.

Regards

Former Member
0 Kudos

Hi,

For your requirement you can try Table maintenance Generator.

It will generate you a Screen where you can maintain(Input/Edit/Delete) your table entries.

Search Forum on Table Maintenance Generator.

See the following Links;

[What is table maintenance generator?|http://www.saptechies.com/what-is-table-maintenance-generator/]

[How to create table maintenance generator?|http://www.saptechies.com/how-to-create-table-maintenance-generator/]

Regards

Karthik D

Former Member
0 Kudos

Hi,

first create a workarea with all the screen fields then u can move all the screen field variables into that workarea and use insert statement. u can use F1(help on Insert for various options) but in this case it is

INSERT INTO (dbtabname) VALUES wa.

Regards,

Pavani

Former Member
0 Kudos

Hi,

if you want to save the data entered by the user into table

use INSERT TABLE NAME.

if you want to change the existing data then use

MODIFY TABLE NAME.

Former Member
0 Kudos

Hi,

If your requirement is to insert values entered on the selection screen into a single custom table then you can create table maintenance from Table maintenance generator with Maintenance type as 'two step'. Specify overview screen number (say 100) and single screen number (say 200) and activate it.

Whenever you go to SM30 and trying to click on New entries button you can see the selection screen. You can simply enter values on the selection screen and save it.

Regards,

Venkat

Former Member
0 Kudos

Hi,

Creat table maintainence generator. Assign a transaction code to it.

Regards,

Prashant

shadow
Participant
0 Kudos

Hi,

u can use insert stmt for inserting data i data-base.......

for example .

tables:lfa1.

parameters:p_lifnr like lfa1-lifnr.

lfa1-lifnr = lifnr.

insert lfa1.

-


---

it will be work.......

Regard's

Shaik.

Former Member
0 Kudos

hi

tables : zalok_mo.
data : itab type table of zalok_mo with header line,
       wa type zalok_mo.
data : v_PUR_ORD_NO type zalok_mo-PUR_ORD_NO.

parameters : p_PUR like zalok_mo-PUR_ORD_NO.


move p_PUR to v_PUR_ORD_NO.

move v_PUR_ORD_NO to itab-PUR_ORD_NO.

modify zalok_mo from itab.

I have taken my own ztable and uploaded the data, same way u also follow the procedure. It will work.

Former Member
0 Kudos

go to se93,

create transaction Z***

select Transaction With Parameter

in transaction put 'sm30'

now put this parameter in proporsed value

name of the screen field value

VIEWNAME your table name

UPDATE X

regards,

Alpesh