博客园-刘波的学习园地-最新评论http://www.cnblogs.com/leos/CommentsRSS.aspx让我们一起进步！zh-cnThu, 21 Jul 2011 07:19:55 GMTThu, 21 Jul 2011 07:19:55 GMTcnblogsre: SAP产品简介_ZThttp://www.cnblogs.com/leos/archive/2008/12/25/1083837.html#1412940jzhou2001jzhou2001Thu, 25 Dec 2008 02:42:59 GMThttp://www.cnblogs.com/leos/archive/2008/12/25/1083837.html#1412940
jzhou2001 2008-12-25 10:42 发表评论
]]>re: 一些有用的SAP技术TCODE http://www.cnblogs.com/leos/archive/2008/06/10/805048.html#1221809MIR王MIR王Tue, 10 Jun 2008 01:34:17 GMThttp://www.cnblogs.com/leos/archive/2008/06/10/805048.html#1221809
MIR王 2008-06-10 09:34 发表评论
]]>re: SAP CRM Tables 1 http://www.cnblogs.com/leos/archive/2008/03/31/890587.html#1130756Tony LiuTony LiuMon, 31 Mar 2008 02:30:00 GMThttp://www.cnblogs.com/leos/archive/2008/03/31/890587.html#1130756
Tony Liu 2008-03-31 10:30 发表评论
]]>请教一个关于EXCEL的问题http://www.cnblogs.com/leos/archive/2007/08/31/555437.html#877299sophia47sophia47Fri, 31 Aug 2007 07:42:00 GMThttp://www.cnblogs.com/leos/archive/2007/08/31/555437.html#877299 现在有这么一个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

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


sophia47 2007-08-31 15:42 发表评论
]]>re: FUNCTION ALV中加按钮.doc[未登录]http://www.cnblogs.com/leos/archive/2007/08/02/555319.html#840503kkThu, 02 Aug 2007 08:54:00 GMThttp://www.cnblogs.com/leos/archive/2007/08/02/555319.html#840503
k 2007-08-02 16:54 发表评论
]]>re: SAP & Excelhttp://www.cnblogs.com/leos/archive/2007/07/20/555437.html#825039linmumulinmumuFri, 20 Jul 2007 01:56:00 GMThttp://www.cnblogs.com/leos/archive/2007/07/20/555437.html#825039
linmumu 2007-07-20 09:56 发表评论
]]>PShttp://www.cnblogs.com/leos/archive/2007/06/19/788574.html#788576Leo'sLeo'sTue, 19 Jun 2007 02:00:00 GMThttp://www.cnblogs.com/leos/archive/2007/06/19/788574.html#788576
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.

Leo's 2007-06-19 10:00 发表评论
]]>