Skip to Content
avatar image
Former Member

lookup inside abap data flow

hi all,

I am using ABAP data flow to pull data from ECC standard tables in BODS 4.0 version.

To pull only required data, i introduced where clause inside ABAP data flow, but

this is having performance issue since i started using many values using IN() caluse.

Can i use Lookup() inside ABAP, instead of filters in where clause?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Jan 11, 2015 at 11:26 AM

    Hi,

    I dont think we can use lookup_ext function within an ABAP dataflow. but the column on which you are applying the filter.... does it have an index ? If not try to get your BASIS team to setup an index on that column. It will help with performance.

    Raghu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2015 at 01:50 PM

    You cannot use lookup_ext() inside a ABAP DF.How many rows are expected to extract?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 12, 2015 at 04:01 PM

    hi Raghu,

    I am getting below error

    Execute ABAP program </*****.aba> error < ABAP SYNTAX ERROR "CCODE--lookuptable" must be a flat structure. You cannot use internal tab>.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      usually access to the SAP Fileshare will be restricted to the BASIS team. You should have some process to raise a request with your basis support team to place the file inthe desired location meant for BODS. Configuration Management and similar process are usually in place with Basis teams and you can certainly contact them to help with this.

      Raghu