Skip to Content
avatar image
Former Member

Need an approch for data fetching

Hi Experts,

I have a requirement to fetch data from three tables on the basis of a date we have passed through selection screen.

I have the three tables EVER , EANLH and ERCH.

I have to check the BELEGDAT in table ERCH and pick the VERTRAG from it .This BELEGDAT should be passed through selection screen.

And then I have to check this VERTRAG in table EVER and pick the ANLAGE.

And then I need to pick TARIFTYP from table EANLH using this ANLAGE. Also I need to check the BIS = 31.12.9999 in table EANLH. Because it has multple records for our selection.

AT least I need the values of ANLAGE and TARIFTYP in one internal table.

I have tried various select approches and also the inner join technique. But not able to fetch the data as per of requirement.

Can you please let me know which approch I need to use as I am new to ABAP.

Thanks and Regards,

Jasvinder Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 04, 2013 at 12:43 PM

    Hi Jasvinder,

    You can use different select queries with "for all entries"- this will reduce database use in case of joins.

    get data in different internal tables and combine them in program.

    Hope this helps.

    Regards,

    Nachiket

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 04, 2013 at 01:08 PM

    The problem as i see it is your starting point - it cannot reasonably be ERCH unless the user is providing the billing document number.

    The normal approach would be to have user provide a contract value and get the ANLAGE from EVER based on that contract.  Then use ANLAGE to check EANLH with your restrictions.  I don't see what ERCH adds to your process.

    regards,

    bill.

    Add comment
    10|10000 characters needed characters exceeded