EY Global Delivery Services ( EY GDS) Interview Questions, Process, and Tips

LDB stands for Logical Database. There are two types of LDB - PNP and PCH.

• LDB is a special feature in SAP ABAP that allows easy access to data from database tables.

• PNP (Personnel Administration) LDB is used for HR-related data.

• PCH (Payroll Accounting) LDB is used for payroll-related data.

Concurrent employment refers to an individual holding multiple jobs simultaneously.

• Occurs when an employee works for more than one employer at the same time

• Each employer must be aware of the concurrent employment

• May involve different roles or responsibilities in each job

• Requires careful management of work schedules and potential conflicts

Use infotype 0001 (Organizational Assignment) to link multiple pernrs for one employee.

• Use infotype 0001 (Organizational Assignment) to find multiple pernrs for one employee

• Check the relationship between the employee and the positions they hold

• Look for any additional infotypes related to the employee's assignments

The program flow in LDB report involves data selection, data retrieval, data processing, and data display.

• Data selection: Define selection criteria to fetch relevant data from the database.

• Data retrieval: Use LDB functions to retrieve data from the database tables specified in the logical database.

• Data processing: Perform any necessary calculations or manipulations on the retrieved data.

• Data display: Present the proces...read more

Macros are pre-defined code snippets that can be reused multiple times in a program.

• Macros are defined using the #define directive in C programming.

• They are used to simplify complex code by replacing repetitive code with a single macro.

• For example, a macro can be used to define a constant value that is used multiple times in a program.

To hit the payresult in a report, use the function module 'HR_PAYROLL_RESULT_READ'. T-code 'PC_PAYRESULT' can be used to see payroll results for an employee.

• Use function module 'HR_PAYROLL_RESULT_READ' to hit the payresult in a report

• T-code 'PC_PAYRESULT' can be used to see payroll results for an employee

• There is no specific indicator in the payroll directory, but you can access payroll results through various reports

To identify payroll results for a particular period, you can use the payroll result table and filter by period. CRT and RT in payroll directory refer to different types of results.

• You can identify payroll results for a particular period by querying the payroll result table and filtering by the period in question.

• CRT in the payroll directory typically refers to current results, while RT may refer to retroactive results.

• ...read more

Retroactive refers to something that applies to a period before it was enacted or implemented.

• Retroactive changes can impact data that was entered in the past

• In SAP, retroactive changes can be made to correct errors or update information

• Retroactive adjustments may require additional testing to ensure data integrity

Yes, I have experience uploading INFOTYPES data using BAPIs and BDCs.

• I have created BAPIs to upload master data in SAP using standard function modules or custom function modules.

• I have used BDC (Batch Data Communication) to upload data into SAP by recording the manual steps and then automating them.

• I have experience uploading INFOTYPES data such as personal data, organizational data, and time data.

• I have worked on proj...read more

Yes, INFOTYPES can be enhanced but not all INFOTYPES are customizable.

• INFOTYPES can be enhanced using custom fields or logic to meet specific business requirements.

• Not all INFOTYPES can be enhanced as some are standard and cannot be modified.

• Enhancing INFOTYPES requires thorough understanding of the data structure and business processes.

• Examples of enhanced INFOTYPES include adding custom fields for additional informat

The exact tab for enhancing fields in infotypes is the 'Enhancement Category' tab.

• Navigate to the 'Enhancement Category' tab in the infotype maintenance screen.

• Select the appropriate enhancement category for adding a field to the infotype.

• Enhancement categories include 'Customer Include', 'Customer Enhancement', and 'Customer Modification'.

Time constraints of INFOTYPES can be identified by checking the configuration settings in SAP system.

• Time constraints in INFOTYPES are defined in the configuration settings of the SAP system.

• Time constraint 'T' indicates that only one record can exist for a specific time period.

• Time constraint 'T' is commonly used for master data like employee records in SAP HR module.

The number range for absence related and custom infotypes is in 2 series.

• Absence related infotypes typically fall within number range 2000-2999

• Custom infotypes can be assigned number range 9000-9999

To identify available BADI, use transaction code SE18 or SE19 and search for relevant BADI implementations.

• Use transaction code SE18 or SE19 to search for BADI implementations

• Enter the BADI name or description to find relevant implementations

• Check the active implementations for the BADI to see which ones are being processed

Classical BADI is older and uses filter values, while new BADI is more flexible and uses multiple implementations.

• Classical BADI uses filter values to determine when to trigger the enhancement, while new BADI uses multiple implementations.

• New BADI allows for multiple implementations to be active at the same time, while classical BADI only allows one implementation at a time.

• New BADI is more flexible and easier to use c...read more

Customer exits can be identified by searching for specific function modules or by checking the enhancement spots in the system.

• Search for function modules with naming convention starting with 'EXIT_'

• Check enhancement spots using transaction code CMOD

• Look for customer exits in the SAP menu path: Tools -> ABAP Workbench -> Development -> Enhancements

• Customer exits can also be found in the SAP IMG (Implementation

Asynchronous and synchronous in BDC refer to the timing of data processing in Batch Data Communication.

• Asynchronous BDC processes data in the background without user interaction.

• Synchronous BDC processes data in real-time with user interaction.

• Asynchronous BDC is preferred for large data volumes to avoid system performance issues.

• Synchronous BDC is suitable for smaller data sets where immediate feedback is required.

• Exa...read more

ABAP Memory is used for storing data during a single transaction, while Global Memory is used for storing data across multiple transactions.

• ABAP Memory is used for storing data within a single transaction and is accessible only within that transaction.

• Global Memory is used for storing data across multiple transactions and is accessible throughout the entire session.

• ABAP Memory is cleared at the end of a transaction, wh...read more

I have worked on various interfaces including IDOC, RFC, BAPI, and web services.

• IDOC (Intermediate Document)

• RFC (Remote Function Call)

• BAPI (Business Application Programming Interface)

• Web services

The syntax to write a file into the application server in SAP ABAP involves using the OPEN DATASET, TRANSFER, and CLOSE DATASET statements.

• Use OPEN DATASET statement to open the file in application server

• Use TRANSFER statement to write data into the file

• Use CLOSE DATASET statement to close the file

To load a logo in an Adobe form, you can use the standard function module 'SSF_FUNCTION_MODULE_NAME' to get the function module name for the logo and then use 'CALL FUNCTION' to display the logo.

• Use function module 'SSF_FUNCTION_MODULE_NAME' to get the function module name for the logo

• Use 'CALL FUNCTION' to display the logo in the Adobe form

Select the key field and bind it to the corresponding value field in SAP ABAP.

• Select the key field based on the unique identifier for the data

• Bind the key field to the value field that contains the relevant information

• Ensure proper mapping between the key and value fields for accurate data retrieval

You can identify the employee manager in SAP using the OM (Organizational Management) module.

• In SAP, you can use the function module 'RH_STRUC_GET' to retrieve the organizational structure of an employee.

• The manager of an employee can be identified by looking at the 'Reports To' field in the organizational structure.

• You can also use features like 'Position' or 'Job' to determine the employee manager.

HRP1000, HRP1001, HRP1002 are tables in SAP used for employee hierarchy. T-code PPOME can be used to view employee hierarchy in OM.

• HRP1000 stores the object ID of the organizational unit

• HRP1001 stores the object ID of the position

• HRP1002 stores the object ID of the employee

• T-code PPOME can be used to view the employee hierarchy in Organizational Management (OM)

A federated data warehouse is a system that combines data from multiple sources into a single, virtual database.

• It allows for querying and analyzing data from different sources without physically moving the data.

• Data remains in its original location but can be accessed and queried as if it were in a single database.

• Federated data warehouses are useful for organizations with diverse data sources and distributed data.

• Exa...read more

Database table versioning is the practice of maintaining historical data in a table by creating new versions of records instead of updating existing ones.

• Database table versioning involves creating new records for each change instead of updating existing records.

• It allows for tracking changes over time and maintaining a history of data.

• Common techniques for database table versioning include using effective dating or ti...read more

1:M and M:M relationships in data modeling are handled using foreign keys and junction tables.

• For 1:M relationships, a foreign key is added in the 'many' side table referencing the primary key in the 'one' side table.

• For M:M relationships, a junction table is created with foreign keys referencing the primary keys of both related tables.

• Example: In a bookstore database, a book can have multiple authors (M:M), so a junct...read more

Lambda architecture is a data processing architecture designed to handle massive quantities of data by using both batch and stream processing methods.

• Combines batch processing for historical data with real-time stream processing for current data

• Allows for both speed and accuracy in data processing

• Enables fault tolerance and scalability

• Example: Using Apache Hadoop for batch processing and Apache Storm for stream process

Improving data warehouse/DB performance involves optimizing queries, indexing, hardware, and data modeling.

• Optimize queries by using appropriate indexes, avoiding unnecessary joins, and limiting the amount of data retrieved.

• Implement proper indexing strategies to speed up data retrieval, such as creating indexes on frequently queried columns.

• Upgrade hardware components like CPU, memory, and storage to handle larger wor...read more

Hyper-normalization is a data modeling technique that involves breaking down data into smaller, more manageable pieces.

• Hyper-normalization involves breaking down data into smaller, more manageable pieces to reduce redundancy and improve data integrity.

• It helps in organizing data in a more granular and structured manner, making it easier to query and analyze.

• Hyper-normalization can lead to a more efficient database desi...read more