川维厂项目客户合同量、计划量、执行量统计表数据映射.docVIP

Data Mapping Matrix（数据映射表） Output-form field: Field # Field name Table name PC* Format/ Length Field Calculations Comments R01 BUKRS BKPF H CHAR/4 公司代码 R02 VKORG VBAK H CHAR/4 销售组织 R03 VKORG VBAK H CHAR/2 销售渠道 R04 SPART VBAK H CHAR/2 部门 R05 VKBUR VBAK H CHAR/4 销售办公室 R06 REGION ? H CHAR/10 销售地区 R07 FKDAT ？ H DATS/8 日期 R08 H CHAR/10 是否逐月显示 R09 KUNNR KNA1 P CHAR/10 客户 R10 KUKLA KNA1 P CHAR/10 客户等级 R11 ZMENG VBAP P QUAN/13 年度合同量 R12 ZMENG VBAP P QUAN/13 计划量 R13 KWMENG S008 P QUAN/15 执行量 R14 KBETR KONW P CURR/11 价格 Field # = Number used in report layout to indicate placement (across and then down) PC* = Print Control Print Control Codes: H =Header (Field that is in the header) F =Footer (Field in the footer) P =Page Continuation (Line Item data on which no page break should occur) S =Start new page (Field on which a page break takes place. Typical fields for page breaks are plant, product group, GL account) B =Beginning of data group (Sometimes a sort on a field in a report is performed in order to group information logically although we do not necessarily do a page break on that sort field. Example: We could do a page break on plant and then sort material data by product group. The report would have sections of data in which product group would be a subheader and material line items would be written under that subheader.) E =End of data group (Often there is something that identifies the end of a logical grouping. Most often this is a total or subtotal.) 注： R02、R03、R 05、R 04的字段如下图所示： 事务代码：VA01 R09的字段如下所示， 事务代码VD03 R10的字段如下所示，T-CODE：VD03， R11,R12的字段如下所示，T-CODE：VA43： R13,R14的字段如下所示，T-CODE：VD03： R11 R12 R05 R02 R13 R14 R10 R03 R04 R09