Logical system entry for table entry

[Former Member]

Hi,

After system copy from one system name to another , I am facing some inconsistenices in various tables.

The table entry can be seen in se16.But when I try to select entries from the same table using SELECT statement, table are not getting populated.

I ran the BDLS also . How do I check the logical system entried for table where I have inconsistent entries?

Thanks,

Chitta

[Former Member]

After system copy BDLS was not run. Hence it was creating problem.

[debasissahoo]

Hello Chitta,

But when I try to select entries from the same table using SELECT statement, table are not getting populated.

what are you trying to populate?

If your question is, its not showing anything... what error message you're getting? are you trying to run in the DB level?

If you're getting error, that this object doesn't exist in the database then you might not be logging with correct user. its an SAP table, then its owner is the SAP schema user. If you login with the schema user, it should show in a normal select statement. But if you login with <sid>adm then you have to give the correct schema id before tablename.

select * from <SchemaID>.<tablename>

SchemaID may be sapr3, sapsr3, or sap<SID> depending on your release.

Regards,

Debasis.

[Former Member]

which userID you logged to run SQLPLUS? have you give schema name with table name (ie. sapr3.t000)

cheers,

-Sunil