Modification in Script output

[Former Member]

Hi friends,

I' m modifying a standard script for ARE1 form.

In tcode J1IA103(ARE1) there are multiple line items like........

Sl No Mat No Qty Price

1 900256 1 10000

2 900256 1 10000

But in the print output they want like ........

Sl No Mat No Qty Price

1 900256 2 20000

Now I have change the driver program J_1IPRNTARE.

How can I achieve above requirement?

thanks in advance.

[Former Member]

hiii

if you want to do changes in standard program then you will need access key to do this the can provide you access key if they have or they want to do in same program. otherwise you can just copy that program into zreport program then u van do changes as u want but now u have to change the transaction code for that program for enduser.

thanks

[GauthamV]

hi,

copy the standard program.

in perfrom just use the statement SUM in the loop in which the above window is used.

[Former Member]

hi,

I have already copied to my z.

It should not for one requirement.

It's like this also......

Sl No Mat No Qty Price

1 900256 1 10000

2 900256 1 10000

3 900257 1 10000

But in the print output they want like ........

Sl No Mat No Qty Price

1 900256 2 20000

2 900257 1 10000

I should add only if material no is repeated in the next serial no...........

How to compare material no with next one ..

Following code in which items details are populated....How to do here....

PERFORM select_data

TABLES lt_excdtl

USING ls_exchdr.

FORM select_data TABLES p_lt_excdtl

USING p_ls_exchdr LIKE j_1iexchdr.

DATA: lt_bond_entry TYPE STANDARD TABLE OF j_1ibond,

ls_bond_entry TYPE j_1ibond,

l_zeile TYPE j_1ibond-zeile,

ls_excdtl TYPE j_1iexcdtl.

IF p_lt_excdtl[] IS INITIAL.

BREAK-POINT.

SELECT * FROM j_1iexcdtl INTO TABLE p_lt_excdtl

WHERE trntyp = p_ls_exchdr-trntyp

AND docno = p_ls_exchdr-docno

AND docyr = p_ls_exchdr-docyr.

ENDIF.

LOOP AT p_lt_excdtl INTO j_1iexcdtl.

SELECT SINGLE * FROM j_1ilichdr WHERE licyr = j_1iexcdtl-licyr

AND licno = j_1iexcdtl-licno.

SELECT * FROM j_1iexchdr

WHERE trntyp = 'DLFC'

AND exnum = j_1iexcdtl-rdoc2

AND exyear = j_1iexcdtl-ryear2

AND lifnr NE ' ' .

MOVE-CORRESPONDING j_1iexchdr TO gt_excdate.

APPEND gt_excdate.

ENDSELECT.

ENDLOOP.

[GauthamV]

hi,

use at new matnr.

then use the sum statement in the loop.

[Former Member]

hi,

IF p_lt_excdtl[] IS INITIAL.

BREAK-POINT.

SELECT * FROM j_1iexcdtl INTO TABLE p_lt_excdtl

WHERE trntyp = p_ls_exchdr-trntyp

AND docno = p_ls_exchdr-docno

AND docyr = p_ls_exchdr-docyr.

ENDIF.

LOOP AT p_lt_excdtl INTO j_1iexcdtl.

SELECT SINGLE * FROM j_1ilichdr WHERE licyr = j_1iexcdtl-licyr

AND licno = j_1iexcdtl-licno.

SELECT * FROM j_1iexchdr

WHERE trntyp = 'DLFC'

AND exnum = j_1iexcdtl-rdoc2

AND exyear = j_1iexcdtl-ryear2

AND lifnr NE ' ' .

MOVE-CORRESPONDING j_1iexchdr TO gt_excdate.

APPEND gt_excdate.

ENDSELECT.

at new matnr.

sum.

endat.

ENDLOOP.

it's throwing syantax error......

the specified type has no structure and therefore no component called 'MATNR.

Actually,In debugging mode table p_lt_excdtl contains matnr and it has been populated.

[Former Member]

Hi friends,

any inputs please..........

Edited by: Hosmath on Aug 13, 2008 9:07 AM