Skip to Content
author's profile photo Former Member
Former Member

select statment

hi all,

i have to retrieve all pernr from table pa0000 and all pernr from table pa0105 but not linked with usrid.

and the data download into notpad/excel sheet.

please sugest me how to retrieve data from database table.

best regards,

ashok.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Apr 11, 2008 at 06:53 AM

    reward i f useful

    get pernr.

    rp_priove_fromlast p0001 space pn-begda pn-eneda.

    rp_priove_fromlast p0000 space pn-begda pn-eneda.

    rp_priove_fromlast p0105 space pn-begda pn-eneda.

    just chekc pnp_sw_found = 1. then allow the flow other wise use reject statment.

    if u want to combination of three...

    use provide

    • from p0000

    • from p0001

    • from p0105

    between pn-begda pn-enddda.

    endprovide.

    but this we never use.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 11, 2008 at 07:13 AM

    Hi,

    Use the following to fetch PERNR.

    infotypes: 0000, 0105.

    tables: pa0000, pa0105, pernr.

    data: it_0000 type table of pa0000,

    it_0105 type table of pa0105,

    wa_0000 type pa0000,

    wa_0105 type pa0105.

    select * from pa0000 into table it_0000.

    if not it_0000[] is initial.

    select * from pa0105 into table it_0105 for all entries in it_0000

    where pernr = it_0000-pernr.

    endif.

    apply the logic for uploading the data to notepad/excel.

    Reward accordingly.

    regards

    ChandraK

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.