05-10-2017 6:40 PM
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
05-10-2017 8:10 PM
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.
05-10-2017 8:21 PM
Please add a comment repeating your question in your own language.
05-11-2017 6: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?
05-11-2017 6: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.
11-10-2017 2: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,