Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ATP Bloqueo de Acceso!!

ESTIMADO FORO,

EN VERDAD NECESITO DE SU APOYO PARA BLOQUEAR A TODOS EXCEPTO A MANAGER PARA EL ACCESO A ESTA VENTANA.

CANTIDAD ATP.

MUCHAS GRACIAS

replied

Prueba lo siguiente

if @object_type='13' and @transaction_type='A'

begin

    declare @Item nvarchar(20)

    set @Item=(select top 1 T0.ItemCode from INV1 T0 where T0.DocEntry=@list_of_cols_val_tab_del and T0.Quantity>(select T1.OnHand-T1.IsCommited+T0.Quantity from OITW T1 where T1.ItemCode=T0.ItemCode and T1.WhsCode=T0.WhsCode))

    if @Item is not null

    begin

        select @error=1710, @error_message='El Articulo '+@Item+' no tiene stock suficiente'

        --goto EndTr

    end

end

Atte.

1 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question