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.
Showing results for 
Search instead for 
Did you mean: 

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

0 Kudos

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"

  • SAP Managed Tags:

Community Manager
Community Manager
0 Kudos

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, 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 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:

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

  • SAP Managed Tags: