What date is used to calculate week in the Sales Order Items Backorders report (C_SlsOrdConfAnlytsQry)? #Supreme #COE

[former_member75289]

Hello Experts,

In the Sales Order Items Backorders report (based on the Confirmation of Sales Orders Query -  C_SlsOrdConfAnlytsQry), what date is used to generate the "Week of Order" Dimension?

From the report settings:

Looking at C_SlsOrdConfAnlytsQry in the View Browser, it's not clear to me whether this date is being calculated from the sales order creation date, the document date, or the posting date:

Does anyone know where I can view documentation for this kind of thing?

Thanks,

Sarah S

[former_member131745 · Accepted solution]

Hi Sarah - I don't see any documentation on this field. It comes from I_SlsOrdConfAnalyticsCube and uses the Calendar week. Maybe you can find the origin through trial and error. I assume it comes from the sales order header, document date.

[former_member132363]

Here are some SAP resources you may review based on your topic "calculate | of | sales order items backorders report | sales orders | sales order"

Best Practices for SAP S/4HANA Cloud

Accounting for Incoming Sales Orders - This scope item provides a report of all ... Purchase Order Accruals - This process supports automatic calculation, review, ... the features for Product Availability Check and Backorder Processing.

https://support.sap.com/en/product/best-practices-s4hana-cloud.html

Common Issues related to Credit Management functionality with ...

May 12, 2020 ... Issue: Backordered Sales Orders getting Credit Blocks. 1. Sales order for users is getting credit block even with credit card ... Unable to do delivery of Back ordered items due to credit block, ... No activity data to report yet.

https://blogs.sap.com/?p=475

Trouble shooting for SOAP API Sales Order/Customer Return ...

Jun 3, 2020 ... Trouble shooting for SOAP API Sales Order/Customer Return ... The system could not determine a sale area as no record has been ... Purchase order &2 of customer &1 is referenced by multiple sales orders ... Sales document items cannot contain Sold-To-Party information ... No activity data to report yet.

https://blogs.sap.com/?p=605

[former_member75289]

Hello Edmin - answer not relevant

[former_member132363]

The loading date is currently not supported in the Sales Order API's. As an alternative, I suggest to explore the possibility of CDS - I_SALESDOCUMENTSCHEDULELINE where Loading Date and time are both provided.

Please refer to documentation: [CDS - I_SALESDOCUMENTSCHEDULELINE]

(https://api.sap.com/cdsviews/I_SALESDOCUMENTSCHEDULELINE/fields)

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_member75289]

Hello Edmin - answer not relevant