Application Development and Automation 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: 
Read only

how into insert databse table with client number and autoincremental value

Former Member
0 Likes
749

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

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

5 REPLIES 5
Read only

Former Member
0 Likes
724

hi,

Use MANDT field to enter client specified data.

Regards,

Santosh

Read only

0 Likes
724

Dear santhosh

thank you ,

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

Read only

Former Member
0 Likes
724

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.

Read only

0 Likes
724

thank you srelatha

but how i count the letest number in db table.

please help me

Read only

Former Member
0 Likes
724

its answered