71 likes | 90 Views
SAP Logical database is a special ABAP program that reads data from database tables. The logical database can be used in an executable program by just specifying the name of the logical database in the program attributes.
E N D
What is Logical Database in SAP ABAP? Presented By - APPRISIA
SAP HR – Logical Database • SAP Logical Databases are special ABAP programs that read data from database tables. • We can use logical database in a executable program by just specifying the name of the logical database in the program attributes. • When you run your executable program, the logical database program will also run simultaneously with it. www.apprisia.com
SAP HR – Logical Database • SAP has provided logical database for all categories. • In Human Resources (HR), the following logical databases can be used as a data source for HR InfoSets: PNP (PNPCE) Structure PAP Selection PCH DatabaseProgram www.apprisia.com
SAP HR – Logical Database • Structure: The structure of a logical database determines the database tables which it can access. It adopts the hierarchy of the database tables defined by their foreign key relationships. This also controls the sequence in which the tables are accessed. • Selection: Every logical database has its own selection screen. Every executable program can use the selections defined in the logical database and it can add its own specific selections. The selection screen 1st displays the selection of the logical database followed by the selection of the calling program. www.apprisia.com
SAP HR – Logical Database • Database Program: The database program of a logical database is a container for special subroutines, in which the data is read from the database tables. These subroutines are called by the reporting processor in the runtime environment in a predefined sequence. The most important functions of the logical database are: 1.Data Retrieval 2.Data Selection 3.Authorization www.apprisia.com
SAP HR – Logical Database Need Help • In case you need assistance in SAP Logical Database, please contact us. • Please send us your questions, comments or assistance request. www.apprisia.com
THANK YOU Address: 9330 LBJ Freeway Suite 900 Dallas TX 75243 Contact: +1 (214) 556-5416 Email: support@apprisia.com www.apprisia.com