Item Product Dimensions

Submitted by Nathan Clouse on 09/11/15.

A view that shows product dimensions and the elements that compose them. For instance, using Contoso data, product dimension group "SizeCol" will show has have Size and Color enabled.

AX Version:

AX 2012

Module:

Product Information Management

CREATE VIEW [dbo].[vw_pimProductDimensions] 
AS 
  SELECT *, 
         'ConfigEnabled' = (SELECT isactive 
                            FROM 
         ecoresproductdimensiongroupfldsetup fld 
                            WHERE  fld.productdimensiongroup 
                                   = 
                                   erp.recid 
                                   AND fld.dimensionfieldid 
                                       = 
                                       7 
                                   AND fld.partition = 
                                       erp.partition), 
         'InventSizeEnabled' = (SELECT isactive 
                                FROM 
         ecoresproductdimensiongroupfldsetup fld 
                                WHERE 
         fld.productdimensiongroup = erp.recid 
         AND fld.dimensionfieldid = 8 
         AND fld.partition = erp.partition), 
         'InventColorEnabled' = (SELECT isactive 
                                 FROM 
         ecoresproductdimensiongroupfldsetup fld 
                                 WHERE 
         fld.productdimensiongroup = erp.recid 
         AND fld.dimensionfieldid = 9 
         AND fld.partition = erp.partition), 
         'InventStyleEnabled' = (SELECT isactive 
                                 FROM 
         ecoresproductdimensiongroupfldsetup fld 
                                 WHERE 
         fld.productdimensiongroup = erp.recid 
         AND fld.dimensionfieldid = 16002 
         AND fld.partition = erp.partition) 
  FROM   ecoresproductdimensiongroup erp

quicktab