资源描述:
《备件.进销存统计表》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、备件.进销存统计表*&---------------------------------------------------------------------**&ProgramTitle:内蒙古亿阳备件进、销、存统计表**&Reportname:SalesAnalysisReport**&---------------------------------------------------------------------**&Author:GuoDongYang**&Createdate:2004/05/12**&Progr
2、amtype:Report**&Messageclass:**&Modifications:**&---------------------------------------------------------------------*REPORTYMMR0001MESSAGE-IDY04"程序中会用到的MessageClassNOSTANDARDPAGEHEADING"输出的报表不使用标准的页标题LINE-SIZE110."输出的报表每页的字符宽度**********定义常量CONSTANTS:C_NETWR1(5)TYPEPD
3、ECIMALS2VALUE'0.05',C_NETWR2(5)TYPEPDECIMALS2VALUE'0.06',C_NETWR3(5)TYPEPDECIMALS2VALUE'0.07',C_NETWR4(5)TYPEPDECIMALS2VALUE'0.09',C_NETWR5(5)TYPEPDECIMALS2VALUE'0.82',C_NETWR6(5)TYPEPDECIMALS2VALUE'0.87',C_NETWR7(5)TYPEPDECIMALS2VALUE'1.17'.**********表定义TABLES:EKKO,"采
4、购凭证抬头EKPO,"采购凭证项目EKET,"计划协议计划行VBAK,"销售凭证:抬头数据VBAP,"销售凭证:项目数据MBEW,"商品评估MKPF,"抬头:物料管理MSEG,"凭证部分:商品KONV,"条件(事务数据)S039,"统计:存货控制MARA,"常规物料数据MARD."物料的仓储位置数据*********数据定义DATA:BEGINOFG_I_BILLINGOCCURS0,EINDTLIKEEKET-EINDT,"项目交货日期KNUMVLIKEEKKO-KNUMV,"单据条件数EBELNLIKEEKKO-EBELN,"采
5、购凭证EKORGLIKEEKKO-EKORG,"采购组织EBELPLIKEEKPO-EBELP,"采购凭证的项目编号MATKLLIKEEKPO-MATKL,"物料组MATNRLIKEMSEG-MATNR,"物料号码MENGELIKEMSEG-MENGE,"数量WERKSLIKEMSEG-WERKS,"工厂LGORTLIKEMSEG-LGORT,"库存地点MBLNRLIKEMSEG-MBLNR,"物料凭证编号BWARTLIKEMSEG-BWART,"移动类型KBETRLIKEKONV-KBETR,"采购价格(含税)JE1LIKEKON
6、V-KBETR,"采购金额ENDOFG_I_BILLING.DATA:BEGINOFD_I_BILLINGOCCURS0,SPTAGLIKES904-SPTAG,"当前日期VKORGLIKES904-VKORG,"销售组织SPARTLIKES904-SPART,"部门VTWEGLIKES904-VTWEG,"分销渠道MATKLLIKES904-MATKL,"物料组MATNRLIKES904-MATNR,"物料号码REKZWI1LIKES904-REKZWI1,"毛收益WAVWRLIKES904-WAVWR,"凭证成本JE2LIKEK
7、ONV-KBETR,"金额ENDOFD_I_BILLING.DATA:BEGINOFC_I_BILLINGOCCURS0,AUDATLIKEVBAK-AUDAT,"单据日期AUFNRLIKEAUFM-AUFNR,"订单号MATNRLIKEAUFM-MATNR,"物料号码MENGELIKEAUFM-MENGE,"数量BWARTLIKEAUFM-BWART,"移动类型AUARTLIKEAUFK-AUART,"订单类型VERPRLIKEMBEW-VERPR,"成本价CBJLIKEMBEW-VERPR,"成本金额ENDOFC_I_BILLI
8、NG.DATA:BEGINOFY_I_BILLINGOCCURS0,BLDATLIKEMKPF-BLDAT,"凭证中的凭证日期ERSDALIKEMARD-ERSDA,"创建日期MATNRLIKEMARD-MATNR,"物料号码WERK