FunctionalSpecificationsMaterialSplitversionPage1of14PROGRAMSPECIFICATIONPROGRAMPROFILECompanyFoxconnNWEApplicationIdentifierSPR/3System–COSpecIDZRCO_NWE_0032ProgramNameZRCO_NWE_0032ProgramTitleInventoryin-outgeneraltableCONTENTSItemDescriptionPageNumber1ProgramDescription22AuthorizationSpecification23TablesUsed24ProgrameMainFlow5ProcessingDetails26SelectionScreen97OutputDataLayout9REMARKSPROGRAMMERAPPROVEDCHECKEDISSUEDCreatedon:2004/09/21Createdby:吳靜TEL:798362003,SAPImplementationNWEProgramClassificationProg.classCA:(ScriptForm/ModulePool),B:(BatchInput/Enhancement),C:(Report/FunctionModule),D:(Other/Special)Prog.kindBA:(BugFix),B:(CreateNew),C:(Modify/Change)Prog.difference21:Easy2.Normal3:HardProg.developdaysABAPerDefinedType:DevelopDays:CreateproductionversionMarch1,20251FunctionalSpecificationsMaterialSplitversionPage2of141.PROGRAMDESCRIPTION本報表用於顯示指定時間內的NEW庫存異動匯總表2.AuthorizationSpecificationNWE3.TablesUsedTableName:BKPF,BSEGmara,ekko,mkpf,mesg,likp,ckmlcr.FieldDataTypeDescriptionRemarkMara-MATNRMara-MATNRMaterial料號Mara-mtartMara-mtartMaterialtype物料類別Mkpf-XBLNRMkpf-XBLNRReferencedocumentnumber參考單號Mkpf-MblnrMkpf-MblnrNumberofmaterialdocument物料異動單號Mkpf-BUDATMkbf-BUDATPostingdateinthedocument物料異動日期Mseg-MblnrMseg-MblnrNumberofmaterialdocument物料異動單號Mseg-bwartMseg-bwartMomventtype異動類型Mseg-MATNRMseg-MATNRMaterialNumber料號Mseg-erfmgMseg-erfmgQuantity數量Mseg-WERKSplantplant工廠Mseg-meinsMseg-meinsBaseunit基本單位Mseg-ERFMEMseg-ERFMEUNIT單位Mseg-DMBTRMseg-DMBTR金額5.ProcessingDetails5.1輸入條件:1.from年月日(用戶輸入)to年月日(用戶輸入)2.工廠:(CNHF,THWW)的工廠可多選5.1.1根據報表要求定義相關變量CreateproductionversionMarch1,20252FunctionalSpecificationsMaterialSplitversionPage3of14期初采購收貨盤盈費用性退工令退料委外入庫銷售退回轉廠入內交入工令完工入庫標改差期末差異收貨退回盤虧費用性領工令發料委外發料銷售轉廠出內交出庫存報廢原物料O_initO_po_iO_count_iO_c_iO_wo_iO_o_iO_s_iO_pl_iO_in_iO_wF_iO_S_cO_EndO_cO_po_oO_count_OO_c_oO_wo_oO_o_oO_s_oO_pl_oO_in_oO_inv_o半成品S_initS_po_is_count_iS_c_iS_wo_iS_o_iS_s_iS_pl_iS_in_iS_wf_iS_s_cs_EndS_cs_po_os_count_oS_c_oS_wo_oS_o_oS_s_oS_pl_oS_in_oS_inV_o成品F_initF_po_if_count_iF_c_iF_wo_iF_o_iF_s_iF_pl_iF_in_iF_wf_iF_S_cF_EndF_cF_po_of_count_oF_c_oF_wo_oF_o_oF_s_oF_pl_oF_in_oF_inV_o小計T_initT_Po_IT_CouNt_IT_C_IT_wo_iT_o_iT_s_iT_pl_iT_in_iT_wf_iT_S_cT_EndT_cT_Po_OT_CouNt_OT_C_OT_wo_oT_o_oT_s_oT_pl_oT_in_oT_inV_o合計T_initT_poT_CountT_CT_woT_oT_sT_plT_inT_invT_s_cT_EndT_c5.1.2從BKPF,BSEG中找出符合期間(Bkpf-BUDAT)和工廠(Bseg-WERKS)和科目(Bseg-HKONT)(TWHH:132501(原物料),132301(半成品),132201(成品);CNHF:1211110100(原物料),1241110000(半成品),1243011100(成品))的所有記錄,兩表之間通過FI-DocumentNo(BELNR)來關聯5.1.3遍歷上面查出的結果5.1.3通過Bkpf-AWKEY的前10位(就是MATDOCNO)對應MSEG和MKPF表的Mblnr值來找到對應的記錄找不到的部份先暫列標改差按下計算:5.1.3.1增加(Bseg-DMBTR)(1)Bseg-SHKZG=’S’5.1.3.2減少(Bseg-DMBTR)(1)Bseg-SHKZG=’H’5.1.3.3根據對應的科目(Bseg-HKONT)來決定(1)公司TWHH(1):132501:原物料(O_S_C)(2):132301:半成品(S_S_C)(3):132201:成品..(F_S_C)(2)公司CNHF(1):1211110100:原物料(O_S_C)(2):1241110000:半成品(S_S_C)(3):1243011100:成品..(F_S_C)5.1.3.4分別記入對應的變量CreateproductionversionMarch1,20253FunctionalSpecificationsMaterialSplitversionPage4of145.1.4再根據下列條件來判斷該金額應屬哪個欄位...
