cancel
Showing results for 
Search instead for 
Did you mean: 

Query ventas por artículo y vendedor con error SAP BO

0 Kudos
83

Amigos, hice una query de ventas por artículo y por rango de fecha, pero al ejecutar me trae 28 veces cada línea de artículo vendido, ¿me podrían ayudar a solucionarlo?

SELECT T1.“FolioPref”, T1.“FolioNum”, T1.“LicTradNum”, T1.“CardCode”, T1.“CardName”, T1.“DocDate”, T5.“SlpName”, T0.“ItemCode”, T0.“Dscription”, T0.“Quantity”, T0.“StockPrice”, T0.“PriceBefDi”, T0.“GrssProfit” FROM INV1 T0 INNER JOIN OINV T1 ON T0.“DocEntry” = T1.“DocEntry” INNER JOIN OCRD T2 ON T0.“BaseCard” = T2.“CardCode” INNER JOIN ORIN T3 ON T2.“CardCode” = T3.“CardCode” INNER JOIN RIN1 T4 ON T3.“DocEntry” = T4.“DocEntry” INNER JOIN OSLP T5 ON T0.“SlpCode” = T5.“SlpCode” WHERE T0.“DocDate” >=[%0] AND T0.“DocDate” <=[%1]

Gracias!!

lenastodal
Product and Topic Expert
Product and Topic Expert
0 Kudos

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: https://community.sap.com/resources/questions-and-answers, 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 at: https://developers.sap.com/tutorials/community-qa.html. 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: https://www.youtube.com/watch?v=46bt1juWUUM

Accepted Solutions (0)

Answers (0)