*&---------------------------------------------------------------------*
*& Report ZPP023
*&
*&---------------------------------------------------------------------*
*& Author:**** DAta:****
*& description: *****
*&---------------------------------------------------------------------*
Report ZPP023.
tables:KEKO,KEPH,marc.
DATA: BEGIN OF F_KEKO_KEY.
INCLUDE STRUCTURE CKIKEKOKEY.
DATA: END OF F_KEKO_KEY.
DATA: BEGIN OF F_KEKO.
INCLUDE STRUCTURE KEKO.
DATA: END OF F_KEKO.
DATA: BEGIN OF GT_KEKO OCCURS 20.
INCLUDE STRUCTURE KEKO.
DATA: END OF GT_KEKO.
DATA: BEGIN OF GT_EXCEL OCCURS 20.
DATA: MONTH(6) type C,
MAKTX LIKE MAKT-MAKTX,
MTART LIKE MARA-MTART.
data: MATNR LIKE KEKO-MATNR,
KLVAR like KEKO-KLVAR,
LOSGR like KEKO-LOSGR.
INCLUDE STRUCTURE KEPH.
data: KST_HJ001(16) type p decimals 5,
KST_HJ005(16) type p decimals 5,
KST_HJ007(16) type p decimals 5,
KST_HJ009(16) type p decimals 5,
KST_HJ011(16) type p decimals 5,
KST_HJ013(16) type p decimals 5,
KST_HJ(16) type p decimals 5.
DATA: END OF GT_EXCEL.
DATA: BEGIN OF GW_EXCEL .
DATA: MONTH(6) type C,
MAKTX LIKE MAKT-MAKTX,
MTART LIKE MARA-MTART.
DATA: MATNR LIKE KEKO-MATNR,
KLVAR like KEKO-KLVAR,
LOSGR like KEKO-LOSGR.
INCLUDE STRUCTURE KEPH.
data: KST_HJ001(16) type p decimals 5,
KST_HJ005(16) type p decimals 5,
KST_HJ007(16) type p decimals 5,
KST_HJ009(16) type p decimals 5,
KST_HJ011(16) type p decimals 5,
KST_HJ013(16) type p decimals 5,
KST_HJ(16) type p decimals 5.
DATA: END OF GW_EXCEL.
type-pools:slis.
data:f_pos type i,
it_fieldcat type lvc_t_fcat,
is_fieldcat type lvc_s_fcat,
it_layout type lvc_s_layo.
selection-screen