Invalid object name 'NEP.nep.BSEG'

[Former Member]

Day Book Tcode - S_ALR_87012296

The main source of information for 'Day Book' is coming from the tables BSEG, BKPF and BSIK.

Further we want to develop this report with some more additional details and we want to customize this report to automate the execution from other reporting tools.

BKPF and BSIK tables are accessible from Microsoft SQL Server through select query.

But, BSEG table is restricted in SAP, where we cannot use any traditional ways to retrieve the data.

When executing the SQL Query "select * from NEP.nep.BSEG;" from MS SQL Server Management Studio, we are getting this error.

"Invalid object name 'NEP.nep.BSEG' ".

[prithvirajr · Accepted solution]

Hi

BSEG is cluster table and you cannot access it using native sql statement.

For you reference:

https://blogs.sap.com/2014/12/08/reading-and-writing-data-in-cluster-table/

https://help.sap.com/http.svc/rc/abapdocu_751_index_htm/7.51/en-US/abenddic_database_tables_poclure....

Regards,

Prithviraj