Data Accessing Problems from the Tables while using Code Inspector.

[Adi_Bathineni]

HI Gurus,

I'm developing a Smart Form for SD Packing Slip.

In that my requirement is to get the Shipping Unit Header Data From the VEKP Table

For this i'm using the Link as

LIKP-VBELN = VEPO-VENUM

From the above condition i'm getting the VENUM from the VEPO Table.

Based on that VENUM i'm getting the Data From the VEKP by Equalling the VEPO-VENUM and VEKP-VENUM.

My Problem is when i run the Code Inspector, I'm getting the Following Error.

"Large Table: VEPO No Filed of a Table Index in where condition"

Is there any other way to access the Data from the VEKP table.

CAn i use Inner Join for those Three Tables to get the data (LIKP,VEPO & VEKP).

If i use Inner Join, What about the Performance?

Thanks in Advance.

Regards,

Adinarayana

[Former Member]

Hi,

The error you are getting because you are not using key fields of the table VEPO.

By using inner join there may not be the performance issue. Or else you can use for all entries.

Thanks,

Sri.

[Adi_Bathineni]

Hi Sriram,

I'm using For All Entries Only to get the Data from VEPO

Following is the Code

SELECT VBELN

VENUM

FROM VEPO

INTO CORRESPONDING FIELDS OF TABLE I_VEPO

FOR ALL ENTRIES IN I_LIKP

WHERE VBELN = I_LIKP-VBELN.

I know i'm not using any Key field of VEPO table to get the Data...

Which Key field should i use to get the data from the VEPO table with reference to the LIKP table.

In VEPO and LIKP only VBELN is the common field.

I'm using the VBELN as the Reference.

Please Guide me.

Thanks in Advance.

Regards,

Adinarayana