Skip to Content
0
Sep 18, 2016 at 09:23 AM

issue with select for EKPO and LIPS tables

1413 Views

Hi experts,

I am fetching data from EKPO table based on entries in LIPS table, where I am getting an error as EBELP and I_LIPS-VGPOS must be of same type and length

SELECT ebeln ebelp cuobj

FROM ekpo

INTO TABLE i_cuobj

FOR ALL ENTRIES IN i_lips

WHERE ebeln = i_lips-vgbel

AND ebelp = i_lips-vgpos.

I know we can move the contents into a temporary internal table I_LIPS_TEMP, which is a copy of I_LIPS table , and use the temporary internal table I_LIPS_TEMP when fetching data from EKPO.

I also know that VGPOS is of type NUMC 6 and EKPO EBELP is of type NUMC 5 . Please suggest any good solution for this.

Thanks,

RG