Skip to Content

Data Accessing Problems from the Tables while using Code Inspector.

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 06, 2008 at 06:48 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.