regarding FMS

[Former Member]

hello everyone,

I'm a problem in sap about FMS.

For example:

I have created a new PO.

NO:PO 1

itemcode qty

1901 50

1902 40

1903 60

1908 50

I have a setting AR itemcode FMS search by saved Query:

query sql:

SELECT itemcode,dscription,quantity from por1 T0  where  T0.docentry = [%0]

I created a New AR

hope as follow:

NO:AR 1

itemcode qty

1901 50

1902 40

1903 60

1908 50

but actually as follow:

itemcode qty

1901 1

1902 1

1903 1

1908 1

Please give me advice.

best regards

Eric

[Former Member · Accepted solution]

TO :Suda Sampath

Can you give me a solution in detail?

field whose name is quantity set the query sql in FMS as follow :

SELECT T0.Quantity, T0.ItemCode, T0.Dscription 
FROm [dbo],[POR1] T0  WHERE T0.DocNum = '[%0]' AND T0.ItemCode = $[$38.1.0]

and then what shoud I do ?

searched by saved query

--> check auto refresh

-->choose when existing altered column

-->choose itemno.

Is that right ?

[former_member204969 · Accepted solution]

To copy the data from a purchase order to an AR document, you should use two FMS:

The first should be connected to the item code field without setting auto refresh:

Select T0.ItemCode, T0.Dscription,T0.Quantity
 From POR1 T0
  INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.DocNum =  $[$1004.1]

The second should be connected to the quantity field, setting auto refresh when exiting altered column Item No. and display saved user defined value:

Select T0.Quantity 
From POR1 T0
  INNER JOIN OPOR T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.DocNum =  $[$1004.1]
  and T0.ItemCode=$[$38.1]

To use this FS-s, the user should

1. enter the document number of the purchase order into the Manual Number field,

2. on the first item code field use the Shft+F2 combination and select all the item codes displayed.

The system will then copy the item code and the quantity values from the source purchase order document.

[former_member583013]

Are you saying you want to copy the Items along with their quantities from a PO number you select.

One one field can be populated at a time. I would recommend using the DocNum instead of the DocEntry...

You will need 2 FMS..one on ItemCode field and and other on Qty field.

This on the ItemCode

SELECT T0.ItemCode, T0.Dscription 
FROm [dbo],[POR1] T0  WHERE T0.DocNum = '[%0]'

This on the Quantity

SELECT T0.Quantity, T0.ItemCode, T0.Dscription 
FROm [dbo],[POR1] T0  WHERE T0.DocNum = '[%0]' AND T0.ItemCode = $[$38.1.0]

[Former Member]

Hi,

what is the purpose of this FMS? Are you trying to get the PO data for AR or what? please explain in details?

Regards