07-16-2013 11:00 AM
Hello Experts,
I have one scenario where I am reading sales order item information. In some cases sale order value is blank and only item information gets filled.
where I am using parameter as below:-
ID = Z102
NAME = 000010
OBJECT = VBBP
LANGUAGE = DE
And i am returning some number in TDLINE. But I am not able track that number where it has been stored. Please let me know your suggestions.
Regards,
Shiv
07-16-2013 12:18 PM
Hi Shivshanker,
The text information which you enter into the Sales order item is stored in various clusters in SAP. The various attributes related to your texts are stored in the two transparent tables STXH & STXL. The cluster into which your text has been saved will be stored in STXL-CLUSTR field. The function READ_TEXT reads this cluster number from the STXL table and returns the text from this cluster into the return parameter 'LINES'.
Thanks & Regards,
Sarath.
07-16-2013 11:50 AM
07-16-2013 11:51 AM
Hello shiv,
We generally use read_text to read the texts present in so ,po etc.go to text tab in SO dauble click on text then goto->header text. you ll find all realted parameter related to read_text.
Thanks,
Sam
07-16-2013 11:57 AM
07-16-2013 12:18 PM
Hi Shivshanker,
The text information which you enter into the Sales order item is stored in various clusters in SAP. The various attributes related to your texts are stored in the two transparent tables STXH & STXL. The cluster into which your text has been saved will be stored in STXL-CLUSTR field. The function READ_TEXT reads this cluster number from the STXL table and returns the text from this cluster into the return parameter 'LINES'.
Thanks & Regards,
Sarath.
07-16-2013 12:30 PM
Thanks for all of your response.
I know these values are stored in this table but I want to see it in text tab of sales order screen but I am not to able to get it.
Please let me know if sales order value is blank and only item number is passed. So would it mean that it will consider '00010' as sales order number. If yes then I searched the text for this sales order number but not able to find out.
My main aim is to locate return parameter value for sales order number and delete it.
07-16-2013 12:49 PM
Hi,
This function module does check on several things based on the tables STXH, STXL as said above
To make this function module work you need to specify the object name most important
where stored in table
TTXOB
These are all the valid objects
STXL uses relative ID for each object above where this function reads and identifies on
its recommended you use this function to read rather then you go direct by yourself
As it validates other referencing data too
Hope it helps
07-16-2013 12:49 PM
Hi,
if TDLINE contains a number only, this is the number of a standard text, which you can display with transaction SO10. Text name is the number, id is 'ST'.
If I remember right, function module EDIT_TEXT with empty display option will give you the text; and the standard text number is replaced by text lines.
Regards,
Klaus
07-16-2013 1:28 PM
07-16-2013 2:20 PM
07-16-2013 2:30 PM
Yes it is customer code, but I want to delete this code. Please let me konw how can i do that?
07-17-2013 7:17 AM
Hi,
I just wanted to say that you can include standard text of text id ST in your Z102 texts as a part or complete text.
But I was wrong that there is only a number in TDLINE for that.
In case of standard text inclusion TDFORMAT should have value '/:' and TDLINE something like ' INCLUDE XYZ ID ST' where XYZ is the name of the standard text in SO10.
Sorry for this partially wrong information.
Regards,
Klaus
07-17-2013 1:21 PM
Hello
Can I delete this text via running function module in production? If yes please let me konw the name?
07-17-2013 3:42 PM
Hi,
Steps:
1.- Check SE91 where the message is used and delete that code as well.
2.- check SO10, there you can delete that text.
3.- also maybe can be in customizing, tcode OVAH
Regards
Miguel
07-18-2013 5:37 AM
Hi,
you can delete your Z102 text with functio module DELETE_TEXT.
Please check, if you need the SAVEMODE_DIRECT flag set to 'X'.
Regards,
Klaus
07-17-2013 2:36 PM
Check table stxh
ID = Z102
NAME = 000010
OBJECT = VBBP
LANGUAGE = DE
CALL FUNCTION 'READ_TEXT'
EXPORTING
id = stxh-tdid " (Z102)
language = STXH-TDSPRAS " (DE)
name = STXH-TDNAME " (000010)
object = STXH-TDOBJECT (VBBP)
TABLES
lines = it_text
EXCEPTIONS
id = 1
language = 2
name = 3
not_found = 4
object = 5
reference_check = 6
wrong_access_to_archive = 7
OTHERS = 8.