1
Closed DO Item with Invoice Number Query
source link: https://community.sap.com/t5/enterprise-resource-planning-q-a/closed-do-item-with-invoice-number-query/qaq-p/13592498
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
Closed DO Item with Invoice Number Query
Hi All
Please help advise how to enhance this Query to show the actual Invoice Number of Closed Delivery Order. Right now it is only showing internal Target Entry from DO.
SELECT T0."DocDate", T0.DocEntry, T0.[DocNum] 'DO No', T0.[CardCode], T0.[CardName], T1.[VisOrder] + 1 'LineNo.', T1.[ItemCode], T1.[Dscription], T1.[Quantity], T1.[OpenQty], T2.Telephone as 'Sales Employee', T1.[TargetType], T1.[TrgetEntry] FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry] INNER JOIN OSLP T2 ON T0.[SlpCode] = T2.[SlpCode] LEFT OUTER JOIN INV1 T3 on T1.[TargetType]=T3.[TrgetEntry] LEFT OUTER JOIN OINV T4 ON T4.[DocEntry] = T3.[DocEntry]
WHERE T0."DocStatus" = 'C'
Kedalene Chong
Recommend
About Joyk
Aggregate valuable and interesting links.
Joyk means Joy of geeK