Hi all,
I am trying to do a formatted search to select a cost center depending on the customer's business property selected. In this case, the customer cannot have more than one property selected as per company policy.
The formatted search is to be done on the RCT2 table (row of incoming payment). Here is the query I have (we use HANA):
SELECT CASE WHEN T0."QryGroup1" = 'Y' THEN 'ARG'
WHEN T0."QryGroup10" = 'Y' THEN 'BRA'
WHEN T0."QryGroup16" = 'Y' THEN 'DEU'
WHEN T0."QryGroup17" = 'Y' THEN 'POL'
WHEN T0."QryGroup18" = 'Y' THEN 'ROU'
WHEN T0."QryGroup19" = 'Y' THEN 'ESP'
WHEN T0."QryGroup2" = 'Y' THEN 'CHI'
WHEN T0."QryGroup20" = 'Y' THEN 'PRT'
WHEN T0."QryGroup21" = 'Y' THEN 'ITA'
WHEN T0."QryGroup3" = 'Y' THEN 'USA'
WHEN T0."QryGroup4" = 'Y' THEN 'UK'
WHEN T0."QryGroup5" = 'Y' THEN 'COL'
WHEN T0."QryGroup6" = 'Y' THEN 'MEX' ELSE 'UK' END
FROM OCRD T0 INNER JOIN ORCT T1 ON T0."CardCode" = T1."CardCode"
INNER JOIN RCT2 T2 ON T2."DocNum" = T1."DocEntry"
WHERE T0."CardCode" = $[$5.0.0]
If I do not include the "WHERE TO", the query runs, but I need this "WHERE TO" so the query looks at the customer selected in the current document. This does not work if I do $[ORCT."CardCode"] either (even if I remove the quotation marks as well).
Is my WHERE TO part of the query wrong? Thanks!