topic Coding in SAP Query in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/coding-in-sap-query/m-p/2817582#M658951 <HTML><HEAD></HEAD><BODY><P>Dear Experts</P><P></P><P>I have a requirement in which I have to fetch some fields from VBAP and LIPS tables using SAP query based on a condition VBAP-VBELN = LIPS-VGBEL and VBAP-POSNR = LIPS-VGPOS. I have developed a query for the same and its working but we have a additional requirement like If more than one delivery are done for one item of SO, it is required to sum the delivery qty for the same sales order and item and then get the open qty report outside SAP system.It can be done through coding but please can any one suggest me the steps how to go about it.Thanks in advance.</P><P></P><P>Regards,</P><P>Sangram</P></BODY></HTML> Thu, 20 Sep 2007 06:55:40 GMT Former Member 2007-09-20T06:55:40Z Coding in SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/coding-in-sap-query/m-p/2817582#M658951 <HTML><HEAD></HEAD><BODY><P>Dear Experts</P><P></P><P>I have a requirement in which I have to fetch some fields from VBAP and LIPS tables using SAP query based on a condition VBAP-VBELN = LIPS-VGBEL and VBAP-POSNR = LIPS-VGPOS. I have developed a query for the same and its working but we have a additional requirement like If more than one delivery are done for one item of SO, it is required to sum the delivery qty for the same sales order and item and then get the open qty report outside SAP system.It can be done through coding but please can any one suggest me the steps how to go about it.Thanks in advance.</P><P></P><P>Regards,</P><P>Sangram</P></BODY></HTML> Thu, 20 Sep 2007 06:55:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/coding-in-sap-query/m-p/2817582#M658951 Former Member 2007-09-20T06:55:40Z Re: Coding in SAP Query https://community.sap.com/t5/application-development-and-automation-discussions/coding-in-sap-query/m-p/2817583#M658952 <HTML><HEAD></HEAD><BODY><P>My opinion is that you should write a report program from scratch and not use ABAP query. ABAP query generates code which is not very efficient if you start to add your own code.</P></BODY></HTML> Thu, 20 Sep 2007 07:03:53 GMT https://community.sap.com/t5/application-development-and-automation-discussions/coding-in-sap-query/m-p/2817583#M658952 Former Member 2007-09-20T07:03:53Z