Adress specific values in a table


#1

Hello everyone,

I would like to know if it is possible to adress a specific value in a table (not the first, last, max, or anything else).
For example:
I have the table VBEP and the field ETENR. For an order position I can have different delivery schedule line numbers. I’m only interested in the first schedule line with a confirmed quantity >0.
Has someone an idea how I can adress this problem? Check whether the quantity is >0, if not, go to the next schedule line with a quantity > 0

Best Regards,

Friedemann


#5

Dear Friedemann,

Thanks for your question. PU functions allow you to set a filter. In your case we suggest you use:

PU_FIRST(“VBAP”, “VBEP”.“ETENR”, “VBEP”.“BMENG”>0)

This will give you the first Delivery Schedule Line Number with Confirmed Quantity greater than 0 for each Order Position.

Best,
Viana