Skip to Content

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

Formatted Search not working

Hi Friends,

My company has a requirement for FMS for populating the Distibution Rule but its not working.

The setup is as below:

Dimension 1 - Cost Centre1 - Distribution Rule 1 ( 100% of CoC1)

Dimension 1 - Cost Centre2 - Distribution Rule 2 ( 100% of CoC2)

The company has 4 regions of work - North /South/East/West. Each region will have their document numbering series and will have its own cost centre created and configured eventually.

The requirement is that the user selects the document series based on region and the document line automatically populates the relevant distribution rule.

The FMS query used is as below

SELECT

CASE WHEN $[ORDR.series]='5' THEN 'N'

CASE WHEN $[ORDR.series]='55' THEN 'S'

CASE WHEN $[ORDR.series]='56' THEN 'E'

CASE WHEN $[ORDR.series]='57' THEN 'W'

END

The UDV setup is as below

-Auto refresh - when field changes

criteria on document series

-Display saved UDV

The problem is that selecting of the document series from top does not populate the relevant distribution rule but if the field is double clicked it pops up the selection window for distributionr rule. If i open the query manager to run the FMS query it shows the correct distribution rule.

Any idea or any other solution that might help get the result.

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