Tables to read PO Header and Item texts in S4 Hana

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/05770e568de83a35e10000000a44538d.html?q=Purchase%20order

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/ef55edda68864a709d513453383fe236.html

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

Hope this blog post helps.

Thank you