Formatted Search Help

1 month ago 16

Hi,
I americium having a occupation with a formatted hunt successful SAP B1 Hana

Table OPOR, I person a UDF    TRX_Expired
Table POR1, I person a UDF     TRX_Expired
I request a formatted hunt successful OPOR to populate TRX_Expired with "Item Expired" if immoderate lines successful POR1 TRX_Expired = "Item Expired"

Example 1
     OPOR
     DocNum       TRX_Expired
     1234             Item Expired  (1 point successful POR1 has the wording Item Expired)
     POR1
     DocNum        Item Code   TRX_Expired
     1234              ABC1            (Empty)
     1234              ABC2            Item Expired

Example 2
     OPOR
     DocNum       TRX_Expired
     1234             (empty)
     POR1
     DocNum        Item Code   TRX_Expired
     1234              ABC1           (Empty)
     1234              ABC2           (Empty)

It seems consecutive forward, but I americium getting weird errors
Any assistance volition beryllium appreciated.

Read Entire Article