Need to where "internal note" "supplier note/text" are stored

[Former Member]

Hi,

I need to know in which table /FM these values are stored ? like "internal note" than item wise we have some others like "Suppliers note/ other text " etc

Thanks and regards

Harish

[Former Member]

Hi harish,

Did u got to know in which table this internal note gets stored .

Please let me know .

Regards,

Savitha

[Former Member]

Hi. They are stored in STXH and STXL I think.

STXH stores the header, the information that links the text to the shopping cart / PO or whatever.

STXL stores the actual text, however is is in hex, so you need to use function READ_TEXT to get the text out.

Regards,

Dave.

[Former Member]

Any other answers please?

[Former Member]

Hi. Use function READ_TEXT.

ID = type of text, check table STXH to work out the name of each text, it changes by release sometimes so I can't tell you

NAME = the GUID of your shopping cart

OBJECT = BBP_PD

Then tbale LINES will have all your text.

Regards,

Dave.

Edited by: David Barber on Jun 3, 2009 11:31 AM - Ccorrected Table name

[Former Member]

Hi ,

Run Function Module 'BBP_PDLTX_GETDETAIL' with the Guid of the Shopping cart, BID, PO etc.

this will return all the associated text in the Business Object .

Tables: STXH can be of help

Regards,

Sapna