Skip to Content
0
Jan 13, 2012 at 06:45 AM

RE: Code is not fetching correct recors

34 Views

HI Experts,

I am into SAP BI. I have done datasource enhancement to get Delivery costs(DMBTR) from EKBZ table to EKPO table structure.

In EKPO having 3 items - data is like this -

EBELN--- EBELLP POQTY

415150901--10 --- 30

415150901---20 --- 40

415150901---30 --- 40

In EKBZ data is like this

EBELN- EBELLPGR qty--Delivery cost(DMBTR)

415150901---10 -- 40--10

415150901--10 -- 40---20

415150901---20 - 205

After writing code in CMOD - code is

WHEN '2LIS_02_ITM'.

DATA :C_T_DATA1 type table of MC02M_0ITM,

WA_MC02M_0ITM LIKE MC02M_0ITM.

LOOP AT C_T_DATA INTO WA_MC02M_0ITM.

IF WA_MC02M_0ITM-ALIEF = '0'.

DELETE C_T_DATA index sy-tabix .

ENDIF.

ENDLOOP.

c_t_data1[] = c_t_data[].

sort C_T_DATA1 by ebeln ebelp.

LOOP AT C_T_DATA1 INTO WA_MC02M_0ITM.

SELECT DMBTR FROM EKBZ INTO WA_MC02M_0ITM-ZZDMBTR

WHERE EBELN = WA_MC02M_0ITM-EBELN

AND EBELP = WA_MC02M_0ITM-EBELP

AND MENGE = WA_MC02M_0ITM-AKTWE.

MODIFY C_T_DATA1 FROM WA_MC02M_0ITM index sy-tabix transporting zzdmbtr .

endselect.

After executing code the result is not coming properly. The result is like this -

EBELN-EBELLPPO qty GR qty- Delivery cost(DMBTR)

415150901---10 -30 40--10

415150901--20 - 40-20---5

415150901---30 -- 40-20-0

I am missing one item document i.e.

415150901---10 -- 40----20

Can any one help on this issue.

Regards,

rvc