avoid the -1 (which causes the Not NULL preserving effect) by aggregating positive and negative values separately (which also make aggregation much faster):define view Z_P_POITEMIRCALC2a
as select from I_PurchaseOrderHistory
{
PurchaseOrder,
Pu...
I am not sure what you want to do.
Do you need a where condition that matches both emtpy values and some given value? That would be ... ( WERKS = ‘4797’ OR WERKS = ' ' )
Or do you want to know how to fill a selection table with this condition? Th...
I am not an expert for SQL Script. But what I sometimes hear, is that sequential code like your WHILE loop prevents optimization. Also ensure that your AMDP is marked with OPTIONS READ-ONLY.Regards, Thomas
