Extracting PO's and PO's item daya from SRM

[Former Member]

I need to get all PO's and PO's item data within SRM .

What FM do you use ? We are using Extended Classical Scenario. Client wants a small program to execute in batch. Once all data is collected PO's will be passed to BBP_SAPXML1_PO_SEND (SAP proxy call).

Your help is appreciated.

[Former Member · Accepted solution]

Hello Emir,

you should develop a little report scheduled daily that list all changed PO during the day (BBP_PD_PO_GETLIST or direct extraction of PO GUID from CRMD_ORDERADM_H), and use a piece of standard to send each PO with BBP_SAPXML1_PO_SEND (ex: copy BBP_OUTPUT_SUSPO_XML logic).

Rgds

Christophe

[Former Member · Accepted solution]

Thanks Denysiak. This is very helpful.

When I execute plain BBP_PD_PO_GETLIST in my system i pull 773 records. When I select all from CRMD_ORDERADM_H (object type BUS2201 for PO) i get 1100 records). Why the difference?

[former_member191111 · Accepted solution]

Hi Emir,

Function Mod BBP_PD_PO_GETLIST will give you list of PO which are active.

Whereas in table CRMD_ORDERADM_H having all the records even which are deletd also .

Regards

Sachin

[Former Member · Accepted solution]

Hello,

Do get the complete list of PO with BBP_PD_PO_GETLIST, you need to execute it twice:

- one with BUS2012 only

- one with BUS2012 + the parameter I_WITH_CLOSE

If you only want to extract last modified PO GUID list, you should access directly CRMD_ORDERADM_H.

Rgds

Christophe

[yann_bouillut]

Hi Emir,

You can look at function BBP_PO_BW_EXTRACT.

Kind regards,

Yann