CDS View on Changes in Sales Orders?

[Saskia_Fontaniv]

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

[OlgaBubis · Accepted solution]

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

[Sai_Kasturi · Accepted solution]

Thanks for the update Olga.

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

[former_member75289 · Accepted solution]

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

[Simona2 · Accepted solution]

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

[former_member731394]

Hello Team,

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

Regards,

Sid

[Sean_Zhang]

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

[former_member731394]

Hi Sean,

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

Thanks,

Sid

[Sai_Kasturi]

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

[former_member609863]

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?

[former_member132363]

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

[former_member132363]

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

[former_member132363]

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.

[former_member132363]

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.