How to create QVD from following SQL join Statement

[vikasmahajan]

Hii,

Experts   Can any one tell me how to create qvd from  following SQL Statement

Select Doc_Num,Doc_Type,Item_Ledger_Entry_No,B.Quantity

FROM FACT_QV_ValueEntry A

INNER JOIN FACT QV_ProductionOrder B

ON A.Doc_Num  = B.No_

WHERE A.Entry_Type = 6 AND A.[Item Ledger Entry Quantity] <> 0 AND A.[Expected Quantity] = 0

AND Item_Ledger_Entry_No IN

(SELECT MIN(Item_Ledger_Entry_No) FROM FACT_QV_ValueEntry A

INNER JOIN FACT_QV_ProductionOrder B

ON A.Doc_Num  = B.No_

WHERE A.Entry_Type = 6 AND A.[Item Ledger Entry Quantity] <> 0 AND A.[Expected Quantity] = 0

GROUP BY Doc_Num)

Thanks

Vikas

[sivarajs]

This is single table now. You can create,

Table:

your sql

store Table into Table.qvd (qvd);

Is this your expected output?

[vikasmahajan]

I want to create qvd from sql sub query  see this clause

  Item_Ledger_Entry_No  IN ( ...) 

do you have any idea how to perform this for creation of qvd ?

Vikas