Skip to Content
avatar image
Former Member

I need a Delivery Packaging type in delivery report in sap b one

I am creating a CR report for Delivery and I need Packaging type For DLN7 but the data is duplicate in CR report ......

SELECT T0.[DocNum], T0.[DocDate], T0.[CardCode], T0.[CardName], T1.[Address], T2.[PymntGroup], T1.[Phone1], T1.[Fax], T1.[CntctPrsn], T3.[ItemCode], T3.[Dscription], T3.[ShipDate], T3.[Quantity], T3.[Currency], T3.[Price], T3.[LineTotal], T4.[PackageNum], T4.[PackageTyp] FROM ODLN T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode INNER JOIN OCTG T2 ON T1.GroupNum = T2.GroupNum INNER JOIN DLN1 T3 ON T0.[DocEntry] = T3.[DocEntry] INNER JOIN DLN7 T4 ON T0.[DocEntry] = T4.[DocEntry]

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers