Skip to Content
author's profile photo Former Member
Former Member

Tables related customer text

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:27 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:38 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 09:53 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 10:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.