漫谈SRM主数据迁移及同步(2.1 物料主数据篇)

最新推荐文章于 2025-08-15 09:00:49 发布

weixin_30321449

最新推荐文章于 2025-08-15 09:00:49 发布

阅读量392

点赞数

CC 4.0 BY-SA版权

文章标签：数据库

原文链接：http://www.cnblogs.com/lazymango/archive/2010/11/03/1867631.html

本文详细介绍了SAP系统中产品ID的设置方法及注意事项，包括定义输出格式和存储形式、中间件参数配置等内容，并提供了具体操作步骤及示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

首先还是先说系统基本设置:

1. Define Output Format and Storage Form of Product ID

T-code: COMCPRFORMAT (SRM)

T-code: OMSL (ERP)

两个系统的Lexicographically设置需要一致:

1.1 Indicator set: Numeric product IDs are stored left-justified as entered.

Example
Defined length: 8 characters
Assigned ID: 123
Stored ID: 123

With lexicographical storage, the product IDs 123 and 0123 refer to different products. (如果不设,则123与0123视为同一物料)

1.2 Sorting: The sequence in lists and tables sorted by product ID depends on the storage form chosen.

Example of lexicographical storage
123 < 1A3 < 2 < 234 Example of non-lexicographical storage (assuming an ASCII character set)
2 < 123 < 234 < 1 1.3 Selection

The result of generic selections or of from-to selections depends on the storage form chosen. For example, with non-lexicographical storage, a selection with 5* will not find the product ID 50 because the product ID is stored in the database as 0...050.

1.4 Interfaces (for example, BAPIs)

Non-lexicographical storage can be problematic with regard to cross-system interfaces in particular. The product ID is normally transferred in the database format, but problems can occur if the sending system and receiving system have different storage forms.

1.5 Number assignment

If you choose non-lexicographical storage, solely numeric product IDs must not contain more than 20 characters when products are created. This is because the lower limit and upper limit of

number range intervals is restricted to 20 characters.

This restriction does not apply to lexicographical storage because the product ID is stored left-justified as entered and can be checked from left to right against the number range interval.

Example

Lower limit	10000000000000000000
Upper limit	19999999999999999999
Product ID to be checked	111111111111111111111111111111

With non-lexicographical storage, the product ID is not within the number range interval because it is larger than the upper limit.

With lexicographical storage, the product ID is within the number range interval because the product ID is not interpreted as a number, but as a character (see also under

Sorting).

2. Setting the Middleware Parameters in SAP SRM

发送端(ECC)的配置是标准的..仅需在SRM端配置 T-code SMOEAC

3. Configure Settings in ECC for SAP SRM Master Data

需要维护以下表: CRMCONSUM, CRMSUBTAB, CRMRFCPAR, CRMPAROLTP, TBE11

3.1 CRMCONSUM (对于单个SRM,则只需维护一行. 如果有多个SRM系统/clients, 则维护多行)

下图可以理解为你创建了3个USERS