entries in SM30

[Former Member]

i create table in sm30 zxc, i click on NEW ENTRIES and i get option to put only 1 line i want all the table will be ahite so i can put full of records

[agnihotro_sinha2]

Sorry but at a time you cant upload total data...

u hv to do it with few lines only.

[agnihotro_sinha2]

Do smthng...

Generate a Y report to upload data to table using INSERT statemnt and then Commit if upload is successful.

Read data from ur flat file into this program and upload table.

[Former Member]

SM30 doesnt allow you to do it all at a time.

Instead you need to get in to SE11 to achieve the same....

Hope it is helpful

[Former Member]

sorry i didnt understand you say i can not enter few entries...

why??????

[agnihotro_sinha2]

Try this code:

types: BEGIN OF gt_table,
        ZNAME type char20,
        ZSOURCE TYPE char20,
        ZCUST_SCR TYPE char40,
        ZCUST_TAR TYPE KUNNR,
        ZCUST_ACC TYPE KTOKD,
      END OF GT_TABLE.

TYPES: BEGIN OF GT_TABLE1,
        F1 TYPE STRING,
        END OF GT_TABLE1.
DATA: GI_TABLE TYPE STANDARD TABLE OF zdbxref,
      GWA_TABLE TYPE zdbxref,
      GI_TAB TYPE STANDARD TABLE OF GT_TABLE1,
      GWA_TAB TYPE GT_TABLE1.

DATA: GV_PATH TYPE STRING VALUE 'C:\TESTCSV'.

CALL METHOD cl_gui_frontend_services=>gui_upload

EXPORTING

filename = 'C:\TESTCSV.CSV' "Comma separated file

CHANGING

data_tab = GI_TAB.

DELETE GI_TAB INDEX 1.

LOOP AT GI_TAB INTO GWA_TAB.

SPLIT GWA_TAB-F1 AT ',' INTO GWA_TABLE-ZNAME GWA_TABLE-ZSOURCE GWA_TABLE-ZCUST_SCR

GWA_TABLE-ZCUST_TAR GWA_TABLE-ZCUST_ACC.

APPEND GWA_TABLE TO GI_TABLE.

ENDLOOP.

BREAK-POINT.

DELETE FROM ZDBXREF.

commit WORK.

*LOOP AT gi_table INTO GWA_TABLE.

INSERT ZDBXREF FROM TABLE GI_TABLE.

IF sy-subrc EQ 0.

COMMIT WORK.

ELSE.

ROLLBACK WORK.

ENDIF.

[former_member242255]

if you want to update with large no of records..then better go thru programmatically...

[Former Member]

In the Table maintenace click the maintenace type 'one step'. then I think it will work...

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records. here you can enter multiple records at a time.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details and at a time only one entry is possible.

regards,

Nilay

[Former Member]

hi,

while creating a TMG u need to go for one step and not two step. so that now you can enter all the values at simgle time.

[Former Member]

well if i am thinking the same way as you,,then do one thing,,

you must be getting your data from some excell file, just put them in the same order as in your table,,then copy (cntrl + y,then cntrl +c)them and now go to sm 30 and place your cursor on the first column and paste it....

well if it is not so,,please put your question in a detailed way so that we can help you in a better way