Create reports SQVI

[Former Member]

Hello experts,

From this link i started to create this report in SQVI http://scn.sap.com/blogs/digantvora27/2015/09/16/how-to-create-reports-by-joining-two-tables-in-sap and managed to obtain a report that is listing me the PO with the SC.

Now i wanted to take it to the next level.

I want to add the table for account assignment and have in 1 report all the information i need, PO number ->SC number->SC creator and Cost center ( account assignment/order)

I have managed to get this far, but I do not know what to link and to have it displayed so that when I run the report and then export it to list me the Cost center/Order from SAP.

Could you please advise from the table bellow what should I link with table BBP_PDACC so that when i export it will list me the highlighted fields?

I

Thank you and waiting for your reply.

Regards Gigi.

[Former Member · Accepted solution]

Hi Gigi,

You need to map the GUID in BBP_PDACC to GUID in CRMD_ORDERADM_I. This will will you the account assignment details entered in the cart.

Thanks,

Ashwin

[Former Member · Accepted solution]

Hello Ashwin,

tried that mapping.

saved and execute it.

encounter this yellow warning.

however when run the query had no result.

no data was selected ...

[Former Member · Accepted solution]

Hello Gigi,

The link between CRMD_ORDERADM_I and BBP_PDACC is table CRMD_LINK.

Can you please link the tables as follows:

CRMD_ORDERADM_I-GUID <--> CRMD_LINK-GUID_HI

CRMD_LINK-GUID_SET <--> BBP_PDACC-GUID_SET

This should link the item with the account assignment info.

Cheers,

Franz

[Former Member · Accepted solution]

Hello Franz,

Thank you it worked.

Regards Gigi.