刘波的学习园地

介绍的非常不错，总算对SAP的产品系列有一个清楚的认识。能否在技术上也给一个介绍。比如Add-On开发方面。另外，学习SAP应用开发应该如果着手？

谢谢 到处找呢

怎么根据产品找序列号，你看一下这两个表：COMM_PRODUCT和COM_TA_MANUFAC，用GUID连接

请教一个问题:
现在有这么一个excel表格:

K001 100
200
300
400
K002 100
200
300
400
K003 100
200
300
400
K004 100
200
300
400
K005 100
200
300
400
K006 100
200
300
400

我希望实现这样一个功能,可以把每一个货号下面的空白部分按上面的货号自动埴充好,可以怎样来实现? 谢谢

thank you very much!

可不可以发个完整的程序，附加固定的.xls的文件模板供参考学习一下，谢谢！

In general:

CRMCxxxx = Customising
CRMTxxxx = Customising
CRMDxxxx = transactional

BUT* = Customer Master
BUT000 = ~KNA1 Customer Master General Data
BUT020 = Address Link Table
ADRC = Address Details (Master Data)
ADRV = Address Details (unique to orders)

CRMC_PARTNER_FT = Partner function Description
PRCD_COND = Pricing Conditions
CRM_JEST = Status Table

COMM_PRODUCT = Materials General Table

SCATTSEG = Valid from/ Valid to

CRMD_ORDERADM_H = Document Header Table
CRMD_ORDERADM_I = Document Line item Table

CRMD_LINK = 连接到与order相关的其他信息数据表的guid
如: CRMD_PARTNER 是order相关的partner，但表有自己的guid，这些guid在crmd_link中都关联到order header的guid上，所以crmd_link是order的表关系中心，其中的字段：

GUID_HI = Header/ Line item Guid
OBJTYPE_HI:
‘05’ = Header
‘06’ = Line item

GUID_SET = Subset GUID
OBJTYPE_SET:
‘07’ = Partners
‘11’ = Sales
‘21’ = Orgman
‘29’ = Subject

CRMD_SALES = Sales Data
(reference data)

CRMD_SHEDLIN = Schedule Line item

CRMD_ORGMAN = Organisational Data

CRMD_PRODUCT_I = Line item product detail
PROCESS_QTY_UNIT (EUR)

Example: You want to list all complaints that partner no 31 appears as a header partner, and the partner functions:

Select PARTNER_GUID from the table BUT000.

Get all instances of that partner in the order/partner table:

Select GUID PARTNER_FCT from CRMD_PARTNER
Where PARTNER_NO = BUT000-PARTNER_GUID.

Then get the order guid from the link table:

Select GUID_HI from CRMD_LINK
Where GUID_SET = CRMD_PARTNER-GUID.

Get the Order No:

Select OBJECT_ID from CRMD_ORDERADM_H
Where GUID = CRMD_LINK-GUID_SET.