Skip to Content

Hi all,

We know about purchase document text. This text can be maintain in header level and item level.

Text can be maintain on Info record, Material, PR, PO, SA, Contract etc..

It’s stored into a table STXH and STXL, but its little difficult to find out with compare these two tables.

SAP has another way where we can get a report for these texts with all details.

Let’s discuss details about it.

Suppose we have a lots of material, some material has a text and some material hasn’t.

How can I found the material which has a text and what is the text for those particular materials.

Lets display one material for the tab Purchase Order text.

ScreenShot.jpg

Here is the text for material master for this particular material.

Now just click on the Editor, You can find the option bottom of the screen in left side. Its look like ScreenShot.jpg

Now the screen will looks like as below screen shot.

ScreenShot.jpg

Then in application bar, press Goto – Header

ScreenShot.jpg

Now you can see a pop-up screen will appear. Which will contain some information.

ScreenShot.jpg

Note the text id for Material.

Standard Text ID for material purchase order text is BEST.

Note that.

Now go to SE38 and give the program name RSTXTC3.

ScreenShot.jpg

Now press execute.

ScreenShot.jpg

Here enter the Text ID (which you have got from material master)

Then again press execute.

ScreenShot.jpg

Here we can get a list of all material which has a purchase order text.

Now press the option Additional information ScreenShot.jpg

ScreenShot.jpg

After pressing additional information, you can see all information including the purchase order text with respective to material..

Now you can also copy the all information into excel sheet for further process.

If your text contain more than one line item, then you can only see the first line item text in this report. You can see the more line item for this text by clicking the display text option as below:

/wp-content/uploads/2014/01/dev_542718.jpg

You can also change the text from here (at the time of this change option, you can see the text for all line items)

Just select the line item and press Change Text ScreenShot.jpg.

ScreenShot.jpg

The above information for Material master – purchase order text.

We can also get a list for all purchasing document.

Like for Purchase Order/ Contract/ Sch. Agree./RFQ- Header Text:

The selection field will be

ScreenShot.jpg

Because of header text, we have to select object as EKKO and text ID as same as the way for material master – purchase order text.

You can also select the text as purchase order number+Line item number (Purchase order number will be 10 characters and line item number will be 5 characters)

ScreenShot.jpg

For Purchase Order/ Contract/ Sch. Agree./RFQ- Item Text:

The selection field will be

ScreenShot.jpg

For Purchase Requisition – Header Level : Use Object = EBANH and Text ID = B01.

For Purchase Requisition – Item Level : Use Object = EBAN and Text ID = B01.

For Purchase Info Record – Info Record Note : Use Object EINA and Text ID = AT.

For Purchase Info Record – Purchase Order Text : Use Object EINE and Text ID = BT.

For Vendor Master – Accounting note : Use Object LFA1 and Text ID = 0001.

For Vendor Master – Purchasing memo : Use Object LFA1 and Text ID = 0002.

For Sales Order – Header Level : Use Object = VBBK and Text ID = 0001

For Sales Order – Item Level : Use Object = VBBP and Text ID = 0001

For Service Entry Sheet – Long Text : Use Object = ESSR and Text ID = TX01

For Service Entry Sheet – Line Long Text : Use Object = ESLL and Text ID = LTXT

For Service Entry Sheet – Service Long Text : Use Object = ESLL and Text ID = LLTX

In this way we can get a report for all purchasing document’s text and as well as master data’s text.

Thanks and Regards

Dev Patra

To report this post you need to login first.

31 Comments

You must be Logged on to comment or reply to a post.

  1. Rakesh M Choudhary

    Hi Dev, It’s good to have more information on handling Text . In my experience, it is always difficult to do a function report based on texts- mainly because they cannot be consistent.

    Informative document.

    Thanks

    Rakesh.

    (0) 
  2. Mohsin Abbasi

    Great………. 😉 , just tell me form where you get program-me name(RSTXTC3), i mean to say that i might be wrong, but normally if you want to know about programm name(RSTXTC3) than just click status on system from application tool bar. but i didn’t get programme name like this.

    Moreover i made PO for that material but didn’t get the list of PO in EKPO and giving text ID  F01, i follow the process as mention by you, se38->prgramme name (RSTXTC3), than Object EKPO, and text ID, but no PO is shown. although in PO i have seen text in item overview. any step i am missing kindly do let me know.

    Best Regards

    Mohsin Abbasi

    (0) 
    1. Dibyendu Patra Post author

      Actually the program is not assigned with any t-code.

      I was just reading many threads in SCN, I got the program in one thread. Its an individual program, nowhere it used at all.

      (0) 
      1. Mohsin Abbasi

        Dear Dev,

        thanks for you prompt response, Understood. one more clarification required,

        Moreover i made PO for that material but didn’t get the list of PO in EKPO and giving text ID  F01, i follow the process as mention by you, se38->prgramme name (RSTXTC3), than Object EKPO, and text ID, but no PO is shown. although in PO i have seen text in item overview. any step i am missing kindly do let me know.


        Best Regards

        Mohsin Abbasi

        (0) 
        1. Dibyendu Patra Post author

          Is it coming from material master ?

          Check which source is copied from in PO. Also check the text linkage for the source object.

          Check is there fix set as “N”

          (0) 
  3. Brock Cummings

    Thanks ! I’ve used the Read_text function module in queries and functional specifications before, but didn’t know about this report. Its very helpful !

    (0) 
  4. B V Yadav

    Hi Dev Sir,

    Very Nice and good Document. Now I got how to get Material PO text.

    Thank you sir for sharing document.

    Regards,

    B V

    (0) 
  5. Rafael Zaragatzky

    Excellent tip, Dev. I remember I had to develop ABAP for a client willing to see all the long texts in material master. If I only knew about RSTXTC3 then… 🙁

    (0) 
  6. Tom Skrzypiec

    Is there a way to limit output to just a selection of materials?
    We have over 100000 materials and it’s taking forever to run it. Also, I can’t save it to a local file for further processing or copy/paste probably due to its size.

    Can you please help?

    Thanks!

    TZS

    (0) 
  7. Tom Skrzypiec

    Actually, you can select materials.

    Make sure that you put MATERIAL in Object field

    then you can enter your material or materials in Text field

    SCN.jpg

    (0) 
    1. Dibyendu Patra Post author

      Right. No need to fill the Object as Material.

      You can filter the material by just entering the material number in text field.

      Thanks for sharing.

      (0) 
  8. B V Yadav

    Hi Dev sir,

    How many character it will show in this report, i had executed RSTXTC3 as you said but system not showing full text only few character i am getting. please find screen shotsCapture1.PNG

    display text screen

    Capture 2.PNG

    (0) 
    1. Dibyendu Patra Post author

      If your text contain more than one line item, then you can only see the first line item text in this report, it is 73.

      Alternatively if you want to pull all line item, use the function module READ_TEXT.

      (0) 

Leave a Reply