Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

query for item #, lot #, exp. date, specific vendor

0 Kudos
306
  • SAP Managed Tags:

Hey hey,

Is there a way to build a query that shows all of these fields?

Below is what I have:

SELECT DISTINCT T0."ItemCode", T0."itemName", T0."DistNumber" as "SynergyLabs Lot #", T0."MnfSerial" as "Vendor Lot #", T0."ExpDate"

FROM OBTN T0 INNER JOIN OITM T1 ON T0."ItemCode" = T1."ItemCode" INNER JOIN ITL1 T2 ON T1."ItemCode" = T2."ItemCode"

1 REPLY 1

moshenaveh
Community Manager
Community Manager
0 Kudos
231
  • SAP Managed Tags:

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!