topic Re: Get Pernr? in Application Development and Automation Discussions

topic Re: Get Pernr? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102729#M1706103 <HTML><HEAD></HEAD><BODY><P>Hi Vinoth,</P><P>the link is not available it seems.</P><P>when i tried to open that link i am getting the PAGE IS NOT FOUND.</P></BODY></HTML> Thu, 06 Dec 2012 04:25:42 GMT Former Member 2012-12-06T04:25:42Z Get Pernr? https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102727#M1706101 <HTML><HEAD></HEAD><BODY><P>HI all,</P><P>I am trying to execute a standard program,</P><P>but in GET PERNR event for some employees its taking the pernr-pernr as the employee number </P><P>but for some employee spernr-pernr is showing as "###########" like this . so i am not getting the data for those employees.</P><P>Please advise on this.</P></BODY></HTML> Thu, 06 Dec 2012 04:07:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102727#M1706101 Former Member 2012-12-06T04:07:01Z Re: Get Pernr? https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102728#M1706102 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>refer this link it will be helpful,</P><P><A href="http://wiki.sdn.sap.com/wiki/display/Snippets/Report+in+HR+ABAP+(LDB">http://wiki.sdn.sap.com/wiki/display/Snippets/Report+in+HR+ABAP+(LDB</A>)</P></BODY></HTML> Thu, 06 Dec 2012 04:19:44 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102728#M1706102 vinoth_aruldass 2012-12-06T04:19:44Z Re: Get Pernr? https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102729#M1706103 <HTML><HEAD></HEAD><BODY><P>Hi Vinoth,</P><P>the link is not available it seems.</P><P>when i tried to open that link i am getting the PAGE IS NOT FOUND.</P></BODY></HTML> Thu, 06 Dec 2012 04:25:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102729#M1706103 Former Member 2012-12-06T04:25:42Z Re: Get Pernr? https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102730#M1706104 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>refer this code.</P><P><A href="http://help.sap.com/saphelp_47x200/helpdata/en/4f/d527ba575e11d189270000e8322f96/content.htm">http://help.sap.com/saphelp_47x200/helpdata/en/4f/d527ba575e11d189270000e8322f96/content.htm</A></P><P></P><P></P><P><STRONG>Using Logical Database and Macro</STRONG></P><P>Logical Databases used In HR:</P><P>PAP                                        </P><P>PNP</P><P>PNPCE - Enhanced version of PNP available form SAP Enterprise version onwards</P><P>PCH</P><P>PTRVP</P><P>        The LDB PAP is for Applicant administration, PNP and PNPCE for Personnel</P><P>         Management, PCH for Organisational Management and PTVRP for Travel</P><P>         Management.</P><P>        The Logical Databases PNP/PNPCE and  PCH are mostly used. <BR />Step 1:</P><P>In the program attributes, include the name of the logical database. </P><P><SPAN class="image-wrap"><IMG class="jiveImage" src="https://community.sap.com/wiki/download/attachments/39417/hr1.jpg?version=1&modificationDate=1184926460048" style="border: 0px solid black;" /></SPAN></P><P>If you want to customize selection screen, you can use HR report category button. But in this document, we are using PNP logical database selection screen itself.</P><P>Step2: We can see Logical database structure (Tcode SE36) PNP has PERNR in top. PERNR is a data dictionary structure without a database. That should be declared in program as</P><P>Tables PERNR.</P><P>After writing the statement and adding PNP in program attributes, if we execute the program we can see the selection screen of Logical Database PNP.</P><P>Step 3: We need to mention the infotypes we need from the LDB using infotypes declaration. In our program, we need data from organization data (Infotype 0001).</P><P>Infotypes 0001. <BR />Step 4: Inorder to get the data inside the p0001, we need to mention GET PERNR statement inside start-of-selection and end-of-selection.</P><P>Event keywords for data retrieval from a logical database have the following syntax.</P><P>GET <TABLE>.</P><P><SPAN style="color: black;">start-of-selection.</SPAN></P><P><SPAN style="color: black;">get pernr.</SPAN></P><P><SPAN style="color: black;">End-of-selection.</SPAN></P><P><SPAN style="color: black;">This statement will fetch the employee one at a time inside the block start-of-selection and end-of-selection.</SPAN> <SPAN style="color: black;">At the GET PERNR event, the PERNR structure contains the data for a</SPAN><SPAN style="color: black;"> </SPAN></P><P><SPAN style="color: black;">personnel number chosen on the basis for selection screen entries. The PERNR-PERNR field contains the personnel number which is selected for processing. Only the PERNR-PERNR field should be read from the work area of the PERNR table. The other fields are intended for internal use only.</SPAN></P><P><SPAN style="color: black;">Step 5: We can use Macros to get the particular record for that pernr.</SPAN></P><P><SPAN style="color: black;">Some of the Macros used in PNP logical database are:</SPAN></P><P><SPAN style="color: black;">RP-PROVIDE-FROM-FRST - Retrieve particular employee first record in the selected period.</SPAN></P><P><SPAN style="color: black;">RP-PROVIDE-FROM-LAST - Retrieve particular employee last record in the selected period.</SPAN></P><P><SPAN style="color: black;">The parameters to be passed to those macros are structure, subtype, begda and endda.</SPAN></P><P><SPAN style="color: black;">You can see the MACROS in database TRMAC table.</SPAN></P><P><SPAN style="color: black;">RP-READ-INFOTYPE - Retrieve all the records of the particular employee in the selected period.</SPAN></P><P><SPAN style="color: black;">Parameters to be passed to this macros are:</SPAN></P><P><SPAN style="color: black;">PERNR</SPAN><SPAN style="color: black;">     </SPAN> <SPAN style="color: black;">PERSONALNUMBER</SPAN></P><P><SPAN style="color: black;">INFTY</SPAN><SPAN style="color: black;">     </SPAN> <SPAN style="color: black;">INFOTYPNUMBER</SPAN></P><P><SPAN style="color: black;">INFTY-TABLE OUTPUT-TABLE LIKE PNNNN</SPAN></P><P><SPAN style="color: black;">BEGDA</SPAN><SPAN style="color: black;">     </SPAN> <SPAN style="color: black;">INTERVAL-BEGIN</SPAN></P><P><SPAN style="color: black;">ENDDA</SPAN><SPAN style="color: black;">     </SPAN> <SPAN style="color: black;">INTERVAL-END</SPAN><SPAN style="color: black;"> </SPAN></P><P><SPAN style="color: black;">Step 6: After calling the macro, PNP-SW-FOUND should be checked. If it is equal to 1,then it means the data is retrieved successfully. If it is equal to zero, then there is no entry.</SPAN></P><H1><A name="ReportinHRABAP%28LDB%29-"></A><SPAN style="color: #225a8d;">Complete Code</SPAN></H1><P><SPAN style="color: black;">TABLES pernr.</SPAN></P><P><SPAN style="color: black;">INFOTYPES : 0001.</SPAN></P><P><SPAN style="color: black;">START-OF-SELECTION.</SPAN></P><P><SPAN style="color: black;">GET pernr.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">WRITE : / 'Result from Macros'.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">rp-provide-from-frst p0001 space pn-begda pn-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">IF pnp-sw-found = 1.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / 'Result from rp-provide-from-frst'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / p0001-pernr, p0001-begda, p0001-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">ENDIF.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">rp-provide-from-last p0001 space pn-begda pn-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">IF pnp-sw-found = 1.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / 'Result from rp-provide-from-last'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / p0001-pernr, p0001-begda, p0001-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">ENDIF.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">rp-read-infotype pernr-pernr 0001 p0001 pn-begda pn-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">IF pnp-sw-found = 1.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / 'Result from rp-read-infotype'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">LOOP AT p0001.</SPAN></P><P><SPAN style="color: black;">     </SPAN> <SPAN style="color: black;">WRITE : / p0001-pernr, p0001-begda, p0001-endda.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">ENDLOOP.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">ENDIF.</SPAN></P><P><SPAN style="color: black;">END-OF-SELECTION.</SPAN></P><P></P><P></P><H1><A name="ReportinHRABAP%28LDB%29-"></A><SPAN style="color: #225a8d;">Output :</SPAN></H1><P>  <SPAN class="image-wrap"><IMG class="jiveImage" src="https://community.sap.com/wiki/download/attachments/39417/hr2.jpg?version=1&modificationDate=1184926481732" style="border: 0px solid black;" /></SPAN></P><P><SPAN class="image-wrap"><IMG class="jiveImage" src="https://community.sap.com/wiki/download/attachments/39417/hr3.jpg?version=1&modificationDate=1184926550670" style="border: 0px solid black;" /></SPAN></P><H1><A name="ReportinHRABAP%28LDB%29-"></A><SPAN style="color: #225a8d;">Procedure</SPAN></H1><P><STRONG>Using Logical Database and ProvideEndProvide</STRONG> <BR />Follow Steps 1 to 4 as explained above.</P><P>Step 5 : The infotype records are processed sequentially by PROVIDE-ENDPROVIDE loop.</P><P><SPAN style="color: black;">provide * from p0001 between pn-begda and pn-endda.</SPAN></P><P><SPAN style="color: black;">write : / p0001-pernr, p0001-begda, p0001-endda.</SPAN></P><P><SPAN style="color: black;">endprovide.</SPAN>  </P><H1><A name="ReportinHRABAP%28LDB%29-%26nbsp%3B"></A> </H1><H1><A name="ReportinHRABAP%28LDB%29-%26nbsp%3B"></A> </H1><H1><A name="ReportinHRABAP%28LDB%29-"></A><SPAN style="color: #225a8d;">Complete Code</SPAN></H1><P><SPAN style="color: black;">TABLES pernr.</SPAN></P><P><SPAN style="color: black;">INFOTYPES : 0001.</SPAN></P><P><SPAN style="color: black;">START-OF-SELECTION.</SPAN></P><P><SPAN style="color: black;">GET pernr.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">WRITE : /'Result from ProvideEndprovide'.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">WRITE : / '-------------------------------------'.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">PROVIDE * FROM p0001 BETWEEN pn-begda AND pn-endda.</SPAN></P><P><SPAN style="color: black;">   </SPAN> <SPAN style="color: black;">WRITE : / p0001-pernr, p0001-begda, p0001-endda.</SPAN></P><P><SPAN style="color: black;"> </SPAN> <SPAN style="color: black;">ENDPROVIDE.</SPAN></P><P><SPAN style="color: black;">END-OF-SELECTION.</SPAN> </P><H1><A name="ReportinHRABAP%28LDB%29-"></A></H1><P>   <SPAN class="image-wrap"></SPAN><BR /> <BR /> <BR /> <BR /><SPAN class="image-wrap"></SPAN></P></BODY></HTML> Thu, 06 Dec 2012 04:43:45 GMT https://community.sap.com/t5/application-development-and-automation-discussions/get-pernr/m-p/9102730#M1706104 vinoth_aruldass 2012-12-06T04:43:45Z