cancel
Showing results for 
Search instead for 
Did you mean: 

NOT LESS THAN(!<) SIGN NOT WORKING STORED PROCEDURE

eonsase
Participant
0 Kudos

Not less than sign (!<) not working in my stored procedure, Kindly assist as the attached output.

IF (:transaction_type = ('A') OR :transaction_type = ('U')) AND :object_type = '17' THEN

cnt := 0;

select count(*) into cnt from ORDR T0

INNER JOIN RDR1 T1 ON T1."DocEntry"= T0."DocEntry"

where T1."Quantity" !< T1."U_MoQ" AND T0."DocEntry"= :list_of_cols_val_tab_del ;

IF :cnt > 0 THEN

error := 106;

error_message := 'OTL_SCL;Quantity cannot be 0';

END IF;

END IF;

Ryan-Crosby
Active Contributor

If it's "not less than", then doesn't that imply you could use "greater than or equal to" as an alternative?

View Entire Topic
fedaros
Advisor
Advisor
0 Kudos

Hi Ernest,

!< does not exist. You can express same it with possibilites from documentation https://help.sap.com/docs/SAP_HANA_PLATFORM/4fe29514fd584807ac9f2a04f6754767/20a380977519101494ceddd...

Regards, Fernando Da Rós