topic Re: how to extract the po data in Application Development and Automation Discussions

how to extract the po data

Former Member — Thu, 16 Nov 2006 05:40:21 GMT

hi,

i have one problem in data extraction,my requirment is ,

i want to extract the transactional data that to be related to the Puchase order,but how to extract the data i am not geting,can any body have the dia kindly let me know.

thanks,

Rammohan.

Re: how to extract the po data

venkata_ramisetti — Thu, 16 Nov 2006 05:48:49 GMT

Hi,

Before extraction, you should know what data need to be extracted from the purchase order. This is because purchase order contains lot of details.

Once you get the details, you can fetch the purchase order data from tables EKKO, EKPO, EKET, EKBE tables.

Thanks

Ramakrishna

Re: how to extract the po data

former_member69765 — Thu, 16 Nov 2006 05:50:38 GMT

What I have understood of ur Quest it that you have a Purchase Order No and you want to extraact all the details for that PO ...

If this is the Quest.. Use this FM - BAPI_PO_GETDETAIL.

Just Pass the PO No. to it.

If your question is some thing else... please elaborate on this...

Please reward points if it is helpful.

Re: how to extract the po data

former_member69765 — Thu, 16 Nov 2006 05:53:42 GMT

Mr Ramakrishna....

If the FM is available... why do you want to write select statements...

Yes you are correct.. when a PO is created lots of tables are updated...

We will have to do select on many tables... may be we will have to Join query...

Instead this BAPI will give us all the details...

Am I correct Mr. Ramakrishna ????

Re: how to extract the po data

Former Member — Thu, 16 Nov 2006 05:59:06 GMT

hi varun,

Thanks for reply,exactly the same what you under dtand,i will explain you ,

our data is already in the production sever ,but we need to extrct the data from the production server,and then we need to load the data into the another server(that is global server),i am able to extract the master data,but problem with transactional data ,like po,because of some of configarations is going to change in global server,we need to extract the data into excel,and then we need to load the data.can u pls send if u have any sample code,or any standerd programes for this issue,

thanks,

Rammohan.

Re: how to extract the po data

venkata_ramisetti — Thu, 16 Nov 2006 06:04:56 GMT

Hey Varun,

Using the BAPI is the best approach.

Only when we don't find the required purchase order details in BAPI, we can fetch data from tables.

I am sorry rammohan if I misguided you.

Thanks

Ramakrishna

Message was edited by:

Ramakrishna Ramisetti

Re: how to extract the po data

former_member69765 — Thu, 16 Nov 2006 06:32:18 GMT

Hi..

This BAPI will give you all the data that is related to the PO .. the PO Item data also..

there is one more BAPI .. see if this suits ur requirement - BAPI_PO_GETITEMS

Regarding the downloading to excel part... there are some standard FMs available that download the data in Excel sheet.

For Upload POs again there is a BAPI - BAPI_PO_CREATE.

Regarding Standard Programs .. Sorry my friend I am not aware of ... Experience is where I lack..

May be Ramakrishna can help or others can help.

Hope all this was useful...