I could not find the CDS view for Material Description and Tax Details for Purchase Order.

[former_member610378]

Hi all,

I am generating a report where to extract all the Purchase Orders details like

PO No.

PO Item No.

Material

Material Name/Description

Supplier

Tax Amount

Net Amount

Total Amount (Tax Amount + Net Amount)

I have searched to my extent for Material Name/Description and Tax related details, I could not trace it out.

Please help me from which CDS Views I can achieve it.

Thanks,

[Feras_Al-Basha · Accepted solution]

Hi susheelkumar ,

Before jumping on to CDS views I would like to bring to your attention the vast array of analytics for sourcing, procurement and purchasing available out-of-the box. Please see attached examples of the central dashboard and relevant Fiori apps from which the information you are looking for could essentially be viewed and exported to excel.

Now with regards to CDS views there may be many different views to report on your requirements. A slight complication I foresee is perhaps the measures you required that is tax amount, net amount and total amount.

My recommendation would be to explore the CDS views "I_PurchaseOrderHistoryAPI01" as well as the AccDoca cube "I_OperationalAcctgDocCube" which should provide the complete ingredients to fulfill your requirement. Some minor calculated or restricted measures may need to be created as custom. In addition to merges of views.

Lastly, the readily available custom analytical query "C_PURCHASEORDERVALUEQUERY" may also fit your requirement. Perhaps a good starter would be to copy/create on this query and add restricted measures for the missing amounts where applicable.

Hope this information helps,

Thank you,

Feras

[former_member610378 · Accepted solution]

Hi Feras,

Thanks for your support.

It helped me a lot.

Thanks,

[former_member610378 · Accepted solution]

Hi Feras,

I couldn't find the tax value from the C_PURCHASEORDERVALUEQUERY. I have gone through I_PurchaseOrderHistoryAPI01 and I_OperationalAcctgDocCube also. I need to fetch the tax data into the report. Please do the needful.

Thanks,

[former_member610378]

Hi Feras,

For more brief, I am herewith attaching the file for reference.

Please do the needful.

Thanks,

[Feras_Al-Basha]

Hi Susheel,

Thanks for getting back.

From what you are describing seems like you may need to create a custom calculated field that would essentially add two measures that is the tax amount and gross amount. This could be accomplished by creating your custom CDS view in the app 'custom CDS views.' Thereafter you may build a query on top for end-user consumption and tile generation.

Hope this information helps,

Thank you,

Feras

[former_member610378]

Hi Feras,

I couldn't find the tax value from the C_PURCHASEORDERVALUEQUERY. I have gone through I_PurchaseOrderHistoryAPI01 and I_OperationalAcctgDocCube also. I need to fetch the tax data into the report. Please do the needful.

Thanks,

[former_member610378]

Hi Feras,

In addition to this, I have gone through the Monitor Purchase Order Items app also, but, I couldn't find the tax related data. If you could find somewhere else, please let me know.

Thanks,

[Feras_Al-Basha]

Hi susheelkumar

Thank you for the follow-up. Glad to hear the progress.

I am surprised that you were unable to retrieve the tax information in the CDS views mentioned in this thead. I have attached a document that shows the relevant fields available in both CDS views.

Further, you may also revert to the out-of-box report 'display purchasing documents by supplier' and execute the report using the 'ALV' grid control parameter. Thereafter you may change the layout to include tax related information and export to excel for further quick manipulation. Have included screenshots in the attachment.

Hope this helps,

Thank you,

Feras

[former_member610378]

Hi Feras,

Thanks for the support in keeping the effort by taking sometime to resolve my query.

Thanks a lot.

I have gone through your attachment.

Actually, I need to display the amount which is under Invoice tab and not under Conditions tab. The CDS View and the Display Purchasing Document by Supplier app is showing as 3000 and not the amount 13500. The same is herewith attached for your reference. Please do the needful.

Thanks,

[former_member610378]

Hi ferasbasha3,

Thanks for the help.

We need to create calculated column for Gross/Total Amount which is to be calculated as Net Amount + Tax Amount. In the CDS view, we are having Net Amount. But, I am unable to find the Tax Amount (13,500/- in this case). That's the issue.

Hope you got my point.

Thanks,