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?

Accepted Solutions (0)

Answers (1)

Answers (1)

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