MM_TABLES
SAP事务码(MM常用)
Devk900118 100 SAP事务码1．MMBE:查看IM层物料库存信息2．LS24：查看WM层物料库存信息3．SE11：查看表定义4．SE16（N）：查看表记录5．SE37 ：查看BAPI程序6．SE38 ：查看BAPI报表7．SM35：Batch Input Monitoring#8．ME21：创建采购订单9．ME22：更改采购订单#10．ME23：显示采购订单11．ME24：采购订单补充12．MB01：按采购订单收货13．MB31：成品收货（入库）14．MB23：显示预留15．MB24:保留清单库存管理16．MB21:创建预留17．LT01~25:01：创建转储单02：按转储单清除库存21：显示TO 24：查看TOLT01 Create Transfer Order 创建转储单LT02 Create TO for Inventory Difference 创建库存差额转储单LT03 Create TO from Delivery Note 按交货单创建转储单LT04 Create TO from TR 按转储要求创建转储单LT05 Process Posting Change Notice 处理记帐改变通知LT06 Create TO for Material Document 创建物料凭证的转储单LT07 Create TO for mixed storage unit 创建混和存储单位的转储单LT08 Manual addition to storage unit 人工增加仓储单位LT09 ID point function for storage units 仓储单位的标识点功能LT0A Pre-plan storage units 预先计划仓储单位LT0B Stock Placement of Shipping Units 发运单位的入库LT0C Stock Removal of Shipping Units 发运单位的出库LT0D Stock Transfer of Shipping Units 装运单元的库存转储LT0E Create Removal TO for 2-Step Picking 为两步领货创建移动TOLT10 Create Transfer Order from List 创建自清单的划帐委托LT11 Confirm Transfer Order Item 确认转储单项目LT12 Confirm Transfer Order 确认转储单LT13 Confirm TO for storage unit 确认仓储单位的转储单LT14 Confirm preplanned TO item 确认预计划的转储单项目LT15 Cancelling transfer order 取消转储单LT16 Cancelling TO for storage unit 取消仓储单位的转储单(TO)LT17 Single Entry of Actual Data 实际数据的单个条目LT1A Change Transfer Order 改变划帐委托LT21 Display Transfer Order 显示转储单LT22 Display Transfer Order / Stor. Type 显示转储单/仓储类型LT23 Display Transfer Orders by Numbers 按号码显示转储单LT24 Display Transfer Order / Material 显示转储单/物料LT25 Display Transfer Order / Reference 显示划帐委托/参考LT26 Transfer orders for storage bin 仓位转储单LT27 Transfer order for storage unit 仓储单位用的转储单LT28 Display Transfer Order / Reference 显示划帐委托/参考LT31 Print TO Manually 手工打印转储单LT32 Print transfer order for stor.unit 打印仓储单位转储单LT41 Prepare TRs for Multiple Processing 准备多重处理的转储单LT42 Create TOs by Multiple Processing 按多处理创建转储单LT43 Forming groups for deliveries 形成交货组LT44 Release for Multiple Processing 批准重复处理LT45 Evaluation of reference numbers 参考号评估LT51 Maintain Missing Stock 保持遗漏原料LT63 Control: Single Entry of Actual Data 控制：实际数据的单个条目LT64 Single Entry of Actual Data 实际数据的单个条目LT72 Determine 2-step relevance 确定两步相关LT73 Display 2-step 显示两步18．MM01~03:创建、编辑、显示物料20．ME11：创建信息记录#23．MB1B：转储24．MB1A：输入发货25．MB1C：其它收货26．MB11：转储27．MB51（N）：查看物料凭证清单28．MBST：取消物料凭证29．MB03：显示物料凭证30．MCBR：批次分析31．XK01：创建供应商32．ME01：维护物料供应商33．ME5A：采购申请的清单显示34．ME55：采购申请的集中批准35．ME57：分配并处理采购申请37．ME28：批准备采购订单38．ME9F:39．ME2L：每个供应商的采购订单40．ME31：创建框架协议41．MD03：42．MD04：显示库存/需求清单43．MRKO：寄售和管道结算44．MELB：45．ME47：报价46．MI3147．MI22：显示物料的库存盘点凭证48．MI24：库存盘点清单49．MI03：显示库存的盘点凭证50．MI04：输入库存清点51．MI20：库存差异清单52．MI07：过帐库存差异53．MI02：更改库存盘点凭证54．ME2O：提供给供应商的SC库存监视55．MB5L：库存值清单：余额56．MB5B：库存按过帐日期57．MB58：58．MB5860．MB5S61．MB31：按订单收货62．MM60：物料清单63．MB52：显示现有仓库物料库存64．CO01~15：生产订单65．IW13：物料反查清单以上只是可能会用到的TCode，在实际开发中如果遇到新的TCode我们会即是时提供给您，同时请提供目前所有流程中所用到的所有TCode。
MM物料库存转移(bapi)
*&---------------------------------------------------------------------**& Report ztmm_e001*& Report Name: MM 物料库存转移*& Report Description: MM 物料库存转移*& T-Code: zmme001*&---------------------------------------------------------------------**& Created By: TTC Created On: 2021-11-15*& Updated By: TTC Updated On: 2021-11-15*&---------------------------------------------------------------------*REPORT ztmm_e001.TABLES: mkpf,mseg,mara,mska,mchb,ztmm_e001,vbap,rm07m,t158b,t001l,msegk. DATA: lv_bwart(5), "移动类型lv_sobkz LIKE mseg-sobkz, "特殊库存lv_bldat LIKE mkpf-bldat, "凭证中的凭证日期lv_budat LIKE mkpf-budat, "凭证中的过帐日期lv_werks LIKE mseg-werks, "工厂lv_matnr LIKE mara-matnr, "物料号lv_vbeln LIKE mska-vbeln, "销售单lv_posnr LIKE mska-posnr, "销售项目lv_vbeln_in LIKE mska-vbeln, "接收销售单lv_posnr_in LIKE mska-posnr, "接收销售项目LV_WERKS_IN LIKE mseg-werks, "接下班厂rp1(1),rp2(1).*SELECTION-SCREEN BEGIN OF BLOCK bl WITH FRAME TITLE text-001.*PARAMETERS: P1 TYPE C RADIOBUTTON GROUP GP1 USER-COMMAND UC01, * P2 TYPE C RADIOBUTTON GROUP GP1.*SELECTION-SCREEN END OF BLOCK bl .*功能码返回值DATA: ok_code TYPE sy-ucomm,save_ok TYPE sy-ucomm.CONTROLS: ztmm_1001 TYPE TABLEVIEW USING SCREEN 1001,ztmm_1002 TYPE TABLEVIEW USING SCREEN 1002,ztmm_1003 TYPE TABLEVIEW USING SCREEN 1003,ztmm_1004 TYPE TABLEVIEW USING SCREEN 1004.DATA: lv_cols LIKE LINE OF ztmm_1001-cols,lv_line TYPE i.DATA: lo_grid TYPE REF TO cl_gui_alv_grid.DATA:gt_ztmm_e001 TYPE ztmm_e001 OCCURS 0 WITH HEADER LINE. DATA:gt_ztmm_e002 TYPE ztmm_e001 OCCURS 0 WITH HEADER LINE. DATA:gt_ztmm_e003 TYPE ztmm_e001 OCCURS 0 WITH HEADER LINE. DATA:gt_ztmm_e004 TYPE ztmm_e001 OCCURS 0 WITH HEADER LINE.TYPE-POOLS: slis, icon.DATA: g_repid LIKE sy-repid,gt_fieldcat TYPE slis_t_fieldcat_alv,wa_fieldcat TYPE slis_fieldcat_alv,gt_event TYPE slis_t_event,wa_event TYPE slis_alv_event,gt_selfield TYPE slis_selfield OCCURS 0,l_layout TYPE slis_layout_alv.START-OF-SELECTION.CALL SCREEN 1010."库存转移主窗口INCLUDE ztmm_e001_status_1010o01.INCLUDE ztmm_e001_user_command_1010i01.* "411 移动类型INCLUDE ztmm_e001_status_1001o01. "411-PBO INCLUDE ztmm_e001_user_command_1001i01. "411-BAI* "412 移动类型INCLUDE ztmm_e001_status_1002o01. "412-PBO INCLUDE ztmm_e001_user_command_1002i01. "412-PAI* "413 移动类型INCLUDE ztmm_e001_status_1003o01. "413-PBO INCLUDE ztmm_e001_user_command_1003i01. "413-PAI* "301 移动类型INCLUDE ztmm_e001_status_1004o01. "301-PBOINCLUDE ztmm_e001_user_command_1004i01. "301-PAI*&---------------------------------------------------------------------**& Form get_matnrdesc*&---------------------------------------------------------------------** text*----------------------------------------------------------------------*FORM get_matnrdesc. "网络值描述DATA: wa_j_3apghd TYPE SORTED TABLE OF j_3apghdWITH UNIQUE KEY mandt j_3apgnr j_3avdat WITH HEADER LINE.DATA: wa_j_3apgen TYPE SORTED TABLE OF j_3apgenWITH UNIQUE KEY mandt j_3apgnr j_3avdat j_3akord1 j_3akord2 j_3akord3 WITH HEADER LINE.DATA: wa_cawn TYPE SORTED TABLE OF cawnWITH UNIQUE KEY mandt atinn atzhl adzhl WITH HEADER LINE.DATA: wa_cawnt TYPE SORTED TABLE OF cawntWITH UNIQUE KEY mandt atinn atzhl spras adzhl WITH HEADER LINE.DATA: BEGIN OF lt_j_3apgnr OCCURS 0,j_3apgnr LIKE mara-j_3apgnr,END OF lt_j_3apgnr.DATA: BEGIN OF lt_charact OCCURS 0,g_3abzd TYPE j_3apghd-j_3abzd1,END OF lt_charact.DATA: BEGIN OF lt_cawn OCCURS 0,atinn TYPE cawn-atinn,END OF lt_cawn.DESCRIBE TABLE wa_j_3apghd LINES lv_line.IF lv_line = 0.LOOP AT gt_ztmm_e001.lt_j_3apgnr-j_3apgnr = gt_ztmm_e001-j_3apgnr.COLLECT lt_j_3apgnr.ENDLOOP.SORT lt_j_3apgnr.SELECT * INTO CORRESPONDING FIELDS OF TABLE wa_j_3apghd FROM j_3apghdFOR ALL ENTRIES IN lt_j_3apgnr WHERE j_3apgnr = lt_j_3apgnr-j_3apgnr.SELECT * INTO CORRESPONDING FIELDS OF TABLE wa_j_3apgen FROM j_3apgen FOR ALL ENTRIES IN lt_j_3apgnr WHERE j_3apgnr = lt_j_3apgnr-j_3apgnr.LOOP AT wa_j_3apghd.CLEAR lt_charact.lt_charact-g_3abzd = wa_j_3apghd-j_3abzd1.COLLECT lt_charact.CLEAR lt_charact.lt_charact-g_3abzd = wa_j_3apghd-j_3abzd2.COLLECT lt_charact.ENDLOOP.LOOP AT lt_charact.lt_cawn-atinn = lt_charact-g_3abzd.APPEND lt_cawn.ENDLOOP.SORT lt_cawn.SELECT * INTO CORRESPONDING FIELDS OF TABLE wa_cawn FROM cawnFOR ALL ENTRIES IN lt_cawn WHERE atinn = lt_cawn-atinn.SELECT * INTO CORRESPONDING FIELDS OF TABLE wa_cawnt FROM cawnt FOR ALL ENTRIES IN lt_cawn WHERE atinn = lt_cawn-atinn.ENDIF.*****************************************************************LOOP AT gt_ztmm_e001."网络值描述DATA:g_3abzd1 TYPE string,g_3abzd2 TYPE string,g_color TYPE string,g_size TYPE string,g_atzhl1 TYPE string,g_atzhl2 TYPE string,g_desc1 TYPE string,g_desc2 TYPE string.CLEAR:g_3abzd1,g_3abzd2,g_color,g_size,g_atzhl1,g_atzhl2,g_desc1,g_desc2. "通过物料网格编号：取得维值1,维值2(内部特性号)READ TABLE wa_j_3apghd WITH KEY mandt = sy-mandtj_3apgnr = gt_ztmm_e001-j_3apgnr .g_3abzd1 = wa_j_3apghd-j_3abzd1.g_3abzd2 = wa_j_3apghd-j_3abzd2."通过网格值及物料网格编号：取得颜色及尺码READ TABLE wa_j_3apgen WITH KEY mandt = sy-mandt j_3apgnr = gt_ztmm_e001-j_3apgnrj_3akordx = gt_ztmm_e001-j_3asize.g_color = wa_j_3apgen-j_3akord1.g_size = wa_j_3apgen-j_3akord2."内部计数器值READ TABLE wa_cawn WITH KEY mandt = sy-mandtatinn = g_3abzd1atwrt = g_color.g_atzhl1 = wa_cawn-atzhl.READ TABLE wa_cawn WITH KEY mandt = sy-mandtatinn = g_3abzd2atwrt = g_size.g_atzhl2 = wa_cawn-atzhl."网络值描述READ TABLE wa_cawnt WITH KEY mandt = sy-mandtatinn = g_3abzd1spras = 1atzhl = g_atzhl1.g_desc1 = wa_cawnt-atwtb.READ TABLE wa_cawnt WITH KEY mandt = sy-mandtatinn = g_3abzd2spras = 1atzhl = g_atzhl2.g_desc2 = wa_cawnt-atwtb.IF g_desc1 IS INITIAL AND g_desc2 IS INITIAL.gt_ztmm_e001-j_3asize_dsc = ''.ELSEIF g_desc2 IS INITIAL.CONCATENATE g_desc1 '' INTO gt_ztmm_e001-j_3asize_dsc.ELSE.CONCATENATE g_desc1 '/' g_desc2 INTO gt_ztmm_e001-j_3asize_dsc. ENDIF.MODIFY gt_ztmm_e001.ENDLOOP.FREE: wa_j_3apghd,wa_j_3apgen,wa_cawn,wa_cawnt.ENDFORM. " matnrdesc*&---------------------------------------------------------------------**& Form clear_data*&---------------------------------------------------------------------** text*----------------------------------------------------------------------*FORM clear_data.CLEAR:lv_bwart, "移动类型lv_sobkz, "特殊库存lv_werks, "工厂lv_matnr, "物料号lv_vbeln, "销售单lv_posnr, "销售项目lv_vbeln_in, "接收销售单lv_posnr_in. "接收销售项目REFRESH: gt_ztmm_e001,gt_ztmm_e002,gt_ztmm_e003,gt_ztmm_e004. FREE:ztmm_e001.ENDFORM. "get_matnrdesc一、执行以上代码得出以下界面：1-1、主窗口界面逻辑流：PROCESS BEFORE OUTPUT.MODULE STATUS_1010.*PROCESS AFTER INPUT.MODULE USER_COMMAND_1010.1-2、主窗口OUTPUT模块代码：MODULE status_1010 OUTPUT.SET PF-STATUS 'ZTMM_STATE'.SET TITLEBAR 'ZTMM_E001_10'. "USER_COMMAND ENDMODULE. " STATUS_1010 OUTPUT1-2、主窗口INPUT模块代码：MODULE user_command_1010 INPUT.save_ok = sy-ucomm.CASE save_ok.WHEN 'LV_BTN1'.CALL SCREEN 1001.WHEN 'LV_BTN2'.CALL SCREEN 1002.WHEN 'LV_BTN3'.CALL SCREEN 1003.WHEN 'LV_BTN4'.CALL SCREEN 1004.WHEN 'LV_BTN5' OR 'EXIT' OR 'BACK' OR 'CANC' .SET SCREEN 0. LEAVE SCREEN.WHEN 'SAVE'.MODIFY SCREEN.ENDCASE.ENDMODULE. " USER_COMMAND_1010 INPUT2-1、1001屏幕界面逻辑流：PROCESS BEFORE OUTPUT.FIELD !lv_bldat MODULE %_lv_bldat.FIELD !lv_budat MODULE %_lv_budat.FIELD !lv_werks MODULE %_lv_werks.FIELD !lv_vbeln MODULE lv_vbeln.FIELD !lv_posnr MODULE lv_posnr.FIELD !lv_matnr MODULE lv_matnr.MODULE status_1001.LOOP AT gt_ztmm_e001 WITH CONTROL ztmm_1001 CURSOR ztmm_1001-top_line. MODULE display_ztmm_1001.ENDLOOP.PROCESS AFTER INPUT.LOOP AT gt_ztmm_e001.MODULE modify_data_1001.ENDLOOP.MODULE user_command_1001.2-2、1001屏幕OUTPUT模块代码：MODULE status_1001 OUTPUT.SET PF-STATUS 'ZTMM_STATE'.SET TITLEBAR 'ZTMM_E001_01'.DESCRIBE TABLE gt_ztmm_e001 LINES lv_line.ztmm_1001-lines = lv_line.IF gt_ztmm_e001 IS INITIAL.lv_bldat = sy-datum.lv_budat = sy-datum.lv_bwart = '411'.lv_sobkz = 'E'.ENDIF.ENDMODULE. " STATUS_1001 OUTPUT*----------------------------------------------------------------------** MODULE display_ztmm_1001 OUTPUT*----------------------------------------------------------------------***----------------------------------------------------------------------*MODULE display_ztmm_1001 OUTPUT.READ TABLE gt_ztmm_e001 INTO ztmm_e001 INDEX ztmm_1001-current_line. " DISPLAY OUTP UTENDMODULE. " DISPLAY_ZTMM_1001 OUTPUT2-2、1001屏幕INPUT模块代码：*----------------------------------------------------------------------****INCLUDE ZTMM_E001_USER_COMMAND_1001I01 .*----------------------------------------------------------------------**&---------------------------------------------------------------------**& Module USER_COMMAND_1001 INPUT*&---------------------------------------------------------------------** text*----------------------------------------------------------------------*MODULE user_command_1001 INPUT.save_ok = sy-ucomm. "ok_code .CASE save_ok.WHEN 'EXIT' OR 'BACK' OR 'CANC' .PERFORM clear_data.SET SCREEN 0. LEAVE SCREEN.WHEN 'SAVE' .PERFORM save_data_1001 .WHEN 'BTN_CLEAR' .FREE:gt_ztmm_e001. "清空列表WHEN 'BTN_GET_STOCK'.PERFORM get_data_1001. "读取数据。
mm操作代码汇总
MM01 - 创建物料主数据XK01 - 创建供应商主数据ME11 - 创建采购信息记录ME01 - 维护货源清单ME51N- 创建采购申请ME5A - 显示采购申请清单ME55 - 批准采购申请（批准组：YH）ME57 –分配并处理采购申请MB21 - 预留MB24 - 显示预留清单ME21N- 创建采购订单ME28 - 批准采购订单（批准组：YS）ME9F - 采购订单发送确认ME2L - 查询供应商的采购凭证ME31 - 创建采购协议MD03 - 手动MRPMD04 - 库存需求清单（MD05 - MRP清单）MRKO - 寄售结算MELB - 采购申请列表（需求跟踪号）ME41 - 创建询价单ME47 - 维护报价ME49 - 价格比较清单MI31 - 建立库存盘点凭证MI21 - 打印盘点凭证MI22 - 显示实际盘点凭证内容MI24 - 显示实际盘点凭证清单MI03 - 显示实际盘点清单MI04 - 根据盘点凭证输入库存计数MI20 - 库存差异清单MI07 - 库存差额总览记帐MI02 - 更改盘点凭证MB03 - 显示物料凭证ME2O - 查询供应商货源库存MB03 - 显示物料凭证MMBE - 库存总览MB5L - 查询库存价值余额清单MCBR - 库存批次分析MB5B - 查询每一天的库存MB58 - 查询客户代保管库存MB25 - 查询预留和发货情况MB51MB5S - 查询采购订单的收货和发票差异MB51 - 物料凭证查询（可以按移动类型查询）ME2L - 确认采购单/转储单正确MCSJ - 信息结构S911 采购信息查询（采购数量价值、收货数量价值、发票数量价值）MCBA - 核对库存数量,金额MM04 - 显示物料改变MMSC - 集中创建库存地点MIGO_GR根据单据收货:MB1C - 其它收货MB1A - 输入发货MB1B - 转储MB31 - 生产收货MB01 - 采购收货)MBST - 取消物料凭证MM60 - 商品清单ME31L- 创建计划协议ME38 - 维护交货计划ME9A - 消息输出MB04 - 分包合同事后调整MB52 - 显示现有的仓库物料库存MB90 - 来自货物移动的输出CO03 - 显示生产订单IW13 - 物料反查订单（清单）IW33 - 显示维修订单VA01 -创建销售订单VL01N - 参照销售订单创建外向交货单VL02N –修改外向交货单（拣配、发货过帐）VL09 –冲销销售的货物移动VF01 –出具销售发票VF04 –处理出具发票到期清单VF11 –取消出具销售发票Warehouse Mangement:LB01 Create Transfer Requirement 创建转储需求LB02 Change transfer requirement 修改转储需求LB03 Display Transfer Requirement 显示转储需求LB10 TRs for Storage Type 按仓储类型的转储请求LB11 TRs for Material 物料转储请求LB12 TRs and Posting Change for MLEat.Doc. 转储请求及物料凭证变更传送LB13 TRs for Requirement 按需求的转储请求LD10 Clear decentralized inventory diff. 清除分散的库存差异LD11 Clear differences for decentral.sys. 清除分散系统的差异LI01 Create System Inventory Record 创建系统库存记录LI02 Change System Inventory Record 修改系统库存记录LI03 Display System Inventory Record 显示系统库存记录LI04 Print System Inventory Record 打印系统库存记录LI05 Inventory History for Storage Bin 仓位的库存历史LI06 Block stor.types for annual invent. 冻结年库存仓储类型LI11 Enter Inventory Count 输入库存盘点LI12 Change inventory count 修改库存盘点LI13 Display Inventory Count 显示库存盘点数LI14 Start Inventory Recount 库存重新盘点开始LI20 Clear Inventory Differences WM 清除库存差异仓库管理WMLI21 Clear Inventory Differences in MM-IM 清除MM-IM 中的库存差额LL01 Warehouse Activity Monitor 仓库活动监控LLVS WM Menu 仓库管理菜单LN01 Number Ranges for Transfer Requirem. 转储需求编号范围LN02 Number Ranges for Transfer Orders 转储单编号范围LN03 Number Ranges for Quants 数量编号范围LN04 Number Ranges for Posting Changes 修改的数字范围记帐LN05 Number Ranges for Inventory 存货的编号范围LN06 Number Ranges for Reference Number 参考号编号范围LN08 Number Range Maintenance: LVS_LENUM 编号范围维护:LVS_LENUMLP10 Direct picking for PO 直接为采购单(PO)分检LP11 WM staging of crate parts WM 装箱部件待运LP12 Staging release order parts (WM-PP) 待运下达订单零件LP21 WM replenishment for fixed bins WM 固定仓位补充LP22 Replenishm. Planning for Fixed Bins 补充。
SAP--MM归档
##
# # # ###### #
####
#
# # # ##### #
####
#
####
#
## ## ###### ######
#### ## # # ## ####
#### # # ###### # # ## ## # # # # ## # ##### # ## ## # ## ## #### # # ######
/usr/sap/DEV/SYS/exe/run /db2/DEV . /usr/bin /etc /usr/sbin /usr/gbin /usr/ucb /
usr/bin/X11 /sbin /db2/DEV/sqllib/bin /db2/DEV/sqllib/adm /db2/DEV/sqllib/misc
Tablespace 归档前：
Type Used Size (kB)
Free Size (kB)
%-Used
PSAPBTABD
DMS 55279808
5932096
90.31
PSAPBTABI 归档后：
DMS 17978496
2798592
86.53
PSAPBTABD
DMS 55312448
5899456
The statement cannot be processed.
Action: Refer to the diagnostic log to determine which file system is full. Free system space by erasing unwanted files. Do not erase database files. If additional space is required, it may be necessary to drop tables and indexes identified as not required.
SAP常用后台数据表大全 FI CO MM SD PP等
TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KA TRANSP KS TRANSP KS TRANSP KSS TRANSP KSS TRANSP KS TRANSP KSS TRANSP KSS TRANSP KSS TRANSP KSS TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME TRANSP ME
COEPR COEPT COKA COKL COKP COKR COKS COSB COSBD COSL COSP COSPD COSR COSS COSSD COST CSKA CSKB CSKS CSKT CSKU CSLA CSLT CSSK CSSL EBAN EBKN EBUB EINA EINE EIPA EKAB EKAN EKBE EKBZ EKES
Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Master Master Master Master Master Master Master Master Master Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction
SAPERP系统MM模块常用增强之六：采购订单审批增强
SAP/ERP系统MM模块常用增强之六：采购订单审批增强在SAP/EPR项目实施中MM模块的采购订单审批的业务需求一般情况下通过配置就可以实现，但有些项目上也会遇到一些特别的需求是无法通过配置实现的，比如：一些公司会要求采购订单在审批中的时候，如果国际贸易条件、付款条款等字段发生变化时候，需要重置审批，即要重新审批。
如果是采购订单审批策略相关的一些关键字段发生变化，比如：采购金额，一般是可以通过配置实现发生变化时自动触发重审的，但一些非审批策略相关的特征字段发生变化时候，就无法通过配置来触发采购订单的重新审批，比如上面提到采购订单的国际贸易条件、付款条款等字段，但可以通过实施增强非常灵活的满足这些特殊的业务需求。
通过增强触发重审的具体解决方法：通过实施BADI增强在增强程序中判断如果哪些字段有变化，则调用BAPI：BAPI_PO_RESET_RELEASE，重置采购订单的审批状态，实现采购订单的重新审批。
BADI增强：BADI名称:ME_PURCHDOC_POSTED方法: IF_EX_ME_PURCHDOC_POSTED~POSTED下面通过一个实际案例来详细介绍下增强的具体实施步骤业务需求：某公司采购订单需要进行二级审批，一级审批为采购经理，二级审批为采购总监，该公司采购订单审批的业务要求：采购经理审批完成，采购总监未审批的时候，允许采购员对采购订单进行修改，但是如果修改的是金额和付款条件则需要触发重审，即采购经理需要重新审批这个采购订单（如下图说明）。
具体解决方案：采购订单金额的变化触发重审可以通过配置实现，具体配置方法可以参考采购订单审批策略配置的相关文章，但是付款条件变化是无法通过配置实现触发重审的，只能通过增强实现，下面是这增强的具体实施步骤。
实施BADI增强（事务码SE19）双击方法：POSTED，进入如下编辑界面。
本例增强源代码：METHOD if_ex_me_purchdoc_posted~posted.DATA:BEGIN OF ls_ekko,ebeln TYPE ekko-ebeln,frggr TYPE ekko-frggr,frgsx TYPE ekko-frgsx,END OF ls_ekko.DATA: wa_ekko TYPE ekko.DATA:ls_t16fs TYPE t16fs.DATA:lv_pre_field TYPE string VALUE 'FRGC'.DATA:lv_fieldname TYPE string.DATA: lt_return TYPE TABLE OF bapireturn .DATA: ls_return TYPE bapireturn.DATA:lw_t16fs TYPE t16fs.FIELD-SYMBOLS:<fs_field> TYPE t16fs-frgc1.IF im_ekko_old-zterm <> im_ekko-zterm. "付款条件有变更 SELECT SINGLEebeln "采购订单frggr "审批组frgsx "审批策略INTO ls_ekkoFROM ekkoWHERE ebeln = im_ekko-ebelnAND frgzu NE ''. "空未审核 X一级审核 XX二级审核 IF sy-subrc = 0.SELECT SINGLE * INTO ls_t16fs FROM t16fsWHERE frggr = ls_ekko-frggr AND frgsx = ls_ekko-frgsx. "审批代码IF sy-subrc = 0.CONCATENATE lv_pre_field '1' INTO lv_fieldname."通过指针获取批准代码ASSIGN COMPONENT lv_fieldname OF STRUCTURE ls_t16fs TO <fs_field>. IF sy-subrc = 0.CALL FUNCTION 'BAPI_PO_RESET_RELEASE'EXPORTINGpurchaseorder = im_ekko-ebelnpo_rel_code = <fs_field>use_exceptions = 'X'TABLESreturn = lt_returnEXCEPTIONSauthority_check_fail = 1document_not_found = 2enqueue_fail = 3prerequisite_fail = 4release_already_posted = 5responsibility_fail = 6no_release_already = 7no_new_release_indicator = 8OTHERS = 9.LOOP AT lt_return INTO ls_return WHERE type CA 'AEX'.EXIT.ENDLOOP.IF sy-subrc NE 0 .WAIT UP TO 2 SECONDS.ENDIF.ENDIF.ENDIF.ENDIF.ENDIF.ENDMETHOD.上面增强代码写完后激活就OK了。
MM模块后台表汇总
Table Class TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP TRANSP
MSM LMM MSM MSM LMM Sales Data (for each country) Warehouse management inventory data Warehouse management inventory type data
MSM
Sales Data (for each Sales Org and Distribution Channel) WRBRT
Application Class ME ME ME ME ME ME ME ME ME ME ME ME ME ME ME ME ME MB MB ME MG MG MG MG MG MG MG MG MG MG MG MG MB MG MG MG MB
Data Class Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Transaction Master Master Master Master Master Master Master Master Master Master Master Master Transaction Master Master Master Transaction Master Master Master
SAP MM库存初始化以及批量扩充库位
LGORT LIKE MSEG-LGORT, "仓码
MATNR LIKE MSEG-MATNR, "料号
* ERFMG LIKE MSEG-ERFMG, "数量
perform bdc_dynpro using 'SAPMM07M' '0421'.
perform bdc_field using 'BDC_CURSOR'
'MSEG-LGORT(01)'.
"'X' = no transaction logging
PARAMETERS: p_qty RADIOBUTTON GROUP g1.
PARAMETERS: p_mat RADIOBUTTON GROUP g1.
PARAMETERS: FILENAME(132) LOWER CASE DEFAULT
* MASK = ',*.txt,*.txt.'
MASK = ',*.xls,*.xls.'
MODE = '0'
TITLE = 'Select a file to open'
FORM INITIALIZE_QTY.
DATA: FILENAME1 LIKE RLGRAP-FILENAME.
FILENAME1 = FILENAME.
TYPE-POOLS:truxs.
DATA:l_raw_data TYPE truxs_t_text_data.
****** N > A
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
SAP MM TablesBy Willem HoekMaterialsMARA - Material Master: General dataMAKT - Material Master: DescriptionMARM - Material Master: Unit of MeasureMAPE - Material master: Export control fileMARC - Material master: Plant dataMARD - Material master: Storage locationMBEW - Material valuationMLGN - Material Master: WM InventoryMLGT - Material Master: WM Inventory typeMDIP - Material: MRP profiles (field contents)MKOP - Consignment price segment (old versions of SAP)EBEW - Valuation of sales order stockQBEW - Valuation of project stockMVER - Material Master: Consumption <Plant>DVER - Material Master: Consumption <MRP Area>MVKE - Material Master: Sales <Sales Org, Distr Ch>MLAN - Material Master: Tax indicatorMAPR - Material Master: ForecastMCH1 - Material Master: X Plant BatchesMCHA - Material Master: BatchesMCHB - Material Master: Batch StockMDMA - MRP Area dataDBVM - MRP Planning File Entry: MRP AreaMOFF - Outstanding Material Master Records (Maintenance status) MARCH - Material Master C Segment: HistoryMARDH - Material Master Storage Location Segment: History MBEWH - Material Valuation: HistoryMCHBH - Batch Stocks: HistoryMKOLH - Special Stocks from Vendor: HistoryMSCAH - Sales Order Stock at Vendor: HistoryMSKAH - Sales Order Stock: HistoryMSKUH - Special Stocks at Customer: HistoryMSLBH - Special Stocks at Vendor: HistoryMSPRH - Project Stock: HistoryMSSAH - Total Sales Order Stocks: HistoryMSSQH - Total Project Stocks: HistoryBOMSTKO – BOM Header DetailsSTPO – BOM Item DetailsMAST –Material to BOM LinkVendorsLFA1 - Vendor Master: General dataLFB1 - Vendor Master: Company dataLFM1 - Vendor Master: Purchasing Data (Purchasing organization)LFM2 - Vendor Master: Purchasing Data (Plant, Vendor sub-range)WYT3 - Vendor Partner FunctionsExternal Service ManagementASMD - Service Master: Basic DataASMDT - Service Short TextsESKL - Account assignment specification for service lineESKN - Account assignment in service packageESLH - Service package header dataESLL - Lines in service packageESSR - Service entry sheet header dataESUC - External services management: Unplanned limits for contract item ESUH - External services management: unplanned service limits header data ESUP - External services management: unplanned limits for service packages ESUS - External services management: Unplanned limits for service typesPurchasingEBAN - Purchase requisition: itemsEBKN - Purchase Requisition: account assignmentSTXH - SAPScript Text HeaderSTXL - SAPScript Text LinesEKKO - Purchasing document headerEKPO - Purchasing Document: ItemEKET - Purchasing Document: Delivery SchedulesMDBS - Material View of Order Item/Schedule Line (good to find open PO's) EKKN - Account assignment in purchasing documentEORD - Purchasing Source ListEIPA - Order price history recordEKAB - Release documentationEKBE - Purchasing document historyEKBZ - Purchasing document history: delivery costsEKPB - "Material to be provided" item in purchasing documentEINA - Purchase Info Record: GeneralEINE - Purchasing info record: purchasing organization dataKONP - Condition ItemKONH - Condition HeaderInventory ManagementISEG - Physical inventory document itemsMKPF - Material document: HeaderMSEG - Material document: itemRKPF - Reservation: HeaderRESB - Reservation: ItemInvoice VerificationBSIM - Secondary index: documents for materialMYMFT - FIFO results tableMYML - LIFO material layerMYMLM - LIFO material layer (monthly)MYMP - LIFO period stocks, single materialMYMP1 - Receipt data LIFO/FIFO valuationMYPL - LIFO pool layerMYPLM - LIFO pool layer (monthly)RBCO - Document item, incoming invoice account assignment RBDIFFKO - Invoice Verification: conditionsRBDIFFME - Invoice Verification: quantity differencesRBDRSEG - Invoice Verification batch: invoice document itemsRBKP - Document header: incoming invoiceRBKPB - Invoice document header (batch invoice verification)RBTX - Taxes:incoming invoiceRBVD - Invoice document: summarization dataRBVDMAT - Invoice Verification: summarization data, material RBWT - Withholding tax:incoming invoiceRKWA - Consignment withdrawalsRSEG - Document item, incoming invoiceCustomising and other master dataT001 - Company CodesT001W - Plants/branchesT001L - Storage LocationsT024E - Purchasing OrganizationsT024W - Valid Purchasing Organizations for PlantMDLV - MRP AreasMDLG - MRP Areas - Storage LocationsMDLW - MRP Areas - PlantsMDLL - MRP Areas - SubcontractorT023 - Material GroupsT024 - Purchasing groupsT030 - Standard Accounts Table (Automatic Account Determination) T156 - Movement TypeT156T - Movement Type: TextT16FS - Release StrategiesT16FT - Descriptions of Release StrategiesT16FV - Release PrerequisitesT16FD - Description of Release CodesT16FK - Release StatusesT16FC - Release CodesT161 - Purchasing Document TypesT052 - Terms of Payment & FM FI_TEXT_ZTERM for long textAUSP - Release Procedure: Strategy values (cl20n, cl24n)AGR_USERS - Assignment of roles to usersCDHDR & CDPOS - Change history of master data and documents EDID4 - EDI informationTSTC - SAP Transaction Codes, lock/unlock: sm01, created: se93 TSTCT - Transaction codes TEXTNAST - Message statusPOPULAR POSTSSAP SD TablesSplit ValuationVery basics of SAP External Service ManagementLoading Material Masters with LSMW Direct Input methodSAP Finance TablesSetting up simple Release Procedure for Purchase RequisitionsChange SAP documents -- tables CDHDR and CDPOSWebsite built by Willem HoekSAP is a registered trademark of SAP AG - This website is not affiliated to SAP AG or any of its subsidiaries。