CK86_99 for Multiple Material

[Former Member]

Dear Expert,

I am using CK86_99 for detailed costing reports of a particular material number that has a BOM.

Is there any type of transaction/report/table, that can be run for multiple materials, as CK86_99 is only functionable for one material at a time ?

or if i want to make ABAP report, then which tables will be used.

Regards,

Pranav Dave

[former_member1159744]

Hi,

this is possible via SAP standard T-Code CKUC - you can add multiple materials, select costing date, variant etc. you can explode the costing to the lowest level + it is possible to export to excel.

BR

Martin

[gayathri_sunil1]

Hi,

There is no standard tcode available for this. As an abaper I ahve developed a report using some class methods which is working fine for multiple materials. Please try this.

if found useful please rate..

The Fm  K_KKB_CALCULATION_FIND gives the details to be passed to the class methods of class CL_COSTING_BOM.   USe the instance method of  this class, GET_CHILDREN() to get the bom lines.

CALL FUNCTION 'K_KKB_CALCULATION_FIND'

    EXPORTING

      i_matnr         = wa_keko-matnr

      i_werks         = wa_keko-werks

      i_klvar         = i_kalkvar

      i_tvers         = i_kalkvers

      i_kadky         = i_kadky

      i_erzka         = i_erzka

      i_kalnr_ba      = i_kalnr_ba

      i_kalnr         = i_kalnr

    IMPORTING

      e_keko          = l11_keko

    EXCEPTIONS

      no_calculation  = 1

      plant_not_found = 3.

Create Instance of class CL_COSTING_BOM

CREATE OBJECT zcl_bom

    EXPORTING

*    I_BZ_LOSGR            =

*    I_BZ_MEEHT            =

      is_kekokey            = ms_kekokey

      ix_explode_raw        = 'X'

      ix_explode_bpo        = 'X'

*    IX_EXPLODE_KF         = space

*    I_VIEW                = '01'

*    I_CURRENCY            = 'O'

*    I_ONLY_M              = 'X'

*    IT_FIELDCATALOG       =

    EXCEPTIONS

      keko_not_found        = 1

      error_unit_conversion = 2

      error                 = 3

      OTHERS                = 4

Get the Bom lines

CALL METHOD zcl_bom->get_children

      IMPORTING

        et_bom_lines = lt_bom_lines.

   IF lt_bom_lines IS NOT INITIAL.

      READ TABLE lt_bom_lines INTO lr_bom_line INDEX 1.

This perform Read the child nodes in recursive way.

      PERFORM get_children USING lr_bom_line .

   ENDIF.

Inside the form GET_CHILDREN.

IF lr_bom_line IS BOUND AND lr_bom_line->m_no_itemization IS INITIAL..

    CALL METHOD lr_bom_line->get_children

      IMPORTING

        et_children = lt_children.

LOOP AT lt_children INTO lr_bom_line.

      IF lr_bom_line IS BOUND AND lr_bom_line->m_no_itemization IS INITIAL.

        CALL METHOD lr_bom_line->get_outtab_line

          IMPORTING

            es_outline = ls_outtab_line.

        APPEND ls_outtab_line TO lt_outtab_line.

      ENDIF.

Recurvise call of subroutine GET_CHILDREN.

      PERFORM get_children  USING lr_bom_line.

    ENDLOOP.

[carmen_garciacisneros]

Dear Pranav,

In standard ECC there is no such report that will show the multilevel

BOM for mass reporting (many materials). The multilevel BOM

display is a detailed information that only makes sense for single

materials.

Mass reporting for itemization is available as datasource for BI

extraction (extractor 0CO_PC_PCP_03). Please have a look at the docu-

mentation 'SAP NetWeaver BI Content' to check the available data

sources in area of product cost planning and if the fit to your re-

quirements accordingly.

I hope this information helps you.

Kind regards,

Carmen