UNION DE OWOR A WOR1 COMENTARIOS

[former_member956186]

Hola realice una consulta pero la verdad es que no me esta extrayendo los comentarios de la tabla WOR1 a OWOR y la query es la siguiente : alguien me podrá ayudar .

Select distinct A.DocEntry, A.DocNum, A.CreateTS, A.Uom, B.U_LOTE, U_PIEZAS, A.PostDate'FECHA OP',A.CardCode,L.CardName 'NOMBRE CLIENTE',

A.OriginNum 'NUMERO DE PEDIDO',A.Type 'TIPÓ DE OT',A.Status,A.CmpltQty,A.OriginNum,

A.StartDate'FECHA INICIO', A.DueDate'FECHA FIN', J.ItmsGrpNam, E.U_NAME,

K.SeqNum,K.StageId, K.Name,

A.ItemCode, A.ProdName, I.FirmName, H.SWW, H.SWeight1, A.PlannedQty,

B.ItemCode'MAT PRIM',D.ItemName,B.BaseQty,B.PlannedQty, B.wareHouse ,D.InvntryUom, N.Address2,

N.NumAtCard,A.Comments, A.U_Dibujo,

A.U_AlmDestino,

B.ItemCode, B.ItemType, B.BaseQty,B.BaseQtyDen,B.BaseQtyNum,A.U_ShopOrder, B.U_Comentarios

from OWOR A

INNER JOIN WOR1 B ON A.DocEntry = B.DocEntry

LEFT JOIN OBTN C ON A.ObjType = C.ObjType

LEFT JOIN OITM D ON B.ItemCode = D.ItemCode

INNER JOIN OUSR E ON A.UserSign = E.USERID

inner JOIN OMRC F ON D.FirmCode = F.FirmCode

INNER JOIN OITB G ON D.ItmsGrpCod = G.ItmsGrpCod

left JOIN OITM H ON A.ItemCode= H.ItemCode

LEFT JOIN OMRC I ON H.FirmCode = I.FirmCode

INNER JOIN OITB J ON H.ItmsGrpCod = J.ItmsGrpCod

LEFT JOIN ITT2 K ON A.ItemCode=K.Father

LEFT JOIN OCRD L ON A.CardCode=L.CardCode

LEFT JOIN ORDR N ON A.OriginAbs=N.DocEntry

--inner join WOR1 ON A.Comments = B.U_Comentarios

where K.SeqNum='1'

[moshenaveh]

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. Second, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community.

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

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always helps our members better understand your problem.

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

The more details you provide (in questions tagged correctly), the more likely it is that members will be able to respond.

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