Tables related customer text

[Former Member]

Dear all,

Wat are the tables related to customer texts.

I have maintained text for the customer and want to fetch the data fro m the table so iam enable to.

so please provide the information.

Thanks

[Former Member]

Hi Sameer,

Customer text is not resident in any table that you can read

readily in a query. It is possible to add it if you have some

ABAP skills. Create an Extra field and insert the READ_TEXT

function module. Multiple lines of text are difficult to deal

with, but when you loop through the LINES table (populated by

the function module) you can concatenate the lines. As I said,

some ABAP skills are required to make this work.

If you are an ABAPer then you can follow what our friends said to you.

pls have a look at this..

http://fuller.mit.edu/SAPDocs/sap_long_text.html

http://sap.ittoolbox.com/groups/technical-functional/sap-log-sd/tables-for-sap-query-1227446

If you want anymore clarity on this , pls contact us .we are happy to help you.

Regards,

Viveks

[Former Member]

Hi,

The text in customer will be stored in SAP script. This can viewed by executing FUNCTION MODULE(FM)

goto --> SE37 -> enter READ_FILE->

ID = 0001(depends where u entered the text)

LANGUAGE = EN

NAME = customer code

OBJECT = KNA1 (Central text) KNVK (Contact person text)

KNVV(sales text)

Execute

below u will find RESULT column with number of enteries---> double click u will find the text which u have entered

hope this helps u

Edited by: arun prasad on Jun 17, 2008 11:54 AM

[Former Member]

I think your only available option is to use the Function Module READ_TEXT.

Maintain ID=0002

Language

Name= sales order number prefixed with four zeroes

object= KNA1

Please let us know if it helps.

Regards

Basavaraj

[Former Member]

Hi

you can fetch the customer texts defined in customers via using function module 'READ_TEXT' using Tcode SE37

and pass the following parameters

CLIENT: -

ID: - Text id defined

LANGUAGE: - EN

NAME: -

OBJECT: -

Reward points if helpful

Regards,

Nimit