select statement

[Former Member]

hi all,

please write a select query for the following description.

A1

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

A2

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

A3

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

[JanStallkamp]

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