cancel
Showing results for 
Search instead for 
Did you mean: 

TDS

Former Member
0 Kudos

Hi

Any Body share TDS Query in SAP Business one.

Gopi

Accepted Solutions (0)

Answers (3)

Answers (3)

KennedyT21
Active Contributor
0 Kudos

Close the Thread with the correct and helpful answers

Regards

Kennedy

KennedyT21
Active Contributor
0 Kudos

Check this one for the detailed one

SELECT T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName], T2.[BaseAmnt], T4.[Rate], T4.[WTAmnt], T0.[BSRCode], T0.[ChallanNo], T1.[DueDate], T1.[CheckNum], T1.[CheckSum] FROM OVPM T0  INNER JOIN VPM1 T1 ON T0.DocEntry = T1.DocNum INNER JOIN OPCH T2 ON T0.DocEntry = T2.DepositNum INNER JOIN PCH1 T3 ON T2.DocEntry = T3.DocEntry INNER JOIN PCH5 T4 ON T2.DocEntry = T4.AbsEntry GROUP BY T2.[DocNum], T0.[DocDate], T2.[CardCode], T2.[CardName], T4.[WTAmnt], T1.[DueDate], T1.[CheckNum], T1.[CheckSum], T0.[BSRCode], T0.[ChallanNo], T2.[BaseAmnt], T4.[Rate]


Regards

Kennedy

KennedyT21
Active Contributor
0 Kudos

Hi Gopinath...

Try this one

select T0.DocNum, T0.DocDate, T0.CardName, T0.DocTotal, T0.WTSum,T2.WTName, T1.Rate from opch T0

inner join pch5 T1 on T0.Docentry=T1.Absentry

inner join owht T2 on T1.WTcode=T2.WTCode

Regards

Kennedy