Skip to Content

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

Show list of Business Partners in BP Udf

Hi,

In Journal Entry Rows, I have added a Udf for Vendor Name, as the debit / credit ledger in a particular business scenario will not involve the BP Name. Here expense GL will be debited and a Prepaid Expense GL will be credited.

In this UDF, I want to show the list of existing BPs (Code and Name) to help the user in selection.

Once selected, this UDF should support the same orange arrow for navigation to the BP master.

Please guide step by step.

Thanks.

Former Member replied

Hi Rajesh.

first Create FMS.

Tools ---> Queries --> Query Generator--->Click On Execute Button.

Copy following query

SELECT T0.[CardCode], T0.[CardName] FROM OCRD T0


and Paste.


Save Query under FMS category.


--------------------------------------------------------

After this Open Document where your UDF exiest.

Select udf by cursour. Then enter (ALT+SHIFT+F2)

Select 3rd Option :- Search in Existing User-Defined Values according to Saved Query

Open Saved Query from FMS category.

If Need Of Auto Refresh Select like CardCode

When you Enter CardCode. In your UDF Its reflect desired Out Put.

Regards

Amol

0 View this answer in context

Helpful Answer

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