How to find comments table for header and line item in SAP SRM

[Former Member]

How to find comments table for header and line item in Supplier relationship management.

[edaniel]

Hi,

/SAPSRM/LONGTEXT table stores the longtexts of the business documents.

Best regards,

Daniel

[Former Member]

Hi Daniel,

Thanks for sharing the details.

I am able to see STXH, STXL and STXB but unable to see /SAPSRM/LONGTEXT table.

Below is the screenshot taken from Netweaver Business Client 5.0 for a shopping cart number. I do not see this text in STXH and STXL table but there is column named CLUSTD in STXL table and looks like data is in encoded format.

Could you please confirm if we decode CLUSTD column I will see the text we are seeing in the Netweaver screentshot?

If yes, How to decode this CLUSTD column?

Is it possible to decode this directly in the database?

Screenshot from Netweaver:

Screenshot from Database (STXL table CLUSTD column):

Thanks,

Amrutha

[edaniel]

Hi,

You can get the longtexts of a business document with function module: READ_TEXT in SRM

Input parameters:

ID: you can get it from BBP_PD (TDID). For example: NOTE

LANGUAGE: language of the longtext

NAME: GUID of the item in case of item longtext or the header GUID in case of header longtext

OBJECT: BBP_PD

Tables used to get the longtext:

STXH

STXL

STXB

/SAPSRM/LONGTEXT

Best regards,

Daniel

[Former Member]

Thanks for your reply! But I'm unable to find BBP_PD object. We have access to the SRM backend database and trying to find table responsible for storing comments information on both header and line item level.