i want result as document level in one line. but in my query it shows itemwise. please help. SELECT T0. DocEntry, CASE WHEN T2. DocDate IS NOT NULL THEN CAST(YEAR(T2. DocDate) AS VARCHAR(4)) + '-' + RIGHT(CAST(YEAR(T2. DocDate)+1 AS VARCHAR(4)),2) ELSE '' END AS [Invoice ...
i want result as document level in one line. but in my query it shows itemwise. please help. SELECT T0. DocEntry, CASE WHEN T2. DocDate IS NOT NULL THEN CAST(YEAR(T2. DocDate) AS VARCHAR(4)) + '-' + RIGHT(CAST(YEAR(T2. DocDate)+1 AS VARCHAR(4)),2) ELSE '' END AS [Invoice ...This article was originally published by Sap.
Read Full Story on Source Site →