Skip to Content

HOW TO MAKE FILED MANDATORY ON BATCH TABLE

Dear Expert,

I want to make stored procedure for the Batch number.

In Batch Number Details field (OIBT.UNE_LNWT) is mandatory.

I use following stored procedure but it's not working.

1.HANA

IF :Object_type = '10000044' THEN
dECLARE temp_var_0 integer;
SELECT
(SELECT t0."AbsEntry"
FROM OBTN T0
WHERE (T0."U_UNE_LGWT" IS NULL OR T0."U_UNE_LGWT" = '0,000000') AND
t0."AbsEntry" = :list_of_key_cols_tab_del) INTO temp_var_0 FROM DUMMY;
IF :temp_var_0 > 0 THEN
SELECT 1, 'Loose Gross Wt. per batch is must' INTO ERROR, error_message FROM DUMMY;
END IF;
END IF;

2.HANA

IF :object_type = '59' THEN
dECLARE temp_var_0 integer;
SELECT
(SELECT T0."BatchNum"
FROM OIBT T0
WHERE T0."U_UNE_LGWT" is null AND T0."BaseEntry" = :list_of_cols_val_tab_del) INTO temp_var_0 FROM DUMMY;
IF :temp_var_0 > 0 THEN
error := 10;
error_message := n'Loose Gross Wt. per batch is must';
END IF;

END IF;

DaNish

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers