Counter in databasetable

[Former Member]

Hi Experts,

how I can create a function to counter my entries in my database table?

Regards,

Mike

[Former Member]

Hi Experts,

how I can create a function to counter my entries in my database table?

Regards,

Mike

[Former Member]

Hi,

Can you please explain it in more details ?

regards,

Advait

[Former Member]

I want to delete a manually input from my ALV.

If I insert rows that is not the problem.

The problem is, when I delete entries from my ALV it did not work, I need a counter or an index how I can delete the entry, who should be deleted.

[Former Member]

Hi Mike,

after the alv grid is dispalyed use SAP$ in command field

this allows you to delete a row by selecting the required row.

regards

Ramchander Rao.K

[Former Member]

How I can do it exactly?

[Former Member]

Hi,

You use DESCRIBE TABLE LINES statement to get no of line in a internal table.

You can get the index for the selected line/s in ALV. You can delete the internal table entries based on those index.

[Former Member]

hI Mike,

Create a NUMBER RANGE OBJECT using tcode SNRO and then call the function module

NUMBER_GET_NEXT. this will give an incremented number each time it is called.

using this number along with other data update the DATABASE table.

regards

Ramchander Rao.K

[Former Member]

Hi

I don't know why u required but , simple way can be .

give input parameter as Table name

then make dyanamic SELECT query as

select * form <Table >.

then catch the value of system field SY-DBCNT.

put it as Export parameter.

this may help.

Regards

Sachin

[Former Member]

Hi,

If you just want to know the number of rows in a table.

See F1 help for SELECT COUNT(*) statement

Regards

Karthik D