topic Module Pool Programming adding line items. in Application Development and Automation Discussions

Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 05:53:42 GMT

Hi,

I am Doing Module Pool Programming in which I Should add line items and if the user gives the save button the data wil be saved in tables and SAP should generate one unique number.

Please give me inputs how to generate unique number and add n number of line items

correct inputs are rewarded

Thanks

Rasheed.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 06:02:27 GMT

Hi,

You may use Number Generator for generating unique ids in the system.

The keyword DEFAULT SERIAL gets a number generator for positive integers and can only be specified for columns that have the data type INTEGER, SMALLINT, and FIXED without decimal places (SERIAL).

The first value generated by the generator can be defined by specifying an unsigned integer (must be greater than 0). If this definition is missing, 1 is defined as the first value.

If an INSERT statement inserts the value in this column, you get the current number generator value and not the value 0.

Each table may not contain more than one column with the DEFAULT specification DEFAULT SERIAL.

Regards,

Renjith

Edited by: Renjith Michael on Oct 23, 2008 11:34 AM

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 06:12:29 GMT

line item you mean(there is any header for the item) for line items you manually increment the previous existing line item. if there is no header then you can use number range for increasing the item number.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 10:29:31 GMT

Hi Vijay,

I have Header Items also i should get these values from standard table and i should enter my line items and once i save i shd generate a unique number like standard transaction codes .

Any correct inputs are rewarded.

Thanks

Rasheed

Re: Module Pool Programming adding line items.

christine_evans — Thu, 23 Oct 2008 10:39:32 GMT


> Hi Vijay,
> I have Header Items also i should get these values from standard table and i should enter my line items and once i save i shd  generate a unique number like standard transaction codes .
> 
> Any correct inputs are rewarded.
> 
> Thanks 
> Rasheed

Standard transactions create a line number for each new line that is unique within the document. Which you should be able to do yourself quite easily by incrementing the max line number for the document by 1 for each new line.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 10:48:10 GMT

Hi Chris,

Thank you for your inputs,

For example if we create a sales order after giving all the line items and header items SAP will generate one unique sales order number for each and every sales order we create.

So i also need to generate a unique number after saving all my data in module pool programming

Correct inputs are suggested

Thanks

Rasheed.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 10:52:42 GMT

Hi,

Hope this helps : http://help.sap.com/saphelp_nw04/helpdata/en/7b/6eb2aa7aed44ea92ebb969e03081fb/frameset.htm

Regards,

Renjith Michael.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 10:53:48 GMT

in your case you don't need the Number range. Little code you require to generate the item numbers for a header document.

For each header you will have items from 1 to n.

how sap handles normal transaction the way you can proceed.

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 11:02:46 GMT

Hi,

I need to have external Number range for my Z t Code which i am developing in module pool.

I need to have one unique number when ever i create new record.

For example like new sales order,new purchase order

Correct inputs are rewarded

Regards

Rasheed

Re: Module Pool Programming adding line items.

Former Member — Thu, 23 Oct 2008 12:05:21 GMT

Thank you very much I got the solution.

Re: Module Pool Programming adding line items.

Former Member — Fri, 22 Aug 2014 15:57:46 GMT

How did you solve this problem. I am having the same issue.

Thanks. can I see your code.