pls anyone help me....urgent

[Former Member]

Hi all..

pls tell me the code...

Get all the service line items in the contracts (Select EKPO line items where item category(PSTYP) is service. item category 9 is service.

. use the Package number(ESLL-PACKNO) from EKPO

Select on ESLL table using this Package number and get the Sub package Number (ESLL-SUB_PACKNO)

Select again on table ESSL to get the Service master number (ESLL-SRVPOS)

thanks in advance.

palavi.

[Former Member]

Hi,

data : begin of t_data occurs 0,

ebelp like ekpo-ebelp,

packno like ekpo-packno,

end of t_data.

select ebelp packno into corresponding fields of table t_data

from ekpo where PSTYP = '9'.

select sub_packno srvpos into corresponding fields of table t_data1

from esll for all entries in t_data where packno = t_data-packno.

Define the table t_data1 accordingly to get the data into it.

Regards,

Himanshu

[Former Member]

Hi ..Himanshu

thank u 4 ur help.

palavi.