how into insert databse table with client number and autoincremental value

[Former Member]

Dear friends

i am new to sap, can you explain how to insert data into db table and should insrt clientid and autoincremental value

please help me

[Former Member]

hi,

Use MANDT field to enter client specified data.

Regards,

Santosh

[Former Member]

Dear santhosh

thank you ,

then how we inter incremental value in table like sql server identity.

[Former Member]

Hi,

1. mandt = sy-mandt. (will give the current client).

2. count = count +1. (you would need to get the latest count from db) or you could use number range object so that it would handle the number calculation. It would add to previous number. Create Number Range Object in transction SNRO.

Regards,

Srilatha.

[Former Member]

thank you srelatha

but how i count the letest number in db table.

please help me

[Former Member]

its answered