Hi,
I am having a problem with a formatted search in SAP B1 Hana
Table OPOR, I have a UDF TRX_Expired
Table POR1, I have a UDF TRX_Expired
I need a formatted search in OPOR to populate TRX_Expired with "Item Expired" if any lines in POR1 TRX_Expired = "Item Expired"
Example 1
OPOR
DocNum TRX_Expired
1234 Item Expired (1 item in 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 straight forward, but I am getting weird errors
Any help will be appreciated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.