topic Re: Table update problem in Application Development and Automation Discussions

Table update problem

Former Member — Wed, 31 Aug 2016 12:27:45 GMT

Hi All ,

We are facing a very weird issue in project , a report is running , which is creating invoices , with that invoice a reference number is also generating , which helps us to stop duplicate invoice posting , now in report spool , the reference number is like 0011111111 , but in table BSEG it is showing like 11111111, first 2 zeroes are not coming , so next time duplicate invoices are posted , we have "conversion_exit_alpha_" fm in our program, so if no zeroes are there infront , it will put zeroes there , even when we are creating the same issue in quality system, table is updated properly , but in production the issue is happening , can you please help?

Thanks ,

Sayan

Re: Table update problem

RaymondGiuseppi — Wed, 31 Aug 2016 12:42:48 GMT

Insure that every concerned field carry same conversion-exit and length, and that every program use same rule to calculate§move value. Did you deactivate conversion exit when browsing tables?

Re: Table update problem

Former Member — Wed, 31 Aug 2016 13:33:06 GMT

Also , this doesn't happen very frequently in production, only twice this happened. ,in non prod it is not happening at all .

Re: Table update problem

Former Member — Wed, 31 Aug 2016 13:37:43 GMT

concerned fields are one for the IDoc from where we are passing the value into reference field , the IDoc field is C(30) , and our reference field is C(12) , the reference number which is created by the program is always C(10) , length mismatch can happen may be once, , but the issue happened twice ..and the program is running for a long time , this never happened before.

Re: Table update problem

RaymondGiuseppi — Wed, 31 Aug 2016 13:54:13 GMT

No debug or manual corrections identified?

Re: Table update problem

Former Member — Wed, 31 Aug 2016 13:56:36 GMT

Nope , we tried to create the same thing in non-prod , there the ref no is creating and showing in BSEG with the leading zeroes , only in PROD twice this happened .