送DN單號(hào)給第三方倉庫

1、Functional Design Specification功能規(guī)格書發(fā)送DN單號(hào)給第三方倉庫DOCUMENT CONTROAuthorReviewer/ ApproverVersionDate of releaseDescription of changes 1.0Initial 發(fā)送DN單號(hào)給第三方倉庫Requested By:Written By: APPROVAL:Functional Specification Approval: SignatureDateSignatureDateProcess ApprovalTechnical ApprovalREQUIREMENT SPEC

2、IFICATIONClientDate Requested by:Extension:Analyst:Extension:Business ModuleMM、PIPriority (M)( X ) Critical ( ) High ( ) Medium ( ) LowComplexity (M)( ) High (X) Medium ( ) Low Technical Estimate (M)Planning EstimateRevised EstimateActualFunctional DesignTechnical DesignTechnical Development & Testi

3、ngFunctional TestingTotal EstimateScenario Name發(fā)送DN單號(hào)給第三方倉庫Scenario IDFunction/Procedure (RFC) NameFunctional BriefingScenario Type( X ) A2A( ) B2BMessage Mode( X ) Asynchronous ( ) SynchronousProgram Type( Multiple choices if necessary )( )Listing( Reports )( )Transaction (Update database)( X )Inte

4、rface( X )Enhancement / Modification ( )Other_Type of Development( ) Modification from Standard SAP ProgramName of Standard Program:( X ) Custom programHave you looked at possible standard Reports/Forms?( ) Yes ( X ) NoImpact of not creating the program (M)( ) Legal requirements will not be fulfille

5、d( ) Lack of information required for the business(X) Lose functionality compared to the old system( ) Others: Alternative (M)Why this alternative wasnt acceptable?( ) Performance problems( ) Complexity( ) OthersProcessing Mode(X) Online (foreground)( ) Batch (background)( ) Annually( ) Quarterly( )

6、 Monthly( ) Weekly( ) Daily( ) Other _Authorization Requirements: Output type( )Message ( )Dialog Window( X )Table Maintenance( )ABAP List( )ALV List( )ALV Grid( )Smart Form ( )Report Painter( )File( )Log table( )IDOC/ALE_( X)Parameters( X )Remote Function Call( X )OthersPrinting Requirements Identi

7、fy any printing requirements such as Spool request only, Special Paper, Preprinted Definitions, Acronyms, Abbreviations AssumptionsMiscellaneous RequirementsInterface InformationDirection of Interface:( ) Inbound ( X ) Outbound ( ) BothAcknowledge Required:( X ) No ( ) YesInterface RequirementsError

8、 Message Output( )Test Run Report( )Error Report( X )Error Message( )Return message table( )Other_Exception Handling ( )Rollback all( )Rollback error only, still commit success items( )Break in error occurs( )Other_SAP Object or Process to be EnhancedChange History (Log)( )Keep all transactions ( )K

9、eep particular transactions( )Only the last date( )Other_Test Script FileDevelop PlatformRemark流程簡述SAP每日定時(shí)透過RFC Adapter 將DN單號(hào)傳給PI，PI 將之轉(zhuǎn)換成文件，再以FTP方式傳送到FTP Server對(duì)應(yīng)的文件夾中。1. SAP程序?qū)N單號(hào)生成，然后 call RFC。2. 透過RFC Adapter，將DN單號(hào)傳入PI，PI 然后會(huì)將通知轉(zhuǎn)為Excel格式的文件。3. PI透過 File/FTP adapter定時(shí)將領(lǐng)料請(qǐng)求文件以FTP的方式放上FTP Server對(duì)應(yīng)

10、的文件夾中。4. 三方物流公司再從文件夾中收下DN單號(hào)文件。來源數(shù)據(jù)接收方式SAP透過 RFC 拋轉(zhuǎn)數(shù)據(jù)，PI環(huán)境相關(guān)設(shè)定如下：Sender端數(shù)據(jù)接收方式Adapter Type 連接方式( X ) RFC ( ) IDoc ( ) JDBC ( ) File ( ) SOAP ACK 確認(rèn)訊息( ) Yes ( X ) NoRFC屬性值A(chǔ)pplication Server (Gateway)Application Server ServiceProgram IDMetadata Application ServerSystem NumberAuthentication ModeLogon U

11、serLogon LanguageLogon Client目標(biāo)數(shù)據(jù)取得方式PI透過FTP將數(shù)據(jù)傳送到文件夾中，PI環(huán)境相關(guān)設(shè)定如下：Receiver端數(shù)據(jù)取得方式Adapter Type 連接方式( ) RFC ( ) IDoc ( ) JDBC ( X ) File ( ) SOAP ACK 確認(rèn)訊息( ) Yes ( X ) NoFile/FTP屬性值FTP IPFTP PortLogon UserPathFile Name來源數(shù)據(jù)結(jié)構(gòu)參考數(shù)據(jù)格式轉(zhuǎn)換需求。目標(biāo)數(shù)據(jù)結(jié)構(gòu)參考數(shù)據(jù)格式轉(zhuǎn)換需求。數(shù)據(jù)格式轉(zhuǎn)換需求SAP 送出的內(nèi)容中必須提供相關(guān)的字段來讓PI判斷文件應(yīng)該發(fā)送給哪一個(gè)物流業(yè)者。SA

12、P 收貨單目標(biāo)數(shù)據(jù)來源數(shù)據(jù)字段名稱字段型態(tài)長度Key字段名稱字段型態(tài)長度Key備注CTR_CODECHAR10CTR_CODECHAR10EKKO- EBELNEKKO- BSART為“UB”“ZUB”O(jiān)rderCHAR20OrderCHAR20TT_NOCHAR10YTT_NOCHAR10YLIKP-VBELNLIKP-LFART為“NL”LINE_NONUMC6YLINE_NONUMC6YLIPS-POSNRTXN_TYPECHAR2YTXN_TYPECHAR2Y固定值“TT”IMPORTCHAR2IMPORTCHAR2固定值為“BB,BN,NN”MEPO1211-RESLO_BEZ T-

13、CODE: ME23N 行項(xiàng)目中的“發(fā)貨存儲(chǔ)地點(diǎn)”從表ztmm_lgort_attr 判斷庫存地屬性如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為B，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為N，則IMPORT顯示BN；如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為B，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為B，則IMPORT顯示BB；如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為N，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為N，則IMPORT顯示NN。HEADER_RMKCHAR255HEADER_RMKCHAR255抬頭文本FOOTER_RMK1CHAR255FOOTE

14、R_RMK1CHAR255篩選界面輸入信息FOOTER_RMK2CHAR255FOOTER_RMK2CHAR255FOOTER_RMK3CHAR255FOOTER_RMK3CHAR255FOOTER_RMK4CHAR255FOOTER_RMK4CHAR255REQ_TRANSFER_YEARCHAR4REQ_TRANSFER_YEARCHAR4REQ_TRANSFER_MONTHCHAR2REQ_TRANSFER_MONTHCHAR2REQ_TRANSFER_DAYCHAR2REQ_TRANSFER_DAYCHAR2MEPO1211EEIND T-CODE: ME23N 行項(xiàng)目中的“交貨日期”

15、REQ_TRANSFER_YEAR 取該日期中的年份REQ_TRANSFER_MONTH 取該日期中的月份REQ_TRANSFER_DAY 取該日期中的天TRANSFER_YEARCHAR4TRANSFER_YEARCHAR4PI發(fā)送對(duì)應(yīng)日期TRANSFER_MONTHCHAR2TRANSFER_MONTHCHAR2TRANSFER_DAYCHAR2TRANSFER_DAYCHAR2FROM_PLANTCHAR4FROM_PLANTCHAR4MEPO_TOPLINE-SUPERFIELDT-CODE: ME23N 抬頭中的“供貨工廠”FROM_WHSCHAR4FROM_WHSCHAR4MEPO

16、1211-RESLO_BEZ T-CODE: ME23N 行項(xiàng)目中的“發(fā)貨存儲(chǔ)地點(diǎn)”TO_PLANTCHAR4TO_PLANTCHAR4MEPO1211- NAME1 T-CODE: ME23N 項(xiàng)目中“工廠”TO_WHSCHAR4TO_WHSCHAR4MEPO1211LGOBE T-CODE: ME23N 項(xiàng)目中“庫存地點(diǎn)”TO_WHS_NAME1CHAR255TO_WHS_NAME1CHAR255取值邏輯如下圖TO_WHS_ADDR1CHAR255TO_WHS_ADDR1CHAR255TO_WHS_CITYCHAR255TO_WHS_CITYCHAR255TO_WHS_PERSONCHAR

17、255TO_WHS_PERSONCHAR255TO_WHS_TEL1CHAR255TO_WHS_TEL1CHAR255TO_WHS_FAXCHAR255TO_WHS_FAXCHAR255TO_WHS_NAME1上圖中的名稱TO_WHS_ADDR1上圖中的街道/門牌號(hào)TO_WHS_CITY上圖中的城市TO_WHS_PERSON上圖中的注釋TO_WHS_TEL1上圖中的電話+分機(jī)號(hào)（電話和分機(jī)號(hào)中用“”連接）TO_WHS_FAX上圖中的傳真ITEM_NOCHAR18ITEM_NOCHAR18RESB-MATNRITEM_DESC1CHAR255ITEM_DESC1CHAR255ZTMM_MAKT-

18、ZMAKTX1ITEM_DESC2CHAR255ITEM_DESC2CHAR255ZTMM_CUSTOMFORM- ZNAMEUOMUNIT3UOMUNIT3RESB-MEINSTRF_QTYQUAN13TRF_QTYQUAN13LIPSD-G_LFIMGBANTCH_NO.CHAR10BANTCH_NO.CHAR10LIPSCHARGAN_NOCHAR10AN_NOCHAR10批次分類中的內(nèi)向交貨單號(hào)PO_NOCHAR10PO_NOCHAR10批次分類中的采購訂單單號(hào)M3_UNITUNIT3M3_UNITUNIT3MARA-GEWEIM3_AMOUNTCHAR16M3_AMOUNTCHAR1

19、6TRF_QTY+ M3_UNITG/Weight_UNITQUAN13G/Weight_UNITQUAN13MARA- BRGEWG/Weight_AMOUNTQUAN13G/Weight_AMOUNTQUAN13G/Weight_UNIT乘以TRF_QTYPO_CCY_CODECUKY5PO_CCY_CODECUKY5批次分類PO_UNIT_COSTCURR11PO_UNIT_COSTCURR11批次分類PO_AMT_FCCURR13PO_AMT_FCCURR13PO unit cost * BATCH QTYHS_CODE1CHAR10HS_CODE1CHAR10ZTMM_CUSTOMF

20、ORM-ZHS_CODE1IMPORT_DUTY_RATENUM13IMPORT_DUTY_RATENUM13ZTMM_CUSTOMFORM-ZTAXCUSTOMES_SUPERVISIONCHAR10CUSTOMES_SUPERVISIONCHAR10ZTMM_CUSTOMFORM-ZCON2COMMODITY_INSPECTIONCHAR10COMMODITY_INSPECTIONCHAR10ZTMM_CUSTOMFORM-ZCON1BRANDCHAR40BRANDCHAR40ZTMM_CUSTOMFORM-ZBRANDDESC1_FOR_C/CCHAR255DESC1_FOR_C/CCH

21、AR255ZTMM_CUSTOMFORM-ZCOM1DESC2_FOR_C/CCHAR255DESC2_FOR_C/CCHAR255ZTMM_CUSTOMFORM-ZCOM2DESC3_FOR_C/CCHAR255DESC3_FOR_C/CCHAR255ZTMM_CUSTOMFORM-ZCOM3REMARK1CHAR255REMARK1CHAR255ZTMM_CUSTOMFORM-ZCOM4REMARK2CHAR255REMARK2CHAR255ZTMM_CUSTOMFORM-ZCOM5EXCHANGE_RATECHAR255EXCHANGE_RATECHAR255BLANK留空DECLARE

22、_STK_AMT_BSCHAR255DECLARE_STK_AMT_BSCHAR255CUSTOM_TAXCHAR255CUSTOM_TAXCHAR255INPUT_TAXCHAR255INPUT_TAXCHAR255CUSTOM_INV_NOCHAR255CUSTOM_INV_NOCHAR255VAT_INV_NOCHAR255VAT_INV_NOCHAR255SAP處理邏輯1. 參數(shù)輸入公司號(hào)產(chǎn)品線DN創(chuàng)建日期DN號(hào)碼Un-sendRe-sendField descriptionField nameType (S/P)Reference field typeLimitation公司號(hào)Com

23、pany必輸控制object維修單號(hào)Order產(chǎn)品線DivisionSelection-optionMARA-SPARTDN日期DN DateSelection-optionLIKPERDATDN號(hào)碼DN NOSelection-optionLIKPVBELNLIKPLFART取值LIKPVBELNLIKPLFART為NLSendButton默認(rèn)取值必須判斷ZDNSEND-SEND為空且ZDNSEND-GI為空。Resend取值必須判斷ZDNSEND-SEND為X，ZDNSEND-GI為空。輸入完參數(shù)后按，如果沒有數(shù)據(jù)，顯示：“沒有符合要求的數(shù)據(jù)”；如有數(shù)據(jù)，顯示格式如format中明細(xì)格式。

24、2. 篩選界面（ALV畫面）FieldSourceLogicRemarkDN號(hào)碼DN NOLIKP-VBELN取值LIKP-VBELNLIKP-LFART為“NL”工廠PlantLIPS-WERKS產(chǎn)品線DivisionMARA-SPART發(fā)貨庫存地Send LocationLIPS-LGORT收貨庫存地Receive LocationMEPO1211LGOBE對(duì)應(yīng)STO的收貨庫存地STO號(hào)碼STO NO通過DN對(duì)應(yīng)的STOImport從表ztmm_lgort_attr來判斷庫存地屬性如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為B，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為N，則IMPORT顯示BN；如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為B，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為B，則IMPORT顯示BB；如MEPO1211-RESLO_BEZ對(duì)應(yīng)的庫存地屬性為N，EKPO-LGOBE對(duì)應(yīng)的庫存地屬性為N，則IMPORT顯示NN。CHAR 2FOOTER_RMK1根據(jù)MASS傳來的REMARK1,2,3,4對(duì)應(yīng)數(shù)據(jù)可輸字段，如用戶需要修改則