Skip to Content
avatar image
Former Member

Uploading ztable from selection screen

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 15, 2008 at 12:11 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2008 at 11:51 AM

    Hi,

    1.Create a TMG for that ztable.

    2.Create a parameter Transaction from SE93.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2008 at 11:58 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2008 at 09:38 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2008 at 10:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2008 at 10:53 AM

    Hi,

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

    Regards,

    Prashant

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2008 at 02:47 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 05:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2008 at 10:32 AM

    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

    Add comment
    10|10000 characters needed characters exceeded