SAP查询操作手册
目录
1无物流集成查询 ............................................................................................................................. 5 1.1总账报表及查询 ........................................................................................................................... 5
1.1.1凭证显示FB03 ..................................................................................................................... 5 1.1.2显示科目余额FAGLB03 ...................................................................................................... 6 1.1.3批量显示行项目FAGLL03 ................................................................................................... 9 1.1.4凭证综合查询ZP1FIRP008（“万能”查询）................................................................. 10 1.1.5科目余额表ZP1FIRP021 .................................................................................................. 11 1.1.6资产负债表ZP1FIRP014 .................................................................................................. 12 1.1.7利润表ZP1FIRP015 .......................................................................................................... 13 1.1.8现金流量表（直接法）ZP1FIRP016 ............................................................................... 14 1.1.9现金流量表（间接法）ZP1FIRP028 ............................................................................... 15 1.1.10成本中心余额显示S_ALR_87013611 ........................................................................... 15 1.1.11成本中心行项目显示KSB1 ............................................................................................. 17 1.1.12成本指标对比分析表ZP1FIRP022 ................................................................................ 18 1.1.13内部订单预算与实际余额查询S_ALR_87013019 ....................................................... 19 1.1.14内部订单行项目查询KOB1 ............................................................................................ 21 1.1.15专项应付款明细表ZP1FIRP042 .................................................................................... 23 1.1.16月结查询报表ZP1FIRP067 ............................................................................................ 23
1.2应收报表及查询 ......................................................................................................................... 24
1
1.2.1客户余额显示FD10N ........................................................................................................ 24 1.2.2客户行项目查询FBL5N ..................................................................................................... 25 1.2.3客户余额明细汇总表ZP1FIRP024 .................................................................................. 26 1.2.4客户往来账龄分析表ZP1FIRP019 .................................................................................. 27
1.3应付报表及查询 ......................................................................................................................... 28
1.3.1供应商余额显示FK10N .................................................................................................... 28 1.3.2供应商行项目查询FBL1N ................................................................................................. 29 1.3.3供应商余额显示FB10N .................................................................................................... 31 1.3.4供应商余额明细汇总表ZP1FIRP025 .............................................................................. 32 1.3.5供应商往来帐龄分析表ZP1FIRP018 .............................................................................. 33 1.3.6未清暂估余额查询ZP1FIRP064 ...................................................................................... 33 1.3.7供应商余额查询（含暂估）ZP1FIRP069 ....................................................................... 34
1.4资产报表及查询 ......................................................................................................................... 35
1.4.1资产卡片显示AS03 ........................................................................................................... 35 1.4.2资产余额（可按期间查询）S_ALR_87012041 .............................................................. 38 1.4.3折旧运行日志（单月折旧查询）AFBP ............................................................................ 39 1.4.4资产综合查询（实时数）ZP1FIRP009 ........................................................................... 41 1.4.5固定资产变动结存表ZP1FIRP032 .................................................................................. 42
1.5贷款相关报表及查询 ................................................................................................................. 43
1.5.1贷款合同显示FNV3 .......................................................................................................... 43 1.5.2贷款合同批量查询FNG3 .................................................................................................. 43 1.5.3长短期借款明细ZP1FIRP057 .......................................................................................... 44
2
1.5.4银行授信余额表ZP1FIRP012 .......................................................................................... 45 1.5.5信用证/保函显示表ZP1FIRP051 ..................................................................................... 46
2物流集成查询 ............................................................................................................................... 48 2.1采购订单查询 ............................................................................................................................. 48
2.1.1采购订单显示ME23N ....................................................................................................... 48 2.1.2采购订单批量查询ME2N ................................................................................................. 52
2.2出入库查询 ................................................................................................................................. 54
2.2.1物料清单MM60 ................................................................................................................ 54 2.2.2物料凭证显示MB03 .......................................................................................................... 54 2.2.3物料凭证清单MB51 .......................................................................................................... 55 2.2.4库存总览MMBE（单个物料）......................................................................................... 57 2.2.5库存清单MB52（实时库存） .......................................................................................... 58 2.2.6收发存汇总查询MB5B ...................................................................................................... 59 2.2.7库龄分析表ZP1MMRP116（实时库龄） ...................................................................... 61 2.2.8收发存明细表ZP1MMRP120 .......................................................................................... 62 2.2.9凭证综合查询ZP1FIRP008 .............................................................................................. 63 2.2.10未清暂估余额查询ZP1FIRP064 .................................................................................... 64 2.2.11供应商余额查询（含暂估）ZP1FIRP069 ..................................................................... 65
2.3采购发票查询 ............................................................................................................................. 66
2.3.2采购发票显示MIR4 ........................................................................................................... 66 2.3.3采购发票批量查询MIR6 ................................................................................................... 67
2.4销售订单查询 ............................................................................................................................. 69
3