Skip to Content
avatar image
Former Member

CRMD_Order Tables for Notes and Reason

Hello Experts,

Could you help me to find out the tables used for storing the

1. Reason field and its corresponding codes.

2. Log (Internal Notes)

For reading the text, I am following the link Table for Notes section in CRMD_ORDER transc but READ_TEXT FM is not working with GUID. It is taking TDNAME as "GUID + <Some text which includes Date>".

Pointers towards this will be a advantages to us.

Thanks in Advance,

Prashant

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 26, 2011 at 12:03 PM

    Hello, Prashant.

    READ_TEXT function module is definetly what you need to get text for order.

    Import parameters should be:

    ID = text id (A002, A003 etc)

    NAME = object GUID

    OBJECT = 'CRM_ORDERH'

    You can check this putting a breakpoint at the beggining of READ_TEXT and entering an order wich has some text.

    Regarding reasons... If you don't need direct table access to them it's better to use FM CRM_ORDER_READ (by the way, it returns texts too in et_text) for getting desired information. It returns only what you ask for. Reasons too.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 17, 2014 at 09:41 AM

    General Procedure to retrieve Transaction specific Text  notes  ( ex Order/Leads/Opportunity/service request etc ).

    Step1: get the "Transaction Guid" (ex Lead) from  from the table "crmd-orderadm_h".

    Step2: Enter the "Transaction Guid" of (step1) ,under the field "Text Name" along with other parameters as shown in example in the table "STXL" in order to retrieve Text Guid.

    note: based upon the number of text types defined ,we will get "n" of Text Guids.

    example:

    ZLD1-lead specific text

    Text object     CRM_ORDERH (SAP Standard for transactions)

    Text Name     E83935A924381ED3A (Transaction Guid)

    Text ID          Lead (you can get Text ids details from the text management as per your project)

    Language       EN.

    Step3: Enter the "Text Guid" in the function module "READ_TEXT" (use T-code SE37) along with other parameters as shown in below example to get Transaction specific long text.

    example

    CLIENT                          XXX

    ID                                  Lead

    LANGUAGE                   EN

    NAME                            E83935A924381AD3AACD46D9E5A45ZXC

    OBJECT                        CRM_ORDERH.

    Result:

    *  Lead is from SAP golden customer,contact asap.

    Add comment
    10|10000 characters needed characters exceeded