How to Create Specific SAP Query for Sales BOM

[Former Member]

Dear All Salute !!

How I can create a SAP Query which provide information from the Sales Order-Line Item, this specific material is having any BOM or not?

Suppose, user want Input,

Sales Order No., Product Category, Duration of Sales Order Release.

want Output,

Sales Order No., Customer No., Customer Description, Sales Order Line Item, Material No., Material Description, Delivery Date, Quantity, Sales Order release Date

Users requirement is, List of All Line Items for which BOM is yet to be Uploaded in the System.

Please provide complete detail with Table & field by using SAP Query.

Rgds

Srivastav

+91-9973504950

[Former Member]

Thanks!

Solved by using other table.

[Lakshmipathi]

"other table."

Which Table ?????

[Lakshmipathi]

If I am correct, in table KDST, you can see the details of Sales BOM with sale order. Since right now, I dont have access to SAP, I am unable to confirm this. You have to consider this table and develop on your own logic with the help of ABAPer.

thanks

G. Lakshmipathi