Skip to Content

S/4HANA IDES data location

Hello,

I have installed S4/HANA IDES system. I would like to ask you where can I find data? There should be tables as LFA1, EKKO, EKPO etc, but I couldnt find them.

I connect to DB via HANA Studio, database user.

tahnk you

Add comment
10|10000 characters needed characters exceeded

18 Answers

  • Posted on Apr 23 at 01:57 PM

    Hi John,

    which system/release do you mean (there is no IDES shipment anymore at least for the recent S/4HANA releases) ?
    If it's about the S/4HANA Fully-Activated Appliance: look in schema SAPHANADB in HANA Studio (user SAPHANADB / <Your Master Password of the CAL Instance>)

    Best, Joerg

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 23 at 02:48 PM

    Hi John,

    please check in client 400.

    This is the default client for IDES!

    BR,

    Jan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 24 at 11:14 AM

    Can I display data in Hana Studio?

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 24 at 12:28 PM

    Hi,

    can you please check in Schema SAP<SID>?

    I crossed checked in ourcurrent system and could find the table there.

    BR,

    Jan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 24 at 02:10 PM

    Hi John,

    looks really strange for me. Any chance that you upload the installation-logs here?

    BR,

    Jan

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 24 at 09:30 PM

    When I logged into client 400 and check table LFA1, there are data


    lfa1.jpg (304.4 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 27 at 09:50 AM

    Could be the reason some authorization issue? But I am connecting to DB via database user.

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 27 at 10:07 AM

    Hi John,

    it seems that the user SYSTEM has not the corresponding rights for seen all schemas (it is correct) Please try again with user SAPHANADB and check.

    regards Oliver

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 27 at 12:23 PM

    Hello, user is shown as SYSTEM, but I conected as SIDADM - in my case HIDADM. I checked

    SAPHANADB user too, but it seems that there is not between users.

    user2.jpg


    user.jpg (65.5 kB)
    user2.jpg (42.8 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 28 at 12:42 PM

    Any idea what is wrong?

    Add comment
    10|10000 characters needed characters exceeded