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
Showing results for 
Search instead for 
Did you mean: 

HI

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

Former Member
0 Kudos

*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

Former Member
0 Kudos

*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

Former Member
0 Kudos

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

IN MY TABLECONTROL I HAVE A COLUMN CALLED STATUS.

0 Kudos

Instead of delete u can write 'Modify' command

Awrd Points if useful

Bhupal

0 Kudos

PLZ COULD U TALL IN BREIF HOW TO USE MODIFY COMMAND