Skip to Content
-1

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

May 10, 2017 at 05:40 PM

67

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded

Could you please paste the portion of your code which has an issue? Sorry, but I don't get exactly your issue, so the ABAP code will help.

0

Please add a comment repeating your question in your own language.

1
* Please Login or Register to Answer, Follow or Comment.

3 Answers

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

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?

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 11, 2017 at 05:44 PM
0
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.
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Nov 10, 2017 at 02:30 PM
0

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,

Share
10 |10000 characters needed characters left characters exceeded