Skip to Content
0
Jul 05, 2016 at 06:40 AM

SAP B1 Query

25 Views

Dear Sir/Mam

Please help me to fix this query, what is wrong with this, i am so sory iam new with regards to queries...

SELECT (T1.OcrCode )

set T0.U_FeederVessel = T1.[OcrCode]

FROM OINV T0 INNER JOIN INV1 T1 ON T0.DocEntry = T1.DocEntry

WHERE T0.DocNum = $[$8.0.0]

Group by T1.OcrCode

All i want for e.g. i have a value from INV1.OcrCode for example "AAA" then i want it to set this value into UDF "FeederVessel"

thank you

regards

Silent