Estruct tables

[Former Member]

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?

Regards

[clas_hortien]

Hello,

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

database.

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

Clas

[Former Member]

Thanks for your help Clas.

Do you have a link with more information about SAP BAPIs?

[clas_hortien]

Hi,

no, unfortunately not. I'm a database guy and not a developer. But help.sap.com should provide some information.

The component is CA-BFA.

Best regards

Clas