Report related to stock retained period.

[yKim]

Dear Commnity,
I'm in charge of preparing SAP Public Cloud project.

I want to check the how long has it been since we post goods receipt for material batch.
I'm able to check the final goods receipt date related to batch.
But I want to see the automatically calculate dates after goods receipt.
For example) I posted goods receipts for Material A and Batch 1 2025/11/01 and In the report side, I want to see the date 10 for Material A and Batch1

Is there any standard report function in the SAP Public cloud?

Kindly advise,
Best Regards

[Chris1973 · Accepted solution]

Good day @yKim

Thank you for your question.

You can consult the following references for further details.

Batch Management, Material Documents Overview & Batch Information Cockpit.

In summary, the public cloud does not provide standard field that directly displays the “days since last goods receipt”. However, the system provides you supported options such as:

• Making use of the Manage Batch Information Cockpit app. This enables you review the last goods receipt date for each batch.
• The “Materials Overview” app helps you use the movement type 101 to track GR posting.
• You can also make use Custom Analytical Query to create a calculated field to enable you dynamically display elapsed days.
• Finally, the Shelf-Life Management option enables the use of expiration tracking for time-sensitive materials.

I recommend the clean-core approach where you build a Custom Analytical Query. You can use I_MaterialDocumentItem or I_Batch as your data source and add a calculated field for “Days Since GR”. This will ensure you comply with public cloud extensibility standards.

Below is a guidance.

In your Tenant, search for Batch Information Cockpit app.

Filter for your target Material, relevant batch number. Select the batch details view and confirm last goods receipt date field. Save and preview the results. You will see a calculated “Days Since GR” column.

You can optionally use Custom Analytical Query to add DaysSinceGR= CurrentDate-LastGoodsReceiptDate as a formular.

Let me know if you have further questions.

Best regards

Chris

[yKim · Accepted solution]

@Chris1973

Thanks for kind response.
The only way to realize based on report type is using custom analytical query.

I really appreciate for finding CDS table for handling my issue

Best Regards