SAP B1 ‘de Duran varlık kartında masraf yerleri boş geçilemesin kontrolü

IF :object_type = '4' AND :transaction_type IN ( 'U','A')

then

select count(*) into cnt

FROM OITM T0

LEFT JOIN ITM6 T1 ON T0."ItemCode" = T1."ItemCode"

WHERE

T0."ItemType" = 'F'

AND (T1."OcrCode"='' OR T1."OcrCode" is null) and ( T1."OcrCode2"='' OR T1."OcrCode2" is null)

AND T0."ItemCode"=:list_of_cols_val_tab_del;

if :cnt > 0 then

error := -111;

error_message := N'[HATA 21-01] Duran varlık masraf yerleri boş geçilemez!';

END if;

END if;