2023 Jul 20 8:27 AM
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"
2023 Jul 20 8:27 AM
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!