Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

create number for table field

Former Member

‎2011 Dec 06 11:25 AM

0 Likes
793

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

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

Reply
3 REPLIES 3
Read only

Former Member

‎2011 Dec 06 12:50 PM

0 Likes
767

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.

Read only

Former Member
In response to Former Member

‎2011 Dec 07 5:01 AM

0 Likes
767

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

Read only

Jelena_Perfiljeva
Active Contributor

‎2011 Dec 06 8:05 PM

0 Likes
767

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.