topic Re: Uploading ztable from selection screen in Application Development and Automation Discussions

Uploading ztable from selection screen

Former Member — Mon, 15 Sep 2008 11:47:32 GMT

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

Re: Uploading ztable from selection screen

Former Member — Mon, 15 Sep 2008 11:51:52 GMT

Hi,

1.Create a TMG for that ztable.

2.Create a parameter Transaction from SE93.

Regards

Re: Uploading ztable from selection screen

Former Member — Mon, 15 Sep 2008 11:58:01 GMT

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

Re: Uploading ztable from selection screen

Former Member — Mon, 15 Sep 2008 12:11:38 GMT

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

Re: Uploading ztable from selection screen

Former Member — Tue, 16 Sep 2008 09:38:10 GMT

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.

Re: Uploading ztable from selection screen

Former Member — Tue, 16 Sep 2008 10:10:53 GMT

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

Re: Uploading ztable from selection screen

Former Member — Tue, 16 Sep 2008 10:53:26 GMT

Hi,

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

Regards,

Prashant

Re: Uploading ztable from selection screen

shadow — Thu, 18 Sep 2008 02:47:33 GMT

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.

Re: Uploading ztable from selection screen

Former Member — Thu, 18 Sep 2008 05:39:10 GMT

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.

Re: Uploading ztable from selection screen

Former Member — Thu, 18 Sep 2008 10:32:45 GMT

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