【免费】SAPB1用户自定义值定义与应用资源-CSDN文库

需积分: 0 74 浏览量更新于2024-11-04 收藏 677KB PDF 举报

内容概要：本文档详细介绍了在SAP Business One系统中如何定义和使用自定义值（User-Defined Values）。主要涵盖了以下几个方面：菜单栏的基本操作、设置静态列表值或查询动态值的方法、自动填充字段的配置、以及编写查询的具体示例。同时，还提供了一些常见问题的解决方法和技术细节，帮助用户更好地理解和使用自定义值功能。适合人群：使用SAP Business One系统的管理员、开发人员和支持人员。使用场景及目标：① 在填写表格和输入数据时提高效率和准确性；② 自动填充相关联的数据字段；③ 利用查询获取数据库中的动态值并展示给用户。其他说明：本手册适用于SAP Business One多个版本，并逐步引导用户进行具体操作，附有详细的步骤和图解。此外，还包括了一些常见的查询例子，帮助用户更快地上手。

User Guide | PUBLIC

Document Version: 1.2–2024-01-15

How to Dene and Use User-Dened Values

© 2024 SAP SE or an SAP aliate company. All rights reserved.

THE BEST RUN 

Content

1 Document History........................................................... 3

2 Introduction................................................................4

3 Using the Menu Bar.......................................................... 5

3.1 Activating User-Dened Values for a Field............................................5

3.2 Displaying the  Icon in Fields with User-Dened Values.................................6

3.3 Setting Up a User-Dened Value for a Field...........................................6

4 Setting Up User-Dened Values.................................................8

4.1 Setting Up a List of Predened Values...............................................9

Adding/Updating Predened Values.............................................11

Deleting Predened Values...................................................12

4.2 Setting Up a List of Values from a Query............................................ 12

Auto Refresh.............................................................15

Using User-Dened Values................................................... 17

5 Writing Queries.............................................................18

5.1 Sample Queries............................................................. 19

Example 1 – Copy eld value to another eld...................................... 20

Example 2 – Copy eld value to user-dened eld...................................21

Example 3 – Copy row eld value to user-dened eld................................22

Example 4 – Copy currency symbol.............................................23

Example 5 – Copy a user-dened eld’s value to a system eld..........................24

Example 6 – Calculate value from eld value...................................... 25

Example 7 – Calculate numerical value from eld value...............................25

Example 8 – Cast numerical value..............................................26

Example 9 – Look up value from database........................................27

Example 10 – Create list of values from database lookup..............................28

Example 11 – Create query with user-dened table..................................29

Example 12 – Retrieve current user............................................. 31

Example 13 – Set eld value to complex string..................................... 32

5.2 Field Indexes ...............................................................33

Item Type Documents...................................................... 33

Service Type Documents....................................................36

5.3 Troubleshooting Queries .......................................................38

2

PUBLIC

How to Dene and Use User-Dened Values

Content

剩余41页未读，继续阅读

身份认证购VIP最低享 7 折!

30元优惠券

资源推荐

资源评论

lu_rong_qq

粉丝: 4576
资源: 10

最新资源