cancel
Showing results for 
Search instead for 
Did you mean: 

FMS Required for Fetching Business Partner Information

Former Member
0 Kudos

Dear All,

I Had created a UDT in which i had defined some UDF viz: BP Code, BP Name, BP Account Balance etc.

I required FMS to fetch information of Business Partner based on the BP Code, Suppose i had selected BP Code as C0004 then on other field while clicking on the magnifying glass system may fetch the other respective values.

Regards,

Bhushan Verma

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Bhushan,

Try this,

Select T0.CardName from OCRD T0 where T0.CardCode = $[UDTName.U_UDF.0]

Above FMS is to fetch CardName for selected BP Code where in place of UDT Name replace your UDT name and UDF to BP Code UDF field.

Apply above FMS to BP name field of UDT and kepp it on refresh regularly on BP Code of UDT.

Hope this helps.

Regards,

Rahul

Former Member
0 Kudos

Hi Rahul

Thanks for your response , i did it previously as u had suggested above but i require to link three things Code, Name, Account balance for BP.

Please let me know how to fetch for Account balance

Regards,

Bhushan Verma

Former Member
0 Kudos

Hi Bhushan,

Try Select T0.Balance from OCRD T0 where T0.CardCode = $[UDTName.U_UDF.0]

Thanks,

Gordon

Former Member
0 Kudos

Hi Gordon,

Thanks for your reply i had made the changes in your given query and it worked out.

Thank you again

Regards,

Bhushan Verma

Answers (1)

Answers (1)

former_member184146
Active Contributor
0 Kudos

Hi Bushan ,

put the FMS 's on all fields respect to their fields type then auto refresh all fields on change of UDF.BPcode .

--Manish