基于BOM结构的标准成本明细批量查询报表

最新推荐文章于 2024-11-08 09:35:37 发布

原创

最新推荐文章于 2024-11-08 09:35:37 发布 · 1.5k 阅读

1 ·

CC 4.0 BY-SA版权

本文详细介绍了一种在SAP系统中实现标准成本明细报表的方法，通过使用ABAP编程语言，报告ZMMR102提供了对成本构成的深入分析。报告涵盖了物料、工厂、成本要素等关键信息，并通过调用CS_BOM_EXPL_MAT_V2函数模块来展开物料清单，计算直接材料、人工、折旧和外协加工的成本。此外，报告还展示了如何从CKIS和KEKO表中读取成本数据，以及如何处理成本核算期间的数据。

*&---------------------------------------------------------------------*
*& Report ZMMR102
*&---------------------------------------------------------------------*
*& Author              :  NathanSun
*& Create Date         :  2019-05-23
*& Program Type        :  Report
*& Description         :  标准成本明细报表
*&---------------------------------------------------------------------*
REPORT ZFIR127.
*&---------------------------------------------------------------------*
*& 包含               YN_TEST02_TOP
*&---------------------------------------------------------------------*
TABLES:MARA,STKO,MARC,STPO,MAST,STKOB,KEKO.

TYPE-POOLS:SLIS,T001W.

"定义ALV输出所需变量
DATA: S_LAYOUT    TYPE SLIS_LAYOUT_ALV,
      GT_FIELDCAT TYPE SLIS_T_FIELDCAT_ALV.

DATA:TOPMAT  LIKE CSTMAT .
DATA:DSTST   LIKE CSDATA-XFELD .
DATA:STB     LIKE STPOX OCCURS 0 WITH HEADER LINE  .
DATA:MATCAT  LIKE CSCMAT OCCURS 0 WITH HEADER LINE  .
DATA:GT_MARD LIKE MARD OCCURS 0 WITH HEADER LINE  .
DATA:GT_MSKA LIKE MSKA OCCURS 0 WITH HEADER LINE  .
DATA:E_MT61D LIKE MT61D .
DATA:E_MDKP  LIKE MDKP  .
DATA:MDPSX   LIKE MDPS OCCURS 0 WITH HEADER LINE  .
DATA:MDEZX   LIKE MDEZ OCCURS 0 WITH HEADER LINE  .
DATA:MDSUX   LIKE MDSU OCCURS 0 WITH HEADER LINE  .
DATA:MRP_ITEMS  LIKE BAPI_MRP_ITEMS OCCURS 0 WITH HEADER LINE  .
DATA:MRP_IND_LINES  LIKE BAPI_MRP_IND_LINES OCCURS 0 WITH HEADER LINE  .

TYPES: BEGIN OF GTS_DATA,
         WERKS     TYPE  STPOX-WERKS,                      "供货工厂
         WERKS_C   TYPE  STPOX-WERKS,                      "工厂
         WERKS_F   TYPE  STPOX-WERKS,                      "工厂
         TTIDX     TYPE  STPOX-TTIDX,                      "在类别表内的索引
         MATNR     TYPE  CSCMAT-MATNR,                     "父项物料
         MATNR_F   TYPE  CSCMAT-MATNR,                     "父项物料
         MAKTX     TYPE  MAKT-MAKTX,                       "描述
         STLAN     TYPE  STPOX-STLAN,                      "BOM用途
         STLAL     TYPE  STPOX-STLAL,                      "可选BOM
         BMENG     TYPE  STKO-BMENG,                       "基本数量
         STUFE     TYPE  STPOX-STUFE,                      "层次
         STUSX     TYPE  CHAR20,                           "层次
         POSNR     TYPE  STPOX-POSNR,                      "项目号
         IDNRK     TYPE  STPOX-IDNRK,                      "子项物料
         OJTXP     TYPE  STPOX-OJTXP,                      "描述
         MNGLG     TYPE  ZCURR01,                          "BOM用量
         MNGBF     TYPE  ZCURR01,                          "含报废率用量
         MMEIN     TYPE  STPOX-MMEIN,                      "单位
         VPRSV     TYPE  MBEW-VPRSV,                       "价格控制
         AUSCH     TYPE  STPOX-AUSCH,                      "组件报废
         WERTN_CL  TYPE  ZCURR01,                          "材料
         WERTN_RG  TYPE  ZCURR01,                          "人工
         WERTN_JQ  TYPE  ZCURR01,                          "机器
         WERTN_WX  TYPE  ZCURR01,                          "外协
         WERTN_HJ  TYPE  ZCURR01,                          "成本合计

         CELLCOLOR TYPE  LVC_T_SCOL,                       "单元格颜色
       END OF GTS_DATA.

TYPES: BEGIN OF GTS_RUN,
         WERTN TYPE  CKIS-WERTN,                      "供货工厂
         LSTAR TYPE  CKIS-LSTAR,                      "工厂
         TYPPS TYPE  CKIS-TYPPS,                      "工厂
         LOSGR TYPE  KEKO-LOSGR,                      "在类别表内的索引
       END OF GTS_RUN.

DATA: GT_DATA   TYPE TABLE OF GTS_DATA WITH HEADER LINE.<

最低0.47元/天解锁文章