select statement

Former Member — Mon, 23 Jun 2008 11:05:37 GMT

hi all,

please write a select query for the following description.

Go to CDPOS and pass OBJECTID where EINE-INFNR=OBJECTID. Get the CHANGENR where TABNAME=EINE and FNAME=NETPR and get VALUE_NEW

Go to CDHDR and pass OBJECTID where EINE-INFNR=OBJECTID. Get the CHANGENR based on the UTIME. Ascend UTIME and get the CHANGENR last but one. Pass the CHANGENR to CDPOS, get VALUE_NEW where FNAME=NETPR

Go to CDHDR and pass OBJECTID where EINE-INFNR=OBJECTID. Get the CHANGENR based on the UTIME. Ascend UTIME and get the last CHANGENR. Pass the CHANGENR to CDPOS, get VALUE_NEW where FNAME=NETPR

thanks & regards

Suprith

Re: select statement

JanStallkamp — Mon, 23 Jun 2008 11:14:22 GMT

Hi.

Please open an ABAP editor, type SELECT and press F1. You will get all the information you need to do this task. If there any questions left after reading the documentation feel free to come back to the forums and explain your issue.

Best regards,

Jan Stallkamp

topic select statement in Application Development and Automation Discussions

select statement

Re: select statement