Why is this *validating*?
SELECT SBOOK.MANDT, SBOOK.AGENCYNUM,
SUM (SBOOK.FORCURAM) AS FORCURAM,
FORCURKEY, NAME, COUNTRY, CURRENCY
FROM SYSTEM.SBOOK, SYSTEM.STRAVELAG
WHERE SBOOK.AGENCYNUM = STRAVELAG.AGENCYNUM
AND SBOOK.MANDT = STRAVELAG.MANDT
GROUP BY SBOOK.MANDT, SBOOK.AGECYNUM,
FORCURKEY, NAME, COUNTRY, CURRENCY;
but not *activating*?
2011-11-04 13:51:13 679Create Table Type DDL: create type “_SYS_BIC”.”xxxx/SC_AGENCY_REV/proc/tabletype/VAR_OUT” as table (“MANDT” NVARCHAR(3), “AGENCYNUM” NVARCHAR(8), “FORCURAM” FLOAT(0), “FORCURKEY” NVARCHAR(5), “NAME” NVARCHAR(25), “COUNTRY” NVARCHAR(3), “CURRENCY” NVARCHAR(5))
2011-11-04 13:51:13 679Create Table Type failed: SQL: sql syntax error: out of range: the number must be a value between 1 and 53 2011-11-04,10:51:09.543
SAP Consultant, needs help regarding “this sql won’t run “