Logical Database

[Sandra_Rossi]

Hi everyone,

I recently came across a issue where the pay slips are mailed through a custom report every month , but the problem is everyone is receiving it twice.
I tried to understand the report but can't narrow down the problem .They are using logical database in which I don't have much knowledge.

Does GET PERAS repeat the pernr? like is there any possibility that the same pernr might come again in GET PERAS pernr-pernr.

The report is being run only for one payroll area which means only one time the loop will run for an employee, but if we get the same pernr again it might run again.

[Sandra_Rossi]

What program is it and what logical database it uses? (the LDB name is in the program properties)

[FredericGirod]

Logical database could be seen in transaction SE36.
It looks like Association in CDS view between tables.

Get should be the statement to go in a new relation from the Header table.

and, yes, it is a nightmare to use / debug 🙂

[KarthickD]

hi thanks for the replay it uses PNPCE

[Sandra_Rossi]

You could read the documentation of the logical database PNPCE to understand what the different nodes are for. I see things like "In PNP mode, the GET PERAS event is triggered as a result for each personnel number." and PNP mode depends on presence of INFOTYPES in your program...

[KarthickD]

will check on it , thank you.

[BGibbons]

Hi

Run it with the debugger for one employee and it should be easy to see whats happening.

I would say investigating the LDB is a red herring.

bg

[KarthickD]

yes , it will be

but I found the cause it is not logical database.

[TammyPowlas]

Hi - to review the logical database, use transaction SE36 to see how it is built.

If you want more details and help, please state which logical database is being used - is it PNP or ?

[KarthickD]

hi it uses PNPCE