Sales & Delivery Report - SAP PUBLIC CLOUD

[Tehreem_Fatima1]

Hi,

We have a business requirement to create a Sales and Delivery Stock Report that should display the following key details:

• Sales Order Quantity

• On-Hand Quantity

• Blocked Order Quantity

• Dispatched Quantity

We are unable to find any standard report in SAP S/4HANA that covers all these fields together.
When attempting to build it using Custom Fields and Logic, we also noticed that there are no suitable CDS views available that provide a consolidated view of these data points.

Could anyone please suggest:

1. Any standard report or app that can fulfill this requirement, or

2. The relevant CDS views that can be used to retrieve these details —
   i.e. Sales Order Quantity, On-Hand Quantity, Blocked Orders, and Dispatched Orders.

Any guidance or references would be highly appreciated.

Thank you,

Tehreem Fatima

[abulhasnat]

Hi @Tehreem_Fatima1 

We had made a custom stock overview report for this where the system is showing Unrestricted Stock - Total Sales Order Blocked Stock = Available Stock. In this case, we are using the below CDS views: 

I_SALESDOCUMENTITEM
I_STOCKQUANTITYVALUEBYTYPE
I_SALESDOCUMENT
I_DELIVERYDOCUMENTITEM (Additionally, you need this CDS view as well.)

You need to develop a custom report for this; in a standard report your requirement will not be fulfilled. 
Our Custom Report Screenshot for your reference:

Hope this will help you to understand. 
Thanks
Hasnat

---

@Tehreem_Fatima1 wrote:

Hi,

We have a business requirement to create a Sales and Delivery Stock Report that should display the following key details:

• Sales Order Quantity

• On-Hand Quantity

• Blocked Order Quantity

• Dispatched Quantity

We are unable to find any standard report in SAP S/4HANA that covers all these fields together.
When attempting to build it using Custom Fields and Logic, we also noticed that there are no suitable CDS views available that provide a consolidated view of these data points.

Could anyone please suggest:

1. Any standard report or app that can fulfill this requirement, or

2. The relevant CDS views that can be used to retrieve these details —
   i.e. Sales Order Quantity, On-Hand Quantity, Blocked Orders, and Dispatched Orders.

Any guidance or references would be highly appreciated.

Thank you,

Tehreem Fatima

---

CDS views.