Request and link table

[former_member766606]

Hello, I'm trying to get my special rates up with my request, only I can't find the link that allows to link the OCDR table to the EDG1 table for the moment my request is this:

SELECT OITM.ItemCode, OITM.ItemName, OITM.CodeBars, OITB.ItmsGrpNam, OITW.WhsCode, OITW.OnHand, OITW.OnOrder as 'Purchase order', OITW.IsCommited as 'customer order',

((OITW.OnHand + OITW.OnOrder) -ISNULL ((SELECT SUM (Quantity) from RDR1 where CodeBars = OITM.CodeBars And LineStatus = 'O' and OITW.WhsCode = '01' and Shipdate between GETDATE () and DATEADD ( DAY, 21, CAST (GETDATE () AS DATE))), 0.00)) as 'Virtual Available',

(

SELECT T0.Discount FROM OCRD T0

LEFT JOIN OEDG ON T0.CardCode = OEDG.ObjCode

LEFT JOIN EDG1 ON EDG1.AbsEntry = OEDG.AbsEntry

WHERE T0.CardCode = OITM.CardCode

) as 'Price List Special Prices 2'

FROM [dbo]. [OITM] OITM

INNER JOIN [dbo]. [OITW] OITW ON OITM.ItemCode = OITW.ItemCode

INNER JOIN [dbo]. [OITB] OITB ON OITM.ItmsGrpCod = OITB.ItmsGrpCod

INNER JOIN [dbo]. [OCRD] OCRD ON OITM.CardCode = OCRD.CardCode

WHERE OITW.WhsCode = '01 'and OITW.Locked =' N 'and OITM.QryGroup24 =' Y '

I can't get my rates up

I need help

[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.