PT Sterling Tulus Cemerlang



Sampoerna Strategic Square
South Tower Level 30
Jl Jend. Sudirman No. 45-46
Jakarta 12930 – Indonesia

500+ FREE Tips SAP Business One for you to Become SAP B1 Super User from Sterling Tulus Cemerlang (STEM)

How To Create Lookup List (Valid Values) For Field In SAP Business One

In SAP Business One, you can create a list for certain field, so the user can select from the list rather than to type manually. For Example, In Business Partner Master Data Field Foreign Name, you want to Add A list of Customer Type such as (VVIP, VIP, REG)

Here’s the screen before we add a list into the field :

STEM - SAP Business One Indonesia Partner /LookupField1

Create lookup list for field with this step :

  • Select the field and go to Tools> Customization Tools> User-Defined Value-Setup (Shift+Alt+F2 for ShortCut)

STEM - SAP Business One Indonesia Partner /LookupField2

  • After User Defined Value screen appear, Select Search in Existing User-Defined Values and Click Update Button as screenshot below.

STEM - SAP Business One Indonesia Partner /LookupField3

  • You can fill the data that need to be listed in Field Values – Setup screen.

STEM - SAP Business One Indonesia Partner /LookupField4

  • Setup Field Values is finished, Now you can use the Field Values on Business Partner Master Data in Foreign Name field as screenshot below :

STEM - SAP Business One Indonesia Partner /LookupField5

Enjoy the tips. 🙂


Copyright © PT Sterling Tulus Cemerlang – 2016

Also read:

Run Your Business With The Piece of Mind Using SAP Business One

This article was written by PT. Sterling Tulus Cemerlang
More details about SAP Business One,
email to: or call +6221-5806336 or wa +6287786555055