SELECT [SourceSystem]
,[Client]
,[MaterialDocumentYear]
,[MovementType]
,[MaterialId]
,[PlantId]
,[StorageLocationId]
,[CurrencyId]
,[BaseUnitOfMeasure]
,Year = Year([DocumentPostingDate])
,Month = Month([DocumentPostingDate])
, #Pos = count([MaterialDocumentId])
, Quantity = sum([Quantity])
, Value = sum([AmountLocalCurrency])
FROM [VartaDataWarehouse].[fct].[MaterialDocumentSegment]
WHERE [SourceSystem] = 'M' and [StorageLocationId] <> '' -- and [DocumentPostingDate] >= '2021-01-01'
GROUP BY [SourceSystem]
,[Client]
,[MaterialDocumentYear]
,[MovementType]
,[MaterialId]
,[PlantId]
,[StorageLocationId]
,[CurrencyId]
,[BaseUnitOfMeasure]
,Year([DocumentPostingDate])
,Month([DocumentPostingDate])
