topic Re: Validate Text Object/Id for sales Docs in Application Development and Automation Discussions

Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:00:54 GMT

Hi,

WE have aprogram that updates header and item texts for sales documents. The problem is that the users sometimes give the wrong Object/Id combinations for sales docs and the BAPI is not giveng any error messages. Is there any method to validate if a Textobject/Id is valid for a particular sales document type?

Regards,

Hari.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:07:09 GMT

I am afraid not. Because it will be the same TEXT OBJECT and TEXT ID for a given TEXT (HEADER / ITEM ...) for all the documents.

What I am unable to understand is why is that user is manually choosing the TDOBJECT and TDID. It should more like VA02, where in he chooses HEADER TEXT / ITEM TEXT / ITEM DELIVERY NOTE, then you internall set the values for the parameters

Regards,

Ravi

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:12:53 GMT

Hi harikrishnan,

If it is a slaes order header text, then the text object /id can be validated against VBAK table.

select single *

from VBAK

where vbeln = <Text Object>.

For Item texts you can validate against VBAP.

select single *

from VBAP

where vbeln = <10 characters or Text Object>

and posnr = <Remaining characters of Text Object>.

Regards,

ravi

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:13:43 GMT

Hi Ravi,

This is a batch program that reads in a file and updates the texts for orders. I think you got my question wrong. For e.g if the input file contains texts for ZFOR ( this is a custom type we have for forecasts) type orders, and the user put in VBBK/01 which is not there in the text determintaion procedure for that document type, i need to give an error message.

Regards,

Hari.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:15:45 GMT

If that is the case you can validate against the TTXID table where in you check for the combination and existence of the TDOBJECT and TDID.

Regards,

Ravi

NOte : Please mark all the helpful answers and close the thread if the question is answered

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:25:38 GMT

Hi Ravi,

This table does not have the information at a order type level. I need to do the validation, i.e if a text object/id is valid for a particular order type.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 14:29:14 GMT

If you are modifying existing tables, In that case STXH and STXL are the only table that you can help you.

Else, fire a READ_TEXT and then see the output to see if its a valid parameter and do the SAVE_TEXT / BAPI whichever one you are doing.

Again, these paramaters are not specific to the ORDER TYPE.

Regards,

Ravi

Message was edited by: Ravikumar Allampallam

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 15:42:08 GMT

Is there any configuration table where i can get all valid textobject/Id's that are maintaied for an order type?

Regards,

Hari.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 15:51:18 GMT

Attaching a TEXT OBJECT / ID to a specific order is a transaction and not a configuration. At the same time as I said the texts are attached to a order type, as the texts will have to be valid for all the order types.

So, if at all there is any config, that is in TTXID table.

Regards,

Ravi

Note : Please mark the helpful answers

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 17:08:19 GMT

Hi Ravi,

Yes, that is what i am looking for. The table that can give me the text objects (not transaction data) valid for a order type. like we define that VBBK/001 is a valide text for TA order type.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 17:21:34 GMT

Hi Hari,

Have you looked table <b>TTXG</b> and <b>TTXGT</b>?

Hope this will help.

Regards,

Ferry Lianto

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 17:26:09 GMT

The link is through the document type. TVAK has the order type information. Associated to it is a text procedure which is stored in TTXG. Associated with each text procedure, are text objects and text ids, which are stored in TTXS.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 18:52:49 GMT

Hi Srini,

Thanks for the Info. But i found that TTXS contains all the text ids, but TTXER contain the ones that actually appear on VA02. I THINK that the missing step here is that you should look at the field on the TTXER table called "Reference/dupl.".

If there is an X in that field, then those are REALLY the only Text IDs that are active in a particular Text procedure. Am i correct in assumnng this?

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:05:18 GMT

TTXER is the one that stores what text ids are relevant to a text determination procedure. So here, if I give a text determination procedure of 01(=sales header), object = VBBK, I get all the texts associated with the sales order header. The field you are referring to will only tell whether the text is referenced or duplicated (copied).

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:08:33 GMT

Access sequence table TTXZ also comes into picture here.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:28:00 GMT

I see that TVAK has '08' as the text determination procedure for one order type. Header texts when i checked is correct . But item texts is VBBP 01 as seen from transaction VOTXN. Can you please tell me which table gives the item procedure?

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:32:38 GMT

Oh sorry, it is TVAP, i got it thanks.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:32:38 GMT

Same TTXER, TDOBJECT = VBBP and TXTGR = 01. Why you are not getting the text ids like this?

What is your requirement? Why are you reading config?

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:34:14 GMT

Ok, yes, item text procedures are tied to item categories. That is why you need to take the item category to find the procedure assigned to it.

Re: Validate Text Object/Id for sales Docs

Former Member — Mon, 19 Jun 2006 19:35:08 GMT

Hi Srini,

We have a batch Job that updates texts for sales documents. The program takes an input file that has order no/line/text object/id and text. Some times users put the wrong text object/id. So we need to validate before using the BAPI if that object/id is valid for that order/line and give an error message if not found