Report in EBP

[Former Member]

Hi All,

Iam new to EBP, I need to code a report output fields shopping cart number,PO number,created by,Amount, currency,shopping cart creation date, type of approval and Po creation date,

Please let me know the fields and table names for the above.

Thanks

rk

[yann_bouillut · Accepted solution]

Hi Raj,

Transaction BBP_PD give you tables used in SRM.

You can alos look at tables :

CRMD_ORDERADM_H (header level)

CRMD_ORDERADM_I (item level)

Others tables :

BBP_PDBEH

BBP_PDBEI

Besides you have already some reports beginning with :

bbp_bw_SC...

It could be a starting point for your extension.

Kind regards,

Yann

[Former Member · Accepted solution]

Hi,

Thanks, very useful info.

The report displays list whose shopping carts that have already been approved and therefore converted into a PO, and also those ones that have pending approvals.

Iam unable to find PO's. that is link between shopping cart and PO.

Can some one help me where PO's are stored when shopping carts are approved.

Thanks

rk

[Former Member · Accepted solution]

hi raj

Once a shopping cart is created you can go to Tcode

BBP_PD and insert the shopping cart number execute it will display all the tables detail when you docuble click on details in each section say header level Item level , Account assignment etc. Just check the linkages of tables from TCode BBP_PD.

Regards

Nimish Sheth

NB - Do rewards points for helpful answers.

[Former Member · Accepted solution]

Hello Raj,

Depending on your scenario, POs are created in SRM or in R/3.

In any case, PO reference is stored (by the job CLEAN_REQREQ_UP) at SC item level in BBP_PDBEI, with business object BUS2012 (R/3)) or BUS2201 (SRM).

Check it with BBP_PD transaction, item data.

Rgds

Christophe

[Former Member · Accepted solution]

Hi,

Thanks for the info, PO are created in SRM, and when I try to query BBP_PDBEI with business object BUS2201, I see no data.

Could you please throw more light.

Thanks

Raj

[Former Member · Accepted solution]

Hi Raj,

you must query BBP_PDBEI for each SC item GUID.

You will find:

- BBP_PDBEI-BE_OBJECT_TYPE = BUS2201

- BBP_PDBEI-BE_OBJECT_ID = SRM PO number

Rgds

Christophe

[Former Member · Accepted solution]

what is the significance of GUID?

[Former Member · Accepted solution]

what is the significance of GUID?

Thanks

Raj

[yann_bouillut · Accepted solution]

Hi Raj,

The GUID is a unique identifier that SRM is creating for a table entry.

Kind regards,

Yann

[Former Member · Accepted solution]

Hi,

Can anybody let me know where PO Creation date is stored in EBP.

Thanks

Raj

[Former Member · Accepted solution]

Hi,

PO creation date is stored in table CRMD_ORDERADM_I in the field CREATED_AT. You can also see it in the header data using transaction BBP_PD.

BR,

Sjoerd.

[Former Member · Accepted solution]

Hi Sjoerd,

Thanks for the help

CRMD_ORDERADM_H-Created_AT seems to be PO creation date instead of CRMD_ORDERADM_I-Created_AT as worflow table has crmd_orderadm_H-created_at(date is ok Time different)

Please correct me .

How to take PO Number, for some cart numbers BBP_PDBEI - BE_OBJECT_ID is the PO number and for some it is not and PO number is stored in structure BAPIEBAN field PO_Number.

How can I take PO number ? please provide logic

Answers are highly rewarded

Thanks in Advance,

Raj

[Former Member · Accepted solution]

Hi,

Sorry I meant CRMD_ORDERADM_H.

The field BE_OBJECT_ID in table BBP_PDBEI is the PO number. However, it is not filled until the PO is replicated in the backend. Furthermore, in this table there are also shopping carts, for which this field is not filled. So, there are entries in this table which do not have a value in this field.

The PO number is in the field OBJECT_ID in the table CRMD_ORDERADM_H (for entries with the right document type for purchase orders). This is the PO number in SRM. Once it is replicated in the backend, you will find the PO number in the backend in BBP_PDBEI - BE_OBJECT_ID.

BR,

Sjoerd.

[Former Member · Accepted solution]

Hi,

I have

BBP_PDBEI-BE_OBJECT_ID = 4000002531

BBP_PDBEI-BE_OBJECT_TYPE = BUS2105.

but R/3 PO number = 4500004257, Is PO not replicated in the backend ?

is there a logic to use be_object_id = 4000002531 to get 4500004257.

Thanks

Raj

[yann_bouillut · Accepted solution]

Hi Raj,

BUS2105 is a purchase requisition...

that was later converted into a purchase order...

Kind regards,

Yann

[Former Member · Accepted solution]

Hi ,

Thanks for the info, when is the later,I already have PO for this SC number in R/3.

Is the PO need to be replicated in the back end to show in EBP? this is what you are trying to say?

I need to display this PO in my EBP report, is it possible? how?

Thanks

Raj

[yann_bouillut · Accepted solution]

Hi Raj,

Once the PR will be converted into a PO in R/3, SRM table will be updated.

You will then be able to access the PO number and display it in your report.

Kind regards,

Yann

[Former Member · Accepted solution]

Hi Yann,

PR is converted into PO in R/3 but table bbp_pdbei is not updated.

is there any backend replication need to be done ?

Iam taking few examples in dev and trying to create report,

Process type iam using (CRMD_ORDERADM_H-PROCESS_TYPE = SHC ).

does this process type has any effect in displaying Po created in R/3.

Thanks

Raj