ABAP: finding logical database with table name
Posted on May 4, 2010, under SAP.
I wrote this tip to embrace many – sometimes strange – needs of ABAP programmers.
To find a logical database having database table name only you should use transaction SE36 – Logical database builder. We choose Extras -> Table usage and write table name. The result is a list of logical databases, which use this table.
And for instance for PERNR table we got LDBs: PNP (HR Master Data) i PNPCE (HR Master Data including concurrent employment).
This knowledge may be useful for example during exploration of not known ERP modules, when your only anchor point is table name from that area. Quick&useful.
Search help for PCHOBJID in PNP raport
Lately I went through a problem in SAP HR program, HR-PA to be precise. I write an application, which uses PNP database, but one of its functionality uses organizational management, that means PCH usage. Generating selection screen fields from PCH application is quite easy. The problem shows off, when we want to add search help for object ID – common for PCH selection screen.
(more…)
