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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

HI

Go to solution
Former Member

‎2007 Dec 24 5:13 AM

0 Kudos
133

HOW CAN I DELETE ONE RECORD FROM TABLE CONTROL SO THAT IT ALSO GET DELETAED FROM DATABASE TABLE.

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎2007 Dec 24 5:21 AM

0 Kudos
104

*Delete the SELECTED Record

if gt_item-cflag = 'X'. --> Field assigned to W/ Selection field on Screen

  • This deletes from Table

delete from yvbap where vbeln = gt_item-vbeln

and posnr = gt_item-posnr

and matnr = gt_item-matnr

and matkl = gt_item-matkl

and arktx = gt_item-arktx.

  • This deletes from Table control

delete gt_item index my_table-current_line.

endif.

awrd Poits if useful

Bhupal

4 REPLIES 4

Go to solution
Former Member

‎2007 Dec 24 5:21 AM

0 Kudos
105

*Delete the SELECTED Record

if gt_item-cflag = 'X'. --> Field assigned to W/ Selection field on Screen

  • This deletes from Table

delete from yvbap where vbeln = gt_item-vbeln

and posnr = gt_item-posnr

and matnr = gt_item-matnr

and matkl = gt_item-matkl

and arktx = gt_item-arktx.

  • This deletes from Table control

delete gt_item index my_table-current_line.

endif.

awrd Poits if useful

Bhupal

Go to solution
Former Member

‎2007 Dec 24 5:37 AM

0 Kudos
104

CAN I MAKE A PARTICULAR RECORD STATUS TO BE INACTIVE INSTEAD OF DELETING.

IN MY TABLECONTROL I HAVE A COLUMN CALLED STATUS.

Go to solution
Former Member
In response to Former Member

‎2007 Dec 24 5:53 AM

0 Kudos
104

Instead of delete u can write 'Modify' command

Awrd Points if useful

Bhupal

Go to solution
Former Member
In response to Former Member

‎2007 Dec 24 6:02 AM

0 Kudos
104

PLZ COULD U TALL IN BREIF HOW TO USE MODIFY COMMAND