Skip to Content
0
Sep 19, 2016 at 11:42 PM

SAP BO 9.0 - Shipping Type Query

22 Views

Hello SAP Gurus,

I'm not sure how to make this query show the Shipping Type in full name.

ex. "UPS 2 Day" instead of the Shipping Type number "3".

Here is the query:

SELECT T0.[CardCode], T0.[CardName], T0.[DocDate] AS [Invoice Date], T0.[NumAtCard] AS [PO Number], T0.[DocNum] AS [Invoice No.], T0.[TrnspCode], T0.[TrackNo]

FROM OINV T0

INNER JOIN INV1 T1 ON T0.[DocEntry] = T1.[DocEntry]

WHERE T0.[DocDate] >= [%0]

AND T0.[DocDate] <= [%1]

AND T0.[CardCode] = 'C000156'