Skip to Content
avatar image
-1
Former Member

who (stxl-tdname with tdobject='SCMG_CASE' ca be serch in the table SCMG_T_CASE_ATTR-case_guid

in my work im doing a program this program read all notes fields and search a word between this fields so the programs is good only when i'm trying to search a case i cant to search anymore couse there are difieren long

who stxl-tdname with tdobject='SCMG_CASE' can be searching in the table SCMG_T_CASE_ATTR-case_guid if stxl-tdname has 56 chars and SCMG_T_CASE_ATTR-case_guid has 34 chars

and i dont now who fix it

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    May 11, 2017 at 05:41 PM

    Table :STXL

    TDOBJECT TDNAME TDID TDSPRAS SRTF2

    CRM_ORDERH 005056B478F41ED1A2B4E28BF7F70889 Z030 S 0 157

    Si yo busco esta informacion en la crmd_orderadm_h entonces hago la comparación de la siguiente manera

    crmd_orderadm_h-guid =stxl-tdname y encuentro la información

    si busco el la but000 es

    TDOBJECT TDNAME TDID TDSPRAS

    BUT000 0000000002 0003 S

    La comparacion es la siguiente:

    But000-partner = stxl-tdname

    En el caso de SCMG_CASE

    TDOBJECT TDNAME TDID TDSPRAS

    SCMG_CASE 005056B478F41ED19BF3E69E1B3EE889201203230054414490000 Z002 S

    La comparacion NO puede ser:

    SCMG_T_CASE_ATTR-case_guid = stxl-tdname

    Porque no son los mismos datos y tienen longitudes diferentes sin embargo leyendo en los post

    El stxl-tdname para el scmg-case puedes dividirlo en 3 partes la de enmedio es la fecha de creacion y las otras dos no se que sean

    005056B478F41ED19BF3E69E1B3EE889 20120323 0054414490000

    Fecha de

    Creación

    la primera parte no es un exadecimal reconcible en la SCMG_T_CASE_ATTR

    El problema es ¿que tengo que hacer para comparar el stxl-tdname en SCMG_T_CASE_ATTR-case_guid?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 11, 2017 at 05:44 PM
    el codigo es el siguiente:
    
    form verificadatos using objeto  nombre did pras changing nota texto.
      "****************************FILTRO DE TIPO DE NOTA(TEXT)
       select
         TDSPRAS
         TDOBJECT
         TDID
         TDTEXT
         from TTXIT INTO TABLE it_TTXIT
            where  TDSPRAS = 'S' AND TDOBJECT = OBJETO AND TDID = DID .
         READ TABLE it_TTXIT INTO WA_TTXIT INDEX 1.
         if sy-subrc eq 0.
           CONCATENATE 'TIPO DE NOTA' wa_ttxit-TDTEXT INTO NOTA SEPARATED BY ' '.
         else.
            nota = '  '.
         endif.
     case objeto.
         when 'BUT000'.
    "*****************FILTRO DATOS EN  BUTOOO********************************
               SELECT
                      PARTNER
                       NAME_FIRST
                      NAME_LAST
                      NAME_LST2
                      FROM BUT000 INTO TABLE IT_BUT000
                        WHERE PARTNER = NOMBRE.
                      READ TABLE IT_BUT000 INTO WA_BUT000 INDEX 1.
                      if sy-subrc eq 0.
                    concatenate 'NOM. INTERLOC COM.'wa_BUT000-NAME_FIRST wa_BUT000-NAME_LAST wa_BUT000-NAME_LST2 into texto separated by ' '.
                       ELSE.
                      ENDIF.
         when 'CRM_ORDERH'.
               select
                     guid
                     object_id
                     process_type
                     description
                     from CRmD_ORDERADM_H into table   IT_ORDERH
                     where guid = nombre.
                      READ TABLE IT_ORDERH INTO WA_ORDERH INDEX 1.
                      if sy-subrc eq 0.
                      concatenate 'ID. OPER. COM.' wa_ORDERH-object_id  'TIPO OPER.'  wa_ORDERH-process_type 'DESCIPCION'wa_ORDERH-description into texto separated by ' '.
                      else.
                      endif.
         when 'SCMG_CASE'.
               select
                   case_guid
                   case_type
                   ext_key
                   case_title
              from SCMG_T_CASE_ATTR into table IT_SCMG_T_CASE_ATTR
                 where case_guid = nombre.
                     READ TABLE IT_SCMG_T_CASE_ATTR INTO WA_SCMG_T_CASE_ATTR INDEX 1.
                     if sy-subrc eq 0.
                       concatenate 'TIPO DE CASO' wa_SCMG_T_CASE_ATTR-case_type  'NO. OPER' wa_SCMG_T_CASE_ATTR-ext_key 'DESCRIP.'wa_SCMG_T_CASE_ATTR-case_title into texto separated by ' '.
                     else.
                     endif.
         when 'CRM_ORDERI'.
         when 'PRODUCT'.
         when  'TEXT'.
     endcase.
    
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 10, 2017 at 02:30 PM

    Hello Luis,

    Have you found how to connect these two tables? I currently have the same issue that the first part of TDNAME in STXL and STXH does not match with CASE_GUID from SCMG_T_CASE_ATTR.

    Regards,

    Add comment
    10|10000 characters needed characters exceeded