资源描述:
《原料仓库存价值报表》由会员上传分享,免费在线阅读,更多相关内容在行业资料-天天文库。
1、原料仓库存价值报表*&---------------------------------------------------------------------**&REPORTZTFICO_RP004*&ReportName:原料仓库存价值报表*&ReportDescription:原料仓库存价值报表*&T-Code:ZTF004*&---------------------------------------------------------------------**&CreatedBy:TTCCreatedOn:2012-10
2、-15*&UpdatedBy:TTCUpdatedOn:2012-10-15*&---------------------------------------------------------------------*REPORTztfico_rp004.TABLES:mara,makt,t023t,ekko,lfa1,vbak,vbap,eket,mseg,mska,vbpa,mchb,ekpo,mbew."MCHBMTS无销售单库存"MSKAMTO有销售单库存DATA:i_rowTYPEi.DATA:g_value1LIKEaus
3、p-objek.DATA:wa_sclassLIKEsclassOCCURS0WITHHEADERLINE,wa_clobjdatLIKEclobjdatOCCURS0WITHHEADERLINE.DATA:BEGINOFwa_stockOCCURS0,mtartLIKEmara-mtart"物料类型,werksLIKEmska-werks"工厂,slrq(12)"上料日期,charg(20)"批次,barcode(20)"条形码,matnrLIKEmska-matnr"物料号,maktxLIKEmakt-maktx"物料描述,wgbe
4、zLIKEt023t-wgbez"物料组描述,j_3apgnrLIKEmara-j_3apgnr"物料网格编号,j_3asizeLIKEmska-j_3asize"网格值,atwtbLIKEcawnt-atwtb"网格值描述,smno(15)"供应商物料编码,clabsLIKEmchb-clabs"非限制使用库存,cinsmLIKEmchb-cinsm"质量检验库存,cspemLIKEmchb-cspem"已冻结库存,now_qtyLIKEmska-kalab"最新库存数量,meins(10)"基本单位,j_3arqdaLIKEvbap
5、-j_3arqda"成衣货期,state_qi(10)"QI状态,lgortLIKEmchb-lgort"仓位,cwdes(20)"仓位描述,ersdaLIKEmska-ersda"入仓日期,eindtLIKEeket-eindt"交货日期,sldh(20)"上料单号,ebeln(15)"采购单号,lifnr(15)"供应商编码,name1(30)"供应商名称,kfmc(30)"客户名称,prfh(20)"生产款号,insmk(10)"库存状态,gh(20)"缸号,sush(15)"供应商色号,cgrp(15)"颜色组,vbelnLIK
6、Emska-vbeln"销售凭证,posnrLIKEmska-posnr"项目,spartLIKEvbak-spart"产品类型,remark(30)"备注,matklLIKEmara-matkl"物料组,cpwlh(20)"成品物料号,yx_line(15)"预算生产线,verprLIKEmbew-verpr"移动平均价格,peinhLIKEmbew-peinh"价格单位,waersLIKEkonv-waers"币别,kbetr_hkTYPEpDECIMALS5"移动平均价折港汇率(取PO当前日期汇率TCODE;OB08),kwert
7、_hk_amtLIKEkonv-kwert"折港币金额,bukrsLIKEt001-bukrs"公司代码,ENDOFwa_stock.DATA:wa_stock_bLIKEwa_stockOCCURS0.DATA:wa_stock_headerLIKEwa_stockOCCURS0WITHHEADERLINE.SELECTION-SCREENBEGINOFBLOCKblWITHFRAMETITLEtext-001.SELECT-OPTIONS:s_werksFORekpo-werksOBLIGATORY,"Default'8101',"
8、工厂s_mtartFORmara-mtartOBLIGATORY,"DEFAULT'ZROH',"物料类型s_matklFORmara-matkl,"物料组s_matnrFORmara-matnr,"DEF