Insert records to dbt

[Former Member]

Hi,

How to insert records into database table. i requirment is like this ..

record 1 ) xxx 123 yyy ' X '(initially space before inserting 2 rc)

record 2) xxx 124 yyy ' '

and so on ......

the data base table should hold all the records that are inserted to dbt like history of records with new recored with archive space.

any sample code pls...

thanks,

vind.

[Former Member]

Hi,

How to insert records into database table. i requirment is like this ..

record 1 ) xxx 123 yyy ' X '(initially space before inserting 2 rc)

record 2) xxx 124 yyy ' '

and so on ......

the data base table should hold all the records that are inserted to dbt like history of records with new recored with archive space.

any sample code pls...

thanks,

vind.

[Former Member]

Hi,

Create a new number range in the transaction SNRO..and use the FM NUMBER_GET_NEXT to get the next number in the sequence..

Check this link for how to create number range.

http://help.sap.com/saphelp_nw04/helpdata/en/2a/fa0331493111d182b70000e829fbfe/content.htm

Let me know if this is not what you are looking for..

Thanks,

Naren

[Former Member]

hi narendra ,

I am looking for an update of database table with new records and the previous records with an achive flag 'X' when user inputs new records to a internal table . So when user runs the report next time he should see all the records that are been updated and also when we check the data base table it shold shows all history of all records with archive flag 'X' to it except the latest input record with out an archive flag.

thanks,

vind.