Ayuda, habrá algún Query para visualización de llamadas de servicios y serie de artículos?

[rcalderon26]

Soy nuevo en la comunidad y en SAP, Quiero realizar un reporte de una llamada de servicio, que contenga los materiales que he utilizado en esa llamada de servicio y adicional que en los materiales o artículos me muestre su numero de serie, he tratado de muchas maneras pero no logro dar con el informe adecuado. He usado las Tablas OSCL, OITM y OSRN para las serie, me refleja datos nulos

[former_member751591]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A , as it provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a picture to your Profile you encourage readers to respond.

[rcalderon26]

SELECT T0."customer", T1."ItemCode" ,T1."ItemName",T0."U_HG_SOT", 
--(SELECT T2."DistNumber" FROM OSRN T2 INNER JOIN OITM T1 ON T2."ItemCode" = T1."ItemCode" ),
--WHERE T2."ItemCode" = T0."ItemCode"),
T3."ItemCode", T3."Dscription", T3."Quantity", T4."DocNum", T4."Printed", 
T3."ItemCode", T3."Dscription", T3."Quantity", T4."InvntSttus" 

FROM OSCL T0 
LEFT JOIN OITM T1 ON T0."itemCode" = T1."ItemCode" 
LEFT JOIN OSRN T2 ON T1."ItemCode" = T2."ItemCode" 
LEFT JOIN DLN1 T3 ON T1."ItemCode" = T3."ItemCode" 
LEFT JOIN ODLN T4 ON T3."DocEntry" = T4."DocEntry" 
WHERE T0."DocNum" = 6187