I getting duplicate values against item code when I remove Item code from chart then i am come to near my output but here is also I am missing my Shipment No. SHGO316/000207
I think the key between the two tables is not granular enough to give you Item_Code level Quantity.... You are joining the two tables on Document No_ and whereas it seems that you want to join on Document No_ and Item_Code. Is there Item information in Shipment table? It seems No_ include the same information as Item_Code... try this
Shipment:
LOAD [Document No_] as ShipmentNo,
[Sell-to Customer No_],
Type,
No_ as Item_Code,
[Location Code],
[Shipment Date],
Description,
Quantity,
[Unit Price],
[Unit Cost (LCY)],
[Shortcut Dimension 1 Code],
[Shortcut Dimension 2 Code],
[Order No_] as DocNum,
[Order No_] ,
[Order Line No_],
[Bill-to Customer No_],
[Gen_ Bus_ Posting Group],
[Gen_ Prod_ Posting Group],
[Unit Cost],
[Posting Date],
[Planned Delivery Date],
[Planned Shipment Date],
[Order Date]
FROM
(qvd)
where Quantity <> 0;
and may be you want to further link them on the Location Code also....
Note: You will get synthetic key which can be avoided by created a concatenated key using Document No_ and No_ field from Shipment table and similarly Document No_ and Item_Code from SalesLine table
