topic Re: Number Range dependent upon date in Application Development and Automation Discussions

Number Range dependent upon date

Former Member — Thu, 17 Dec 2009 13:05:20 GMT

Hi SAP Guru's,

Can we provide new number range to be genrated daily,

for eg.NR should be like this DDMMYY+(NEW-SERIAL NO)

posting date 11.12.2009: NR genrated is 111209001 to 111209050

posting date 12.12.2009: NR genrated is 121209001 to 121209060

and if somebody post document for 11.12.2009: NR genrated Should be genrated 111209051.

I am on implementation project , this is client's requirement.

It looks to me that this is not poosible but Please do suggest, how we can provide a solution for this problem.

Thanks & kind regards,

Rahul

Re: Number Range dependent upon date

former_member206377 — Thu, 17 Dec 2009 13:15:58 GMT

Hi Rahul,

Use the FM 'QF05_RANDOM_INTEGER' to generate a random number and concatenate the obtained value with sy-datum field.


data : l_rnd_numb type i.

CALL FUNCTION 'QF05_RANDOM_INTEGER'
 EXPORTING
   RAN_INT_MAX         = '999'
   RAN_INT_MIN         = '000'
 IMPORTING
   RAN_INT             = d_result
 EXCEPTIONS
  INVALID_INPUT       = 1
   OTHERS              = 2
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

concatenate sy-datum d_result into l_rnd_numb.

Re: Number Range dependent upon date

Former Member — Fri, 18 Dec 2009 04:52:38 GMT

Dear Vasuki S Patki ,

Thanks for reply.

But my problem is to post the document in back date, in that case the sy-date will be the current date and i want to pick the document date or posting date mention in the order or invoice.

Kind regards,

Rahul

Re: Number Range dependent upon date

Former Member — Fri, 18 Dec 2009 05:41:32 GMT

Hi Rahul,

As you said want to pick the document date or posting date mention in the order or invoice. Exactly thats what you have to do.

You will get that posting date field by debugging program. You have to just some efforts for that.

Re: Number Range dependent upon date

Former Member — Thu, 10 Feb 2011 01:26:22 GMT

It is recommended from sap not to change the auto generated number range as there could be a chance of missing the number range .. We have refused this scenario to client by explaining the complication which can be faced on implementing it.. Closing the old thread........