Skip to Content
0
Sep 02, 2020 at 03:24 AM

SAP BI query

230 Views

Hello all,

I am writing a query to display the Landed Cost Number, Posting Date, Actual Customs, Shipping Amount, Inland Freight, Others.

SELECT

T0.[DocNum], T0.[DocDate], T0.[ActCustom]

FROM

OIPF T0 INNER JOIN IPF2 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OALC T2 ON T1.[AlcCode] = T2.[AlcCode]

WHERE

T2.[AlcCode] IN ('Shipping','Inland Freight', 'Others')

Please help me correct the above query.

The tables used are OIPF, IPF2, OALC in that order in query generator.

How can I disply the Shipping Amount, Inland Fright Cost, and Others Cost?