Get Financial Dimensions using LEDGERJOURNALTRANS in Single Line, Query x++ Dynamics AX, Finance and Operations

Get Financial Dimensions using LEDGERJOURNALTRANS  in Single Line, Query x++ Dynamics AX, Finance and Operation

select LEDGERJOURNALTRANS.LEDGERDIMENSION, LEDGERJOURNALTRANS.journalnum, DimensionAttributeLevelValueAllView.DISPLAYVALUE, DIMENSIONATTRIBUTE.NAME,

DimensionAttributeLevelValueAllView2.DISPLAYVALUE, DIMENSIONATTRIBUTE2.NAME,

DimensionAttributeLevelValueAllView3.DISPLAYVALUE, DIMENSIONATTRIBUTE3.NAME

from LEDGERJOURNALTRANS

inner join DimensionAttributeLevelValueAllView on DimensionAttributeLevelValueAllView.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

inner join DIMENSIONATTRIBUTE on DIMENSIONATTRIBUTE.RECID = DimensionAttributeLevelValueAllView.DIMENSIONATTRIBUTE

and DIMENSIONATTRIBUTE.Name = 'Projects'

inner join DimensionAttributeLevelValueAllView as DimensionAttributeLevelValueAllView2 on DimensionAttributeLevelValueAllView2.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

inner join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE2 on DIMENSIONATTRIBUTE2.RECID = DimensionAttributeLevelValueAllView2.DIMENSIONATTRIBUTE

and DIMENSIONATTRIBUTE2.Name = 'MainAccount'

inner join DimensionAttributeLevelValueAllView as DimensionAttributeLevelValueAllView3 on DimensionAttributeLevelValueAllView3.VALUECOMBINATIONRECID = LEDGERJOURNALTRANS.LEDGERDIMENSION

inner join DIMENSIONATTRIBUTE as DIMENSIONATTRIBUTE3 on DIMENSIONATTRIBUTE3.RECID = DimensionAttributeLevelValueAllView3.DIMENSIONATTRIBUTE

and DIMENSIONATTRIBUTE3.Name = 'Purpose'
where  LEDGERJOURNALTRANS.RECID = 5637176076 

Read how to make UIBuilder Class Click Here

Simple UIBuilder Class x++ D365 Finance and Operations

Read how to make DP class for Contact Click Here
DP Class for UI Builder ListEnumerator d365 x++ Finance and Operations