Tags

, , ,

Hi All,

suppose we have only cost center with us and we want to find out the various items attached to it. We can find it out in a very simple way. 

Thanks to @Sunil Behara and @Kavita Choure who helped me find out the table for it.

The table where all cost centers are present is the view named “DimAttributeOMCostCenter”

View : DimAttributeOMCostCenter

Field : Value

and the default dimension present in the invent table is also present in other table with the combination of various dimension in the table “DimensionAttributeValueSetItem”

Table : DimensionAttributeValueSetItem

field : DisplayValue

field : DimensionAttributeValueSet

Now the relation is as follows : 

DimAttributeOMCostCenter.Value == DimensionAttributeValueSetItem.DisplayValue

&& Inventtable.defaultDimension == DimensionAttributeValueSetItem.DimensionAttributeValueSet

Advertisements