Tables to read PO Header and Item texts in S4 Hana

[SeshaP]

Hi All,

This blog post provides information on how to read or view Purchase order Header and Item texts through a CDS view and tables.

What is a Purchase order:

Purchase order in sap is a type of legal contract which binds the supplier to supply the described materials or services & purchaser to pay after receiving the described materials or services.

A purchase order consists of a document header and a number of items.  It can be created using transaction’s ME21 or ME21N

More information about PO

https://help.sap.com/docs/SAP_S4HANA_ON-PREMISE/af9ef57f504840d2b81be8667206d485/05770e568de83a35e10...

Two kinds of texts can be maintained for a PO.

• Header texts: Applies to the whole document.


• Item text:  Applies only to the relevant item.

These texts can be configured in SPRO or Display IMG

Header:

SPRO>IMG>Materials Management>Purchasing>Purchase Order>Texts for Purchase Orders>Define Text Types for Header Texts

Item:

SPRO>IMG>Materials Management>Purchasing>Purchase Order>Texts for Purchase Orders>Define Text Types for Item Texts

Coming to the blog,

To view or display created Purchase order texts, we can use the following tables.

• ITXTOBJPLNLTXT - Replicated Plain Longtext(SAPScript) – This table consists long text information of a PO.


• TTTXIT- Texts for Text IDs – This table captures description of ID’s (F01,F02 etc.,)

I have created a sample PO for the demo purpose with the below pre-defined texts configurations.

Header :

Item:



 

SQVI Query:

Demo :

Header Text:

Header texts can be viewed by passing the values in table ITXTOBJPLNLTXT as below.

• Text Object: EKKO


• Text ID: F01,F02,F03 etc.,,Language: EN,FR etc.,


• Text Name: PO Number -- 45***


• Long text : Description of the object

 

Output:

 

Item:

Item Text: Item text can be viewed by passing the values in table ITXTOBJPLNLTXT as below

• Text Object: EKPO


• Text ID: F01,F02,F03 etc.,,Language: EN,FR etc.,


• Text Name: PO Number -- 45***


• Long text : Description of the object

 

Output:

 

Note: Data to this table ITXTOBJPLNLTXT is populating or feeding through an ABAP program ESH_SR_LTXT_REPLICATE.

We can Schedule or run the abap program depending on frequency of usage.

References :

https://help.sap.com/docs/SAP_NETWEAVER_750/6522d0462aeb4909a79c3462b090ec51/ef55edda68864a709d51345...

https://me.sap.com/servicessupport/search/%7B%22q%22%3A%22ESH_SR_LTXT_REPLICATE%22%2C%22originContex...

Hope this blog post helps.

Thank you

[raymond_giuseppi]

You should provide a link to documentation (or another blog) on how to fill those tables ESH_SR_LTXT_REPLICATE

[SeshaP]

I have updated the references documentation and blogs, thank you.

[shais]

sgperam ,

I have some kind of Deja Vu (Accessing long text of SAP Master data Objects or fields in S4 Hana through a CDS View).

Is there any significant difference, except the fact you are using a different text object from your previous post?

[SeshaP]

shais ,

Thank you for reading the blog and providing your feedback.

In this blog post, I have added additional information

1. Description table for long text object types - TTTXIT
2. Demo, to retrieve long text information
3. End to End example of Creating PO text, Configuration of PO texts and Retrieving texts through table
4. Sample query through - SQVI.

In the other blog post, I could not provide any examples or sample data. It has just an overview of how to retrieve texts through CDS view and tables.

Thank you.