Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

regarding FMS

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

replied

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.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question