product cost analysis ?

[former_member211601]

Dear experts,

my client need to (product cost by sales order ) , actual material cost, actual activity and actual oh cost for sales order line item wise sales order cost and sales order number and item, production order and material number i mentioned in below progrem even though we are not getting actual cost......

*&---------------------------------------------------------------------*

*&  Include           YCO_WIP_LEDGER_DD

*&---------------------------------------------------------------------*

TYPES: BEGIN OF GTY_FINAL,

         AUFNR  TYPE AUFNR,           "Production Order

         VBELN      TYPE VBELN_VA,   "Sales Order

         POSNR      TYPE POSNR_VA,   "SO Item

         PS_PSP_PNR TYPE PS_PSP_PNR, "WBS Element

         DAUAT      TYPE AUFART,     "Order Type

         MATNR      TYPE MATNR,      "Header material

         ARKTX      TYPE ARKTX,      "Material Description

         ZMENG      TYPE KWMENG,     "Quantity

         KZWI1      TYPE KZWI1,      "Value

         KWERT      TYPE KWERT,      "Agreed Price

         CLOSEINV   TYPE FKIMG,

         MEINS       TYPE MEINS,

         OP_MATC     TYPE KSTEL,

         OP_SMM     TYPE KSTEL,

         OP_SVM     TYPE KSTEL,

         OP_SFM     TYPE KSTEL,

         OP_COH     TYPE KSTEL,

         OP_OFF     TYPE KSTEL,

         OP_TOTAL   TYPE KSTEL,

         BK_MATC     TYPE WTGXXX,

         BK_SMM     TYPE WTGXXX,

         BK_SVM     TYPE WTGXXX,

         BK_SFM     TYPE WTGXXX,

         BK_COH     TYPE WTGXXX,

         BK_OFF     TYPE WTGXXX,

         BK_TOTAL   TYPE WTGXXX,

         CP_QTY     TYPE FKIMG,

         CP_UNIT    TYPE MEINS,           " Add By Nilesh Patel on 22.12.2011

         CP_AGRVAL  TYPE KBETR,           " Add By Nilesh Patel on 26.12.2011

         CP_MATC     TYPE KSTEL,

         CP_SMM     TYPE KSTEL,

         CP_SVM     TYPE KSTEL,

         CP_SFM     TYPE KSTEL,

         CP_COH     TYPE KSTEL,

         CP_OFF     TYPE KSTEL,

         CP_TOTAL   TYPE KSTEL,

         CL_QTY     TYPE FKIMG,

         CL_MATC     TYPE KSTEL,

         CL_SMM     TYPE KSTEL,

         CL_SVM     TYPE KSTEL,

         CL_SFM     TYPE KSTEL,

         CL_COH     TYPE KSTEL,

         CL_OFF     TYPE KSTEL,

         CL_TOTAL   TYPE KSTEL,

         STDMAT     TYPE KSTEL,

         CONTR      TYPE KZWI1,

         PERC       TYPE P DECIMALS 2,

         STIME       TYPE VGWRT,

         ATIME       TYPE MEGXXX,

        END OF GTY_FINAL,

        BEGIN OF GTY_AFPO,

         AUFNR  TYPE AUFNR,

         POSNR  TYPE CO_POSNR,

         KDAUF TYPE CO_KDAUF,

         KDPOS TYPE CO_KDPOS,

         PROJN TYPE PS_PSP_ELE,

         DAUAT TYPE AUFART,

         MATNR TYPE CO_MATNR,

         OBJNR TYPE  J_OBJNR,

        END OF GTY_AFPO,

        BEGIN OF GTY_AFKO,

         AUFNR  TYPE AUFNR,

         AUFPL TYPE CO_AUFPL,

        END OF GTY_AFKO,

        BEGIN OF GTY_VBAP,

          VBELN      TYPE VBELN_VA,

          POSNR      TYPE POSNR_VA,

          PS_PSP_PNR  TYPE PS_PSP_PNR,

          MATNR      TYPE MATNR,

          ARKTX      TYPE ARKTX,

          ZMENG      TYPE KWMENG,

          KZWI1      TYPE KZWI1,

          KNUMV      TYPE VBAK-KNUMV,

        END OF GTY_VBAP,

        BEGIN OF GTY_VBAK,

          VBELN TYPE VBELN_VA,

          KNUMV TYPE KNUMV,

        END OF GTY_VBAK,

        BEGIN OF GTY_KONV,

          KNUMV TYPE KNUMV,

          KPOSN TYPE KONV-KPOSN,

          KSCHL TYPE KSCHL,

          KBETR TYPE KBETR,

          KWERT TYPE KWERT,

        END OF GTY_KONV,

        BEGIN OF GTY_COEP,

          KOKRS TYPE KOKRS,

          BELNR TYPE CO_BELNR,

          BUZEI TYPE CO_BUZEI,

          PERIO TYPE CO_PERIO,

          GJAHR TYPE GJAHR,

          OBJNR TYPE  J_OBJNR,

          KSTAR TYPE  KSTAR,

          MATNR TYPE MATNR,

          WRTTP TYPE  CO_WRTTP,

          BEKNZ TYPE  BEKNZ,

          WTGBTR  TYPE WTGXXX,

          MEGBTR  TYPE MEGXXX,

          AUFNR  TYPE AUFNR,

        END OF GTY_COEP,

        BEGIN OF GTY_KEKO,

          KALNR TYPE CK_KALNR1,

          KALKA TYPE CK_KALKA,

          KADKY TYPE  CK_KADKY,

          MATNR TYPE MATNR,

          VBELN TYPE VBELN,

          POSNR TYPE POSNR,

       END OF GTY_KEKO,

       BEGIN OF GTY_KEPH,

         KALNR  TYPE CK_KALNR,

         KALKA  TYPE CK_KALKA,

         KADKY  TYPE CK_KADKY,

         KKZST  TYPE CK_STUFE,

         KST001 TYPE KSTEL,

         KST002 TYPE KSTEL,

         KST004 TYPE KSTEL,

         KST005 TYPE KSTEL,

         KST007 TYPE KSTEL,

       END OF GTY_KEPH,

       BEGIN OF GTY_MSEG,

         MBLNR_I  TYPE MBLNR,

         MJAHR_I  TYPE MJAHR,

         ZEILE_I  TYPE MBLPO,

         BUDAT TYPE BUDAT,

         BWART_I  TYPE BWART,

         KDAUF_I  TYPE KDAUF,

         KDPOS_I  TYPE KDPOS,

         PS_PSP_PNR_I TYPE PS_PSP_PNR,

         SMBLN_I  TYPE MBLNR,

         SMBLP_I  TYPE MBLPO,

         AUFNR_I  TYPE AUFNR,

         MENGE_I  TYPE MENGE_D,

         MEINS_I TYPE MEINS,            " Add By Nilesh Patel on 22.12.2011

         LGORT_I TYPE LGORT_D,

         MATNR_I TYPE MATNR,

         MAT_KDAUF_I TYPE KDAUF,

         MAT_KDPOS_I TYPE KDPOS,

         MAT_PSPNR_I TYPE PS_PSP_PNR,

       END OF GTY_MSEG,

       BEGIN OF GTY_GR,

         KDAUF_I  TYPE KDAUF,

         KDPOS_I  TYPE KDPOS,

         PS_PSP_PNR_I TYPE PS_PSP_PNR,

         MENGE_I  TYPE MENGE_D,

         MEINS_I TYPE MEINS,             " Add By Nilesh Patel on 22.12.2011

       END OF GTY_GR,

       BEGIN OF GTY_CAUFV,

         AUFNR TYPE AUFNR,

         AUFPL  TYPE CO_AUFPL,

         KDAUF  TYPE KDAUF,

         KDPOS  TYPE KDPOS,

         PSPEL TYPE PS_PSP_ELE,

       END OF GTY_CAUFV,

       BEGIN OF GTY_AFVV,

         AUFPL  TYPE CO_AUFPL,

         BMSCH TYPE BMSCH,

         VGW01  TYPE VGWRT,

         VGW02  TYPE VGWRT,

         VGW03  TYPE VGWRT,

       END OF GTY_AFVV,

       BEGIN OF GTY_AFPO_Q,

         AUFNR  TYPE AUFNR,

         PROJN TYPE PS_PSP_ELE,

         PGMNG  TYPE GSMNG,

        END OF GTY_AFPO_Q,

       BEGIN OF GTY_STIME,

         KDAUF  TYPE KDAUF,

         KDPOS  TYPE KDPOS,

         PSPEL TYPE PS_PSP_ELE,

         STIME  TYPE VGWRT,

        END OF GTY_STIME,

        BEGIN OF GTY_ATIME,

         KDAUF  TYPE KDAUF,

         KDPOS  TYPE KDPOS,

         PROJN TYPE PS_PSP_ELE,

         MEGBTR TYPE MEGXXX,

        END OF GTY_ATIME,

        BEGIN OF GTY_CLOSE,

         KDAUF  TYPE KDAUF,

         KDPOS  TYPE KDPOS,

         PS_PSP_PNR TYPE PS_PSP_PNR,

         MENGE  TYPE MENGE_D,

        END OF GTY_CLOSE.

DATA: GT_FINAL TYPE TABLE OF GTY_FINAL,

       GS_FINAL TYPE GTY_FINAL,

       GS_FINAL1 TYPE GTY_FINAL,

       GT_AFPO TYPE TABLE OF GTY_AFPO,

       GS_AFPO TYPE GTY_AFPO,

       GT_AFPO_C TYPE TABLE OF GTY_AFPO,

       GS_AFPO_C TYPE GTY_AFPO,

       GT_VBAP TYPE TABLE OF GTY_VBAP,

       GS_VBAP TYPE GTY_VBAP,

       GT_VBAK TYPE TABLE OF GTY_VBAK,

       GS_VBAK TYPE GTY_VBAK,

       GT_KONV TYPE TABLE OF GTY_KONV,

       GS_KONV TYPE GTY_KONV,

       GT_COEP TYPE TABLE OF GTY_COEP,

       GS_COEP TYPE GTY_COEP,

       GT_KEKO TYPE TABLE OF GTY_KEKO,

       GS_KEKO TYPE GTY_KEKO,

       GT_KEPH TYPE TABLE OF GTY_KEPH,

       GS_KEPH TYPE GTY_KEPH,

       GT_MSEG TYPE TABLE OF GTY_MSEG,

       GS_MSEG TYPE GTY_MSEG,

       GT_GR   TYPE TABLE OF GTY_GR,

       GS_GR   TYPE GTY_GR,

       GT_CAUFV TYPE TABLE OF GTY_CAUFV,

       GS_CAUFV TYPE GTY_CAUFV,

       GT_AFVV   TYPE TABLE OF GTY_AFVV,

       GS_AFVV   TYPE GTY_AFVV,

       GT_AFPO_Q   TYPE TABLE OF GTY_AFPO_Q,

       GS_AFPO_Q   TYPE GTY_AFPO_Q,

       GT_AFKO   TYPE TABLE OF GTY_AFKO,

       GS_AFKO   TYPE GTY_AFKO,

       GT_STIME   TYPE TABLE OF GTY_STIME,

       GS_STIME   TYPE GTY_STIME,

       GT_ATIME   TYPE TABLE OF GTY_ATIME,

       GS_ATIME   TYPE GTY_ATIME,

       GT_CLOSE   TYPE TABLE OF GTY_CLOSE,

       GS_CLOSE   TYPE GTY_CLOSE.

TYPES: BEGIN OF GTY_OPEN.

         INCLUDE STRUCTURE YCO_RECON_OPEN.

TYPES: END OF GTY_OPEN.

DATA: GT_OPEN TYPE TABLE OF GTY_OPEN,

       GS_OPEN TYPE GTY_OPEN.

TYPES: BEGIN OF GTY_BOOK,

         VBELN      TYPE VBELN_VA,   "Sales Order

         POSNR      TYPE POSNR_VA,   "SO Item

         PS_PSP_PNR TYPE PS_PSP_PNR, "WBS Element

         BK_MATC     TYPE WTGXXX,

         BK_SMM     TYPE WTGXXX,

         BK_SVM     TYPE WTGXXX,

         BK_SFM     TYPE WTGXXX,

         BK_COH     TYPE WTGXXX,

         BK_OFF     TYPE WTGXXX,

         BK_TOTAL   TYPE WTGXXX,

       END OF GTY_BOOK.

DATA: GT_BOOK TYPE TABLE OF GTY_BOOK,

       GS_BOOK TYPE GTY_BOOK.

RANGES: S_DATE FOR SY-DATUM.

RANGES: S_MON FOR ZMONTH_STRUC-ZMONTH.

RANGES: S_MATNR FOR MARA-MATNR.

*-----------------------------------------------------------------------

*   ALV Declaration

*-----------------------------------------------------------------------

TYPE-POOLS: SLIS.

DATA: T_FCAT  TYPE SLIS_T_FIELDCAT_ALV,

       GS_FCAT TYPE SLIS_FIELDCAT_ALV.

*****Variables for fieldcatalogue

DATA:GT_FIELDCAT TYPE TABLE OF SLIS_FIELDCAT_ALV,

      GS_FIELDCAT TYPE SLIS_FIELDCAT_ALV.

******Variables for layout

DATA:GS_LAYOUT TYPE SLIS_LAYOUT_ALV.

******Variables for sorting

DATA:GT_SORT_INFO TYPE TABLE OF SLIS_SORTINFO_ALV,

      GS_SORT_INFO TYPE SLIS_SORTINFO_ALV.

******Variables for event

DATA:GT_EVENT TYPE TABLE OF SLIS_ALV_EVENT,

      GS_EVENT TYPE SLIS_ALV_EVENT.

DATA:GD_VARIANT TYPE DISVARIANT, "FOR PARAMETER IS_VARIANT

      GX_VARIANT LIKE DISVARIANT,

      G_SAVE.

DATA:GT_FCAT1  TYPE TABLE OF SLIS_FIELDCAT_ALV,

      GS_FCAT1  TYPE SLIS_FIELDCAT_ALV.

Pls   suggest !!!

Regards,

Naveen

[Former Member · Accepted solution]

Dear Naveen,

I believe your requirement will be full fill by standard reports why your going to develop customization report please check standard report care fully and client can refer references and if he access one or two reports your requirement will be full filled.

I request you please check standard reports and try to convene client.

If really required you can go for customized report development.

regards

Sadiq

[former_member211601 · Accepted solution]

Dear sadiq,

1.Based on the GR date, management wants to see the actual cost for the total quantity (if the order is completed) & if the order is not completed then client cosnsider standard cost

   2.They want to see the GR quantity up to the last and in current year also in single execute.

   3.By default system will pick the period from April in the current year.

[Former Member · Accepted solution]

Dear naveen,

You have to refer each tables based on business process/system updates and design report but it is very ha-tic. you need to fetch data from different tables.it may cause performance issues.

but you can lit these issues based on purchase order and GR /Production Order reference by sorting out.

In this case you need to design zreprot based on customer requirement.

Regards

sadiq

[Former Member · Accepted solution]

Dear naveen,

You have to refer each tables based on business process/system updates and design report but it is very ha-tic. you need to fetch data from different tables.it may cause performance issues.

but you can lit these issues based on purchase order and GR /Production Order reference by sorting out.

In this case you need to design zreprot based on customer requirement.

Regards

sadiq

[former_member211601 · Accepted solution]

Dear sadiq,

Your right.... in sap Possibility is there na user also stick based on that issue only

please help me which table are required how to mape the tables

befor consultant he prepare the spec but actual material cost,activity cost and oh cost not come properly......

Thanks&regards

Naveen D

[Former Member · Accepted solution]

dear Naveen,

Based on requirement you have to analyze and do it, you will not get ready data for your requirement.

regards

sadiq