topic create number for table field in Application Development and Automation Discussions

create number for table field

Former Member — Tue, 06 Dec 2011 11:25:14 GMT

Helo friends,

As I created one FM for sending mail as Adobe Form as an attachment....As per requirement at the same time Zdbase table named Zstatus......will we updated....

it contains 12 fields......every time when this API run in Sap back ground a number is generated through number range and assigned to this uniquely identified Adobe Form......

One more field is there in ZStatus table called Status....

When mail sent status will be 'send'

When mail receive status will be 'Received'.

along with this field UI guys want there one more field named 'Status Key' is also embedded in Zstatus table...

and on the basis of this 'Status Key' field they can recgnize the status....

So my problem is that how to generate dynamically 'Status Key' number in my program....or It can be handle by text id concept..

please suggest me the solution...

regards

rahul singh

Re: create number for table field

Former Member — Tue, 06 Dec 2011 12:50:20 GMT

How do you know if email has been "received"? You can capture an attempt to send, but that doesn't even mean that the email made it out of your mail system. Ask your users what they expect to see in the "status key" and program for that. Why would you even need this if you are already storing "send" or "received"? the requirements seem unusually garbled.

Re: create number for table field

Jelena_Perfiljeva — Tue, 06 Dec 2011 20:05:32 GMT

I agree with the previous post that such requirement within SAP does not make sense. We can only track an attempt to send something (it might not even make it out of SAP, you'll never know until you look).

Aside from that, if you need to have a key and a corresponding text value and want to utilize the SAP text/translation functionality, then just do it the same way SAP does - use a separate table with language key to store the descriptions.

Re: create number for table field

Former Member — Wed, 07 Dec 2011 05:01:21 GMT

I appreciate your valuable time...

ifor your information i tell you it can be acheived by created text-ids...

and second thing please understand the requirement if not possible please do not reply with abrupt answers...

i hope u guys keep in your mind in future for replying the answer..

anyway....thanks for your valuable comment...

rahul