Skip to Content

Get text TDNAME from CASE GUID (FSCM dispute managment)

Hi SAP professionals,

Can someone tell me, how do I find the TDNAME value for texts associated with dispute cases, if I have the case guid?

Case GUID can be gotten from FDM_DCOBJ-CASE_GUID_LOC or UDM_COLL_ITEMCAS-CASE_GUID. These give the same value. However I have not found a link from case guid to the corresponding TDNAME value, which is very close but not exactly the same.

Is there a table that links these values?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 08 at 08:21 AM

    Please check this other thread: https://archive.sap.com/discussions/thread/133954

    I would highlight this answer:

    "John Flynn replied:

    To read the texts for a Dispute case you can use function module BDM_DISPUTE_NOTES_GET.

    To use it just pass the GUID of the case. It will return the Notes in and internal table. You can then loop through that itab and read the text lines.

    There are more functions related to Dispute cases in function group DISPUTE."

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Pablo, thank you for your response. I am aware of the function module. I am looking for how to retrieve text for several cases via a SQL statement. So, I am looking for the table names and how they are linked.

  • Mar 05 at 08:07 AM

    Use FM BAPI_CASE_GETNOTES (function group SCMG_BAPI_CASE).

    Enter the GUID as Import parameter.

    Export parameters will return under NOTE_HEADERS, field TDNAME that you're looking for.

    Hope this helps.

    Georgios Sofianos

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 30 at 05:10 PM

    Hi,

    Yeahh, i also wanted to investigate the data model and create some CDS views, but so far it's not that easy.

    I have created a Z-table which is updated form CASE save BADI.

    Anyway the CASE <> TEXT links are the following (in my case):

    Table: SCMG_T_CASE -> Field: NOTE_PDIR

    CASE_GUID 0894EF0801901ED799C1DFB44E911D67

    NOTE_PDIR 0894EF0801901ED799C1FFB27AC87DE4


    Table: SCMGPDIR -> Field: POIDSTR

    POIDID 0894EF0801901ED799C1FFB27AC87DE4

    POIDSTR CRM_SPS_CASE_NOTES||RMS_ID|CRM_CMG_DATA||GUID|0894EF0801901ED799C1DFB44E913D67


    Table: STXH -> Field: TDNAME

    STXH-> TDNAME LIKE 0894EF0801901ED799C1DFB44E913D67%

    Maybe this helps somehow.... Someone...

    BR, Dima

    Add comment
    10|10000 characters needed characters exceeded