how to get data in given condition select statement

[Former Member]

hai friends.

i want to fulfill this condition using Outer join on SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN

but i do not find any relationship between these the two tables . how to fulfill this condition.

using this two tables.

SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN

thanks in advance.

[Former Member]

hai friends.

i want to fulfill this condition using Outer join on SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN

but i do not find any relationship between these the two tables . how to fulfill this condition.

using this two tables.

SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN

thanks in advance.

[former_member156446]

CASE_GUID is a unique key for the case... you need to use that and find a place where you find it and then think of linking to VBRP.... GUID is like the OBJNR for matnrs and aufnrs....

[Former Member]

hi

i am not able to understand, could u pls explain me in detail, so tat it will be crystal clear for me to map these tables

SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN

thanks in abvance.

[Former Member]

If i understand correctly, you are storing VBRP-VBELN in a text field in table SCMG_T_CASE_ATTR.

Either check if the field SCMG_T_CASE_ATTR-CASE_TITLE has the value of VBRP-VBELN with or without leading zeroes.