Question Re: CDS View on Changes in Sales Orders? in Enterprise Resource Planning Q&A

CDS View on Changes in Sales Orders?

Saskia_Fontaniv — Tue, 11 Jun 2019 08:26:21 GMT

Hi Community,

do you know if there is a CDS View containing the change data of sales orders (especially schedule line date)?

We want to create a report showing all sales orders with their schedule line data - old value and new value.

We know it's possible to access that in the sales order via --> more --> environment --> Changes. However, we want to have a report that shows all changed dates at once.

Thanks & Regards, Saskia

Re: CDS View on Changes in Sales Orders?

former_member132363 — Tue, 11 Jun 2019 08:26:26 GMT

After creating the customer project the sales order is generated automatically upon the maintenance of the billing plan (in Plan Customer Projects app Billing tab). The sales order is a 1:1 copy of the project meaning that for each project there is one sales order and for each billing item there is a corresponding sales order item.

The opposite behavior - that is creating the sales order first and generating a customer project out of it - is not supported.

[View Article](https://answers.sap.com/questions/13243097/view.html)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.

Re: CDS View on Changes in Sales Orders?

former_member132363 — Tue, 11 Jun 2019 08:26:27 GMT

The opposite behavior - that is creating the sales order first and generating a customer project out of it - is not supported.

[View Article](https://answers.sap.com/questions/13243097/view.html)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.

Re: CDS View on Changes in Sales Orders?

former_member132363 — Tue, 11 Jun 2019 08:26:31 GMT

Here are some SAP resources you may review based on your topic "community,create,access,environment"

2323418 - Advanced Reporting - Others Resources from Support

SAP Learning Hub provides 24/7 access to online learning content, ... and live SAP training systems (optional) in a public or private cloud environment. ... Advanced Reporting for Employee Central Customers (SF Community access required) ... to create custom BIRT template which can be used with Ad Hoc report to create?...

https://apps.support.sap.com/sap/support/knowledge/public/en/2323418

Install SAProuter

Logged on as an administrator, set the environment variables SNC_LIB and ... a) You must provide a password, which will be used to create your SAProuter PSE; ... CN=SAProuter CA, OU=SAProuter, O=SAP Trust Community II, C=DE. 7.

https://support.sap.com/en/tools/connectivity-tools/saprouter/install-saprouter.html

2291236 - Online Report Designer (ORD) - Guide / Training ...

You can use the full capabilities to create multi page, formatted reports with pivot tables, charts, text & images or simple lists to report on a set of fields. ... product team provide all guides for Online Report Designer on the Analytics product section via the Help Portal and the Successfactors Community. .... Environment.

https://apps.support.sap.com/sap/support/knowledge/public/en/2291236

Re: CDS View on Changes in Sales Orders?

former_member132363 — Tue, 11 Jun 2019 08:26:33 GMT

Here are some SAP resources you may review based on your topic "community,create,access,environment"

2323418 - Advanced Reporting - Others Resources from Support

https://apps.support.sap.com/sap/support/knowledge/public/en/2323418

Install SAProuter

https://support.sap.com/en/tools/connectivity-tools/saprouter/install-saprouter.html

2291236 - Online Report Designer (ORD) - Guide / Training ...

https://apps.support.sap.com/sap/support/knowledge/public/en/2291236

Re: CDS View on Changes in Sales Orders?

Former Member — Tue, 11 Jun 2019 08:27:21 GMT

Hi Saskia,

I can't see a CDS view that holds that data, the standard "I_SalesDocumentScheduleLine" CDS view doesn't seem to hold the change information. Is there another way of looking at the data to give you what you need?

Re: CDS View on Changes in Sales Orders?

Sai_Kasturi78 — Wed, 26 Jun 2019 07:11:30 GMT

Hi Saskia,

Could you please respond if your query has been answered?

Or is there a workaround you have adopted that you can share with the community to address above issue?

Thanks

Sai

Re: CDS View on Changes in Sales Orders?

OlgaBubis — Wed, 26 Jun 2019 07:37:20 GMT

Hi Sai,

we addressed this as an impediment request to SAP. Will let you know about the outcome of the process if positive.

Thanks,

Olga

Re: CDS View on Changes in Sales Orders?

Sai_Kasturi78 — Thu, 27 Jun 2019 04:59:42 GMT

Thanks for the update Olga.

Please keep us informed as it could be beneficial for other community users.

Re: CDS View on Changes in Sales Orders?

former_member75289 — Mon, 21 Dec 2020 04:36:04 GMT

Hello olgabubis ,

Did your impediment request to SAP result in a positive outcome? I would also be interested in accessing a CDS view with change log data for sales orders.

Many thanks,

Sarah S

Re: CDS View on Changes in Sales Orders?

former_member731394 — Tue, 12 Jul 2022 10:57:09 GMT

Hello Team,

Any update on this query or any solution did anyone found it?

Regards,

Sid

Re: CDS View on Changes in Sales Orders?

Sean_Zhang — Fri, 15 Jul 2022 01:41:09 GMT

Hi Sid,

May you check wither CDS C_SalesChangeDocItemDEX could help?

Otherwise, you can create an entry in SAP Customer Influence. http://influence.sap.com/saps4hanacloud

Best Regards,
Sean

Re: CDS View on Changes in Sales Orders?

former_member731394 — Tue, 02 Aug 2022 02:25:47 GMT

Hi Sean,

Thank for the input. Yes I have found the same and it works perfectly.

Thanks,

Sid

Re: CDS View on Changes in Sales Orders?

Simona2 — Thu, 28 Mar 2024 12:56:16 GMT

Hello, is there something new? We have also requirement to create report with sales orders with their schedule line data - old value and new value. Thank you, Simona