扬农化工（瑞祥）SAP项目-FI-采购合同执行情况明细表开发说明书-V3.0-20180502

开发规格书第5页，共9页扬农化工SAP项目-开发规格书1需求模块MACROBUTTONCheckIt_CheckBox£MM MACROBUTTONCheckIt_CheckBox£PP MACROBUTTONCheckIt_CheckBox£SD ■FIMACROBUTTONCheckIt_CheckBox£CO MACROBUTTONCheckIt_CheckBox£PSMACROBUTTONCheckIt_CheckBox£其它Spec编号FI009短描述瑞祥采购合同执行情况明细表类型报表MACROBUTTONUnCheckIt_Radiobutton报表MACROBUTTONCheckIt_RadiobuttonABAPProgramMACROBUTTONCheckIt_RadiobuttonInformationSystemMACROBUTTONCheckIt_RadiobuttonReportPrinterMACROBUTTONCheckIt_RadiobuttonReportWriterMACROBUTTONCheckIt_RadiobuttonSAPQueryMACROBUTTONCheckIt_RadiobuttonBWreportMACROBUTTONCheckIt_RadiobuttonCrystalReportsMACROBUTTONCheckIt_RadiobuttonOthers_____________________________________________________MACROBUTTONCheckIt_Radiobutton表单MACROBUTTONCheckIt_Radiobutton流程增强MACROBUTTONCheckIt_RadiobuttonUserExitMACROBUTTONCheckIt_RadiobuttonBADIMACROBUTTONCheckIt_RadiobuttonDialogProgramMACROBUTTONCheckIt_RadiobuttonOthers__________________________________MACROBUTTONCheckIt_Radiobutton接口MACROBUTTONCheckIt_RadiobuttonBAPIMACROBUTTONCheckIt_RadiobuttonIDOCMACROBUTTONCheckIt_RadiobuttonALEMACROBUTTONCheckIt_RadiobuttonOthers__________________________MACROBUTTONCheckIt_Radiobutton数据转移需求优先级MACROBUTTONCheckIt_RadiobuttonHigh/关键 MACROBUTTONUnCheckIt_RadiobuttonMACROBUTTONCheckIt_RadiobuttonMid/推荐 MACROBUTTONCheckIt_RadiobuttonLow/可选预计开发天数（由功能顾问与开发顾问评估）必填_______天是否有标准功能MACROBUTTONCheckIt_RadiobuttonYes MACROBUTTONUnCheckIt_RadiobuttonNo标准功能未采用的原因:MACROBUTTONCheckIt_RadiobuttonPerformanceMACROBUTTONCheckIt_RadiobuttonComplexityMACROBUTTONCheckIt_RadiobuttonOtherse参考的标准功能表单开发：列出参考的标准的Form的技术名称报表开发：列出参考的标准报表文档变更历史版本号文档维护时间姓名简要的描述1.02018/1/25杨锋新增2.02018/3/29张锦涛补充开发技术说明

2详细功能描述2.1选择屏幕：公司代码：XXXX采购组织：FROM：XXXX/XX/XXTO：XXXX/XX/XX订单类型：FROM：XXXX/XX/XXTO：XXXX/XX/XX供应商：FROM：XXXX/XX/XXTO：XXXX/XX/XX采购订单号：FROM：XXXX/XX/XXTO：XXXX/XX/XX订单日期：FROM：XXXX/XX/XXTO：XXXX/XX/XX创建人：XXXX顺序字段名称字段技术名称字段描述特殊需求1公司代码EKKO-BUKRS公司代码必输2项目编码PROJ-PSPID项目编码项目编码查询公司代码非必输3WBS编码PRPS-PSPIDWBS编码WBS编码查询公司代码非必输4供应商编号EKKO-LIFNR供应商编号5采购订单号EKKO-EBELN采购订单号6订单类型EKKO-BSART订单类型7订单日期EKKO-BEDAT订单日期8采购组织EKKO-EKORG采购组织9创建人EKKO-ERNAM创建人2.2报表/表单/功能的字段顺序字段字段技术名称字段描述类型长度说明BUKRSEKKO-BUKRS公司代码CHAR4LIFNREKKO-LIFNR供应商编号CHAR10NAME1LFA1-NAME1供应商名称CHAR35BSARTEKKO-BSART订单类型CHAR4BATXTT161T-BATXT订单类型名称CHAR20EKORGEKKO-EKORG采购组织CHAR4EKOTXT024E-EKOTX采购组织名称CHAR20创建人EKKO-ERNAM创建人CHAR12NAME_TEXTADRP-NAME_TEXT创建人名称CHAR80EBELNEKKO-EBELN采购订单号CHAR10BSTNKEKKO-BSTNK合同号CHAR20MATNREKPO-MATNR物料号CHAR18服务:ESLL-SRVPOSMAKTXMAKT-MAKTX物料描述CHAR40服务描述:ASMD-ASKTXSGTXTRESB-SGTXT设备位号CHAR50MATKLEKPO-MATKL物料组CHAR9WGBEZT023T-WGBEZ物料组描述CHAR20TXZ01EKPO-TXZ01短文本CHAR40ANLN1EKPO-ANLN1资产号CHAR12TXT50ANLA-TXT50资产描述CHAR50WERKSEKPO-WERKS工厂CHAR4MENGEEKPO-MENGE订单数量CHAR13NETWREKPO-NETWR订单金额CHAR13BRTWREKPO-BRTWR订单含税金额CHAR13MENGEMSEG-MENGE收货数量CHAR13MENGEEKBE-MENGE发票数量CHAR13WRBTREKBE-WRBTR发票金额CHAR13MWSKZEKBE-MWSKZ税码CHAR2税率*‰SHKZGMSEG-SHKZG收货借/贷标识CHAR1S-借，H-贷SHKZGEKBE--SHKZG发票借/贷标识CHAR1S-借，H-贷BELNREKBE-BELNR采购发票号CHAR13PS_PSP_PNREKKN-PS_PSP_PNRWBS编号CHAR8POST1PRPS-POST1WBS描述CHAR40ZSQJEZSQJE付款申请金额CHAR10相同PO汇总ZSFJEZTFI003-ZSFJE已付金额CHAR10相同PO汇总ZFKMCT042Z-TEXT1付款方式CHAR30FKBLFKBL付款比例DEC5BANFNEKPO-BANFN采购申请CHAR10BNFPOEKPO-BNFPO采购申请行项目NUMC5RSNUMRSDBS-RSNUM预留NUMC10RSPOSRSDBS-RSPOS预留行项目NUMC42.4逻辑关系：根据屏幕的码=PRPS-PRHI，取PRPS-PSPNR，PRPS-PSPNR=EKKN-PS_PSP_PNR，根据屏幕输入WBS=EKKN-PS_PSP_PNR,取EKKN-EBELN,EKKN-EBELPEKKO-EBELN=EKPO-EBELN=EKKN-EBELN,EKPO-EBELN=EKBE－EBELN=EKKN-EBELN,EKPO-EBELP=EKBE－EBELP=EKKN-EBELPADRP-NAME_TEXT:创建人名称,条件EKKO-ERNAM=USR21-BNAME,取USR21-PERSNUMBER,USR21-PERSNUMBER=ADRP-PERSNUMBER,取ADRP-NAME_TEXTESLL-SRVPOS:服务条目编码,条件：EKPO-EBELN=ESLH-EBELN，EKPO-EBELP=ESLH-EBELP，MAX（ESLH-PACKNO），ESLH-PACKNO=ESLL-PACKNO，取ESLL-SRVPOSASMD-ASKTX:服务短文本,条件：ASMD-ASNUM=ESLL-SRVPOSRSDBS-RSNUM:预留,条件:EKPO-EBELN=RSDBS-EBELN,EKPO-EBELP=RSDBS-EBELP,RSDBS-RSPOS:预留行项目,条件同预留逻辑MARA-MATKL（物料组）：MARA-MATNR=MSEG-MATNR，取MARA-MATKLT023T-WGBEZ（物料组描述）：T023T-MATKL=MARA-MATK，取T023T-WGBEZFKBL:付款比例条件:SUM(ZTFI003-ZSFJE)/SUM(EKPO-NETWR),按照单个订单行项目金额汇总.根据MSEG-EBELN、EBELP对应的MSEG-MBLNR，取到各采购订单行项目的MSEG-MENGE，按(MSEG-SHKZG=S)-(MSEG-SHKZG=H)汇总，得到收货数量根据MSEG-EBELN、EBELP对应的MSEG-MBLNR，取各采购订单行项目的EKPO-NETWR*MSEG-MENGE/EKPO-MENGE值，按(MSEG-SHKZG=S)-(MSEG-SHKZG=H)汇总，得到收货金额根据EKBE-EBELN、EBELP对应的EKBE-BELNR，取到各采购订单行项目EKBE-MENGE，按(EKBE-SHKZG=S)-(EKBE-SHKZG=H)汇总，得到发票数量根据EKBE-EBELN、EBELP对应的EKBE-BELNR，取各采购订单行项目的EKBE-WRBTR*（1+EKBE-MWSKZ对应的KONP-KBETR值*‰，按(EKBE-SHKZG=S)-(EKBE-SHKZG=H)汇总，得到发票金额。（根据A003-MWSKZ找到对应的KNUMH，根据KONP-KNUM找到KBETR的值，并乘以‰得到税率）3技术说明ProgramnameZFIR1008TransactioncodeZFIR1008AuthorizationObjectFormFormnameN/AOutputtypeN/AFormroutineN/A3.1程序逻辑：根据选择屏幕输入条件，关联表EKKO,EKPO,EKKN取得相关采购订单信息，如果选择屏