FunctionalSpecificationsPagePAGE5ofNUMPAGES6FILENAME營收與成本Spec.doc DATE\@"MMMMd,yyyy"November30,2005FUNCTIONALSPECIFICATIONSIDCSAPTEAMRev.20050929A01FUNCTIONPROFILECompany/BUEU/USA/CN/TWProjectnameorProjectNo.CSDPROJECTFunctionTitleInvoiceAmount/營收與成本ProgramName/T-codeZRFI_CSD_0004SAPMODULEFImoduleCONTENTSItemDescriptionPageNumber1PROGRAMDESCRIPTION(Purpose/Useful)2AUTHORIZATIONSPECIFICATION3PROGRAMMODE4PROGRAMRUNFREQUENCY5PROCESSINGDETAILS(IPO)6OTHERDESCRIPTION7TABLESUSEDANDDESCRIPTION8TRANSACTIONS9SELECTIONSCREEN10OUTPUT:SampleList/FormsFunctionalSpecificationAPPROVEDProgrammerCHECKEDISSUEDCreatedon:Createby:Tel.Ext.:NotesMail:DirectLead:UrgentLevel:□Urgent□NormalExpecttestingDate:ExpectCompletedDate:ProgramClassificationProg.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.developdays1ABAPerDefinedType:DevelopDays:1

PROGRAMDESCRIPTION(Purpose/Useful)查詢某段期間的銷售金額2.AUTHORIZATIONSPECIFICATION(User/Dept./OWNER)供各地區(qū)經(jīng)管同仁、會計同仁使用。3.PROGRAMMODE(BACKGROUND/BECALLED/INDEPENDENCE)INDEPENDENCE4.PROGRAMRUNFREQUENCYEVERYDAY5.PROCESSINGDETAILS(INPUT/PROCESSING/OUTPUT)5.1建立一個TABLE,TABLE只有一個欄位，用來讓USER維護負數(shù)的BILLINGTYPE。5.2依據(jù)篩選條件到VBRK、VBRP抓取:CompanyCode:(VBRK-BUKRS)、InvoiceNo.(VBRK-VBELN)、BillingType(VBRK-FKART)、InvoiceDate(VBRK-FKDAT)、ShipNo.(VBRP-VGBEL)、PartNo.(VBRP-MATNR)、ModelName(MARA-BISMT)、Quantity(VBRP-FKIMG)、Amount(VBRP-NETWR)、Currency(VBRK-WAERK)、Std.Cost(MSEG-DMBTR)、Country(VBRK-LAND1)、CustomerCode(VBRK-KUNAG)、CustomerName(KNA1-NAME1/NAME2)、Depart(VBRP-PRCTR)、W/HBoundP/N(VBRP-LGORT)、E.AcDate(VBRK-ERDAT)、Customer.Type(VBRK-VTWEG)、Rate(VBRK-KURRF).5.3計算每一資料的Price(原幣未稅單價)=VBRP-NETWR/VBRP-FKIMG、AmountUSD=VBRP-NETWR*(原幣對美金當月匯率)、Costtotal=VBRP-FKIMG*MSEG-DMBTR、Marginamount(USD)=[VBRP-NETWR(Amount)減去VBRP-FKIMG*MSEG-DMBTR(Costtotal)]*(原幣對美金當月匯率).5.4報表最後一欄放的Rate是當月美金對歐元的匯率，供用戶參考.5.5依據(jù)每筆明細的銷單號碼(VBRP-AUBEL)到VBPA去抓取Partnerfunction(VBPA-PARVW)為PE所對應的銷售人員在客戶主檔中建立的客戶代碼(VBPA-KUNNR),再按照此代碼到客戶主檔KNA1中抓取客戶名稱(KNA1-NAME1/NAME2)即為報表中的PERSON欄位值.5.6依據(jù)每筆明細的PartNo.(VBRP-MATNR)到MARA去抓取對應的MODLENAME(MARA-BISMT)5.7依據(jù)每筆資料的CustomerCode(VBRK-KUNAG)到KNA1去抓取此客戶代碼的名稱(KNA1-NAME1/NAME2)6.OTHERDESCRIPTIONA.請以ALV方式呈現(xiàn)TABLESUSEDANDDESCRIPTION所使用的tablesTablesDescriptionKeyfieldsVBRKBilling:HeaderDataVBRPBilling:ItemDataKNA1GeneralDatainCustomerMasterMARAMaterialMaster:GeneralDataVBAKSalesDocument:HeaderDataVBPASalesDocument:Partner所使用的TableandFields:IDTable-FieldDescriptionRemarkAccountingdocumentheaderdata1VBRK-VBELNBillingdocumentInvoiceNO.2VBRK-FKARTBillingType區(qū)分售退3VBRK-FKDATBillingDateInvoiceDate4VBRK-LAND1Country5VBRK-KUNAGCustomercodeCust.Code6VBRK-VTWEGDistributionChanelCust.Type7VBRP-MATNRMaterialnumberPartNo.8VBRP-FKIMGSalequantityQuantity9VBRP-NETWRSaleamountAmount10VBRP-AUBELSaledocument11VBRP-PRCTRProfitcenterDepart12calculationPrice原幣未稅單價13calculationCosttotal原幣成本金額14calculationMarginamount(USD)毛利15calculationRate每金對歐元匯率16VBPA-PARVWPartnerfunctioncategory17VBPA-KUNNRCustomercode抓PersonNo.用18KNA1-NAME1CustomernamePersonName19VBRK-BUKRSCompanyCode20VBRK-WAERKCurrency21VBRP-VGBELShip.No.TRANSACTIONS

SELECTIONSCREENCompanyCode:VBRK-BUKRS(required/interval)Billingdate:VBRK-FKDAT(required/interval)Billingtype:VBRK-FKART(required/interval)County:VBRK-LAND1(Optional/interval)Currency:VBRK-WAERK(Optional/interval)Distributionchanel:VBRK-VTWEG(Optional/interval)CustomerCode:VBRK-KUNAG(Optional/in