Skip to Content
0

How may I retrieve the 'note to recipient' defined in transaction VV13?

Jun 07, 2017 at 10:11 AM

192

avatar image
Former Member

Dear experts,

I've been trying to look for a way to retrieve the 'Note to recipient' as defined in the transaction, VV13, but to no avail. Please see the highlighted text in yellow here -> screen.jpg

The closest clue that I've had is via the FM, SO_DYNP_OBJECT_SEND but this will cause a runtime error (POSTING_ILLEGAL_STATEMENT) because my custom print program is executed in the background.

Does anyone have an idea on how I can achieve this please?

Much thanks..

screen.jpg (82.8 kB)
10 |10000 characters needed characters left characters exceeded

What is your question: how to retrieve, or how to send?

0
Former Member
Sandra Rossi

My question was how to retrieve the highlighted text in the screenshot that I've shared..

0
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Mike Pokraka Jun 07, 2017 at 09:16 PM
1

The screenshot looks like a standard SAPOffice mail. If so, this is a SAPOffice document linked to your VV13 document. This could be either simple or messy or impossible (I know that isn't a very helpful statement). Please have a look in your outbox (in SBWP) after sending one of these. If it is a mail without any link or attachment, it may not be possible to retrieve programatically. If it has a hyperlink or something by which you can navigate back to the original doc, then something could be done.

I don't have an SAP system in front me me right now, what is VV13? How is this note created?

Show 10 Share
10 |10000 characters needed characters left characters exceeded
Former Member

After the email is sent, the text is shown in a plain text attachment only - no hyperlinks or anything of that sort.

VV13 is the transaction for output conditions record.. The 'note to recipient' can be created and saved here..

0

I am not sure if this is possible. I would have to spend a good amount of time on your system to see if this was even possible, because links can be tricky to say the least.

Please check the sent item in the outbox of the sending user if you can find any links in there.

As a starting point I would look at class CL_BINARY_RELATION, which has a few methods to find relationships. But again I don't have a huge hope, because the relation could be stored elsewhere or not at all (just a simple outbound email...).

The sent mails should be visible in tables SOFM and SOOD. The keys will take some getting used to, the document year of 2017 is 42.

1
Former Member
Mike Pokraka

Hi Mike,

Thanks for thinking this out as well. Really appreciate it.

I've checked the tables, SOFM and SOOD - it looks like that only sent items / transaction data are stored here. What I need for my requirement, is to retrieve 'setup / config' data ('note to recipient') as what has been shown in VV13.

0

Oh, I completely misunderstood the issue then, I thought you wanted to retrieve the text that had been sent out :(

If this is for a custom program, an easier quick and not-so-dirty solution may be to just define your own text in SO10 and sending it out with BCS.

0
Former Member
Mike Pokraka

Thanks Mike. I was hoping I could find a perfect solution to this, but looks like it's really difficult.

0
Former Member
Mike Pokraka

Hi Mike,

I've debugged the transaction, VV13 further on today. Here's what I've found:-

** The subroutine, SOCX_SELECT of the program, SAPFSSO0:-
import objhead_tab objcont_tab objpara_tab objparb_tab transa report dialog functi from database soc3(dt) id sortfield ignoring conversion errors.

The text for 'note to recipient' will be populated at this statement in OBJCONT_TAB.

I tried to write this out in a new temporary local program, but it ended with no data being found.

Any ideas on how else can I obtain this text? :(

0

Thought the transaction code was familiar... It's for the condition records, so you must do some additional steps there (e.g. enter certain output type) to get the screen which mentioned in the question. We do use output conditions but I haven't heard of this functionality and standard condition record screens look nothing like in the example. Can only guess it's some kind of special output type.

"The text is shown" where? What is it attached to? Kindly provide all the details.

Also you might want to clarify what you are actually trying to achieve with this text. There might be a completely different option.

1
Former Member
Jelena Perfiljeva

Hi Jelena,

Yes, that's right. For me, I will need to retrieve the text for 'note to recipient' for a specific custom output type that has been set up in the transaction VV12 for output conditions record. You may refer to the screenshot that I have posted here in my first post (question).

Here's what I need to do:-

Write a custom print program (specified in the transaction, NACE) for a custom output type that will send out an email to the intended recipient. This email body should contain the 'note to recipient' text that has been set up in the transcation, VV12.

1

Sorry but this feels like one of those weird text games (like Whiteout)... Would you mind giving us full information instead of spoon-feeding it piece by piece?

The screenshot provided in OP has no useful information whatsoever. As I mentioned, it does not look anything like standard VV11...VV13 (output condition record maintenance) transaction. If you've implemented something custom in your system then the SCN members cannot know anything about this.

If your goal is to enter an additional note to be included in the email produced by the standard condition-based output functionality then I don't understand what part does this whole VV12-VV13 plays in it. What was the design? Why did you (or someone?) decide to create this piece without thinking how you'd actually include it in the email.

In general, questions about including such notes in the emails have been asked on SCN multiple times before. If I had to write a program for this then I'd never use the mystery "note" you're asking about. Unless I'm missing something and SAP came out with some new design recently.

1
Former Member
Jelena Perfiljeva

Hi there,

I've debugged the transaction, VV13 further on today. Here's what I've found:-

** The subroutine, SOCX_SELECT of the program, SAPFSSO0:-
import objhead_tab objcont_tab objpara_tab objparb_tab transa report dialog functi from database soc3(dt) id sortfield ignoring conversion errors.

The text for 'note to recipient' will be populated at this statement in OBJCONT_TAB.

I tried to write this out in a new temporary local program, but it ended with no data being found.

Any ideas on how else can I obtain this text? :(

0
Jelena Perfiljeva
Jun 07, 2017 at 08:53 PM
0

We don't use this transaction, so I don't know for sure how this data is stored (standard text?). In general, however, it's easy to find out using SQL trace in ST05, for example. When you know how / where it's stored then it should not be difficult to find out how to read it.

I'm very much confused why SO_DYNP_OBJECT_SEND would seem like a suitable solution just to read any data.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

When debugging VV13, I found that this FM will return the 'note to recipient' in its parameter, NOTE_TEXT - this is why this was the closest clue that I could find during my investigation. Sorry for the confusion.

I guess I'll try ST05 then -- I do not know where this 'note to recipient' is stored, yet~

0