‎2008 May 26 3:55 AM
Hi
The following statement going to dump. pls advise me if anything wrong
SELECT VBELN POSNR MATNR ERDAT LFIMG ERNAM WERKS VGBEL VGPOS FROM LIPS INTO
TABLE LT_LIPOV
for all entries in it_likp
WHERE VBELN = it_LIKP-VBELN.
‎2008 May 26 4:04 AM
Hi Kumar,
Check the structure of table LT_LIPOV.
Has it got all the fields that you have given in the select statement?
Any change in the field mentioned in the select and the structure of LT_LIPOV will go to dump.
Hope this helps you.
Thanks,
Arun
‎2008 May 26 4:01 AM
Hi there..
check the structure of lt_lipov... are the field in the same order in the decleration of ur table...VBELN POSNR MATNR ERDAT LFIMG ERNAM WERKS VGBEL VGPOS
if not it_likp[ ] is initial. "<< this is mandatory for all entries.
SELECT VBELN POSNR MATNR ERDAT LFIMG ERNAM WERKS VGBEL VGPOS FROM LIPS INTO
TABLE LT_LIPOV
for all entries in it_likp
WHERE VBELN = it_LIKP-VBELN.
endif.
‎2008 May 26 4:03 AM
do the following before using for all entries.........
1.delete adjacent duplicates from that itab...
2.sort that itab.........
‎2008 May 26 4:04 AM
Hi Kumar,
Check the structure of table LT_LIPOV.
Has it got all the fields that you have given in the select statement?
Any change in the field mentioned in the select and the structure of LT_LIPOV will go to dump.
Hope this helps you.
Thanks,
Arun
‎2008 May 26 4:09 AM
Hi Kumar ...
There is no mistake in Your Select Statment ....
but we need to check firstly whether the LIKP table is initial or not then only we need hit the data base..
Just chect whether it_likp is having data or not..
Thanks,
sg
‎2008 May 26 4:21 AM
hi Kumar,
Check out if the structure of LT_LIPOV has fields of order VBELN POSNR MATNR ERDAT LFIMG ERNAM WERKS VGBEL VGPOS ...
else use corresponding fields of table statement ...
if not it_likp[] is initial.
SELECT VBELN POSNR MATNR ERDAT LFIMG ERNAM WERKS VGBEL VGPOS FROM LIPS INTO corresponding fields of
TABLE LT_LIPOV
for all entries in it_likp
WHERE VBELN = it_LIKP-VBELN
endif..Regards,
Santosh