topic Re: how to get data in given condition select statement in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155729#M1194363 <HTML><HEAD></HEAD><BODY><P>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....</P></BODY></HTML> Fri, 30 Jan 2009 13:43:56 GMT former_member156446 2009-01-30T13:43:56Z how to get data in given condition select statement https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155728#M1194362 <HTML><HEAD></HEAD><BODY><P>hai friends.</P><P></P><P> i want to fulfill this condition using Outer join on SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN</P><P></P><P>but i do not find any relationship between these the two tables . how to fulfill this condition.</P><P>using this two tables.</P><P></P><P> SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>thanks in advance.</P></BODY></HTML> Fri, 30 Jan 2009 13:10:32 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155728#M1194362 Former Member 2009-01-30T13:10:32Z Re: how to get data in given condition select statement https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155729#M1194363 <HTML><HEAD></HEAD><BODY><P>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....</P></BODY></HTML> Fri, 30 Jan 2009 13:43:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155729#M1194363 former_member156446 2009-01-30T13:43:56Z Re: how to get data in given condition select statement https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155730#M1194364 <HTML><HEAD></HEAD><BODY><P>hi</P><P>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</P><P></P><P> SCMG_T_CASE_ATTR-CASE_TITLE = VBRP-VBELN</P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>thanks in abvance.</P></BODY></HTML> Sat, 31 Jan 2009 10:24:59 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155730#M1194364 Former Member 2009-01-31T10:24:59Z Re: how to get data in given condition select statement https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155731#M1194365 <HTML><HEAD></HEAD><BODY><P>If i understand correctly, you are storing VBRP-VBELN in a text field in table SCMG_T_CASE_ATTR.</P><P></P><P>Either check if the field SCMG_T_CASE_ATTR-CASE_TITLE has the value of VBRP-VBELN with or without leading zeroes.</P></BODY></HTML> Mon, 02 Feb 2009 11:07:41 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-get-data-in-given-condition-select-statement/m-p/5155731#M1194365 Former Member 2009-02-02T11:07:41Z