Custom CDS View for SD Document X Material X Batch X Serial Number

[former_member133768]

Hi All,

We have a requirement from client to create a Custom Analytical Query to fetch the Batch and Serial numbers based on the Sales Document and Material. 

We did the following to create a Custom Analytical Query:

1. Created Custom CDS View to get all SD Documents with Items using I_SalesDocument and  I_SalesDocumentItem

2.Created Custom CDS View we tried to fetch the Delivery Document from the SD Document to get the Batch . using I_SalesDocument and I_SDDocumentMultiLevelProcFlow (Note: The Batch and Serial Numbers are entered only in the Delivery Document)

3.And Based on the 2nd Custom CDS View we have linked with the Delivery Document using YY1_SalesOrderListL2 and I_DeliveryDocumentItem

4.And Based on the 3rd Custom CDS View we have linked with the  Equipment Standard CDS View which is having all the Material X Batch X Serial Number using YY1_SalesOrderListL3 and I_Equipment

With this above approach we are not able to extract exact serial number and Batch from the Sales Document.

So help me if you have any other approach thanks in advance.

Thanks,

Lingaraj

[former_member133768 · Accepted solution]

Hi Gerad,

Thanks for asking.

This one is resolved now.

We are entering batch number and serial number in delivery level . So with the help of Material Document we tracked the exact batch and serial number for the particular Sales Order.

We have used "I_SerialNumberMaterialDocument" to get the serial numbers. In this way we have achieved client requirement.

Thanks,

Lingaraj

[former_member133768]

Hi Joanne,

We are maintaining batch and serial in the Delivery document. For that only i have taken sales CDS view and I_SDDocumentMultiLevelProcFlow- this will give me the subsequent document (Delivery Document).

Once i get the Delivery document then i am trying to map with I_Equipment which is having Material, Batch , serial.

Thanks,

Lingaraj

[GerardM]

Hi Lingaraj - can you elaborate on this: "With this above approach we are not able to extract exact serial number and Batch from the Sales Document."

[Joanne_Lysy]

Hello,

Where are you maintaining the batch determination? If it is in the delivery document, then the sales order CDS view may not be a viable approach.

Thanks,

Joanne