topic how into insert databse table with client number and autoincremental value in Application Development and Automation Discussions

how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 12:37:01 GMT

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

Re: how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 12:43:07 GMT

hi,

Use MANDT field to enter client specified data.

Regards,

Santosh

Re: how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 12:48:34 GMT

Dear santhosh

thank you ,

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

Re: how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 12:49:19 GMT

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.

Re: how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 13:01:03 GMT

thank you srelatha

but how i count the letest number in db table.

please help me

Re: how into insert databse table with client number and autoincremental value

Former Member — Sun, 01 Jul 2007 13:26:20 GMT

its answered