Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

writing alias query with casting

Dear Experts,

i want to excute a query which have a condition that needs some casting. the table is MSEG the users are entering the reffrencing article document in the item text field. now all i need is to excute a query which have the mseg aliased and the joining condition should be mblnr with sgtxt

i imagine it should be something like this

select * from recmseg,supmseg where supmseg.mblnr=cast(recmseg.sgtxt as blnr)

recmseg is alias mseg for the recieving site

supmseg is alias Mseg for suplying site

so please can you tell me where i can write it and how to excute it and correct the syntax also

Former Member
Not what you were looking for? View more on this topic or Ask a question