FMS pulling Free Text from Blanket Order to PO

[former_member813554]

Experts,

I created this FMS query to pull the Blanket Purchase Order Free Text (Line) to the PO Line Free Text field.

It seems to fail on lines where the Blanket Order Planned QTY and Open QTY is equal - meaning that that line was not yet copied to a PO. Here my thinking of using POR1 might be flawed...

SELECT T1."FreeTxt"

FROM 
POR1 T0  
LEFT OUTER JOIN OAT1 T1 ON  T0."ItemCode" = T1."ItemCode" AND T0."AgrNo" =  T1."AgrNo"

WHERE T0."ItemCode" = $[POR1."ItemCode"]<br>

Your assitance will be greatly appreciated,

Marli Schutte

[LoHa]

Hi Marli,

you have to go from POR BlanketAgreement to OOAT and then to OAT1

I'am not familiar with HANA perhabs to have to modify the query a litte bit.

SELECT 
T1."FreeTxt"
FROM 
OOAT T0
INNER JOIN OAT1 T1 ON T1."AgrNo" = T0."AbsID" AND T1."ItemCode" = $[$38.1.0]
WHERE T0.Number = $[$38.1980002193.0]

Hint for developing FMS.

If you want to test your FMS. Save it. Click in the Form (Lines / Header where the FMS should be stored) and go through the menu to your saved querie. The Placeholder will be filled with the right values.

regards Lothar