Skip to Content
avatar image
Former Member

Estruct tables

Hi all

I'm new loading from SAP to SQLServer 2008 with a store procedure,

how can I work with SAP Estruct tables in order to load data from these tables like KVAGV or COBL?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 27, 2011 at 09:17 AM


    it is not recommended to use any direct access to the R/3 SQL Server


    1.) You can not access SAP pool and cluster tables with this method.

    2.) In addition to this, you will run into code page and locale problems, if you read data from a R/3 database directly.

    3.) The definition of tables in SQL Server might change from R/3 release to R/3 release, even if the definition of this table does not change in R/3 data dictionary. For example, the definition of table ATAB did change two times in R/3 releases 3.1I, 4.0A, 4.6A

    It's a much better idea to use the SAP BAPIs to create an interface to non-SAP components.

    Best regards


    Add comment
    10|10000 characters needed characters exceeded