Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
cancel
Showing results for 
Search instead for 
Did you mean: 
sgperam
Participant
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
4 Comments