topic Table modification through BDC in Application Development and Automation Discussions

Table modification through BDC

Former Member — Sat, 29 Sep 2007 12:50:05 GMT

Purpose : There are 5 records in a table zgkmaster

er_id er_name

1 gopi

2 raju

3 priya

4 preeti

5 mahesh

I want to make all er_names as 'xxx' .I created excel sheet with

xxx

Now I want to import this to zkmaster and updated all 5 records with er_name as 'xxx'.

What I did is :

-Created ptable type of bdcdata and move each screen data as record like

BDCcode:

1.Edit - Where you enter table name and click 'change'

2.TDSH-cntrlshiftf10 to display

3.ONLI - execute

4.Mark-to mark all displayed records(in goto menu i think)

5.AEN2-to change the data in selected records (in table entry menu)

I have coded till this and checked.To my surprise the program execution stops at execute screen.The records are displayed but not getting marked automatically.I dont understand why.If i give 'MARK' in transaction code or 'select all' from menu text box,then all records are marking.Why its not getting marked.Any problem with

CALL TRANSACTION 'SE11' USING PTABLE MODE 'A'

(sorry if sytanx is wrong,this is working fine in my system without syntax error).Please help me why the records or not getting marked,even I tried giving other codes like 'BACK','%EN'(exit) but anything after that 'execute' screen is not working.Help me

Thanks a lot in advance

Re: Table modification through BDC

Former Member — Sun, 30 Sep 2007 09:58:11 GMT

if its Z table , u can do like this also.

data: itab like ztable occurs 0 with header line.

select * from ztable

into corresponding fields of table itab.

loop at itab.

do some thing.

modify ztable.

commit work.

endloop.

please check for sytax.

Regards

Peram

Re: Table modification through BDC

Former Member — Sun, 30 Sep 2007 13:57:39 GMT

Guys,

I solved the problem.I did recording.I checked the screen sequences,once screen was missing.I added that in my abap program,now the records are marking.But getting another error 'fields invalid in batch input data'.May be some problem with input file.I need to check it out.

Thanks