display all records

[Former Member]

i am using two standard tables namely likp and lips.

my task is to give date field in likp and retrieving corresponding

vbeln field in likp.By using the vbeln from likp i should retrieve

the lfimg field in lips table by using the corresponding

vbeln field in lips.

The problem is it does not take total number of records.

(for Ex if 1 appears 5 times means,the output contains

only one 1field rather than five ).So the number of records

is 25 rather than 95.how to i get 95 records.reply immediately

plz.

plz send the coding now i have to finish it immediately

[Former Member]

i am using two standard tables namely likp and lips.

my task is to give date field in likp and retrieving corresponding

vbeln field in likp.By using the vbeln from likp i should retrieve

the lfimg field in lips table by using the corresponding

vbeln field in lips.

The problem is it does not take total number of records.

(for Ex if 1 appears 5 times means,the output contains

only one 1field rather than five ).So the number of records

is 25 rather than 95.how to i get 95 records.reply immediately

plz.

plz send the coding now i have to finish it immediately

[Former Member]

Hi,

Try to retrieve complete primary key along with your LFIMG. And also check your where class of select statement.

Rgds,

Bujji

[Former Member]

Hi Ranjith.

Tables : likp, lips.

select-options : s_date for likp-date.

select vbeln from likp into table it_likp where date in s_date.

select fields from lips into table it_lips FOR ALL ENTRIES IN it_likp.

Thanks,

S.Gangi reddy

[Former Member]

Hi Ranjith,

In the last SELECT statement where you fetch the items from LIPS table, just past the VBELN from LIKP.

This would bring all the data related to the delivery items.