financial dimension

(0) Share

Report

Posted on by munsif

1,536

hi expert, when we create new sales order and give dimension (e.g cost center,department,business unit)more than one, so where that dimension data are stored, by default there is field in sales table named default dimension ,when i assigned only one dimension to a SO,either on sales header or sales line, then data in default dimension field were updated, but in case more than dimension (i.e, cost center,department,business unit) where be data will store in table, if in sales table ,then where? and another table, then please guide

Regards.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

5400 7,162 on at

Like (0)

Report

It is not in salesl table or salesline It will store in below tables.

\Data Dictionary\Tables\DimensionAttributeValueSet

\Data Dictionary\Tables\DimensionAttributeValueSetItem

DimensionAttributeValueSet - recid is nothing but your default dimension in salesline or salestable.

It has same relation with child (Dept,Cost ext) table DimensionAttributeValueSetItem

Thanks

Bhaskar

Was this reply helpful? Yes No
Suggested answer

jasman 1,413 on at

Like (0)

Report

The DefaultDimension field relates to a record in table DimensionAttributeValueSet via Recid-field.
The DAVSet is the gathering point for one or more DAVSetItem records.
Each of these have a relation to DimensionAttributeValue which links to the backingentity.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

The solution uses several tables.

DefaultDimension contains a RecId of DimensionAttributeValueSet table; the next table you need is DimensionAttributeValueSetItem and from there you can find the actual DimensionAttributeValue.

Nevertheless you normally don't have to work with these tables directly. If you explain what you're trying to achieve, we might show you some easier way.

Was this reply helpful? Yes No
Mariano Gracia on at

Like (0)

Report

Look at DimensionAttributeLevelValueAllView, ValueCombinationRecId will match with salesTable DefaultDimension or SalesLine DefaultDimension, you will find one record for each dimension attribute (cost center, department...) and value.

Was this reply helpful? Yes No
munsif 1,536 on at

Like (0)

Report

thanks martin,i always learn some new thing from experts, i want to know when we create sales order , and in header level i just applied more than one financial dimension ,then the record of that dimension against that SO where were store?

Was this reply helpful? Yes No
Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

I thought we've just answered that. What else do you need or which part don't you understand?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report
Default dimension is nothing but int64 field in Salestable.

if you want to fetch the data which you are entered in sales table in multiple dimension fields

you have to write query as below

static void Job4(Args _args) { DimensionAttributeValueSetItem DimensionAttributeValueSetItem; DimensionAttributeValueSet DimensionAttributeValueSet; DimensionAttributeValue DimensionAttributeValue; SalesTable salestable = SalesTable::find('SO_0001'); while select DimensionAttributeValueSetItem join DimensionAttributeValueSet where DimensionAttributeValueSet.recid == salestable.DefaultDimension && DimensionAttributeValueSetItem.DimensionAttributeValueSet == DimensionAttributeValueSet.RecId join dimensionAttributeValue where dimensionAttributeValue.recid == DimensionAttributeValueSetItem.DimensionAttributeValue { info(strFmt("%1",DimensionAttributeValueSetItem.DisplayValue)); } }

Was this reply helpful? Yes No